You can check and repair database definitions (DBDs) in the catalog and directory by using the REPAIR utility with the DBD statement.
About this task
You can use REPAIR DBD on declared temporary tables, which must be created in a database that is defined with the AS TEMP clause. No other Db2 utilities can be used on a declared temporary table, its indexes, or its table spaces.
To repair DBDs:
- Run REPAIR DBD with the TEST option to determine whether
the information in the Db2 catalog
is consistent with the DBD in the Db2 directory.
REPAIR DBD TEST obtains environment information, such as the character that is used for the decimal point, from the application defaults load module that is used by the subsystem. The application defaults load module is either the default load module DSNHDECP or a user-specified application defaults load module.If the return code is not 0, inconsistencies exist.
- If inconsistencies exist, run REPAIR DBD with the DIAGNOSE
and OUTDDN options to produce diagnostic information.
REPAIR DBD DIAGNOSE obtains environment information, such as the character that is used for the decimal point, from the application defaults load module that is used by the subsystem.
Contact IBM® Support for assistance in analyzing this information.
- If IBM Support
instructs you to do so, replace the existing DBD by running REPAIR
DBD with the REBUILD option. Attention: Do not use the REBUILD option if you suspect that information in the catalog is causing the inconsistency. REBUILD uses information in the catalog to rebuild the DBD; if the catalog is incorrect, the rebuilt DBD cannot be correct.
REPAIR DBD REBUILD obtains environment information, such as the character that is used for the decimal point, from the DSNHDECP module for the subsystem.
Db2 starts the database for access by utilities only. After successful completion of the REPAIR utility, the database continues to be started for utility access only.
When REPAIR DBD REBUILD is running, an S-lock is acquired for the appropriate catalog tables. If the S-lock fails, REPAIR DBD fails.
Db2 reads each table space in the database during the REBUILD process to gather information. If the data sets for the table spaces do not exist or are not accessible to Db2, the utility abnormally terminates.
- If you suspect an inconsistency in the DBD of the work
file database, consider issuing the DROP DATABASE SQL statement or
running REPAIR DBD DROP. Then re-create the database. Attention: Use REPAIR DBD DROP with extreme care. Using DROP can cause additional damage to your data. For more assistance, contact IBM Support.
If you receive errors when you drop the work file database, contact IBM Support for assistance.
- If you ran REPAIR DBD REBUILD, the database is started for utility-only access, and you must restart the database for read/write access manually by issuing the START DATABASE (database-name) ACCESS(RW) command.
- Rebind any trigger packages that were invalidated.
When you run REPAIR DBD REBUILD on a database, Db2 invalidates packages for any triggers that are defined on tables in that database. To find those triggers, use the following query:
SELECT T.NAME, T.SCHEMA FROM SYSIBM.SYSTRIGGERS T,SYSIBM.SYSDATABASE D WHERE T.DBID= D.DBID AND D.NAME = ' your database name here'
After you run REPAIR DBD REBUILD, you must rebind those trigger packages. The Db2 release on which you rebind the trigger packages must be the same as the Db2 release on which you ran REPAIR DBD REBUILD.