Accelerator Statistics Attributes

Use these attributes to view accelerator statistics information.

Accelerator name The accelerator server identifier (Field name: Q8STNAME).

Accel in invalid state Number of failed query requests due to an invalid accelerator state (Field name: Q8STFINV).

Accum accel CPU time Overall accelerator CPU time (Field name: Q8STACPU).

Act Worker Nodes The number of active worker nodes (Field name: Q8STWNOD).

Avail Disk (MB) The disk storage (MB) available at the accelerator (Field name: Q8STDSKA).

Avg Coord CPU Integer Average CPU utilization on accelerator coordinator nodes (Field name: I8STCCPU).

Avg Queue Wait Time (MS) The average wait time at the accelerator query queue (Field name: Q8STQUEW).

Avg queue len, last 24 h The average query queue length during the last 24 hours at the accelerator (Field name: Q8STAV24).

Avg queue len, last 3 h The average query queue length during the last 3 hours at the accelerator (Field name: Q8STAV03).

Avg Worker CPU Integer Average CPU utilization on accelerator worker nodes (Field name: I8STWCPU).

Buffer Pool Hit (%) The accelerator buffer pool hit ratio. This value is the buffer pool hit ratio for all work that the accelerator performs on behalf of currently paired Db2 subsystems (Field name: Q8STABHR).

COMMIT Accumulated number of COMMIT statements sent from Db2 to the Accelerator server (Field name: Q8STCMTC).

CPU cost for all DB2 The total CPU cost spent in the accelerator for data maintenance operations from all DB2 systems. Replication-related operations are not included (Field name: Q8STTCMA).

CPU cost for this DB2 The total CPU cost spent in the accelerator for data maintenance operations from this DB2 system. Replication-related operations are not included.(Field name: Q8STTCMS).

CPU time executing this DB2 The total CPU cost associated with executing queries in the accelerator on behalf of this DB2 system (Field name: Q8STTCQS).

CPU time executing all DB2 The total CPU cost associated with executing queries in the accelerator on behalf of all DB2 systems (Field name: Q8STTCQA).

CREATE Accumulated number of CREATE statements sent from Db2 to the Accelerator server (Field name: Q8STCRTC).

Curr Active Requests The number of currently (actively) executing queries in the accelerator on behalf of all DB2 systems (Field name: Q8STACTV).

Curr executing queries The number of currently executing queries in the accelerator on behalf of this DB2 system (Field name: Q8STNQCS).

Current queue len The current query queue length at the accelerator (Field name: Q8STCQL).

Current Queue Len Db2 The current queue length at the accelerator back-end for this Db2 subsystem (Field name: Q8STCQLS).

DB2 Subsystem The DB2 subsystem ID.

DB2 Version The DB2 version.

DELETE Accumulated number of DELETE statements sent from Db2 to the Accelerator server (Field name: Q8STDELC).

DROP Accumulated number of DROP statements sent from Db2 to the Accelerator server (Field name: Q8STDRPC).

DSG Member Name The Data Sharing Group (DSG) member name.

Data Sharing Group The Data Sharing Group name.

Data Skew Interger Data skew (Field name:I8STSKEW)

Data slices The number of data slices at the accelerator. This equals the degree of parallel I/O channels (Field name: Q8STNMDS).

Elapsed time in accel The accumulated elapsed time spent in the accelerator when executing requests from the DB2 subsystem (Field name: Q8STAELA).

Failed reqs since start The number of queries (sent by this DB2 system since accelerator start) that failed to be successfully executed for any reason (Field name: Q8STFREQ).

INSERT Accumulated number of INSERT statements sent from Db2 to the Accelerator server (Field name: Q8STINSC).

In-use disk all DB2 % The disk storage (MB) in-use for accelerator databases for all DB2 systems (Field name: Q8STDSA).

In-use disk this DB2 % The disk storage in-use for accelerator databases for this DB2 system. (Field name: Q8STDSKB).

In-Use for LOG Data Amount of disk space in megabytes across all Db2 subsystems for log data (Field name: Q8STLSA).

In-Use for TEMP Data Amount of disk space in megabytes across all Db2 subsystems for temporary data (Field name: Q8STTSA).

