IFCID 002 - Accelerator Data - Subsystem/Group Perspective V4 or later

This topic shows detailed information about Record Trace - IFCID 002 - Accelerator Data - Subsystem/Group Perspective V4 or later.

Note: This topic only refers to IBM DB2 Analytics Accelerator for z/OS version 4 or later.

A value of -1 in the following fields indicates that the status of the acceleration or replication server is unknown:

  • CPU TIME EXECUTING QUERIES
  • CPU TIME LOAD/ARCHIVE/RESTORE
  • WAIT TIME IN ACCELERATOR
  • CPU TIME FOR REPLICATION
  • REPLICATION LATENCY
Note: 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.

Record Trace - IFCID 002 - Accelerator Data - Subsystem/Group Perspective V4 or later

The field labels shown in the following sample layout of Record Trace - IFCID 002 - Accelerator Data - Subsystem/Group Perspective V4 or later are described in the following section. 


                                      ACCELERATOR DATA - SUBSYSTEM/GROUP PERSPECTIVE

PRODUCT ID .........: AQT07052
SERVER ID ..........: IDAAZ59
STATE ..............: ONLINE

QUERIES SUCCESSFULLY EXECUTED .......:                   78   QUERIES FAILED TO EXECUTE ...........:                   21
CURRENTLY EXECUTING QUERIES .........:                    0   CPU TIME EXECUTING QUERIES ..........:             4.320000
MAXIMUM   EXECUTING QUERIES .........:                    1   CPU TIME LOAD/ARCHIVE/RESTORE .......:            58.810000
CURRENT QUEUE LENGTH ................:                    0

CONNECTS TO ACCELERATOR .............:                    2   BYTES    SENT TO ACCELERATOR ........:                 4282
REQUESTS SENT TO ACCELERATOR ........:                    4   BYTES    RECEIVED FROM ACCELERATOR ..:                 3852
REQUESTS TIMED OUT ..................:                    0   MESSAGES SENT TO ACCELERATOR ........:                   22
REQUESTS FAILED .....................:                    0   MESSAGES RECEIVED FROM ACCELERATOR ..:                   22
BLOCKS   SENT TO ACCELERATOR ........:                    0   ROWS     SENT TO ACCELERATOR ........:                    0
BLOCKS   RECEIVED FROM ACCELERATOR ..:                    1   ROWS     RECEIVED FROM ACCELERATOR ..:                   10

ELAPSED TIME IN TCP/IP SERVICES .....:             9.889521   ELAPSED TIME IN ACCELERATOR .........:             9.775866
CPU     TIME IN TCP/IP SERVICES .....:             0.001102   CPU     TIME IN ACCELERATOR .........:             0.000692
ELAPSED TIME IN ACCELERATOR SERVICES :             0.000000   WAIT    TIME IN ACCELERATOR .........:             9.762848
CPU     TIME IN ACCELERATOR SERVICES :             0.000000

CPU TIME FOR LOG READER TASK.........:             0.000000   ZIIP TIME FOR LOG READER TASK........:             0.000000
ZIIP ELIGIBLE TIME FOR LOG READ TASK.:             0.000000

LOG RECORDS READ ....................:                20458   INSERT ROWS FOR ACCELERATOR TABLES ..:                    4
LOG RECORDS FOR ACCELERATOR TABLES ..:                20397   UPDATE ROWS FOR ACCELERATOR TABLES ..:                    0
LOG RECORD BYTES PROCESSED ..........:              1349033   DELETE ROWS FOR ACCELERATOR TABLES ..:                    2
CPU TIME FOR REPLICATION ............:          4:57.779008   REPLICATION LATENCY .................:             1.000000
REPLICATION STATUS ..................:                    0   REPLICATION VELOCITY ................:             1.062799
REPLICATION STATUS CHANGE ...........: 09/28/20 17:52:29.264347

WAITFORDATA - SUCCESSFUL ............:                   10   WAITFORDATA - TIMED OUT .............:                   21
PRODUCT ID

The accelerator product identifier.

Field Name: Q8STPRID

SERVER ID

The accelerator server identifier.

Field Name: Q8STNAME

STATE

