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