Personal tools
You are here: Home → DB2 → How To's → How to verify that your database is ready for migration
Navigation
Log in


Forgot your password?
 
Document Actions

How to verify that your database is ready for migration

db2ckmig

 

  •    1 -  Log on to the DB2 server as the DB2 instance owner that you want to migrate.
  •    2 -  Stop the instance by running the db2stop command.
  •    3 - From a DB2 command line prompt move to the appropriate directory:

          -  On UNIX or Linux operating systems, change to the $DB2DIR/bin directory where DB2DIR is the location that you specified during the DB2 Version 9.5 installation.
          -  On Windows® operating system, you need to insert the DB2 Version 9.5 product CD in the drive and change to the \db2\Windows\utilities directory.

  •   4 -  Run the db2ckmig command to verify that the databases that are owned by the current instance are ready to be migrated and to generate a log file.
db2ckmig sample -l db2ckmig.log -u adminuser -p password

Output:

         db2ckmig was successful.  Database(s) can be migrate

 

If you don't receive the message below. check the conditions below to your database:

 

  •     A catalogued database actually exists.
  •     A database is not in an inconsistent state.
  •     A database is not in a backup pending state.
  •     A database is not in a restore pending state.
  •     A database is not in roll-forward pending state.
  •     Table spaces are in a normal state.
  •     A database does not contain user-defined types (UDTs) with the name ARRAY, BINARY, DECFLOAT, VARBINARY and XML.
  •     A database does not contain the system-defined DATALINK data type.   
  •     A database does not have orphan rows in system catalog tables that would cause database migration to fail.
  •     A database enabled as an HADR primary database allows successful connections.
  •     An HADR database role is not standby.
  •     If SYSCATSPACE is a DMS table space and the automatic resizing functionality is not enabled, SYSCATSPACE has at least 50% free pages of  
        total pages.

 

A database must pass all of these checks to succeed at the migration process.

 

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls