14. DB2 problem diagnosis
As with all problems, the messages and codes generated by the DB2 subsystem should be reviewed for symptoms. When diagnosing DB2 problems it will be necessary to dump the DB2 address spaces. DB2 consists of more than one address space. Depending on your installation these could be:
DB2 master (MSTR) address space
Database manager (DBM) address space
Internal resource lock manager (IRLM) address space
Distributed data facility (DIST) address space
Established stored procedures (SPAS) address space
Usually you would dump the MSTR, DBM, and IRLM address spaces.
This chapter describes the following:
System trace table
DB2 dump collection
Data sharing and IRLM
DB2 tracing
DB2 dump diagnosis using IPCS
Get z/OS Diagnostic Data Collection and Analysis now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.