Accelerator Data - Version 4 or later

This topic shows detailed information about "Statistics - Accelerator Data - Version 4 or later".

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 part consists of accelerator performance metrics from a subsystem or data sharing group perspective. The right parts contains total values from an accelerator perspective. The accelerator name is shown in the header line of each column.

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. As for other counters, 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 in the left part. On the contrary, the corresponding total accelerator values in the right part are snapshot counters. This is due to the fact, that the replication can be disabled during the reporting period such that the accelerator only 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 p erformance 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 labelled with SQL STMTS 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

The field labels shown in the following sample layout of "Statistics - Accelerator Data - Version 4 or later" are described in the following section.

TF3              FOR SUBSYSTEM/GROUP              QUANTITY    TF3              TOTAL ACCELERATOR                QUANTITY
------------------------------------  --------------------    ------------------------------------  --------------------
SQL STMTS SUCCESSFULLY EXECUTED                      1.00    SQL STMTS SUCCESSFULLY EXECUTED                       1.00
SQL STMTS FAILED TO EXECUTE                          0.00    SQL STMTS FAILED TO EXECUTE                           0.00
CURRENTLY EXECUTING SQL STMTS                        0.70    CURRENTLY EXECUTING SQL STMTS                         0.70
MAXIMUM EXECUTING SQL STMTS                          1.00    MAXIMUM EXECUTING SQL STMTS                           1.00
CPU TIME EXECUTING SQL STMTS                     1.790000    CPU TIME EXECUTING SQL STMTS                      1.790000
CPU TIME LOAD/ARCHIVE/RESTORE                   20.260000    CPU TIME LOAD/ARCHIVE/RESTORE                    20.260000
                                                      
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                                                                    
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    WORKER NODES                                          3.00      
  TIMED OUT                                          0.00    WORKER NODES DISK UTILIZATION (%)                     0.00      
  FAILED                                             0.00    WORKER NODES AVG CPU UTILIZATION (%)                  2.09      
BYTES SENT TO ACCELERATOR                      1204453.00    COORDINATOR CPU UTILIZATION (%)                      11.59      
BYTES RECEIVED FROM ACCELERATOR              402373564.00    PROCESSORS                                           48.00      
MESSAGES SENT TO ACCELERATOR                     12272.00    DATA SLICES                                          22.00                                                                  
MESSAGES RECEIVED FROM ACCEL                     12272.00                                                                
BLOCKS SENT TO ACCELERATOR                           0.00    CPU TIME FOR REPLICATION                          0.148773  
BLOCKS RECEIVED FROM ACCELERATOR                 12250.00    LOG RECORDS READ                                 137055.00  
ROWS SENT TO ACCELERATOR                             0.00      LOG RECORDS FOR ACCEL TABLES                     1456.00  
ROWS RECEIVED FROM ACCELERATOR                       0.00    LOG RECORD BYTES PROCESSED                        97265.00  
                                                             INSERT ROWS FOR ACCEL TABLES                          0.00  
TCP/IP SERVICES ELAPSED TIME                    12.937895    UPDATE ROWS FOR ACCEL TABLES                          0.00  
ELAPSED TIME IN ACCELERATOR                      0.000000    DELETE ROWS FOR ACCEL TABLES                          0.00  
WAIT TIME IN ACCELERATOR                         0.000000                                                                
                                                             ACCELERATOR SERVER START              12/16/13 09:38:08.97  
CPU TIME FOR REPLICATION                         0.085255    ACCELERATOR STATUS CHANGE             12/16/13 09:38:14.66  
LOG RECORDS READ                                   945.00    
  LOG RECORDS FOR ACCEL TABLES                     940.00    
LOG RECORD BYTES PROCESSED                       63209.00    
INSERT ROWS FOR ACCEL TABLES                         0.00    
UPDATE ROWS FOR ACCEL TABLES                         0.00    
DELETE ROWS FOR ACCEL TABLES                         0.00    
REPLICATION LATENCY                              0.000000
REPLICATION STATUS CHANGE            12/16/13 09:38:49.79

IDENTIFIER

The accelerator server identifier.

Field Name: Q8STNAME

SQL STMTS SUCCESSFULLY EXECUTED

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

Field Name: Q8STSREQ

SQL STMTS FAILED TO EXECUTE

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

Field Name: Q8STFREQ

CURRENTLY EXECUTING SQL STMTS

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

Field Name: Q8STNQCS

MAXIMUM EXECUTING SQL STMTS

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

Field Name: Q8STMNQS

CPU TIME EXECUTING SQL STMTS

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

Field Name: Q8STTCQS

CPU TIME LOAD/ARCHIVE/RESTORE

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

INSERT STMTS SENT TO ACCELERATOR

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

Field Name: Q8STINSC

UPDATE STMTS SENT TO ACCELERATOR

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

Field Name: Q8STUPDC

DELETE STMTS SENT TO ACCELERATOR

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

Field Name: Q8STDELC

OPEN STMTS SENT TO ACCELERATOR

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

Field Name: Q8STOPNC

CREATE STMTS SENT TO ACCELERATOR

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

Field Name: Q8STCRTC

DROP STMTS SENT TO ACCELERATOR

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

Field Name: Q8STDRPC

COMMIT STMTS SENT TO ACCELERATOR

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

