IBM 000-8697 Manual Do Utilizador

Utilities

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.