Accelerator Statistics Attributes

Use these attributes to view accelerator statistics information.

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

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

Avail Disk (MB) Total Disk capacity in MB available on the Accelerator database. For performance reasons, the Accelerator may not update this value at each heartbeat status sent to Db2, but at less frequent intervals as determined by the Accelerator. (Field name: Q8STDSKA).

Avg Coord CPU Util Average CPU utilization on accelerator coordinator nodes (Field name: Q8STCCPU).

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

Avg Worker CPU Util The current CPU utilization on the accelerator worker nodes. This is a snapshot, which is the average CPU utilization across all worker nodes (Field name: Q8STWCPU).

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).

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).

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).

Db2 Subsystem The Db2 subsystem ID.

Db2 Version The Db2 version.

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

Data Sharing Group The Data Sharing Group name.

Data Skew Data skew (Field name:Q8STSKEW)

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).

Filler Filler for padding.

Filler2 Filler for padding.

Filler3 Filler for padding.

Filler4 Filler for padding.

IP address of accel IP address of accelerator (Field name: Q8STIPAD).

In-use disk all Db2 % Disk Space (in MB) available on the Accelerator database for all Db2 systems. For performance reasons, the Accelerator may not update this value at each heartbeat status sent to Db2, but at less frequent intervals as determined by the Accelerator. (Field name: Q8STDSA).

In-use disk this Db2 % Disk space (in MB) used by the Accelerator database for this Db2 system. For performance reasons, the Accelerator may not update this value at each heartbeat status sent to Db2, but at less frequent intervals as determined by the Accelerator. (Field name: Q8STDSKB).

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 (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 (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).

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).

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 Successfully executed Requests that were successfully executed.

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 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).

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 (Field name: Q8STTART).

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).

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

Worker Nodes Disk util The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources (Field name: Q8STDSKU).