Skip to content

AIX Sybase

AIX Sybase input supports two modes: when user is configured, it collects connection and database capacity metrics through isql; when user is not configured, it checks liveness through process detection.

Configuration¶

[inputs]
# Global switch for middleware inputs.
enabled = true

[[inputs.sybase]]
# Instance name, reported as the `instance` tag.
name = "ase"
# Whether to enable this Sybase instance collection.
enabled = true
# Collection interval.
interval = "60s"
# Optional file loaded before collection to set instance environment variables.
env_file = ""
# Sybase Server name.
server = "SYBASE_ASE"
# Optional custom metric command. Each output line should be `key=value`.
deep_metrics_command = ""
# isql command path and login user.
isql = "isql"
user = "datakitaix"
# Password is read from an environment variable and is not written to the configuration file.
password_env = "DATAKITAIX_SYBASE_PASSWORD"

Command Dependencies¶

Command	Description
`isql -S <server> -U <user> -b`	Collect ASE metrics after a user is configured.
`ps -eo args`	Used for `dataserver` process liveness probing when no user is configured.
`deep_metrics_command`	Custom command that outputs `key=value` lines for custom metrics.

Metrics¶

All metrics append host, input=sybase, and instance=<name> tags.

`sybase`¶

Tags & Fields	Description
server (`tag`)	Sybase server.
up	Whether the instance is available. Type: int \| (gauge)
connections	`@@connections`. Type: float \| (gauge) Unit: count
process_count	Number of `dataserver` processes matched in process-probe mode. Type: int \| (gauge) Unit: count

`sybase_database`¶

Tags & Fields	Description
server (`tag`)	Sybase server.
database (`tag`)	Database name.
size_mb	Database size. Type: float \| (gauge) Unit: MB
free_mb	Free size. Type: float \| (gauge) Unit: MB
used_pct	Usage percentage. Type: float \| (gauge) Unit: percent

Custom Metrics¶

Custom metric fields are determined by deep_metrics_command output. Fields listed in the table are used as tags; numeric values in other key=value pairs are reported as int/float | (gauge) fields, and non-numeric values are reported as tags. If no numeric field exists, count=1 is added with unit count.

Measurement	Tags	Description
`sybase_sql`	`sql_id`, `database`, `user`	Custom SQL metrics.
`sybase_lock`	`database`, `lock_type`, `state`	Custom lock metrics.
`sybase_cache`	`cache`, `pool`	Custom cache metrics.
`sybase_deep_metric`	`metric`, `unit`	Generic Sybase custom metrics.