RMUDISPLAY72.HLB  —  Overview  Screens  Process Record Overview screen
    This screen provides summary record access information for
    all processes activated to collect global statistics using the
    Process Monitoring facility.

    The processes displayed on this screen have previously activated
    their global statistics collection. Process global statistic
    collection can be either implicitly activated by the database
    monitor, or explicitly activated by the RMU Show Statistic
    utility.

    This screen provides the following information:

    o  Process.ID

       The process ID for the current process, assigned by the
       operating system, and the stream ID, assigned by the database.
       If "G" is appended to the process ID, the process had been
       activated for global statistics collection; this is the normal
       case. Server processes will be designated with the "s" tag.

    o  RecFetched

       This field gives the number of records fetched, including
       snapshot records. This field does not include records
       retrieved from a temporary table.

       Note that this value may be more than the actual number of
       records returned by a query. The reason is that queries may
       fetch records during the search phase, and then refetch the
       selected records so that they may be returned to the user.
       Also, for uniform format storage areas, a sequential scan
       needs to fetch the "next" record on each page of the clump,
       even if there are no records on that page. In addition, every
       page in a uniform format storage area incurs an extra fetch to
       verify that there are no more records residing on that page.

    o  Rec.Marked

       This field gives the number of records marked. A record is
       marked when it is modified or it is erased, but not when it
       is stored. This field does not include records modified in a
       temporary table.

    o  Rec.Stored

       This field gives the number of records stored in the database.
       This field does not include records stored in temporary
       tables.

    o  Pag.Checkd

       This field indicates the number of pages checked in order
       to store a record. Ideally, very few candidate pages need to
       be checked when storing a record. However in certain cases,
       depending on record size, access method, locked space on a
       page, and SPAM thresholds, storing a record requires a number
       of page fetches.

    o  PagDiscard

       This field identifies the number of pages checked but
       discarded because the actual free space on that page did not
       meet the physical requirements needed to store a new record.

    o  Rec.Erased

       This field gives the number of records erased from the
       database. This field does not include records erased from
       temporary tables.
Close Help