Utilities 7-93
Option Descriptions
The next portion of the-p display tabulates the number of times different
ISAMcalls were executed. The calls occur at the lowest level of operation and
do not necessarily correspond one-to-one withSQL statement execution. A
singlequery might generate multiple ISAM calls. These statistics are gathered
acrossthe OnLine system and cannot be used to monitor activity on a single
database unless only one database is active or only one database exists.
isamtot is the total number of calls.
open increments when a tblspace is opened.
start increments when positioning within an index.
read increments when the read function is called.
write increments with each write call.
rewrite increments when an update occurs.
delete increments when a row is deleted.
commit increments each time aniscommit() call is made. There is not
a one-to-one correspondence between this value and the
number of explicitCOMMIT WORK statements that are
executed.
rollbk increments when a transaction is rolled back.