Thread Accelerator Detail
This panel formats Accelerator activity for the selected thread.
________________ ZTACEL VTM O2 V550./C DA31 08/26/13 19:02:36 2
> Help PF1 Back PF3
> THREAD INFORMATION: Enter a selection letter on the top line.
> A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-LOCKS OWNED E-GLOBAL LOCKS
> F-CURRENT SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J-GROUP BP
> K-PACKAGES L-RES LIMIT M-PARALLEL TASKS N-UTILITY O-OBJECTS
> P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY S-APPL TRACE T-ENCLAVE
> U-LONG NAMES *-ACCEL ACTIVITY
===============================================================================
> THREAD ACCELERATOR DETAIL
PLAN
+ Thread: Plan=WAYNEPLN Connid=RRSAF Corrid=W0438FF3A019 Authid=HONG
+ Attach:
+ Dist : Type=DISTRIBUTED ALLIED, Luwid=DEIBMIPS.IPSASA31.CBDED00A4651=4042
+ Location : VMNPS52
acel
+ Accelerator Data for this thread follows
+ Number of accelerators accessed: 1
+
+ Name:VMNPS52
+ CPU Times Elapsed Times
+ ------------- -------------
+ TCP/IP Services 00:00:00.206
+ Accelerator 00:00:00.000 00:00:00.000
+ Accumulated wait 00:00:00.000
+ Counters
+ --------
+ Connects: 1 Requests: 1
+ Timeouts: 0 Failures: 0
+
+ Data Transfer
+ -------------
+ Sent Received
+ -------- --------
+ Bytes: 3270 799
+ Messages: 11 0
+ Blocks: 0 0
+ Rows: 0 0
+
+ Statements Sent To Accelerator
+ ------------------------------
+ Insert 0
+ Rows inserted 0
+ Update 0
+ Rows updated 0
+ Delete 0
+ Rows deleted 0
+ Drop 0
+ Create 0
+ Commit 0
+ Rollback 0
+ Open 1
+ Rows returned 0
+
+ Accum Wait Time for Delay Protocol 00:00:00.000
+ # Stmts Wait Delay Protocol Expired 0
===============================================================================
Navigation
For additional information about:
- A particular thread, move the cursor to the thread information line and press F11 (Zoom).
- Related topics, select one of the options at the top of the panel.
- Other topics, use the PF keys.
Fields
- Number of Accelerators accessed
- The number of Accelerators that are utilized by this thread. This is followed by a list of information for each Accelerator.
- Name
- The name of the Accelerator.
- CPU Times
- The CPU time that is consumed within the Accelerator device.
- Elapsed Times
- TCP/IP Services
- The total elapsed time from the time Db2 started processing requests until the requests are complete.
- Accelerator
- The total elapsed time that the thread is processed on the Accelerator. The Accelerator time is a subset of the TCP/IP time.
- Accumulated Wait
- The total wait time within the Accelerator.
- Connects
- The number of times the Db2 thread connected to the Accelerator.
- Requests
- The number of requests this thread made to the Accelerator.
- Timeouts
- The number of requests that failed due to a timeout while waiting for the Accelerator.
- Failures
- The total number of failed Accelerator requests. This number includes any timeout errors.
The following fields are related to data transfer between Db2 and the Accelerator.
- Bytes Sent
- The count of bytes of data that is sent to the Accelerator.
- Bytes Received
- The count of bytes of data that is received from the Accelerator.
- Messages Sent
- The count of messages that are sent to the Accelerator.
- Messages Received
- The count of messages that are received from the Accelerator.
- Blocks Sent
- The count of blocks that are sent to the Accelerator.
- Blocks Received
- The count of blocks that are received from the Accelerator.
- Rows Sent
- The count of data rows that are sent to the Accelerator.
- Rows Received
- The count of data rows that are received from the Accelerator.
- Insert
- The count of insert statements sent to the Accelerator.
- Rows inserted
- The count of rows inserted.
- Update
- The count of update statements sent to the Accelerator.
- Rows updated
- The count of rows updated.
- Delete
- The count of delete statements sent to the Accelerator.
- Rows deleted
- The count of rows deleted.
- Drop
- The count of drop statements sent to the Accelerator.
- Create
- The count of create statements sent to the Accelerator.
- Commit
- The count of commit statements sent to the Accelerator.
- Rollback
- The count of rollbacks sent to the Accelerator.
- Open
- The count of open statements sent to the Accelerator.
- Rows returned
- The count of rows returned from the Accelerator.
- Accum Wait Time for Delay Protocol [Q8ACTWDP]
- The amount of time spent waiting for completion of data replication to the accelerator using the delay protocol (HTAP).
- # Stmts Wait Delay Protocol Expired [Q8ACNWDP]
- 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).