Interval Start The start time of this interval.

Log rec bytes all DB2 The number of log record bytes processed by the replication capture agents for all DB2 systems (DB2 field name: Q8STNBA).

Log rec bytes this DB2 The number of log record bytes processed by the replication capture agent for this DB2 system (DB2 field name: Q8STNBS).

Log recs read all DB2 The number of log records read by the replication capture agents for all DB2 systems (Field name: Q8STNLRA).

Log recs read this DB2 The number of log records read by the replication capture agent for this DB2 system (Field name: Q8STNLRS).

Log recs tbls all DB2 The number of log records read by the replication capture agents for all DB2 systems that are applicable to tables in this accelerator (DB2 field name: Q8STNLTA).

Log recs tbls this DB2 The number of log records (read by the replication capture agent for this DB2 system) that are applicable to tables in this accelerator (Field name: Q8STNLTS).

MVS System ID The MVS identifier.

Max Query Queue Len The high watermark of the query queue length at the accelerator (Field name: Q8STMAXQ).

Max Queue Wait Time (MS) The maximum wait time at the accelerator query queue (Field name: Q8STQUEM).

Maximum Active Request for this DB2 Shows the maximum number of queries executing in the accelerator at any time since accelerator start on behalf of this DB2 system (Field name: Q8STMNQS).

Maximum Active Request for all DB2 The maximum number of queries actively executing in the accelerator concurrently at any time since accelerator start on behalf of all DB2 systems (Field name: Q8STMAXA).

Mem Avail User Data (MB) Total amount of memory that is configured for buffer pools, across all worker nodes, in megabytes. This value is the amount of memory that is available for user data. (Field name: Q8STTMUD).

Mem Avail User Reqs (MB) Total amount of memory that is available for processing SQL queries or data manipulation language statements in the accelerator, in megabytes. (Field name: Q8STTMPS).

Num blocks received The total number of blocks received from the accelerator (Field name: Q8STBLKR).

Num blocks sent The total number of blocks sent to the accelerator. (Field name: Q8STBLKS).

Num bytes received The total number of bytes received from the accelerator (Field name: Q8STBYTR).

Num bytes sent The total number of bytes sent to the accelerator (Field name: Q8STBYTS).

Num msgs received The total number of messages received from the accelerator (Field name: Q8STMSGR).

Num msgs sent The total number of messages sent to the accelerator (Field name: Q8STMSGS).

Num rows received The total number of rows received from the accelerator (Field name: Q8STROWR).

Num rows sent The total number of rows sent to the accelerator (Field name: Q8STROWS).

OPEN Accumulated number of OPEN statements sent from Db2 to the Accelerator server (Field name: Q8STOPNC).

Originating System The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Product ID The accelerator product identifier (Field name: Q8STPRID).

Query Executed Success Requests that were successfully executed (Field name:S8STSREQ).

Queries failed to execute Shows the number of queries (sent by all DB2 systems since accelerator start) that were not successfully executed for any reason (Field name: Q8STNQFA).

Replication cost all DB2 The total CPU cost associated with the replication apply process for all DB2 systems (Field name: Q8STTCCA).

Replication cost this DB2 The total CPU cost associated with the replication apply process for this DB2 system. (Field name: Q8STTCCS).

Replication Status The current replication state of the accelerator for this DB2 system (Field name: Q8STCSS).
0
Started
1
Stopped
2
Error
3
Starting
4
Stopping

Replication latency The current replication latency for this DB2 system. Latency the time difference between the timestamp, when the applied to the target, compared to the current time (Field name: Q8STCRL).

Replication status change The timestamp when the last change of the accelerator replication state occurred for this DB2 system (Field name: Q8STTLSC).

Replication Velocity Replication velocity of this Db2 subsystem. Replication velocity is measured in Db2 log seconds replicated per second to the accelerator. The value in this field is in microseconds. For external use, convert the value to seconds. This value might be negative if replication for the accelerator is stopped, or if replication information for the accelerator is not yet available (Field name: Q8STVLCS).

ROLLBACK Accumulated number of ROLLBACK statements sent from Db2 to the Accelerator server (Field name: Q8STRBKC).

