IFCID 002 - Accelerator Data - Prior to V4

This topic shows detailed information about "Record Trace - IFCID 002 - Accelerator Data - Prior to V4".

This topic only refers to IBM DB2 Analytics Accelerator for z/OS prior to version 4.

Note: The field descriptions of the fields QUERIES SUCCESSFULLY EXECUTED, QUERIES FAILED TO EXECUTE, CURRENTLY EXECUTING QUERIES, and MAXIMUM EXECUTING 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.

Record trace - IFCID 002 - Accelerator Data - Prior to V4

The field labels shown in the following sample layout of "Record Trace - IFCID 002 - Accelerator Data - Prior to V4" are described in the following section.

                                                     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

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:
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

Field Name: Q8STTATE

QUERIES 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

QUERIES 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

QUERIES FAILED TO EXECUTE - ACCELERATOR IN INVALID STATE

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.

Field Name: Q8STFINV

CURRENTLY EXECUTING QUERIES

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 QUERIES

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

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 ACCELERATOR

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

WAIT TIME IN ACCELERATOR

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

Field Name: Q8STAWAT

AVG. QUEUE LENGTH (LAST 3 HOURS)

Start of change The average queue length during the last 3 hours at the accelerator. End of change

Field Name: Q8STAVGQ03

AVG. QUEUE LENGTH (LAST 24 HOURS)

The average queue length during the last 24 hours at the accelerator.

Field Name: Q8STAVGQ24

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

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 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 AVG 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

DISK STORAGE AVAILABLE (MB)

The disk storage (MB) available at the accelerator.

Field Name: Q8STDSKA

DISK STORAGE AVAILABLE - IN USE (%)

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

Field Name: Q8STDSKU

DISK STORAGE AVAILABLE - IN USE FOR DATABASE (MB)

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

Field Name: Q8STDSKB

DATA SLICES

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

Field Name: Q8STNMDS

DATA SKEW

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.

Field Name: Q8STSKEW

PROCESSORS

The number of CPU cores available on all worker nodes.

Field Name: Q8STCORS

ELAPSED TIME IN ACCELERATOR

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

Field Name: Q8STAELA

CPU TIME SPENT IN ACCELERATOR

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

Field Name: Q8STACPU

Feedback