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