Distributed Location Detail window

Use the Distributed Location Detail window to view information about the serving location selected from the Distributed Data window. This window displays a list of conversations between the thread and this serving location. If many conversations are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list.

To display this window, select any serving location listed in the Distributed Data window.

Figure 1. Distributed Location Detail window

 DGOMTWDL           Distributed Location Detail              ROW 1 TO 2 OF 2

 For additional details, place any character next to conversation, then
 press Enter.

 Remote Location  . . . . . . . . . . : DSNAPC0
 Product ID . . . . . . . . . . . . . : DB2
 Product Version  . . . . . . . . . . : V10 R1 M0
 Requester elapsed  . . . . . . . . . :             7.5908
 Messages Sent  . . . . . . . :     66  Remote Elapsed . . . . . :    3.4373
 Messages Received  . . . . . :     66  Remote CPU . . . . . . . :    0.0731

   ------ Conversation -------              Time of
   State          Type                 last message
 _ SEND           APPL-DIR              03:27:51.15
 _ ALLOC          SYST-DIR              02:37:52.12
 -- End of Distributed Data --

 Command ===> ______________________________________________________________
  F1=Help     F2=Split    F3=Exit     F5=Auto     F6=History   F7=Up
  F8=Down     F9=Swap    F12=Cancel  F16=Look    F17=Collect  F22=Purge

From this window you can select any conversation listed to display the Distributed Conversation Detail window, where the conversation can be examined in greater detail.

The following list describes some of the important fields that are shown in this window:

Requester elapsed

This field shows the elapsed time spent at the requester between the sending of the SQL statement and the receipt of the answer from the server. This includes the processing time in DB2®, VTAM®, and the network.

If this value is large, it could indicate block fetch might not have been used.

Messages Received

This field shows the count of the messages the requester location received from the server location.

More messages might be sent from the server location than are received by the requester location because of the manner in which distributed SQL statements are processed internally.

Remote Elapsed

This field shows the elapsed time spent at the server between the actual receipt of the SQL statement and until the answer is sent to VTAM.

This is not applicable to the Distributed Relational Database Architecture (DRDA).

Comparison of this time with elapsed time (class 2) reveals how much time is spent by the allied distributed thread in remote processing.

Remote CPU

This field shows the CPU time spent at the server from the actual receipt of the SQL statement until the answer is sent to VTAM.

This is not applicable to DRDA.