Multiple choice technology databases

Which standalone Utility verifies the Integrity of DB2 directory and Catalog

  1. DSN1SDMP

  2. DSN1LOGP

  3. DSN1COMP

  4. DSN1CHKR

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DSN1CHKR is the IBM DB2 standalone utility that verifies the integrity of the DB2 directory and catalog. This is a critical diagnostic tool. DSN1SDMP is for formatted dumps, DSN1LOGP prints log records, DSN1COMP compresses data. Only DSN1CHKR performs integrity verification of DB2's core metadata structures.