Pages read

Specifies the number of database pages physically read.

Pages written

Specifies the number of requests made to write a database page.

Pages requested

Specifies the number of times the DBMS requested that a database page can be read.

CALC record on target page

Specifies the number of times a CALC record was stored and the record occurrence fit on its target page.

CALC record overflow

Specifies the number of times a CALC record was stored and the record occurrence overflowed its target page.

VIA record on target page

Specifies the number of times a VIA record was stored and the record occurrence fit on its target page.

VIA record overflow

Specifies the number of times a VIA record was stored and the record occurrence overflowed its target page.

Record requested

Specifies the total number of record occurrences the DBMS accessed to satisfy DML requests.

Records current of run-unit

Specifies the number of record occurrences that were made current of run-unit.

Calls to the DBMS

Specifies the total number of DML commands passed from the user application to the DBMS.

Fragments stored

Specifies the number of variable length record fragments (SR4) stored by the run-unit.

Relocated records

With a non-SQL defined database: Specifies the number of variable length record fragments or relocated records brought back to their original root or target page.

With an SQL defined database: Specifies the number of records relocated from or returned to their original target page.

Locks requested

Specifies the total number of record locks requested.

Select locks held

Specifies the number of select (shared) locks held at the end of the run-unit.

Update locks held

Specifies the number of update (exclusive) locks held at the end of the run-unit.

SR8 records split

Specifies the number of SR8 records that were split during the life of the run-unit.

SR8 spawns

Specifies the number of times that a new level of an index was created due to the splitting of the index's top level SR8.

SR8 records stored

Specifies the number of SR8 records of all levels that were stored into the database.

SR8 records erased

Specifies the number of SR8 records of all levels that were erased from the database.

SR7 records stored

Specifies the number of SR7 records stored into the database.

SR7 records erased

Specifies the number of SR7 records erased from the database.

Total binary searches

Specifies the total number of times the DBMS initiated a binary search against an index.

Levels searched

Incremented every time that the DBMS goes down a level during a binary search throughout the life of the entire run-unit across all accessed indexes.

Orphans adopted

Specifies the number of orphaned user records that were adopted back to their referencing level-0 SR8.

Fewest levels searched

Specifies the fewest number of levels walked during a binary search throughout the life of the run-unit.

Most levels searched

Specifies the greatest number of levels walked during a binary search throughout the life of the run-unit.