db2checkSD - Verify database is ready to upgrade to Db2 pureScale environment command
Verify that your database is ready to be upgraded to a Db2 pureScale environment.
Authorization
SYSADM and DATAACCESS authorities are required.
Command syntax
Command parameters
- database
- Specifies an alias name of a local database to be scanned.
- -e
- Specifies that all local cataloged databases are to be scanned.
- -l filename
- Specifies a log file to which to write errors and warnings generated for the scanned database or databases.
- -u userid
- Specifies the user ID of the system administrator.
- -p password
- Specifies the password of the user ID of the system administrator.
Usage notes
You can run the db2checkSD command against a prior released database before upgrading to determine whether you must take actions before using the database in a Db2 pureScale environment. The db2checkSD command generates a script file containing information about any issues found. Except for certain features that are controlled by database configuration parameters that the db2iupgrade instance upgrade and the db2iupdt instance update commands disable, you must correct issues for the instance upgrade or update to be completed successfully.
The db2iupdt command calls the db2checkSD command with the -e option to check all of the local catalogued databases for the instance. If the db2checkSD command detects issues in any database when it is called by these instance commands, in most cases, the instance command fails, but in some cases, the function is disabled.