Field Name: Q8STCMTC

ROLLBACK STMTS SENT TO ACCELERATOR

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

Field Name: Q8STRBKC

CONNECTS TO ACCELERATOR

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

Field Name: Q8STCONN

REQUESTS SENT TO ACCELERATOR

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

Field Name: Q8STREQ

REQUESTS SENT TO ACCELERATOR - TIMED OUT

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

Field Name: Q8STTOUT

REQUESTS SENT TO ACCELERATOR - FAILED

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

Field Name: Q8STFAIL

BYTES SENT TO ACCELERATOR

The total number of bytes sent to the accelerator.

Field Name: Q8STBYTS

BYTES RECEIVED FROM ACCELERATOR

The total number of bytes received from the accelerator.

Field Name: Q8STBYTR

MESSAGES SENT TO ACCELERATOR

The total number of messages sent to the accelerator.

Field Name: Q8STMSGS

MESSAGES RECEIVED FROM ACCEL.

The total number of messages received from the accelerator.

Field Name: Q8STMSGR

BLOCKS SENT TO ACCELERATOR

The total number of blocks sent to the accelerator.

Field Name: Q8STBLKS

BLOCKS RECEIVED FROM ACCELERATOR

The total number of blocks received from the accelerator.

Field Name: Q8STBLKR

ROWS SENT TO ACCELERATOR

The total number of rows sent to the accelerator.

Field Name: Q8STROWS

ROWS RECEIVED FROM ACCELERATOR

The total number of rows received from the accelerator.

Field Name: Q8STROWR

TCP/IP SERVICES 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

ELAPSED TIME IN ACCELERATOR

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

Field Name: Q8STAELA

WAIT TIME IN ACCELERATOR

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

Field Name: Q8STAWAT

CPU TIME FOR REPLICATION

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

Field Name: Q8STTCCS

LOG RECORDS READ

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

Field Name: Q8STNLRS

LOG RECORDS READ - LOG RECORDS FOR ACCEL TABLES

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

LOG RECORD BYTES PROCESSED

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

Field Name: Q8STNBS

INSERT ROWS FOR ACCEL TABLES

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

Field Name: Q8STNIS

UPDATE ROWS FOR ACCEL TABLES

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

Field Name: Q8STNUS

DELETE ROWS FOR ACCEL TABLES

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

Field Name: Q8STNDS

REPLICATION LATENCY

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.

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

SQL STMTS SUCCESSFULLY EXECUTED

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

Field Name: Q8STNQSA

SQL STMTS FAILED TO EXECUTE

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

Field Name: Q8STNQFA

CURRENTLY EXECUTING SQL STMTS

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

Field Name: Q8STACTV

MAXIMUM EXECUTING SQL STMTS

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 DB2 Analytics Accelerator for z/OS Version 4: Q8STMAXA_64).

Field Name: Q8STMAXA

CPU TIME EXECUTING SQL STMTS

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

Field Name: Q8STTCQA

CPU TIME LOAD/ARCHIVE/RESTORE

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

DISK STORAGE AVAILABLE (MB)

The disk storage (MB) available at the accelerator.

Field Name: Q8STDSKA

DISK STORAGE AVAILABLE - IN USE FOR ACCEL DB - ALL DB2 (MB)

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

Field Name: Q8STDSA

DISK STORAGE AVAILABLE - IN USE FOR ACCEL DB - THIS DB2(MB)

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

Field Name: Q8STDSKB

MAXIMUM QUEUE LENGTH

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

Field Name: Q8STMAXQ

CURRENT QUEUE LENGTH

Start of change The current queue length at the accelerator. End of change

Field Name: Q8STCQL

AVG QUEUE WAIT ELAPSED TIME

Start of change The average wait time at the accelerator queue. End of change

Field Name: Q8STQUEW

MAX QUEUE WAIT ELAPSED TIME

Start of change The maximum wait time at the accelerator queue. End of change

Field Name: Q8STQUEM

WORKER NODES

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

Field Name: Q8STWNOD

WORKER NODES DISK UTILIZATION (%)

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

Field Name: Q8STDSKU

WORKER NODES AVG CPU UTILIZATION (%)

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

Field Name: Q8STWCPU

COORDINATOR CPU UTILIZATION (%)

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

Field Name: Q8STCCPU

PROCESSORS

The number of CPU cores available on all worker nodes.

Field Name: Q8STCORS

DATA SLICES

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

Field Name: Q8STNMDS

CPU TIME FOR REPLICATION

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

Field Name: Q8STTCCA

LOG RECORDS READ

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

Field Name: Q8STNLRA

LOG RECORDS READ - LOG RECORDS FOR ACCEL TABLES

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 RECORD BYTES PROCESSED

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

Field Name: Q8STNBA

INSERT ROWS FOR ACCEL TABLES

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

Field Name: Q8STNIA

UPDATE ROWS FOR ACCEL TABLES

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

Field Name: Q8STNUA

DELETE ROWS FOR ACCEL TABLES

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

Field Name: Q8STNDA

ACCELERATOR SERVER START

The timestamp when the accelerator server process started last time.

Field Name: Q8STTART

ACCELERATOR STATUS CHANGE

The timestamp when the last change of the accelerator occurred.

Field Name: Q8STTATC

Feedback