SQL call activity

The number and type of SQL calls executed in a transaction are reported in the DB2 accounting record.

The values of SQL call activity are repeatable unless there are many different paths possible through a complex program, or the access path changes. The access path chosen can change over time, for example by adding an index.

A given SQL call can be simple or complex, depending on factors such as the access path chosen and the number of tables and rows involved in the requests.

The number of GETPAGEs is in most cases a more precise indicator of DB2 activity than the number of different SQL calls.



dfhtk53.html | Timestamp icon Last updated: Sunday, 4 June 2017