Improving Fault Analyzer DB2 performance

DB2® does not have an index defined on the SYSIBM.SYSDBRM catalog table. Fault Analyzer accesses the SYSIBM.SYSDBRM catalog table whenever it performs analysis for a DB2® fault. To avoid the possibility of poor performance when accessing SYSIBM.SYSDBRM, you can create a user-defined index on the SYSIBM.SYSDBRM catalog table. The non-unique index should specify the following columns (in order):

PLNAME
NAME

The following sample DDL can be used to define the index:

CREATE TYPE 2 INDEX nnnnnn.DBRMX            ❶
          ON SYSIBM.SYSDBRM
         (
          PLNAME ASC,
          NAME ASC
         )
         USING STOGROUP mmmmmm       ❶
               PRIQTY pp             ❷
               SECQTY ss             ❷
CLOSE NO;