RMUDISPLAY72.HLB  —  Overview  Screens  Process Journal IO Overview screen
    This screen provides summary RUJ and AIJ journal I/O 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  RUJ.Reads

       This field gives the number of read QIOs (queued I/O requests)
       issued to the database recovery-unit journal (.RUJ) files.
       This operation reads before-image records from the RUJ file to
       roll back a verb or a transaction.

       This statistic field includes both synchronous and
       asynchronous I/O read requests.

    o  RUJ.Writes

       This field gives the number of write QIOs (queued I/O
       requests) issued to the database recovery-unit journal
       (.RUJ) files. This operation writes before-image records to
       the RUJ file in case a verb or transaction must be rolled
       back. Before-images must be written to the RUJ file before
       the corresponding database page can be written back to the
       database.

       This statistic field includes both synchronous and
       asynchronous I/O write requests.

    o  RUJ.Extend

       This field identifies the number of times an RUJ file has been
       extended. Ideally, this value should be "0" or as close to "0"
       as possible. Each RUJ file extension represents a performance
       bottleneck that is easily resolved.

    o  AIJ.Reads

       The number of read QIOs issued to the database after-image
       journal (.AIJ) file. If after-image journaling is not enabled
       for the database this statistic will be zero.

       This statistic field includes both synchronous and
       asynchronous I/O read requests.

    o  AIJ.Writes

       This field gives the total number of write QIOs (queued
       I/O requests) issued to the database after-image journal
       (.AIJ) file. If after-image journaling is not enabled for the
       database, this statistic will be zero. This operation writes
       after-image records to the after-image journal to facilitate
       rollforward recovery using the RMU Recover utility.

       This statistic field includes both synchronous and
       asynchronous I/O write requests.

    o  AIJ.Extend

       This field identifies the number of times an after-image
       journal has been extended. Ideally, this value should be
       "0" or as close to "0" as possible. Each AIJ file extension
       represents a performance bottleneck that is easily resolved.
Close Help