If SQL queries are not properly governed by the resource
limit facility (RLF), then collect RLF table data, and generate dumps
to diagnose the problem.
Procedure
To collect data to diagnose resource limit facility
problems:
-
Collect service SQL information for
the SQL statement to investigate, as described in Collecting service SQL documentation
- Collect the complete contents of the active RLF tables.
For example, use the following SELECT statements, where
xx are
the two-character identifiers that you specified on the name of the
active RLF tables:
SELECT * FROM DSNRLSTxx
SELECT * FROM DSNRLMTxx
- If a dynamic SQL statement is not being limited by RLF,
then generate a Db2 supervisor
call (SVC) dump when you expect the limit is exceeded.
- If an SQL statement is limited improperly, generate a DSN1SDMP
that is triggered by SQLCODE -905.