The figure shows elapsed times in a DDF environment, as reported by Tivoli® OMEGAMON® XE for Db2® Performance Expert on z/OS® . Table 1 shows a series of distributed events, the location of each event in the distributed environment, and an indication of whether certain trace classes are on during each part of the process.
Table 1. Elapsed times in a DDF environment, as reported by Tivoli OMEGAMON XE for Db2 Performance Expert on z/OS
Event Location Requester Server
Cls1 (1) Cls2 (2) Cls3 (3) Cls3* (4) Cls1 (5) Cls2 (6) Cls3 (7)
Start User address "requester" space              
First SQL statement Db2 requesting system              
Create thread Db2 requesting system On On          
Requester suspension time begins Db2 requesting system On On On        
Process moves to network Network On On On On      
Process moves to Db2 serving system Db2 serving system On On On On On On  
Server suspension time begins Db2 serving system On On On On On On On
Server suspension time ends Db2 serving system On On On On On On  
Process moves to network Network On On On On On    
Process moves to Db2 requesting system Db2 requesting system On On     On    
Process moves to user address "requester" User address "requester" space On       On    
Process moves to Db2 requesting system Db2 requesting system On On     On    
Requester suspension time begins Db2 requesting system On On On   On    
Requester suspension time ends Db2 requesting system On On     On    
Process moves to user address "requester" User address "requester" space On       On    
Process moves to Db2 requesting system Db2 requesting system On On     On    
Requester suspension time begins Db2 requesting system On On On   On    
Process moves to network Network On On On On On    
Process moves to Db2 serving system Db2 serving system On On On On On On  
Server suspension time begins Db2 serving system On On On On On On On
Server suspension time ends Db2 serving system On On On On On On  
Process moves to network Network On On     On    
Process moves to Db2 requesting system Db2 requesting system On On     On    
Process moves to user address "requester" User address "requester" space On       On    
Commit Db2 requesting system On On     On    
Requester suspension time begins Db2 requesting system On On On   On    
Process moves to network Network On On On On On    
Process moves to Db2 serving system Db2 serving system On On On On On On  
Server suspension time begins Db2 serving system On On On On On On On
Server suspension time ends Db2 serving system On On On On On On  
Commit Db2 serving system On On On On On On  
Terminate thread Db2 serving system On On On On On On  
Process moves to network Network On On On On      
Process moves to Db2 requesting system Db2 requesting system On On          
Terminate server thread Db2 requesting system              
End User address "requester" space