Bindplane

The Bindplane Developer Hub

Welcome to the Bindplane developer hub. You'll find comprehensive guides and documentation to help you start working with Bindplane as quickly as possible, as well as support if you get stuck. Let's jump right in!

Connection Parameters

Name
Required?
Description

Host

Required

The IBM DB2 Database Host to connect to.

Port

The port for communication to the IBM DB2 Database.

Database

Required

The database to monitor.

Username

Required

Password

Required

Query Count

The number of queries to collect.

Order Queries By

Collect Events

Controls whether events are collected and returned.

Metrics

Bufferpool

Name

Database

Host

Individual Buffer Pool Hit Ratio (%)

Logical Data Reads

Logical Index Reads

Name

Physical Data Reads

Physical Index Reads

Pool Asynchronous Data Reads

Pool Asynchronous Data Writes

Pool Asynchronous Index Reads

Pool Asynchronous Index Writes

Pool Asynchronous Read Time (Milliseconds)

Pool Asynchronous Write Time (Milliseconds)

Pool Data Writes

Pool Index Writes

Pool Read Time (Milliseconds)

Pool Write Time (Milliseconds)

Database

Name

Active Applications

Active Local Connections

Active Remote Connections

Active Sorts

Agent Waiting Top

Agents Created due to Empty Pool

Agents Created to Assigned Ratio (%)

Agents Registered

Allocated Size (Bytes)

Allocated Sort Heap Memory (Pages)

Applications Connected

Applications Waiting on Locks (%)

Applications Waiting on Locks Count

Average Direct Read Rate (Milliseconds)

Average Direct Write Rate (Milliseconds)

Average Lock Wait Time (Milliseconds)

Average Post Threshold Joins Rate

Average Post Threshold Sorts Rate

Buffer Pool Data Hit Ratio (%)

Buffer Pool Hit Ratio (%)

Buffer Pool Index Hit Ratio (%)

Catalog Cache Inserts

Catalog Cache Lookups

Catalog Cache Overflows

Cleans for Steals

Cleans for Thresholds

Commit SQL Statements

Communication Private Memory (Bytes)

Connection Time

Coordination Agents Top

Current Connections

Current Size (Bytes)

Deadlocks

Direct Read Requests

Direct Read Time (Milliseconds)

Direct Reads

Direct Write Requests

Direct Write Time (Milliseconds)

Direct Writes

Dynamic SQL Statements

Exclusive Lock Escalations

Failed SQL Statements

Host

Idle Agents

Internal Deadlock Rollbacks

Internal Rollbacks

Last Reset

Local Connections

Lock Escalations

Lock List in Use (Bytes)

Lock Timeouts

Lock Waits

Locklist (Bytes)

Locks Held

Log Reads

Log Space Utilization (%)

Log Writes

Logical Data Reads

Logical Index Reads

Logical Location

Maximum Active Applications

Maximum Package Cache Used

Name

Package Cache Inserts

Package Cache Lookups

Package Cache Overflows

Physical Data Reads

Physical Disk Location

Physical Index Reads

Piped Sorts Accepted

Piped Sorts Rejected

Piped Sorts Requested

Pool Agents

Pool Asynchronous Data Reads

Pool Asynchronous Data Writes

Pool Asynchronous Index Reads

Pool Asynchronous Index Writes

Pool Asynchronous Read Time (Milliseconds)

Pool Asynchronous Write Time (Milliseconds)

Pool Asynchronous Writes

Pool Data Writes

Pool Index Writes

Pool Read Time (Milliseconds)

Pool Synchronous Data Reads

Pool Synchronous Data Writes

Pool Synchronous Index Reads

Pool Synchronous Index Writes

Pool Write Time (Milliseconds)

Post Threshold Hash Joins

Post Threshold Sorts

Remote Connections

Rollback SQL Statements

Small Overflow Hash Joins to Total Hash Joins Ratio (%)

Sort Heap Pages Allocated (Pages)

Sort Overflows

Startup Time

Static SQL Statements

Status

Time of Last Backup

Total Connections

Total Hash Join Overflows

Total Hash Join Small Overflow

Total Hash Joins

Total Hash Loops

Total Lock Wait Time (Milliseconds)

Total Log Used (Kilobytes)

Total Sort Time (Milliseconds)

Total Sorts

HADR

Name

Connect Status

Connection Time

Database

Heartbeat

Host

Local Host

Name

Remote Host

Remote Instance

Remote Service

Role

State

Sync Mode

Timeout (Seconds)

Memory Pool

Name

Database

Host

ID

Utilization (%)

SQL Statement

Name

Average Execution Time (Microseconds)

Average System CPU Time (Microseconds)

Average User CPU Time (Microseconds)

Database

Executions

Host

Rows Read

Rows Written

Statement Hash

Statement Text

Tablespace

Name

Bufferpool Identifier

Containers

Database

Extent Size (Pages)

Free Pages (Pages)

Host

Name

Page Size (Bytes)

Prefetch Size (Pages)

Ranges

State

Total Pages (Pages)

Type

Usable Pages (Pages)

Used Pages (Pages)

Utilization (%)