D2B Database

• version: 1.3

• Compatibility: v 7.5.3

• Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Enable Table Monitoring, Metric Collect Interval (Second)

• Operation: Collects information of D2B database.

• Plugin-Metrics:

Metric	Data Type
System Uptime (Seconds):	Numeric
Uptime:	String
Instance Status:	String
Private Committed Memory (KB):	Numeric
Accepted Piped Sorts:	Numeric
Requested Piped Sorts:	Numeric
Local Connections:	Numeric
Remote Connections:	Numeric
Active Gateway Connections:	Numeric
Gateway Connection Waits (Client):	Numeric
Gateway Connection Waits (Host):	Numeric
Gateway Connections:	Numeric
Executing Local Connections:	Numeric
Local Databases with Current Connects:	Numeric
Executing Remote Connections:	Numeric
Registered Agents:	Numeric
Waiting On Token Agents:	Numeric
Idle Agents:	Numeric
Sort Heap Allocation (KB):	Numeric
Stolen Agents:	Numeric
Pool Agents:	Numeric
Agent Assignments/sec:	Numeric
Created Agents (Empty Pool):	Numeric
Agent Creations/sec:	Numeric
Version:	String
Last Snapshot:	String
Last Reset:	String
Partition Number:	Numeric
Nodes:	Numeric
Active Agents:	Numeric
Active Agents/sec:	Numeric
Sort Heap Utilization (%):	Numeric
Connections/sec:	Numeric
Connections:	Numeric
DB Path:	String
DB Uptime (Seconds):	Numeric
DB Uptime:	String
DB Status:	String
DB Alias:	String
DB Last Backup:	String
DB Location:	String
Dynamic SQL Queries:	Numeric
Dynamic SQL Queries/sec:	Numeric
Failed SQL Queries:	Numeric
Failed SQL Queries/sec:	Numeric
Static SQL Queries:	Numeric
Static SQL Queries/sec:	Numeric
Internal Commits:	Numeric
Internal Commits/sec:	Numeric
Commits:	Numeric
Commits/sec:	Numeric
Rollbacks:	Numeric
Rollbacks/sec:	Numeric
Deadlocks:	Numeric
Deadlocks/sec:	Numeric
DDL SQL Queries:	Numeric
DDL SQL Queries/sec:	Numeric
Select SQL Queries:	Numeric
Select SQL Queries/sec:	Numeric
Internal Rollbacks:	Numeric
Internal Rollbacks/sec:	Numeric
Package Cache Inserts:	Numeric
Package Cache Lookups:	Numeric
Active Hash Joins:	Numeric
Active Hash Joins/sec:	Numeric
Sorts:	Numeric
Sorts/sec:	Numeric
Hash Joins:	Numeric
Hash Joins/sec:	Numeric
Sort Overflows:	Numeric
Sort Overflows/sec:	Numeric
Active OLAP Functions:	Numeric
Lock List Memory (KB):	Numeric
Active Sorts:	Numeric
Active Sorts/sec:	Numeric
Connected Applications:	Numeric
Executing Applications:	Numeric
DB Connections:	Numeric
DB Connections/sec:	Numeric
DB Secondary Connections:	Numeric
DB Secondary Connections/sec:	Numeric
Package Cache Overflows:	Numeric
Locks:	Numeric
Direct Reads:	Numeric
Direct Read Requests:	Numeric
Direct Writes:	Numeric
Direct Writes Requests:	Numeric
Lock Waiters:	Numeric
Lock Escalations:	Numeric
Lock Escalations/sec:	Numeric
Deleted Rows:	Numeric
Deleted Rows/sec:	Numeric
Inserted Rows:	Numeric
Inserted Rows/sec:	Numeric
Selected Rows:	Numeric
Selected Rows/sec:	Numeric
Updated Rows:	Numeric
Updated Rows/sec:	Numeric
Row Reads:	Numeric
Row Reads/sec:	Numeric
Log Reads:	Numeric
Log Reads/sec:	Numeric
Log Read Ops:	Numeric
Log Read Ops/sec:	Numeric
Log Write Ops:	Numeric
Log Write Ops/sec:	Numeric
Free Log Space (KB):	Numeric
Used Secondary Log Files:	Numeric
Used Log Space (KB):	Numeric
Log Writes/sec:	Numeric
Log Writes:	Numeric
Exclusive Lock Escalations:	Numeric
Exclusive Lock Escalations/sec:	Numeric
Lock Waits:	Numeric
Lock Timeouts:	Numeric
Lock Timeouts/sec:	Numeric
Catalog Cache Inserts:	Numeric
Catalog Cache Lookups:	Numeric
Catalog Cache Overflows:	Numeric
Successful SQL Queries:	Numeric
Successful SQL Queries/sec:	Numeric
Work Units:	Numeric
Work Units/sec:	Numeric
Package Cache Hit Ratio (%):	Numeric
Lock Waiting (%):	Numeric
Sort Overflow Utilization (%):	Numeric
Log Space (KB):	Numeric
Log Space Utilization (%):	Numeric
Lock Wait Time (ms):	Numeric
Direct Read Time (ms):	Numeric
Direct Read Request Time (ms):	Numeric
Direct Write Time (ms):	Numeric
Direct Write Request Time (ms):	Numeric
Direct Reads/sec:	Numeric
Direct Read Requests/sec:	Numeric
Direct Writes/sec:	Numeric
Direct Write Requests/sec:	Numeric
Sort Time (ms):	Numeric
Database Buffer Pool Hit Ratio (%):	Numeric
Index Page Hit Ratio (%):	Numeric
Data Page Hit Ratio (%):	Numeric
Catalog Cache Hit Ratio (%):	Numeric
Database Size (MB):	Numeric
Connection Time (ms):	Numeric

Instance Metrics

Metric	Data Type
Memory Pool	String
Memory Pool Size (KB)	Numeric
Memory Pool Used (KB)	Numeric
Memory Pool Utilization (%)	Numeric

Buffer Pool

Metric	Data Type
Buffer Pool	String
Buffer Pool Hit Ratio (%)	Numeric

Table Space

Metric	Data Type
Table Space	String
Table Space ID	String
Table Space Type	String
Table Space Content Type	String
Table Space Created	String
Table Space Status	String
Table Space Size (KB)	Numeric
Table Space Used Size (KB)	Numeric
Table Space Free Size (KB)	Numeric
Table Space Utilization (%)	Numeric
Table Space Page Size (KB)	Numeric
Table Space Usable Size (KB)	Numeric
Table Space Containers	Numeric
Table Space Extent Size	Numeric
Table Prefetch Size	Numeric

Table

Metric	Data Type
Table	String
Table Schema	String
Table Type	String
Table Rows	Numeric
Table Size (KB)	Numeric

Data Models

primary: “DB2 Database Metrics”

instance:

• name: “DB2 Memory Pool Metrics” columns: “Memory Pool,Memory Pool Size (KB),Memory Pool Used (KB),Memory Pool Utilization (%)”

• name: “DB2 Buffer Pool Metrics” columns: “Buffer Pool,Buffer Pool Hit Ratio (%)”

• name: “DB2 Table Space Metrics” columns: “Table Space,Table Space ID,Table Space Type,Table Space Content Type,Table Space Created,Table Space Status,Table Space Size (KB),Table Space Used Size (KB),Table Space Free Size (KB),Table Space Utilization (%),Table Space Page Size (KB),Table Space Usable Size (KB),Table Space Containers,Table Space Extent Size,Table Prefetch Size”

• name: “DB2 Table Metrics” columns: “Table,Table Schema,Table Type,Table Rows,Table Size (KB)”