db2cleancat - Report or remove orphan rows

The db2cleancat tool reports or removes orphan rows from the Db2® system catalog. Run the db2cleancat command when db2ckupgrade fails with SQL1344N orphan rows found in the system catalogs.

Note: You must download and install the db2cleancat tool in order to use it. For more information, see db2cleancat download.

Authorization

You must have SYSADM authority to use the db2cleancat command. If you do not have SYSADM authority but still want to run db2cleancat, contact Db2 support for the service password.

Required connection

None

Command syntax

Command parameters

database: Specifies an alias name of a local database to be scanned.
option: If set to 0, a scan is performed on the system catalog to find all the orphan rows.; If set to 1, all previously found orphan rows are removed.

Usage Notes

Procedure to run db2cleancat:

Place the db2cleancat and db2cleancat.bnd files on the server where you need to clean the orphan rows.
Make sure you have SYSADM authority. If you do not have SYSADM authority but still want to run db2cleancat, contact Db2 support for the service password.
Back up the database before running db2cleancat.
Run the db2cleancat tool.
- To report orphan rows on a database, run the db2cleancat the following command:
```
db2cleancat <dbname> 0
```
- To remove all the orphan rows found in a database, run the db2cleancat the following command:
```
db2cleancat <dbname> 1
```
  After running the above command, enter y to confirm remove all the orphan rows, or n to cancel the command.