Accelerator
This topic shows detailed information about Accounting - Accelerator
.
The Accounting Accelerator report block is shown for each accelerator that provided services to a DB2 thread. The block consists of three adjacent columns which contain the accelerator identification, the activity-related counters, and the corresponding times.
- For product identifiers of IBM DB2 Analytics Accelerator for z/OS prior to AQT04015 the values of the following fields are N/A: SQL DML, SQL DDL, ROWS RETURN, COMMIT, and ROLLBACK.
- The Accounting trace shows values and times for each Q8AC section. The Accounting report does not only show accumulated values and times, but also average values and times calculated for one occurrence. It shows the sum of a counter or time of all Q8AC sections processed, divided by the number of processed Q8AC sections.
In the following example both layouts are shown, the report layout is followed by the trace layout.
Accounting - Accelerator
The field labels shown in the following sample layout of Accounting - Accelerator
are
described in the following section.
Report:
ACCELERATOR IDENTIFIER ACCELERATOR AVERAGE TOTAL ACCELERATOR AVERAGE TOTAL
----------- ------------------------------ ----------- ------------ ------------ ------------ ------------ ------------
PRODUCT AQT03010 OCCURRENCES 1.00 1 ELAPSED TIME
SERVER VMNPS14 CONNECTS 1.00 1 SVCS TCP/IP 1:30.772268 1:30.772268
REQUESTS 24877.00 24877 ACCUM ACCEL 0.000000 0.000000
TIMED OUT 0.00 0 CPU TIME
FAILED 0.00 0 SVCS TCP/IP 2.183868 2.183868
SENT ACCUM ACCEL 0.000000 0.000000
BYTES 2439641.00 2439641 WAIT TIME
MESSAGES 24886.00 24886 ACCUM ACCEL 0.000000 0.000000
BLOCKS 0.00 0 HTAP DELAY 0.000000 0.000000
ROWS 0.00 0
RECEIVED
BYTES 817064800.00 817064800
MESSAGES 24886.00 24886
BLOCKS 24875.00 24875
ROWS 0.00 0
SQL DML
INSERT 0.00 0
ROWS 0.00 0
UPDATE 0.00 0
ROWS 0.00 0
DELETE 0.00 0
ROWS 0.00 0
OPEN 0.00 0
SQL DDL
CREATE 0.00 0
DROP 0.00 0
ROWS RETURN 0.00 0
COMMIT 0.00 0
ROLLBACK 0.00 0
HTAP TIMEOUT 0.00 0
Trace:
ACCELERATOR IDENTIFIER ACCELERATOR TOTAL ACCELERATOR TOTAL
----------- ------------------------------ ----------- ------------ ------------ ------------
PRODUCT AQT03010 OCCURRENCES 1 ELAPSED TIME
SERVER VMNPS14 CONNECTS 1 SVCS TCP/IP 11.637221
REQUESTS 2 ACCUM ACCEL 0.000000
TIMED OUT 0 CPU TIME
FAILED 0 SVCS TCP/IP 0.000598
SENT ACCUM ACCEL 0.000000
BYTES 1744 WAIT TIME
MESSAGES 11 ACCUM ACCEL 0.000000
BLOCKS 0 HTAP DELAY 0.000000
ROWS 0 DB2 THREAD
RECEIVED CLASS 1
BYTES 824 ELAPSED 11.647249
MESSAGES 11 CP CPU 0.003386
BLOCKS 0 SE CPU 0.000000
ROWS 0 CLASS 2
SQL DML ELAPSED N/P
INSERT 0 CP CPU N/P
ROWS 0 SE CPU 0.000000
UPDATE 0
ROWS 0
DELETE 0
ROWS 0
OPEN 0
SQL DDL
CREATE 0
DROP 0
ROWS RETURN 0
COMMIT 0
ROLLBACK 0
HTAP TIMEOUT 0
- PRODUCT
-
The accelerator product identifier.
Field Name: Q8ACPRID
- SERVER
-
The accelerator server identifier.
Field Name: Q8ACNAME
- OCCURRENCES
-
The number of sections processed for the accelerator. The name of this accelerator is shown in the report in block ACCELERATOR IDENTIFIER.
Field Name: AIOCCUR
- CONNECTS
-
The number of accelerator connects.
Field Name: Q8ACCONN
- REQUESTS
-
The number of accelerator requests.
Field Name: Q8ACREQ
- TIMED OUT
-
The number of timed out requests.
Field Name: Q8ACTOUT
- FAILED
-
The number of failed requests.
Field Name: Q8ACFAIL
- SENT - BYTES
-
The number of bytes sent.
Field Name: Q8ACBYTS
- SENT - MESSAGES
-
The number of messages sent.
Field Name: Q8ACMSGS
- SENT - BLOCKS
-
The number of blocks sent.
Field Name: Q8ACBLKS
- SENT - ROWS
-
The number of rows sent.
Field Name: Q8ACROWS
- RECEIVED - BYTES
-
The number of bytes returned.
Field Name: Q8ACBYTR
- RECEIVED - MESSAGES
-
The number of messages returned.
Field Name: Q8ACMSGR
- RECEIVED - BLOCKS
-
The number of blocks returned.
Field Name: Q8ACBLKR
- RECEIVED - ROWS
-
The number of rows returned.
Field Name: Q8ACROWR
- SQL DML - INSERT
-
The accumulated number of INSERT statements sent to the accelerator from DB2.
Field Name: Q8ACINSC
- SQL DML - INSERT ROWS
-
The accumulated number of rows inserted to the accelerator by DB2.
Field Name: Q8ACROWI
- SQL DML - UPDATE
-
The accumulated number of UPDATE statements sent to the accelerator from DB2.
Field Name: Q8ACUPDC
- SQL DML - UPDATE ROWS
-
The accumulated number of rows updated on the accelerator by DB2.
Field Name: Q8ACROWU
- SQL DML - DELETE
-
The accumulated number of DELETE statements sent to the accelerator from DB2.
Field Name: Q8ACDELC
- SQL DML - DELETE ROWS
-
The accumulated number of rows deleted on the accelerator by DB2.
Field Name: Q8ACROWD
- SQL DML - OPEN
-
The accumulated number of OPEN statements sent to the accelerator from DB2.
Field Name: Q8ACOPNC
- SQL DDL - CREATE
-
The accumulated number of CREATE statements sent to the accelerator from DB2.
Field Name: Q8ACCRTC
- SQL DDL - DROP
-
The accumulated number of DROP statements sent to the accelerator from DB2.
Field Name: Q8ACDRPC
- ROWS RETURN
-
The accumulated number of rows returned by the accelerator to DB2.
Note: For completed queries, this is the total number of rows returned to DB2. For in-process queries, this is the number of rows that have been sent so far (and more rows may still be coming).Field Name: Q8ACROWC
- COMMIT
-
The accumulated number of COMMIT statements sent to the accelerator from DB2.
Field Name: Q8ACCMTC
- ROLLBACK
-
The accumulated number of ROLLBACK statements sent to the accelerator from DB2.
Field Name: Q8ACRBKC
- HTAP TIMEOUT
-
The number of requests where the replication of data to the accelerator needed to execute the query did not complete before the delay protocol time limit expired (HTAP).
Background and Tuning Information
For more information about how to determine appropriate WAITFORDATA delay time values for query acceleration with replication in your environment, see the IBM Db2 Analytics for z/OS documentation for Hybrid Transactional and Analytical Processing (HTAP) and the WAITFORDATA feature.
Field Name: Q8ACNWDP
- ELAPSED TIME - SVCS TCP/IP
-
The 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: Q8ACTELA
- ELAPSED TIME - ACCUM ACCEL
-
The elapsed time spent in the accelerator when executing requests from the DB2 subsystem.
Field Name: Q8ACAELA
- CPU TIME - SVCS TCP/IP
-
The accelerator services TCP/IP CPU time measured in DB2 for the amount of CPU consumed by the DDF service task to perform the SEND and RECEIVE to an accelerator service. It does not account for the TCP/IP address CPU to route the message on to the network and receive the reply into the DDF task.
Field Name: Q8ACTCPU
- CPU TIME - ACCUM ACCEL
-
The CPU time spent in the accelerator when executing requests from the DB2 subsystem.
Field Name: Q8ACACPU
- WAIT TIME - ACCUM ACCEL
-
The wait time spent in the accelerator when executing requests from the DB2 subsystem.
Field Name: Q8ACAWAT
- WAIT TIME - HTAP DELAY
-
The amount of time spent waiting for completion of data replication to the accelerator using the delay protocol (HTAP).
Background and Tuning Information
For more information about how to determine appropriate WAITFORDATA delay time values for query acceleration with replication in your environment, see the IBM Db2 Analytics for z/OS documentation for Hybrid Transactional and Analytical Processing (HTAP) and the WAITFORDATA feature.
Field Name: Q8ACTWDP
- DB2 THREAD - CLASS 1 - ELAPSED
-
Class 1 elapsed time of the thread. See ADRECETT.
Field Name: ADACCET1
- DB2 THREAD - CLASS 1 - CP CPU
-
Class 1 CP CPU time of the thread. See ADCPUT.
Field Name: ADACCCP1
- DB2 THREAD - CLASS 1 - SE CPU
-
Class 1 SE CPU time of the thread. See AWACC1Z.
Field Name: ADACCSE1
- DB2 THREAD - CLASS 2 - ELAPSED
-
Class 2 elapsed time of the thread. See ADDB2ETT.
Field Name: ADACCET2
- DB2 THREAD - CLASS 2 - CP CPU
-
Class 2 CP CPU time of the thread. See ADDBCPUT.
Field Name: ADACCCP2
- DB2 THREAD - CLASS 2 - SE CPU
-
Class 2 SE CPU time of the thread. See AWACC2Z.
Field Name: ADACCSE2