Using the Interval Monitor › Scratch Detail (PF6)

Scratch Detail (PF6)

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

   02 10:30 SCDT Scratch Detail                                               >
  Area Name                    File Name                    Physical  Physical
                                                               Reads    Writes
  SYSTEM.DDLDCSCR              SYSTEM.DCSCR                        0         0

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

   02 10:30 SCDT Scratch Detail                                            <  >
   Area Name                    Physical     Read     Read    Write    Write
                                  Writes    Waits     Time    Waits     Time
   SYSTEM.DDLDCSCR                     0        0   .0000S        0   .0000S

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

   02 10:30 SCDT Scratch Detail                                            <  >
  Area Name                      Write  Buffer Name          Buffer  Prefetch
                                  Time                         Hits      Hits
  SYSTEM.DDLDCSCR               .0000S  DEFAULT_BUFFER           15         0

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

   02 10:30 SCDT Scratch Detail                                            <  >
  Area Name                   Prefetch  DB_Buf  DB_Buf SHR_Buf SHR_Buf EXC_Buf
                                  Hits   Waits    Time   Waits    Time   Waits
  SYSTEM.DDLDCSCR                    0       0  .0000S       0  .0000S       0

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

   02 10:30 SCDT Scratch Detail                                            <  >
  Area Name                   EXC_Buf EXC_Buf   DBkey   DBkey D-Space D-Space
                                Waits    Time   Waits    Time   Reads    Hits
  SYSTEM.DDLDCSCR                   0  .0000S       0  .0000S       0       0

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

   02 10:30 SCDT Scratch Detail                                            <  >
   Area Name                    D-Space  D-Space  Shared Cache Name  Sh-Cache
                                   Hits   Writes                        Reads
   SYSTEM.DDLDCSCR                    0        0                            0

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

   02 10:30 SCDT Scratch Detail                                            <  >
    Area Name                   Sh-Cache Sh-Cache Sh-Cache Sh-Cache Sh-Cache
                                   Reads     Hits   Writes   Failed    Waits
    SYSTEM.DDLDCSCR                    0        0        0        0        0

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

   02 10:30 SCDT Scratch Detail                                            <
    Area Name                   Sh-Cache Sh-Cache Sh-Cache Sh-Cache Sh-Cache
                                    Hits   Writes   Failed    Waits     Time
    SYSTEM.DDLDCSCR                    0        0        0        0   .0000S

Screen Description

The Scratch Detail screen displays detailed information about the system scratch file for the current interval. This screen does not include the wait time for the scratch single-threaded event control block (ECB).

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.