Exception logging

The customer may define a number of exception criteria in the SQL/MF configuration file. When an SQL statement exceeds one of these criteria during its execution, it is recorded in the SQL/MF Exception Table.

Exception criteria are defined as:

- a maximum number of I/O requests or dataspace accesses
- a maximum number of buffer pool lookups
- a maximum command or LUW response time
- a maximum lock wait time
- a maximum checkpoint wait time
- a maximum idle time
- a defined range of SQLCODEs
- a lock escalation caused by the statement
- a DBspace scan
- execution in dynamic mode

Sample Exception Report