Shows the current accelerator state. The state depends on the version of IBM® DB2® Analytics Accelerator for z/OS:

  • Version 4 or higher, the accelerator state can be:
    0
    = Initializing: IDAA or the Accelerator backend is currently starting up; no processing can currently take place.
    1
    = Online: IDAA and the Accelerator backend are available and fully operational.
    3
    = Offline: IDAA is available, but the Accelerator backend is not. Note: It is very difficult to get the OFFLINE scenario with V7 because apstop will shut down the whole container which include the connection to Db2. So at the Db2 side, accelerator becomes FLATLINE. But the Q8STTATE in IFCID 2 still keeps the last state before it transitions into FLATLINE. APAR PH17726 set Q8STTATE into 255 for the above scenario.
    5
    = Maintenance: A maintenance operation is currently running; no query processing can occur.
    255
    = Unknown: IDAA or the Accelerator backend is in an unknown state.
  • Prior to Version 4:
    0
    = INITIALIZED
    1
    = ONLINE
    2
    = PAUSED
    3
    = OFFLINE
    4
    = STOPPED
    5
    = MAINTENANCE
    6
    = DOWN
    7
    = UNKNOWN

Background and Tuning Information

Shows the current accelerator state. The state depends on the version of IBM DB2 Analytics Accelerator for z/OS:

  • Version 4 or higher, the accelerator state can be:
    0
    = Initializing: IDAA or the Accelerator backend is currently starting up; no processing can currently take place.
    1
    = Online: IDAA and the Accelerator backend are available and fully operational.
    3
    = Offline: IDAA is available, but the Accelerator backend is not. Note: It is very difficult to get the OFFLINE scenario with V7 because apstop will shut down the whole container which include the connection to Db2. So at the Db2 side, accelerator becomes FLATLINE. But the Q8STTATE in IFCID 2 still keeps the last state before it transitions into FLATLINE. APAR PH17726 set Q8STTATE into 255 for the above scenario.
    5
    = Maintenance: A maintenance operation is currently running; no query processing can occur.
    255
    = Unknown: IDAA or the Accelerator backend is in an unknown state.
  • Prior to Version 4:
    0
    = INITIALIZED
    1
    = ONLINE
    2
    = PAUSED
    3
    = OFFLINE
    4
    = STOPPED
    5
    = MAINTENANCE
    6
    = DOWN
    7
    = UNKNOWN

Field Name: Q8STTATE

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

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

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 TIMED OUT

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

Field Name: Q8STTOUT

REQUESTS FAILED

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

Field Name: Q8STFAIL

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

ELAPSED TIME IN TCP/IP SERVICES

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

CPU TIME IN TCP/IP SERVICES

The accelerator services TCP/IP CPU time measured in DB2. It starts when sending the requests to the accelerator and ends when receiving the results from the accelerator.

Field Name: Q8STTCPU

ELAPSED TIME IN ACCELERATOR SERVICES

The accelerator services elapsed time.

Field Name: Q8STSELA

CPU TIME IN ACCELERATOR SERVICES

The CPU time of the accelerator services.

Field Name: Q8STSCPU

CPU TIME FOR LOG READER TASK

CPU time that was consumed by the asynchronous log reader task for this IDAA during the reporting interval. This value does not include CPU consumed on an IBM zIIP.

Field Name: Q8STLRCP

ZIIP ELIGIBLE TIME FOR LOG READ TASK

CPU time that was consumed by the asynchronous log reader task for this IDAA on standard processors during the reporting interval, and those tasks were eligible for execution on an IBM zIIP.

Field Name: Q8STLRZE

LOG RECORDS READ

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

Field Name: Q8STNLRS

LOG RECORDS FOR ACCELERATOR 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

CPU TIME FOR REPLICATION

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:

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

Background and Tuning Information

The current replication state of the accelerator for this DB2 system:

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

Field Name: Q8STCSS

REPLICATION STATUS CHANGE

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

Field Name: Q8STTLSC

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

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

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 ACCELERATOR

The total number of messages received from the accelerator.

Field Name: Q8STMSGR

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

ELAPSED TIME IN ACCELERATOR

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

Field Name: Q8STAELA

CPU TIME IN ACCELERATOR

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

Field Name: Q8STACPU

WAIT TIME IN ACCELERATOR

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

Field Name: Q8STAWAT

ZIIP TIME FOR LOG READER TASK

CPU time that was consumed on an IBM zIIP by the asynchronous log reade task for this IDAA during the reporting interval.

Field Name: Q8STLRZI

INSERT ROWS FOR ACCELERATOR 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 ACCELERATOR 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 ACCELERATOR 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