Accelerator Data - Version 4 or later

With IBM Db2 Analytics Accelerator for z/OS version 4 or later, the Statistics report block shows performance data for the replication services which transmit data from Db2 to the accelerator.

The Statistics Accelerator report block is shown for each accelerator that provided services to the Db2 subsystem or to the Db2 data sharing group within the reported interval. The left side consists of accelerator performance metrics from a subsystem or data sharing group. The right side contains total values from an accelerator. The accelerator name is shown in the header line of each column.

For counters other than IBM Db2 Analytics Accelerator for z/OS version 4 or later, the replication values are shown in a Db2 subsystem or data sharing group view and in a total accelerator view. Most subsystem- or group-related replication fields are aggregated counters and shown as delta values in TRACE blocks and as apportioned interval values in the REPORT blocks on the left. The corresponding total accelerator values on the right are snapshot counters due to the fact that the replication can be disabled during the reporting period, at which point the accelerator summarizes values from enabled replication engines.

In addition, the status of accelerators and replication engines may be unknown, and Db2 externalizes negative values -1 for related performance counters. The Statistics component handles such values as follows:

Unknown (negative) accelerator values are snapshot counters and presented as zero. This matches the behavior of previous Db2 Accelerator versions, where zero values have been provided in the performance counters.
Unknown (negative) replication engine values are shown as N/P in Statistics reports and as -1 in the Statistics accelerator table of the Performance Database as long as the status of the replication engine is not known. Once the status is known and non-negative performance values occur, aggregated and snapshot counters are handled as usual. If the replication status becomes unknown again, the aggregated counters are externalized as zero and shown as non-negative delta and interval values once replication has resumed.

Note:

The Db2 subsystem is connected with an accelerator via DRDA when submitting SQL queries. The performance counters of the DRDA connection (rows from CONNECTS TO ACCELERATOR to WAIT TIME IN ACCELERATOR) are collected and reported on an individual subsystem or member basis in the left part.
The other Statistics counters are collected periodically from the accelerator and reported as single subsystem values or as total data sharing group values in the left part if the reported subsystem is a member (with enabled acceleration) of a data sharing group.
The full accelerator name is shown in the header if it does not exceed 16 characters. Otherwise, the name is replaced by a short name in the header and the long name is displayed at the end of the report.
The descriptions of the fields labeled with QUERIES refer to SQL statements passed to the accelerator. For product identifiers of IBM Db2 Analytics Accelerator for z/OS prior to AQT04015, the SQL statements are SELECT queries passed to the accelerator and the fields INSERT STMTS to ROLLBACK STMTS are N/A.

Statistics - Accelerator Data - Version 4 or later


TF3              FOR SUBSYSTEM/GROUP      QUANTITY   TF3            TOTAL ACCELERATOR       QUANTITY
------------------------------------   -----------   ------------------------------------  ---------
QUERIES SUCCESSFULLY EXECUTED                 1.00    QUERIES SUCCESSFULLY EXECUTED             1.00
QUERIES FAILED TO EXECUTE                     0.00    QUERIES FAILED TO EXECUTE                 0.00
CURRENTLY EXECUTING QUERIES                   0.70    CURRENTLY EXECUTING QUERIES               0.70
MAXIMUM EXECUTING QUERIES                     1.00    MAXIMUM EXECUTING QUERIES                 1.00
CPU TIME EXECUTING QUERIES                1.790000    CPU TIME EXECUTING QUERIES            1.790000
CPU TIME LOAD/ARCHIVE/RESTORE            20.260000    CPU TIME LOAD/ARCHIVE/RESTORE        20.260000
CURRENT QUEUE LENGTH                             0
                                                      
INSERT STMTS SENT TO ACCELERATOR              0.00    DISK STORAGE AVAILABLE (MB)         8024544.00      
UPDATE STMTS SENT TO ACCELERATOR              0.00    IN USE FOR ACCEL DB - ALL Db2 (MB)    15790.80      
DELETE STMTS SENT TO ACCELERATOR        1204453.00    IN USE FOR ACCEL DB - THIS Db2(MB)      992.80      
OPEN STMTS SENT TO ACCELERATOR         02373564.00    IN USE FOR TEMP DATA - ALL Db2(MB)           0
                                                      IN USE FOR LOG DATA - ALL Db2(MB)            0

