Distributed Data window

Use the Distributed Data window to view a list of serving locations that are communicating with the thread. If many locations are listed, you can use the scrolling keys F7 (Up) and F8 (Down) to browse the list.

To display this window, select Distributed Data from the Thread Detail panel.

Some fields can have values that are longer than the space available to show them in this panel. When this happens, the last character in the field is replaced with an asterisk (*) to indicate that the reported value is truncated.

 DGOMTWDD                 Distributed Data

 For additional details, type any character next to location, then
 press Enter.

                          Messages         Messages        Requester
   Location                   Sent         Received          Elapsed
 _ DSNAPC0                      66               66           7.5908
 _ DSNAPC9                   12345            12345           6.2222
 -- 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

The Distributed Data Facility (DDF) enables an application process connected to one RDB (Relational Database) subsystem to access data residing on other RDB subsystems.

From the Distributed Data window and its lower level windows, you can examine any serving location communicating with the thread, and view any conversations sent between the thread and that serving location in detail. Select any serving location listed in this window to display the Distributed Location Detail window for further examination.

The combination of the Buffer Manager Activity window, SQL Statement and Package/DBRM window, and Distributed Data window can provide a picture of where allied-distributed thread time is spent.