Collecting data for resource limit facility problems

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.

About this task

Introductory concepts

Procedure

To collect data to diagnose resource limit facility problems:

  1. Collect service SQL information for the SQL statement to investigate, as described in Collecting service SQL documentation
  2. 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
  3. 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.
  4. If an SQL statement is limited improperly, generate a DSN1SDMP that is triggered by SQLCODE -905.