CREATE STMTS SENT TO ACCELERATOR          12272.00    MAXIMUM QUEUE LENGTH                      0.00      
DROP STMTS SENT TO ACCELERATOR            12272.00    CURRENT QUEUE LENGTH                      0.00      
COMMIT STMTS SENT TO ACCELERATOR              0.00    AVG QUEUE WAIT ELAPSED TIME           0.025600      
ROLLBACK STMTS SENT TO ACCELERATOR            4.00    MAX QUEUE WAIT ELAPSED TIME           0.464235      
CONNECTS TO ACCELERATOR                       2.00                                                              
REQUESTS SENT TO ACCELERATOR              12254.00    MEMORY AVAILABLE - USER DATA (MB)            0
     TIMED OUT                                0.00    MEMORY AVAILABLE - USER REQS (MB)            0 
     FAILED                                   0.00    SORT OVERFLOWS                               0
BYTES SENT TO ACCELERATOR               1204453.00    BUFFER POOL HIT RATIO (%)                 0.00                                      
BYTES RECEIVED FROM ACCELERATOR       402373564.00    TRANSFER RATE - INBOUND (KB/S)               0
MESSAGES SENT TO ACCELERATOR              12272.00    TRANSFER RATE - OUTBOUND (KB/S)              0
MESSAGES RECEIVED FROM ACCEL              12272.00        
BLOCKS SENT TO ACCELERATOR                    0.00    
BLOCKS RECEIVED FROM ACCELERATOR          12250.00
ROWS SENT TO ACCELERATOR                      0.00    WORKER NODES                              3.00
ROWS RECEIVED FROM ACCELERATOR                0.00    WORKER NODES DISK UTILIZATION (%)         0.00
                                                      WORKER NODES AVG CPU UTILIZATION (%)      2.09
TCP/IP SERVICES ELAPSED TIME             12.937895    COORDINATOR CPU UTILIZATION (%)          11.59
ELAPSED TIME IN ACCELERATOR               0.000000    PROCESSORS                               48.00
WAIT TIME IN ACCELERATOR                  0.000000    DATA SLICES                              22.00

CPU TIME FOR REPLICATION                  0.085255    CPU TIME FOR REPLICATION              0.148773
LOG RECORDS READ                            945.00    LOG RECORDS READ                     137055.00
LOG RECORDS FOR ACCEL TABLES                940.00    LOG RECORDS FOR ACCEL TABLES           1456.00

LOG RECORD BYTES PROCESSED                63209.00   LOG RECORD BYTES PROCESSED             97265.00
INSERT ROWS FOR ACCEL TABLES                  0.00   INSERT ROWS FOR ACCEL TABLES               0.00
UPDATE ROWS FOR ACCEL TABLES                  0.00   UPDATE ROWS FOR ACCEL TABLES               0.00
DELETE ROWS FOR ACCEL TABLES                  0.00   DELETE ROWS FOR ACCEL TABLES               0.00
REPLICATION LATENCY                       0.000000    
REPLICATION VELOCITY                      0.405754   ACCELERATOR SERVER START   12/16/13 09:38:08.97
REPLICATION STATUS CHANGE     12/16/13 09:38:49.79   ACCELERATOR STATUS CHANGE  12/16/13 09:38:14.66
REPLICATION STATUS                         UNKNOWN   ACCELERATOR STATUS                       ONLINE
                
WAITFORDATA - SUCCESSFUL                         0   WAITFORDATA - SUCCESSFUL                      0
WAITFORDATA - TIMEDOUT                           0   WAITFORDATA - TIMED OUT                       0

The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.

IDENTIFIER [Q8STNAME]

The accelerator server identifier.

QUERIES SUCCESSFULLY EXECUTED [Q8STSREQ]

The number of SQL statements (sent by this Db2 system since accelerator start) that were successfully executed in the accelerator.

QUERIES FAILED TO EXECUTE [Q8STFREQ]

The number of SQL statements (sent by this Db2 system since accelerator start) that failed to be successfully executed for any reason.

CURRENTLY EXECUTING QUERIES [Q8STNQCS]

The number of currently executing SQL statements in the accelerator on behalf of this Db2 system.

MAXIMUM EXECUTING QUERIES [Q8STMNQS]

