1 – group_commits_field
This field displays the number of group commit operations
performed by the ALS process. Dividing the number of transactions
by the number of groups gives the average group size (the inverse
of the transaction average display.)
2 – quick_flushes_field
This field gives the number of times users requested their .aij
records be flushed to the .aij file and those records had already
been flushed by the cooperative actions of another user (group
commit).
3 – ARB pool searches field
This field gives the number of times the global after-image
journal request block pool was searched. AIJ records are globally
buffered using ARBs.
4 – ____pre_allocation_field_
This field gives the number of ARBs that are able to be pre-
allocated, resulting in reduced transaction commit or rollback
processing (increased throughput).
5 – ____pool_empty_field_
This field gives the number of times that the global after-image
journal request block (ARB) pool was found to be empty. In this
event, the active user must force a write operation to the after-
image journal file to free an ARB.
6 – cancel:_preemptive_field
This field displays the number of times the background group-
commit operation was canceled because there was no additional
data to be formatted.
7 – IO free format field
This field displays the number of times the foreground group-
commit operation was canceled because there was no additional
data to be formatted.
8 – submit:_watchdog_field
This field displays the number of times the ALS process attempted
to perform a group-commit operation in anticipation of new work
but found none.
9 – ___io_completion_field
This field displays the number of times the group-commit
formatting was completed because the pending asynchronous I/O
operation for the previous group-commit operation completed.
10 – ___cache_overflows_field
This field displays the number of times the 64-block .aij cache
has overflowed.
11 – ___cache_satisfied_field
This field displays the number of times the group-commit
formatting was completed because the cache-size constraints have
been reached.
12 – ___control_record_field
This field displays the number of times the group-commit
formatting was completed because of encountering a control
record for which a process was waiting (and there was no I/O
in progress).
13 – DBR recovery field
This field displays the number of times the group-commit
formatting was completed because the current process is DBR and
the database is frozen.