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.