Collecting data for ssnmDBM1 utility problems

To diagnose Db2 utility problems, collect specific data from the ssnmDBM1 address space.

About this task

Problems with Db2 utilities in the ssnmDBM1 address space can involve a broad range of components:
  • z/OS®
  • DFSMS
  • Db2 catalog
  • Third-party software
  • Hardware

Procedure

Collect the following data to diagnose problems with utilities in the ssnmDBM1 address space:
  • A description of the problem situation
  • The utility job log output
  • LOGREC data
  • Generated SVC dump data sets
  • ssnmDBM1 job log output
  • ssnmMSTR job log output
  • SYSLOG data
  • Db2 catalog information from SYSIBM.SYSTABLEPART columns IPREFIX, AVGROWLEN, and PAGESAVE

What to do next

Depending on the problem, more information might be requested by IBM® Support. This information might include:
  • Db2 diagnose reports
  • Db2 internal trace reports from SMF or GTF
  • CHECK INDEX, REPAIR DBD, DSN1COPY, and DSN1PRINT reports