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.