Rows Deleted Accel Tables for this DB2 The number of DELETE rows applicable to accelerator tables that were processed by the replication capture agent for this DB2 system (Field name: Q8STNDS).

Rows Deleted Accel Tables for all DB2 The number of DELETE rows applicable to accelerator tables that were processed by the replication capture agents for all DB2 systems (Field name: Q8STNDA).

Rows Inserted Accel Tables for this DB2 The number of INSERT rows applicable to accelerator tables that were processed by the replication capture agent for this DB2 system. (Field name: Q8STNIS).

Rows Inserted Accel Tables for all DB2 The number of INSERT rows applicable to accelerator tables that were processed by the replication capture agents for all DB2 systems. (Field name: Q8STNIA).

Rows Updated Accel Tables for this DB2 The number of UPDATE rows applicable to accelerator tables that were processed by the replication capture agent for this DB2 system (Field name: Q8STNUS).

Rows Updated Accel Tables for all DB2 The number of UPDATE rows applicable to accelerator tables that were processed by the replication capture agents for all DB2 systems (Field name: Q8STNUA).

Server start time The timestamp when the accelerator server process started last time (DB2 field name: Q8STTART).

Sort Overflows The number of sort overflows at the accelerator back-end. A sort overflow occurs when a SQL statement cannot be processed entirely in memory (Field name: Q8STOFLW).

State Shows the current accelerator state (Field name: Q8STTATE).

Status change time The timestamp when the last change of the accelerator occurred (Field name: Q8STTATC).

Success reqs since start The number of queries (sent by all DB2 systems since accelerator start) that successfully executed in the accelerator (Field name: Q8STNQSA).

Successful Queries The total number of successful query requests since the accelerator started (Field name: Q8STSREQ).

TCP/IP serv elapsed time The accumulated accelerator services TCP/IP elapsed time measured in DB2. It starts when sending the requests to the accelerator and ends when receiving the results from the accelerator (Field name: Q8STTELA).

Timd out reqs since start The number of connections that were timed out when this DB2 system sent requests to the accelerator (Field name: Q8STTOUT).

Total failed reqs The number of connections that failed when this DB2 system sent requests to the accelerator (Field name: Q8STFAIL).

Total num accel connects The number of connects to the accelerator from this DB2 system (Field name: Q8STCONN).

Total num accel requests The number of Distributed Relational Database Architecture (DRDA) requests sent by this DB2 system to the accelerator (Field name: Q8STREQ).

Total num processors The number of CPU cores available on all worker nodes (Field name: Q8STCORS).

Transfer Rate Inbound Current inbound transfer rate for data transmitted through a network interface between the accelerator and Db2, in kilobytes per second (Field name: Q8STANUI).

Transfer Rate Outbound Current outbound transfer rate for data transmitted through a network interface between the accelerator and Db2, in kilobytes per second (Field name: Q8STANUO).

UPDATE Accumulated number of UPDATE statements sent from Db2 to the Accelerator server (Field name: Q8STUPDC).

WAITFORDATA Expired Db2 Total number of query requests that were sent by this Db2 subsystem to the accelerator, were run with the WAITFORDATA DELAY Protocol, and expired because the total wait time was greater than the specified WAITFORDATA value (Field name: Q8STEDPS).

WAITFORDATA Expired Total number of query requests that were sent by all Db2 subsystems to the accelerator, were run with the WAITFORDATA DELAY Protocol, and expired because the total wait time was greater than the specified WAITFORDATA value (Field name: Q8STEDPA).

WAITFORDATA Success Db2 Total number of successful query requests that were sent by this Db2 subsystem to the accelerator, and were run with the WAITFORDATA DELAY Protocol (Field name: Q8STTDPS).

WAITFORDATA Successful Total number of successful query requests that were sent by all Db2 subsystems to the accelerator, and were run with the WAITFORDATA DELAY Protocol (Field name: Q8STTDPA).

Wait time in accelerator The wait time spent in the accelerator when executing requests from the DB2 subsystem (Field name: Q8STAWAT).

Workder nodes Disk Util (%) Current disk utilization on worker nodes (Field name: I8STDSKU).