Command Reference

db2ckmig - Database Pre-migration Tool

Verifies that a database can be migrated. For detailed information about using this tool, see one of the Quick Beginnings books.

Authorization

sysadm

Required Connection

None

Command Syntax

>>-db2ckmig---+-database-+-l filename---+------------+----------> +--e-------+ +--u userid--+ >--+--------------+-------------------------------------------->< +--p password--+

Command Parameters

database: Specifies an alias name of a database to be scanned.
-e: Specifies that all local cataloged databases are to be scanned.
-l: Specifies a log file to keep a list of errors and warnings generated for the scanned database.
-u: Specifies the user ID of the system administrator.
-p: Specifies the password of the system administrator's user ID.

Usage Notes

To verify the state of a database:

Logon as the instance owner.
Issue the db2ckmig command.
Check the log file. If it shows errors, refer to Table 1 for suggested corrective actions.
Note: The log file displays the errors that occur when the db2ckmig command is run. Check that the log is empty before continuing with the migration process.

Table 1. Correcting Error Messages

Error Action
A database is in Backup pending state Perform a backup of the database.
A database is in Roll-forward pending state Recover the database as required; perform or resume a Roll-forward Database.
Table space ID not in normal state Recover the database and table space as required; perform or resume a Roll-forward Database.
A database is in Database transaction inconsistent state Restart the database to return it to a consistent state.
The database contains database objects that have a schema name of SYSCAT, SYSSTAT, or SYSFUN These schema names are reserved for the database manager. To correct this error, do the following:

Backup the database.
Export the data from the database object (catalogs or tables).
Drop the object.
Re-create the object with the corrected schema name.
Import or load the data into the object.
Run db2ckmig against the database again, ensuring that the database passes the db2ckmig check.
Make a backup copy of the database.

Error	Action
A database is in `Backup pending` state	Perform a backup of the database.
A database is in `Roll-forward pending` state	Recover the database as required; perform or resume a `Roll-forward Database`.
`Table space ID not in normal state`	Recover the database and table space as required; perform or resume a `Roll-forward Database`.
A database is in `Database transaction inconsistent` state	Restart the database to return it to a consistent state.
The database contains database objects that have a schema name of SYSCAT, SYSSTAT, or SYSFUN	These schema names are reserved for the database manager. To correct this error, do the following: Backup the database. Export the data from the database object (catalogs or tables). Drop the object. Re-create the object with the corrected schema name. Import or load the data into the object. Run db2ckmig against the database again, ensuring that the database passes the db2ckmig check. Make a backup copy of the database.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]