IFCID 002 - Accelerator Data - Accelerator Perspective V4 or later

This topic shows detailed information about Record Trace - IFCID 002 - Accelerator Data - Accelerator Perspective V4 or later and refers only 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
  • AVG QUEUE WAIT ELAPSED TIME
  • MAX QUEUE WAIT ELAPSED TIME
  • WORKER NODES DISK UTILIZATION (%)
  • WORKER NODES AVG CPU UTILIZATION (%)
  • COORDINATOR CPU UTILIZATION (%)
  • CPU TIME FOR REPLICATION
Note: The descriptions of the fields labeled with 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 and the fields INSERT STMTS to ROLLBACK STMTS are N/A.

Record trace - IFCID 002 - Accelerator Data - Accelerator Perspective V4 or later 


                    ACCELERATOR DATA - ACCELERATOR PERSPECTIVE                                       
                                                                                                                         
QUERIES SUCCESSFULLY EXECUTED .....:                2   QUERIES FAILED TO EXECUTE ..............:         0
CURRENTLY EXECUTING QUERIES .......:                0   CPU TIME EXECUTING QUERIES..............: 43.440000
MAXIMUM   EXECUTING QUERIES .......:                1   CPU TIME LOAD/ARCHIVE/RESTORE ..........: 18.880000
                                                                                                                         
ACCELERATOR SERVER START ............: 12/16/13 09:38:08.975827        
ACCELERATOR STATUS CHANGE ...........: 12/16/13 09:38:14.665673         
                                                                                                                         
CURRENT QUEUE LENGTH ................:                0   DISK STORAGE AVAILABLE (MB) ..........:   8024544
MAXIMUM QUEUE LENGTH ................:                0   DISK STOR IN USE - THIS DB2 SYS (MB) .:       743
AVG QUEUE WAIT ELAPSED TIME .........:         0.005356   DISK STOR IN USE - ALL  DB2 SYS (MB) .:     15541
MAX QUEUE WAIT ELAPSED TIME .........:         0.518395   DISK STOR IN USE - TMP DAT ALL DB2(MB):         0
                                                          DISK STOR IN USE - LOG DAT ALL DB2(MB):         0

WORKER NODES DISK UTILIZATION (%) ...:             0.00   WORKER NODES .........................:         3
WORKER NODES AVG CPU UTILIZATION (%) :             0.99   AVAILABLE CPU CORES ..................:        48
COORDINATOR CPU UTILIZATION (%) .....:            10.00   DATA SLICES ..........................:        22

LOG RECORDS READ ....................:          4142180   INSERT ROWS FOR ACCELERATOR TABLES ...:         6
LOG RECORDS FOR ACCELERATOR TABLES ..:          2839302   UPDATE ROWS FOR ACCELERATOR TABLES ...:         0
LOG RECORD BYTES PROCESSED ..........:        187458080   DELETE ROWS FOR ACCELERATOR TABLES ...:         0
CPU TIME FOR REPLICATION ............:        15.616267 
MEMORY AVAILABLE - USER DATA (MB) ...:                0   MEMORY AVAILABLE - USER REQS (MB) ....:         0 
TRANSFER RATE - INBOUND (KB/SEC) ....:                0   TRANSFER RATE - OUTBOUND (KB/SEC) ....:         0
SORT OVERFLOWS ......................:                0   BUFFER POOL HIT RATIO (%) ............:      0.00
WAITFORDATA - SUCCESSFUL ............:              154   WAITFORDATA - TIMED OUT ..............:        40

The fields shown in this record block are described below. Db2 field names are shown in brackets next to each report field.

QUERIES SUCCESSFULLY EXECUTED [Q8STNQSA]

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

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).

ACCELERATOR SERVER START [Q8STTART]

The timestamp when the accelerator server process started last time.

ACCELERATOR STATUS CHANGE [Q8STTATC]

The timestamp when the last change of the accelerator occurred.

CURRENT QUEUE LENGTH [Q8STCQL]

The current queue length 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 DISK UTILIZATION (%) [Q8STDSKU]

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

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

COORDINATOR 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).

LOG RECORDS READ [Q8STNLRA]

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

LOG RECORDS FOR ACCELERATOR TABLES [Q8STNLTA]

The number of log records read by the replication capture agents for all Db2 systems that are applicable to tables in this accelerator.

LOG RECORD BYTES PROCESSED [Q8STNBA]

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

CPU TIME FOR REPLICATION [Q8STTCCA]

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

MEMORY AVAILABLE - USER DATA (MB) [Q8STTMUD]

The total memory available on the accelerator for user data.

TRANSFER RATE - INBOUND (KB/SEC) [Q8STANUI]

The current inbound network data transfer rate in kilobytes per second.

SORT OVERFLOWS [Q8STOFLW]

The number of sort overflows in the accelerator. A sort overflow means that the SQL statement could not be processed entirely in memory.

WAITFORDATA - SUCCESSFUL [Q8STTDPA]

The number of queries using the wait for data delay protocol that were successfully sent to the accelerator.

QUERIES FAILED TO EXECUTE [Q8STNQFA]

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

CPU TIME EXECUTING QUERIES [Q8STTCQA]

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

CPU TIME LOAD/ARCHIVE/RESTORE [Q8STTCMA]

The total CPU cost spent in the accelerator for data maintenance operations from all Db2 systems. Replication-related operations are not included.

DISK STORAGE AVAILABLE (MB) [Q8STDSKA]

The disk storage (MB) available at the accelerator.

DISK STOR IN USE - THIS DB2 SYS (MB) [Q8STDSKB]

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

DISK STOR IN USE - ALL DB2 SYS (MB) [Q8STDSA]

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

DISK STOR IN USE - TMP DAT ALL DB2 (MB) [Q8STTSA]

The amount of disk space used by all paired Db2 subsystems for temporary data.

DISK STOR IN USE - LOG DAT ALL DB2 (MB) [Q8STLSA]

The amount of disk space used by all paired Db2 subsystems for log data.

WORKER NODES [Q8STWNOD]

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

AVAILABLE CPU CORES [Q8STCORS]

The number of CPU cores available on all worker nodes.

DATA SLICES [Q8STNMDS]

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

INSERT ROWS FOR ACCELERATOR TABLES [Q8STNIA]

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

UPDATE ROWS FOR ACCELERATOR TABLES [Q8STNUA]

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

DELETE ROWS FOR ACCELERATOR TABLES [Q8STNDA]

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

MEMORY AVAILABLE - USER REQS (MB) [Q8STTMPS]

The total memory available on the accelerator for user requests.

TRANSFER RATE - OUTBOUND (KB/SEC) [Q8STANUO]

The current outbound network data transfer rate in kilobytes per second.

BUFFER POOL HIT RATIO (%) [Q8STABHR]

The buffer pool hit ratio in percentage for all requests processed by this accelerator.

WAITFORDATA - TIMED OUT [Q8STEDPA]

The number of queries using the wait for data delay protocol that had their wait time expire.