Shows the maximum number of SQL statements executing in the accelerator at any time since accelerator start on behalf of this Db2 system.

CPU TIME EXECUTING QUERIES [Q8STTCQS]

The total CPU cost associated with executing SQL statements in the accelerator on behalf of this Db2 system.

CPU TIME LOAD/ARCHIVE/RESTORE [Q8STTCMS]

The total CPU cost spent in the accelerator for data maintenance operations from this Db2 system. Replication-related operations are not included.

CURRENT QUEUE LENGTH [Q8STCQLS]

The current queue length at the accelerator for this Db2 system.

INSERT STMTS SENT TO ACCELERATOR [Q8STINSC]

The number of INSERT statements sent by the Db2 system to the accelerator.

UPDATE STMTS SENT TO ACCELERATOR [Q8STUPDC]

The number of UPDATE statements sent by the Db2 system to the accelerator.

DELETE STMTS SENT TO ACCELERATOR [Q8STDELC]

The number of DELETE statements sent by the Db2 system to the accelerator.

OPEN STMTS SENT TO ACCELERATOR [Q8STOPNC]

The number of OPEN statements sent by the Db2 system to the accelerator.

CREATE STMTS SENT TO ACCELERATOR [Q8STCRTC]

The number of CREATE statements sent by the Db2 system to the accelerator.

DROP STMTS SENT TO ACCELERATOR [Q8STDRPC]

The number of DROP statements sent by the Db2 system to the accelerator.

COMMIT STMTS SENT TO ACCELERATOR [Q8STCMTC]

The number of COMMIT statements sent by the Db2 system to the accelerator.

ROLLBACK STMTS SENT TO ACCELERATOR [Q8STRBKC]

The number of ROLLBACK statements sent by the Db2 system to the accelerator.

CONNECTS TO ACCELERATOR [Q8STCONN]

The number of connects to the accelerator from this Db2 system.

REQUESTS SENT TO ACCELERATOR [Q8STREQ]

The number of Distributed Relational Database Architecture™ (DRDA) requests sent by this Db2 system to the accelerator.

REQUESTS SENT TO ACCELERATOR - TIMED OUT [Q8STTOUT]

The number of connections that were timed out when this Db2 system sent requests to the accelerator.

REQUESTS SENT TO ACCELERATOR - FAILED [Q8STFAIL]

The number of connections that failed when this Db2 system sent requests to the accelerator.

BYTES SENT TO ACCELERATOR [Q8STBYTS]

The total number of bytes sent to the accelerator.

BYTES RECEIVED FROM ACCELERATOR [Q8STBYTR]

The total number of bytes received from the accelerator.

MESSAGES SENT TO ACCELERATOR [Q8STMSGS]

The total number of messages sent to the accelerator.

MESSAGES RECEIVED FROM ACCEL. [Q8STMSGR]

The total number of messages received from the accelerator.

BLOCKS SENT TO ACCELERATOR [Q8STBLKS]

The total number of blocks sent to the accelerator.

BLOCKS RECEIVED FROM ACCELERATOR [Q8STBLKR]

The total number of blocks received from the accelerator.

ROWS SENT TO ACCELERATOR [Q8STROWS]

The total number of rows sent to the accelerator.

ROWS RECEIVED FROM ACCELERATOR [Q8STROWR]

The total number of rows received from the accelerator.

TCP/IP SERVICES ELAPSED TIME [Q8STTELA]

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.

ELAPSED TIME IN ACCELERATOR [Q8STAELA]

The accumulated elapsed time spent in the accelerator when executing requests from the Db2 subsystem.

WAIT TIME IN ACCELERATOR [Q8STAWAT]

The wait time spent in the accelerator when executing requests from the Db2 subsystem.

CPU TIME FOR REPLICATION [Q8STTCCS]

The total CPU cost associated with the replication apply process for this Db2 system.

LOG RECORDS READ [Q8STNLRS]

The number of log records read by the replication capture agent for this Db2 system.

LOG RECORDS READ - LOG RECORDS FOR ACCEL TABLES [Q8STNLTS]

The number of log records (read by the replication capture agent for this Db2 system) that are applicable to tables in this accelerator.

LOG RECORD BYTES PROCESSED [Q8STNBS]

The number of log record bytes processed by the replication capture agent for this Db2 system.

