Checking for missing system pages

You can use the REPAIR utility to check for and insert missing system pages into a table space.

Procedure

  1. Run REPAIR CATALOG TEST to check for missing system pages for tables.

    If a table space has any missing system pages, message DSNU667I is issued, with this additional information: MISSING SYSTEM PAGE IN THE PAGE SET.

  2. Run the following query to identify the tables in a table space that are in version 0 format and have not been altered. 
    SELECT NAME, DBID, OBID
 FROM SYSIBM.SYSTABLES
 WHERE VERSION = 0
 AND ALTEREDTS = CREATEDTS
 AND DBNAME =  database-name
 AND TSNAME = table-space-name
  3. Use the results of steps 1 and 2 to determine the table spaces that are in version 0 format and have missing system pages.
  4. For any table space that has any missing system pages for tables that are in version 0 format, run REPAIR INSERTVERSIONPAGES SETCURRENTVERSION to insert system pages into the table space that contains those tables. Tables that are in version 0 format have had no version-changing alter operations.

    REPAIR INSERTVERSIONPAGES SETCURRENTVERSION performs the following actions:

    • Inserts missing system pages for tables that are in version 0 format into the table space.
    • Updates the version numbers in the VERSION column of the SYSIBM.SYSTABLES catalog table for all tables in the table space that are at version 0 to the same version number as in the CURRENT_VERSION column in SYSIBM.SYSTABLESPACE.