
Utilities 7-93
Option Descriptions
The next portion of the -p display tabulates the number of times different
ISAM callswereexecuted.The calls occur atthelowestlevelofoperationand
do not necessarily correspond one-to-one with SQL statement execution. A
singlequerymightgeneratemultipleISAMcalls.Thesestatisticsaregathered
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.
Comentarios a estos manuales