INSERT ROWS FOR ACCEL TABLES [Q8STNIS]

The number of INSERT rows applicable to accelerator tables that were processed by the replication capture agent for this Db2 system.

UPDATE ROWS FOR ACCEL TABLES [Q8STNUS]

The number of UPDATE rows applicable to accelerator tables that were processed by the replication capture agent for this Db2 system.

DELETE ROWS FOR ACCEL TABLES [Q8STNDS]

The number of DELETE rows applicable to accelerator tables that were processed by the replication capture agent for this Db2 system.

REPLICATION LATENCY [Q8STCRL]

The current replication latency for this Db2 system. Latency is defined as the time difference between the timestamp, when the last log record was applied to the target, compared to the current time.

REPLICATION VELOCITY [Q8STVLCS]

The number of Db2 log seconds applied per elapsed second. Db2 log seconds is a measure of the elapsed time between the creation time of the first log record and the last log record applied in a given interval. If the number of log seconds applied is less than the number of seconds elapsed - if the velocity is less than one - then the replication process will not be able to complete.

REPLICATION STATUS CHANGE [Q8STTLSC]

The timestamp when the last change of the accelerator replication state occurred for this Db2 system.

REPLICATION STATUS [Q8STCSS]

The current replication state of the accelerator for this subsystem. The current replication state can be:

STARTED: Replication-enabled tables on this subsystem are currently being replicated (0).
STOPPED: Replication on this subsystem is stopped, no error occurred (1).
ERROR: An error occurred in the replication components for this system (2).
STARTING: Replication components for this subsystem are starting (3).
STOPPING: Replication components are in the process of stopping, for example, waiting until all in-progress work is done (4).
UNKNOWN: Replication state could not be determined (255).

WAITFORDATA - SUCCESSFUL [Q8STTDPS]

The number of queries using the wait for data protocol that were successfully sent to the accelerator.

WAITFORDATA - TIMED OUT [Q8STEDPS]

The number of queries using the wait for data protocol that had their wait time expire.

QUERIES SUCCESSFULLY EXECUTED [Q8STNQSA]

The number of SQL statements (sent by all Db2 systems since accelerator start) that successfully executed in the accelerator.

QUERIES FAILED TO EXECUTE [Q8STNQFA]

Shows the number of SQL statements (sent by all Db2 systems since accelerator start) that were not successfully executed for any reason.

CURRENTLY EXECUTING QUERIES [Q8STACTV]

The number of currently (actively) executing SQL statements in the accelerator on behalf of all Db2 systems (Field name for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STACTV_64).

MAXIMUM EXECUTING QUERIES [Q8STMAXA]

The maximum number of SQL statements actively executing in the accelerator concurrently at any time since accelerator start on behalf of all Db2 systems (Field name for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STMAXA_64).

CPU TIME EXECUTING QUERIES [Q8STTCQA]

The total CPU cost associated with executing SQL statements in the accelerator on behalf of all Db2 systems.

CPU TIME LOAD/ARCHIVE/RESTORE [Q8STTCMA]

The total CPU cost spent in the accelerator for data maintenance operations from all Db2 systems. Replication-related operations are not included.

DISK STORAGE AVAILABLE (MB) [Q8STDSKA]

The disk storage (MB) available at the accelerator.

DISK STORAGE AVAILABLE - IN USE FOR ACCEL DB - ALL Db2 (MB) [Q8STDSA]

The disk storage (MB) in-use for accelerator databases for all Db2 systems.

DISK STORAGE AVAILABLE - IN USE FOR ACCEL DB - THIS Db2(MB) [Q8STDSKB]

The disk storage in-use for accelerator databases for this Db2 system.

DISK STORAGE AVAILABLE - IN USE FOR TEMP DATA - ALL Db2 (MB) [Q8STTSA]

The amount of disk space used by all paired Db2 subsystems for temporary data.

DISK STORAGE AVAILABLE - IN USE FOR LOG DATA - ALL Db2 (MB) [Q8STLSA]

The amount of disk space used by all paired Db2 subsystems for log data.

MAXIMUM QUEUE LENGTH [Q8STMAXQ]

The high watermark of the queue length at the accelerator (Field name for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STMAXQ_64).

CURRENT QUEUE LENGTH [Q8STCQL]

