The CATMAINT Utility

The CATMAINT Utility

The CATMAINT utility is used when migrating from one version or release of DB2 to another. It changes the structure of the DB2 Catalog by altering and creating DB2 tables and indexes using the special links and hashes in the DB2 Catalog database. The CATMAINT utility modifies the DB2 Catalog objects in place.

An execution of CATMAINT cannot be partially successful; all the catalog changes are made when the job is successful, or none are made when the job fails.

Only an INSTALL SYSADM as specified in the DSNZPARM s can execute the CATMAINT utility.

CATMAINT Guidelines

The guideline presented next should be followed when you are considering CATMAINT usage.

Use CATMAINT Only As Directed

The CATMAINT utility should be used only when migrating to a new release of DB2, and then only as directed by IBM in the DB2 release migration procedures.