Filter
Top Products
Utilities 7-93
Option Descriptions
The next portion of the -p display tabulates the number of times different
ISAM calls were executed. The calls occur at the lowest level of operation and
do not necessarily correspond one-to-one with SQL statement execution. A
single query might generate multiple ISAM calls. These statistics are gathered
across the 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 an iscommit() call is made. There is not
a one-to-one correspondence between this value and the
number of explicit COMMIT WORK statements that are
executed.
rollbk increments when a transaction is rolled back.