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
.
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
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
- Version 4 or higher, the accelerator state can be:
- 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