The current queue length at the accelerator.

AVG QUEUE WAIT ELAPSED TIME [Q8STQUEW]

The average wait time at the accelerator queue.

MAX QUEUE WAIT ELAPSED TIME [Q8STQUEM]

The maximum wait time at the accelerator queue.

MEMORY AVAILABLE - USER DATA (MB) [Q8STTMUD]

The total memory available on the accelerator for user data.

MEMORY AVAILABLE - USER REQUESTS (MB) [Q8STTMPS]

The total memory available on the accelerator for user requests.

SORT OVERFLOWS [Q8STOFLW]

The number of sort overflows in the accelerator. A sort overflow means that the SQL statement could not be processed entirely in memory.

BUFFER POOL HIT RATIO (%) [Q8STABHR]

The buffer pool hit ratio for all requests processed by this accelerator.

TRANSFER RATE - INBOUND (KB/S) [Q8STANUI]

The current inbound network data transfer rate in kilobytes per second.

TRANSFER RATE - OUTBOUND (KB/S) [Q8STANUO]

The current outbound network data transfer rate in kilobytes per second.

WORKER NODES [Q8STWNOD]

The number of active worker nodes (Field name for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STWNOD_64).

WORKER NODES DISK UTILIZATION (%) [Q8STDSKU]

The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.

WORKER NODES AVG CPU UTILIZATION (%) [Q8STWCPU]

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 for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STWCPU_64).

COORDINATOR CPU UTILIZATION (%) [Q8STCCPU]

The current CPU utilization on the accelerator coordinator node (Field name for IBM Db2 Analytics Accelerator for z/OS Version 4: Q8STCCPU_64).

PROCESSORS [Q8STCORS]

The number of CPU cores available on all worker nodes.

DATA SLICES [Q8STNMDS]

The number of data slices at the accelerator. This equals the degree of parallel I/O channels.

CPU TIME FOR REPLICATION [Q8STTCCA]

The total CPU cost associated with the replication apply process for all Db2 systems.

LOG RECORDS READ [Q8STNLRA]

The number of log records read by the replication capture agents for all Db2 systems.

LOG RECORDS READ - LOG RECORDS FOR ACCEL TABLES [Q8STNLTA]

The number of log records read by the replication capture agents for all Db2 systems that are applicable to tables in this accelerator.

LOG RECORD BYTES PROCESSED [Q8STNBA]

The number of log record bytes processed by the replication capture agents for all Db2 systems.

INSERT ROWS FOR ACCEL TABLES [Q8STNIA]

The number of INSERT rows applicable to accelerator tables that were processed by the replication capture agents for all Db2 systems.

UPDATE ROWS FOR ACCEL TABLES [Q8STNUA]

The number of UPDATE rows applicable to accelerator tables that were processed by the replication capture agents for all Db2 systems.

DELETE ROWS FOR ACCEL TABLES [Q8STNDA]

The number of DELETE rows applicable to accelerator tables that were processed by the replication capture agents for all Db2 systems.

ACCELERATOR SERVER START [Q8STTART]

The timestamp when the accelerator server process started last time.

ACCELERATOR STATUS CHANGE [Q8STTATC]

The timestamp when the last change of the accelerator occurred.

ACCELERATOR STATUS [Q8STTATE]

Accelerator state. If Q8STPRID is 'AQT04010' or higher, the accelerator state can be:

Initializing: IDAA or the Accelerator backend is currently starting up; no processing can currently take place (0).
Online: IDAA and the Accelerator backend are available and fully operational (1).
Offline: IDAA is available, but the Accelerator backend is not (3).
Maintenance: A maintenance operation is currently running; no query processing can occur (5).
Unknown: IDAA or the Accelerator backend is in an unknown state (255).

If Q8STPRID is lower than 'AQT04010', the accelerator state can be:

INITIALIZED (0).

ONLINE (1).

PAUSED (2).

OFFLINE (3).

STOPPED (4).

MAINTENANCE (5).

DOWN (6).

UNKNOWN (7).

WAITFORDATA - SUCCESSFUL [Q8STTDPA]

The number of queries using the wait for data protocol that were successfully sent to the accelerator.

WAITFORDATA - TIMED OUT [Q8STEDPA]

The number of queries using the wait for data protocol that had their wait time expire.