IFCID 002 - Accelerator Data - Prior to V4
This topic shows detailed information about Record Trace - IFCID 002 - Accelerator
Data - Prior to V4
and refers only to IBM Db2 Analytics Accelerator for z/OS prior to
version 4.
Record trace - IFCID 002 - Accelerator Data - Prior to V4
ACCELERATOR DATA
PRODUCT ID .........: AQT03010
SERVER ID ..........: VMNPS14
STATE ..............: ONLINE
QUERIES SUCCESSFULLY EXECUTED .......: 2 AVG QUEUE LENGTH (LAST 3 HOURS) .....: 0
QUERIES FAILED TO EXECUTE ...........: 0 AVG QUEUE LENGTH (LAST 24 HOURS) ....: 0
ACCELERATOR IN INVALID STATE ......: 0 MAXIMUM QUEUE LENGTH ................: 0
CURRENTLY EXECUTING QUERIES .........: 0 AVG QUEUE WAIT ELAPSED TIME .........: 0.039000
MAXIMUM EXECUTING QUERIES ...........: 4 MAX QUEUE WAIT ELAPSED ..............: 0.392000
CONNECTS TO ACCELERATOR .............: 1 WORKER NODES ........................: 2
REQUESTS SENT TO ACCELERATOR ........: 4 WORKER NODES AVG CPU UTILIZATION (%) : 0.00
TIMED OUT ........................: 0 COORDINATOR AVG CPU UTILIZATION (%) .: 11.00
FAILED ...........................: 0
BYTES SENT TO ACCELERATOR ...........: 2342 DISK STORAGE AVAILABLE (MB) .........: 195426
BYTES RECEIVED FROM ACCELERATOR .....: 99478 IN USE (%) .......................: 22.54
MESSAGES SENT TO ACCELERATOR ........: 13 IN USE FOR DATABASE (MB) .........: 353
MESSAGES RECEIVED FROM ACCELERATOR ..: 13 DATA SLICES .........................: 6
BLOCKS SENT TO ACCELERATOR ..........: 0 DATA SKEW ...........................: 0.43
BLOCKS RECEIVED FROM ACCELERATOR ....: 2
ROWS SENT TO ACCELERATOR ............: 0 PROCESSORS ..........................: 8
ROWS RECEIVED FROM ACCELERATOR ......: 0
TCP/IP SERVICES ELAPSED TIME ........:0.330595 ELAPSED TIME IN ACCELERATOR .........: 0.000000
WAIT TIME IN ACCELERATOR ............:0.000000 CPU TIME SPENT IN ACCELERATOR .......: 0.000000
The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.
- PRODUCT ID [Q8STPRID]
-
The accelerator product identifier.
- SERVER ID [Q8STNAME]
-
The accelerator server identifier.
- STATE [Q8STTATE]
-
Shows the current accelerator state. The state depends on the version of IBM® DB2 Analytics Accelerator for z/OS:
- Version 4:
- 0
- = INITIALIZING
- 1
- = ONLINE
- 3
- = OFFLINE
- 5
- = MAINTENANCE
- 255
- = UNKNOWN
- Prior to Version 4:
- 0
- = INITIALIZED
- 1
- = ONLINE
- 2
- = PAUSED
- 3
- = OFFLINE
- 4
- = STOPPED
- 5
- = MAINTENANCE
- 6
- = DOWN
- 7
- = UNKNOWN
- Version 4:
- 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.
- QUERIES FAILED TO EXECUTE - ACCELERATOR IN INVALID STATE [Q8STFINV]
-
The number of queries (sent by this Db2 system since accelerator start) that failed to be successfully executed, for example, because the accelerator was in an invalid state.
- 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).
- 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 ACCELERATOR [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.
- WAIT TIME IN ACCELERATOR [Q8STAWAT]
-
The wait time spent in the accelerator when executing requests from the Db2 subsystem.
- AVG. QUEUE LENGTH (LAST 3 HOURS) [Q8STAVGQ03]
-
The average queue length during the last 3 hours at the accelerator.
- AVG. QUEUE LENGTH (LAST 24 HOURS) [Q8STAVGQ24]
-
The average queue length during the last 24 hours at the accelerator.
- 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).
- 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.
- 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 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 Db2 Analytics Accelerator for z/OS Version 4: Q8STWCPU_64).
- COORDINATOR AVG 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).
- DISK STORAGE AVAILABLE (MB) [Q8STDSKA]
-
The disk storage (MB) available at the accelerator.
- DISK STORAGE AVAILABLE - IN USE (%) [Q8STDSKU]
-
The current disk utilization of the accelerator worker nodes, expressed as percentage of the used I/O channels/resources.
- DISK STORAGE AVAILABLE - IN USE FOR DATABASE (MB) [Q8STDSKB]
-
The disk storage in-use for accelerator databases for this Db2 system.
- DATA SLICES [Q8STNMDS]
-
The number of data slices at the accelerator. This equals the degree of parallel I/O channels.
- DATA SKEW [Q8STSKEW]
-
When table data is loaded into the accelerator, it may be unevenly distributed across the different data slices on the disks. This disparity is called data skew. The counter represents the accumulated skew over all tables that belong to the Db2 subsystem. The skew of a table is the ratio that shows how uneven the data slices are, as calculated by ((maximum data slice size - minimum data slice size) / median data slice size).
A high value indicates, that data reorganization can improve disk utilization and query performance.
- PROCESSORS [Q8STCORS]
-
The number of CPU cores available on all worker nodes.
- ELAPSED TIME IN ACCELERATOR [Q8STAELA]
-
The accumulated elapsed time spent in the accelerator when executing requests from the Db2 subsystem.
- CPU TIME SPENT IN ACCELERATOR [Q8STACPU]
-
The CPU time spent in the accelerator when executing requests from the Db2 subsystem.