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