Using the Interval Monitor › Queue Detail (PF8)

Queue Detail (PF8)

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                                 >
  Area Name                    File Name                    Physical  Physical
                                                               Reads    Writes
  SYSTEM.DDLDCRUN              SYSTEM.DCRUN                        0         0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
   Area Name                    Physical     Read     Read    Write    Write
                                  Writes    Waits     Time    Waits     Time
   SYSTEM.DDLDCRUN                     0        0   .0000S        0   .0000S

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
  Area Name                      Write  Buffer Name          Buffer  Prefetch
                                  Time                         Hits      Hits
  SYSTEM.DDLDCRUN               .0000S  DEFAULT_BUFFER            0         0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
  Area Name                   Prefetch  DB_Buf  DB_Buf SHR_Buf SHR_Buf EXC_Buf
                                  Hits   Waits    Time   Waits    Time   Waits
  SYSTEM.DDLDCRUN                    0       0  .0000S       0  .0000S       0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
  Area Name                   EXC_Buf EXC_Buf   DBkey   DBkey D-Space D-Space
                                Waits    Time   Waits    Time   Reads    Hits
  SYSTEM.DDLDCRUN                   0  .0000S       0  .0000S       0       0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
   Area Name                    D-Space  D-Space  Shared Cache Name  Sh-Cache
                                   Hits   Writes                        Reads
   SYSTEM.DDLDCRUN                    0        0                            0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <  >
    Area Name                   Sh-Cache Sh-Cache Sh-Cache Sh-Cache Sh-Cache
                                   Reads     Hits   Writes   Failed    Waits
    SYSTEM.DDLDCRUN                    0        0        0        0        0

 PM-Rnn.n SYSTEM71         CA, Inc.                  V71      08.348 11:13:01.73
 CMD-->                                                             Window : 02

   02 10:30 QUDT Queue Detail                                              <
    Area Name                   Sh-Cache Sh-Cache Sh-Cache Sh-Cache Sh-Cache
                                    Hits   Writes   Failed    Waits     Time
    SYSTEM.DDLDCRUN                    0        0        0        0   .0000S

Screen Description

The Queue Detail screen displays detailed information about the system queue file for the current interval.

What To Look For

• Look for db-key waits.
• Look at the buffer utilization statistics. Buffer Hits indicates the number of times a requested database page was already in the buffer, saving the system from performing an I/O. Buffer Waits indicates when the system had to wait for an available page in the buffer. The Buffer Detail screen provides more statistics about buffer use.