IBM DB2 Database
Introduction
IBM DB2 O11ySource enables monitoring of IBM DB2 databases by collecting key database health, performance, resource utilization, tablespace, transaction log, HADR replication, session, and connection metrics. It helps teams track database availability, performance bottlenecks, capacity usage, replication health, and operational issues from a centralized vuSmartMaps dashboard, supporting faster issue detection, troubleshooting, and improved observability for business-critical IBM DB2 database environments.
Getting Started
Compatibility
The IBM DB2 Database O11ySource is compatible with version v12.1.4.0
Data Collection Method
vuSmartMaps collects health and performance data for IBM DB2 Database by using an internal data collector. This data collector collects data based on the source configuration.
Prerequisites
Dependent Configuration
To configure this O11ySource, create a 'credential' of type 'user' under the 'Definition' tab.
Inputs for Configuring Data Source
- Instance Name: Please enter a unique name for this IBM DB2 instance.
- DB Details: Please provide the connection details for the IBM DB2 database.
- IP Address: IP address or hostname of the IBM DB2 server.
- Port: Port number on which IBM DB2 is listening (default: 50000).
- Credential: Access credentials for the IBM DB2 database. Define credentials on the 'Definitions' page.
- DB Name: Name of the IBM DB2 database to be monitored.
- Metrics Collection Queries: SQL queries used to collect IBM DB2 metrics.
- Query: Write the SQL query to be executed against the IBM DB2 database.
- Polling Interval [seconds]: How frequently this custom query is executed. Interval must be between 180 and 86400 seconds.
- Collection Offset [in seconds]: Delay in seconds from the periodic execution time to stagger query execution.
- Custom Queries: Add custom SQL queries here to retrieve additional metrics and data from the IBM DB2 database.
- Query Name: A unique name for the custom query. Used as the query_name tag in the collected metrics.
- Query Topic: Assign a Kafka topic to route this query's data to a specific destination. Ensure the topic is created before configuring.
Firewall Requirement
To collect data from this O11ySource, ensure the following ports are opened:
| Source IP | Destination IP | Destination Port | Protocol | Direction |
|---|---|---|---|---|
| vuSmartMaps IP | IP address of the IBM DB2 server | 50000* (or configured DB2 port) | TCP | Outbound |
| IP address of the IBM DB2 server | vuSmartMaps Kafka Broker IP | 9092 (Non SSL) / 9094 (SSL)* | TCP | Inbound |
*Before providing the firewall requirements, please update the port based on the customer environment.
Configuring the Target
Configure Metrics Collection from IBM DB2 Server Metrics from IBM DB2 LUW are gathered by establishing a connection using the DB2 CLI driver via db2exec.
- To get started, create a read-only monitoring user with the required privileges on your IBM DB2 server.
- Connect to your DB2 instance and execute the following commands:
db2 "CREATE USER vunet USING <PASSWORD>"
db2 "GRANT CONNECT ON DATABASE TO USER vunet"
db2 "GRANT SELECT ON SYSIBMADM.MON_CURRENT_SQL TO USER vunet"
db2 "GRANT SELECT ON SYSIBMADM.MON_LOCKWAITS TO USER vunet"
db2 "GRANT SELECT ON SYSIBMADM.ENV_INST_INFO TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_DATABASE TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_TABLESPACE TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_TRANSACTION_LOG TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_CONNECTION TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_HADR TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_BUFFERPOOL TO USER vunet"
db2 "GRANT EXECUTE ON FUNCTION SYSPROC.ENV_GET_SYSTEM_RESOURCES TO USER vunet"
Configuration Steps
Enablethe IBM DB2 O11ySource.- Select the Sources tab and press the
+button to add an IBM DB2 instance to monitor. - Provide the DB connection details: IP address, port, database name, and credentials.
- Select the metrics collection queries to enable and configure polling intervals.
- Click
Saveto deploy the collector.
Metrics Collected
| Name | Description | Data Type |
|---|---|---|
| Timestamp | Precise timestamp of the event with millisecond precision. | DateTime64(3) |
| Name | Name of the monitoring event or measurement. | LowCardinality(String) |
| Type | The query type identifier (e.g., database-information, tablespace-details). | LowCardinality(String) |
| Host | Hostname or IP of the IBM DB2 server. | LowCardinality(String) |
| Source ID | Unique identifier of the monitored IBM DB2 source. | LowCardinality(String) |
| Target | The target IBM DB2 instance being monitored. | LowCardinality(String) |
| DB Name | Name of the IBM DB2 database being monitored. | LowCardinality(String) |
| DB Port | Port number of the IBM DB2 database server. | UInt64 |
| DB Engine | Database engine type (ibm_db2_luw). | LowCardinality(String) |
| Kafka Topic | Kafka topic used for routing IBM DB2 metrics. | LowCardinality(String) |
| Message Key | Unique Kafka message routing key (IP:DBName). | String |
| Query Name | Name of the SQL query that produced this metric row. | LowCardinality(String) |
| Member | DB2 member number in a partitioned database environment. | UInt64 |
| Coord Member | Coordinating member for the current SQL activity. | Int16 |
| Database Status | Current status of the database (e.g., ACTIVE, INACTIVE). | String |
| DB Activation State | Activation state of the database (e.g., ACTIVATED, NOT_ACTIVATED). | String |
| DB Connection Time | Timestamp when the database connection was established. | String |
| Time Since Last Backup | Elapsed time since the last successful database backup. | String |
| Total Backups | Total number of backups performed on the database. | UInt64 |
| Peak Connections | Peak number of concurrent database connections recorded. | UInt64 |
| Total Connections | Total number of connections established to the database. | UInt64 |
| Total Secondary Connections | Total number of secondary connections established. | UInt64 |
| Current Application Connections | Number of applications currently connected to the database. | UInt64 |
| Applications in DB2 | Number of applications currently active inside DB2. | UInt64 |
| Active Sorts | Number of sort operations currently active. | UInt64 |
| Total Sorts | Total number of sort operations executed. | UInt64 |
| Internal Rollbacks | Number of internal rollback operations performed by DB2. | UInt64 |
| Dynamic SQL Statements | Total number of dynamic SQL statements executed. | UInt64 |
| Internal Commits | Number of commit operations initiated internally by DB2. | UInt64 |
| Active Hash Joins | Number of hash join operations currently active. | UInt64 |
| Lock Timeouts | Total number of lock timeout events that have occurred. | UInt64 |
| Lock Wait Time | Total time (ms) spent waiting for locks. | UInt64 |
| Deadlocks | Total number of deadlock events detected. | UInt64 |
| Lock Waits | Total number of times an application waited for a lock. | UInt64 |
| Failed SQL Statements | Total number of SQL statements that failed execution. | UInt64 |
| Total Commit Time | Total elapsed time (ms) for all commit operations. | UInt64 |
| Total Application Commits | Total number of commit operations initiated by applications. | UInt64 |
| Total Rollback Time | Total elapsed time (ms) for all rollback operations. | UInt64 |
| Total Application Rollbacks | Total number of rollback operations initiated by applications. | UInt64 |
| Rows Deleted | Total number of rows deleted from the database. | UInt64 |
| Rows Inserted | Total number of rows inserted into the database. | UInt64 |
| Rows Updated | Total number of rows updated in the database. | UInt64 |
| Rows Modified | Total number of rows modified (inserted, updated, or deleted). | UInt64 |
| Rows Read | Total number of rows read from the database. | UInt64 |
| Rows Returned | Total number of rows returned to applications. | UInt64 |
| Total CPU Time | Total CPU time (microseconds) consumed by the database. | UInt64 |
| Total Wait Time | Total time (microseconds) spent waiting across all activities. | UInt64 |
| Total Request Time | Total elapsed time (microseconds) for all database requests. | UInt64 |
| Total Hash Joins | Total number of hash join operations executed. | UInt64 |
| Total Hash Loops | Total number of hash loop iterations performed. | UInt64 |
| Hash Join Overflows | Number of hash join operations that overflowed to disk. | UInt64 |
| Buffer Pool Data Logical Reads | Logical reads of data pages from the buffer pool. | UInt64 |
| Buffer Pool Temp Data Logical Reads | Logical reads of temporary data pages from the buffer pool. | UInt64 |
| Buffer Pool Index Logical Reads | Logical reads of index pages from the buffer pool. | UInt64 |
| Buffer Pool Temp Index Logical Reads | Logical reads of temporary index pages from the buffer pool. | UInt64 |
| Buffer Pool XDA Logical Reads | Logical reads of XML data pages from the buffer pool. | UInt64 |
| Buffer Pool Temp XDA Logical Reads | Logical reads of temporary XML data pages from the buffer pool. | UInt64 |
| Buffer Pool Column Logical Reads | Logical reads of column-organized pages from the buffer pool. | UInt64 |
| Buffer Pool Temp Column Logical Reads | Logical reads of temporary column-organized pages from the buffer pool. | UInt64 |
| Buffer Pool Data Physical Reads | Physical reads of data pages from disk into the buffer pool. | UInt64 |
| Buffer Pool Temp Data Physical Reads | Physical reads of temporary data pages from disk. | UInt64 |
| Buffer Pool Index Physical Reads | Physical reads of index pages from disk into the buffer pool. | UInt64 |
| Buffer Pool Temp Index Physical Reads | Physical reads of temporary index pages from disk. | UInt64 |
| Buffer Pool XDA Physical Reads | Physical reads of XML data pages from disk. | UInt64 |
| Buffer Pool Temp XDA Physical Reads | Physical reads of temporary XML data pages from disk. | UInt64 |
| Buffer Pool Column Physical Reads | Physical reads of column-organized pages from disk. | UInt64 |
| Buffer Pool Temp Column Physical Reads | Physical reads of temporary column-organized pages from disk. | UInt64 |
| Total Logical Reads | Total logical read operations across all buffer pools. | Float64 |
| Total Physical Reads | Total physical read operations across all buffer pools. | Float64 |
| Cache Hit Ratio | Percentage of logical reads served from the buffer pool cache. | Float64 |
| Tablespace Name | Name of the DB2 tablespace. | String |
| Tablespace ID | Unique numeric identifier of the tablespace. | UInt64 |
| Tablespace Type | Type of tablespace (e.g., DMS, SMS, AUTOMATIC STORAGE). | String |
| Tablespace Content Type | Content type of the tablespace (e.g., ANY, LARGE, SYSTEMP). | String |
| Tablespace State | Current state of the tablespace (e.g., NORMAL, QUIESCED). | String |
| Tablespace Used Pages | Number of pages currently used in the tablespace. | UInt64 |
| Tablespace Free Pages | Number of free pages available in the tablespace. | UInt64 |
| Tablespace Usable Pages | Total number of usable pages in the tablespace. | UInt64 |
| Tablespace Total Pages | Total number of pages allocated to the tablespace. | UInt64 |
| Tablespace Last Resize Failed | Indicates whether the last tablespace resize operation failed. | UInt8 |
| Tablespace Pending Free Pages | Number of pages pending deallocation in the tablespace. | UInt64 |
| Tablespace Page Top | Highest page number ever used in the tablespace. | UInt64 |
| Tablespace Max Page Top | Maximum page number the tablespace has ever reached. | UInt64 |
| Tablespace Number of Containers | Number of containers assigned to the tablespace. | UInt64 |
| Tablespace Auto Resize Enabled | Indicates if automatic resizing is enabled for the tablespace. | UInt8 |
| Tablespace Initial Size | Initial size allocated to the tablespace (bytes). | UInt64 |
| Tablespace Max Size | Maximum size the tablespace can grow to (bytes). | UInt64 |
| Tablespace Increase Size | Amount by which the tablespace grows on each resize (bytes). | UInt64 |
| Tablespace Increase Size Percent | Percentage growth applied during each tablespace resize. | Int32 |
| Tablespace Last Resize Time | Timestamp of the most recent tablespace resize operation. | String |
| Tablespace Page Size | Size of each page in the tablespace (bytes). | UInt64 |
| Tablespace Track Modification State | State of modification tracking for backup purposes. | String |
| Tablespace Paths Dropped | Number of storage paths dropped from the tablespace. | Int32 |
| Tablespace Using Auto Storage | Indicates if the tablespace uses DB2 automatic storage. | UInt8 |
| Tablespace Extent Size | Extent size of the tablespace (pages). | UInt64 |
| Tablespace Prefetch Size | Prefetch size configured for the tablespace (pages). | UInt64 |
| Tablespace Rebalancer Mode | Current rebalancing mode for the tablespace. | String |
| Tablespace Used Percentage | Percentage of tablespace capacity currently in use. | Float64 |
| Current Active Log | Number of the current active transaction log file. | UInt64 |
| Current Archive Log | Number of the current archive log file. | UInt64 |
| First Active Log | Number of the first active transaction log file. | UInt64 |
| Last Active Log | Number of the last active transaction log file. | UInt64 |
| Total Log Used | Total amount of transaction log space used (bytes). | UInt64 |
| Total Log Available | Total transaction log space available (bytes). | UInt64 |
| Log Reads | Total number of log read operations performed. | UInt64 |
| Log Read Time | Total time (ms) spent reading log records. | UInt64 |
| Log Writes | Total number of log write operations performed. | UInt64 |
| Log Write Time | Total time (ms) spent writing log records. | UInt64 |
| Number of Log Write I/O | Total number of physical I/O requests for log writes. | UInt64 |
| Number of Log Read I/O | Total number of physical I/O requests for log reads. | UInt64 |
| Secondary Log Used Top | Peak number of secondary log files used simultaneously. | UInt64 |
| Total Log Used Top | Peak total transaction log space used (bytes). | UInt64 |
| Log HADR Wait Time | Total time (ms) the primary waited for HADR log acknowledgement. | UInt64 |
| Log HADR Waits Total | Total number of times the primary waited for HADR log acknowledgement. | UInt64 |
| Secondary Logs Allocated | Number of secondary log files currently allocated. | UInt64 |
| Log Held by Dirty Pages | Log space held due to dirty buffer pool pages not yet written. | UInt64 |
| Application ID Holding Oldest Transaction | Application ID holding the oldest active transaction. | UInt64 |
| Oldest Transaction LSN | Log sequence number of the oldest active transaction. | UInt64 |
| Log to Redo for Recovery | Amount of log that must be redone in a crash recovery scenario. | UInt64 |
| Number of Log Buffer Full | Number of times the log buffer was completely full. | UInt64 |
| Transaction Log Utilization Percentage | Percentage of total transaction log space currently in use. | Float64 |
| OS Name | Operating system name of the DB2 host server. | String |
| Host Name | Fully qualified hostname of the DB2 server. | String |
| OS Version | Version number of the operating system. | String |
| OS Release | Release identifier of the operating system. | String |
| Machine Identification | Unique identifier of the physical or virtual machine. | String |
| OS Level | OS maintenance level or patch level. | String |
| Total CPUs | Total number of CPUs available on the host. | UInt64 |
| Online CPUs | Number of CPUs currently online and active. | UInt64 |
| Configured CPUs | Number of CPUs configured for use by the OS. | UInt64 |
| CPU Speed | CPU clock speed in MHz. | UInt64 |
| CPU Timebase | CPU timebase frequency in Hz. | UInt64 |
| CPU HMT Degree | Simultaneous multi-threading degree per CPU. | UInt64 |
| CPU Cores Per Socket | Number of physical cores per CPU socket. | UInt64 |
| Total Memory | Total physical memory available on the host (bytes). | UInt64 |
| Free Memory | Amount of physical memory currently free (bytes). | UInt64 |
| Total Swap Memory | Total swap space configured on the host (bytes). | UInt64 |
| Free Swap Memory | Amount of swap space currently free (bytes). | UInt64 |
| Total Virtual Memory | Total virtual memory (physical + swap) available (bytes). | UInt64 |
| Reserved Virtual Memory | Amount of virtual memory reserved by the OS (bytes). | UInt64 |
| Free Virtual Memory | Amount of virtual memory currently free (bytes). | UInt64 |
| CPU Load (Short Term) | 1-minute CPU load average on the host. | Float64 |
| CPU Load (Medium Term) | 5-minute CPU load average on the host. | Float64 |
| CPU Load (Long Term) | 15-minute CPU load average on the host. | Float64 |
| CPU Usage Total | Total CPU utilization percentage across all cores. | Int32 |
| CPU User Time | Percentage of CPU time spent in user mode. | UInt64 |
| CPU Idle Time | Percentage of CPU time spent idle. | UInt64 |
| CPU I/O Wait Time | Percentage of CPU time spent waiting for I/O operations. | UInt64 |
| CPU System Time | Percentage of CPU time spent in kernel/system mode. | UInt64 |
| Swap Page Size | Size of a swap page on the host (bytes). | UInt64 |
| Swap Pages In | Total number of pages swapped into memory. | UInt64 |
| Swap Pages Out | Total number of pages swapped out of memory. | UInt64 |
| OS Full Version | Complete version string of the operating system. | String |
| OS Kernel Version | Kernel version of the operating system. | String |
| OS Architecture Type | CPU architecture type (e.g., x86_64, ppc64le). | String |
| Memory Used Percentage | Percentage of total physical memory currently in use. | Float64 |
| Virtual Memory Used Percentage | Percentage of total virtual memory currently in use. | Float64 |
| Instance Name | Name of the IBM DB2 instance. | String |
| Is Instance Partitionable | Indicates whether the instance supports database partitioning. | UInt8 |
| Number of DB Partitions | Number of database partitions in the instance. | Int32 |
| Instance Pointer Size | Pointer size of the instance (32-bit or 64-bit). | Int32 |
| Release Number | DB2 product release number. | UInt64 |
| Service Level | DB2 service level identifier (e.g., DB2 v11.5.7.0). | String |
| Build Level | DB2 build level string. | String |
| PTF | Program Temporary Fix identifier applied to the instance. | String |
| Fix Pack Number | Fix Pack number currently installed on the DB2 instance. | Int32 |
| Number of Members | Number of members in the DB2 pureScale or DPF environment. | Int32 |
| Application Handle | Unique handle identifying an application connection to DB2. | UInt64 |
| Application ID | Unique application identifier assigned by DB2. | String |
| Application Name | Name of the application connected to the database. | String |
| Session Auth ID | Authorization ID used for the current session. | String |
| Client Application Name | Name of the client application making the connection. | String |
| Elapsed Time (Seconds) | Elapsed execution time of the current SQL activity in seconds. | Int32 |
| Activity State | Current state of the SQL activity (e.g., EXECUTING, IDLE). | String |
| Activity Type | Type of SQL activity (e.g., READ_DML, WRITE_DML, DDL). | String |
| Direct Reads | Number of read operations that bypassed the buffer pool. | UInt64 |
| Direct Writes | Number of write operations that bypassed the buffer pool. | UInt64 |
| Query Cost Estimate | Optimizer estimated cost for executing the SQL statement. | UInt64 |
| Unit of Work ID | Identifier for the current unit of work (transaction). | Int32 |
| Activity ID | Identifier for the current activity within a unit of work. | Int32 |
| Statement Text | First 500 characters of the SQL statement being executed. | String |
| Client IP Address | IP address of the client making the connection. | String |
| Client Workstation Name | Workstation name of the connecting client. | String |
| Workload Occurrence State | Current state of the workload occurrence. | String |
| Execution ID | Unique identifier for the current execution context. | String |
| Last Request Type | Type of the last request made by the application. | String |
| Client Hostname | Hostname of the client machine making the connection. | String |
| Connection Start Time | Timestamp when the application connection was established. | String |
| System Auth ID | System-level authorization ID for the connection. | String |
| Client Protocol | Network protocol used by the client (e.g., TCPIP). | String |
| Client Platform | Operating system platform of the connecting client. | String |
| Client Product ID | DB2 product identifier of the connecting client. | String |
| Client Process ID | Process ID of the client application on the client machine. | UInt64 |
| Client User ID | User ID provided by the client application. | String |
| Client Accounting | Accounting string provided by the client application. | String |
| Total Connect Requests | Total number of connection requests received. | UInt64 |
| Total Connect Authentications | Total number of successful connection authentications. | UInt64 |
| Total Connect Authentication Time | Total time (ms) spent authenticating connections. | UInt64 |
| Total Connect Request Time | Total time (ms) spent processing connection requests. | UInt64 |
| Unit of Work Start Time | Timestamp when the current unit of work started. | String |
| Unit of Work Stop Time | Timestamp when the current unit of work ended. | String |
| Unit of Work Completion Status | Completion status of the most recently completed unit of work. | String |
| Number of Associated Agents | Number of agents associated with the application. | UInt64 |
| Associated Agents Top | Peak number of agents associated with the application. | UInt64 |
| Workload State Change Time | Timestamp when the workload occurrence state last changed. | String |
| Application Idle Time | Time (seconds) the application has been idle. | UInt64 |
| Total TLS Connections | Total number of TLS-encrypted connections established. | UInt64 |
| Lock Name | Internal name identifying the lock resource being waited on. | String |
| Lock Object Type | Type of database object the lock is held on (e.g., TABLE, ROW). | String |
| Lock Wait Elapsed Time | Elapsed time (seconds) the request has been waiting for the lock. | Int32 |
| Table Schema | Schema name of the table involved in the lock wait. | String |
| Table Name | Name of the table involved in the lock wait. | String |
| Data Partition ID | Partition ID of the data involved in the lock wait. | Int32 |
| Lock Mode Requested | Lock mode being requested by the waiting application. | String |
| Requesting Application Handle | Application handle of the connection waiting for the lock. | UInt64 |
| Requesting Statement Text | SQL statement text of the application waiting for the lock. | String |
| Holding Current Statement Text | Current SQL statement text of the application holding the lock. | String |
| Lock Mode | Current lock mode held on the resource. | String |
| Lock Current Mode | Current granted lock mode for the waiting application. | String |
| Requesting Agent Thread ID | Thread ID of the agent waiting for the lock. | Int32 |
| Requesting Member | DB2 member number of the requesting application. | UInt64 |
| Requesting Application Name | Name of the application waiting for the lock. | String |
| Requesting User ID | User ID of the application waiting for the lock. | String |
| Holding Application Handle | Application handle of the connection holding the lock. | UInt64 |
| Holding Member | DB2 member number of the application holding the lock. | Int16 |
| Holding Application Name | Name of the application holding the lock. | String |
| Holding User ID | User ID of the application holding the lock. | String |
| HADR State | Current state of the HADR pair (e.g., PEER, DISCONNECTED). | String |
| Replay Type | Type of log replay used by the HADR standby. | String |
| Standby ID | Numeric identifier of the HADR standby database. | Int32 |
| Log Stream ID | Log stream identifier for the HADR pair. | Int32 |
| HADR Role | Role of the database in HADR (PRIMARY or STANDBY). | String |
| HADR Connect Status | Connection status between primary and standby (e.g., CONNECTED). | String |
| HADR Connect Status Time | Timestamp when the HADR connection status last changed. | String |
| Heartbeat Interval | Interval (seconds) between HADR heartbeat messages. | UInt64 |
| HADR Timeout | HADR timeout value configured for the pair (seconds). | UInt64 |
| Heartbeat Expected | Number of heartbeats expected since the connection was established. | Int32 |
| Time Since Last Receive | Time (seconds) since the last log record was received by standby. | UInt64 |
| HADR Sync Mode | Synchronization mode of the HADR pair (e.g., SYNC, ASYNC, NEARSYNC). | String |
| HADR Log Gap | Amount of log data (bytes) not yet received by the standby. | UInt64 |
| Standby Receive Replay Gap | Difference (bytes) between log received and log replayed on standby. | UInt64 |
| Standby Replay Delay | Configured delay (seconds) for log replay on the standby. | UInt64 |
| Heartbeat Missed | Number of consecutive heartbeats missed by the standby. | Int32 |
| Log HADR Wait Current | Current wait time (ms) for HADR log acknowledgement. | UInt64 |
| Standby Receive Buffer Percent | Percentage of the standby receive buffer currently used. | Float64 |
| Standby Spool Percent | Percentage of the standby spool space currently used. | Float64 |
| Takeover App Remaining Primary | Number of applications remaining on primary during takeover. | UInt64 |
| Takeover App Remaining Standby | Number of applications remaining on standby during takeover. | UInt64 |
| Primary Member Host | Hostname of the HADR primary member. | String |
| Standby Member Host | Hostname of the HADR standby member. | String |
| Primary Member | DB2 member number of the HADR primary. | Int32 |
| Primary Instance | Instance name of the HADR primary database. | String |
| Primary Log File | Current log file on the HADR primary. | String |
| Primary Log Page | Current log page number on the HADR primary. | UInt64 |
| Primary Log Position | Byte offset within the current log file on the HADR primary. | UInt64 |
| Primary Log Time | Timestamp of the current log record on the HADR primary. | String |
| Standby Log File | Most recently replayed log file on the HADR standby. | String |
| Standby Log Page | Most recently replayed log page on the HADR standby. | UInt64 |
| Standby Log Position | Byte offset of the most recently replayed log record on standby. | UInt64 |
| Standby Log Time | Timestamp of the most recently replayed log record on standby. | String |
| Standby Instance | Instance name of the HADR standby database. | String |
| Standby Member | DB2 member number of the HADR standby. | Int32 |
| HADR Flags | Bitmask of HADR status flags for the pair. | String |
| Raw Message | Raw Telegraf influx line protocol message before parsing. | String |
| Error | Error information captured during data collection or parsing. | String |
