db2checkSD - Verify database is ready to upgrade to DB2 pureScale environment command

Authorization

SYSADM and DATAACCESS authorities are required.

Command syntax

>>-db2checkSD--+-database-+-- -l--filename---------------------->
               '- -e------'                  

>--+----------------------------+------------------------------><
   '- -u--userid-- -p--password-'   

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 DB2 V9.7 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 db2iupgrade and the db2iupdt commands call the db2checkSD command. The db2iupgrade and db2iupdt commands call the db2checkSD command with the -e option to check all of the local cataloged 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.