Hello Spookey.

I would like to ask you something about "the activity" done by an IDS DB.
I'm looking for an indicator (essentialy...a number) that counts all the operation done by an IDS DB.

For example, when I submit an SQL command I immagine that happens something like:
- Parse the text to check for syntax error
- Check if the SQL was previously execute, so you can reuse the parse and the optimization phase
- If not, define the best access path to get the data
- Check if the data are stored in the buffer cache.
- If not, get the index pages (suppose that Optimizer does't use Sequential Scan)
- Put the data in the buffer cache
- Return data to the process

I think that the isamtot column returned by "onstat -p" command is "my number"
Do you think is this correct or have I to sum to this number other values maybe showed by the onstat -p command?

About the "onstat -p" command, the "IBM Informix Dynamic Server Administrator's Reference" says:

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 database server 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 the pointer 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

Thank you in advance!

Andrea Antonello
Italy

P.S. I don't think that you remember me, but I meet you in January in Strasbourg with J.G.Perrin. I hope you are well...