db2ckmig - Database Pre-migration Tool Command
Verifies that a database can be migrated.
Scope
7 This command only affects the database partition on which it is executed.
7 In a partitioned database environment, run the command on each database
partition.
Authorization
sysadm
Required connection
None
Command syntax
(Embedded image moved to file: pic17488.gif)Read syntax diagram(Embedded
image moved to file: pic18945.gif)Skip visual syntax diagram>>-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
7 On UNIX-based platforms, when an instance is migrated with db2imigr, 7
db2ckmig is implicitly called as part of the migration. 7 If you choose to
run db2ckmig manually, it must be run for each instance 7 after DB2 UDB is
installed, but before the instance is migrated. It should be run 7 from the
install path. It is located in DB2DIR/bin, where DB2DIR represents 7
/usr/opt/db2_08_01 on AIX, and 7 /opt/IBM/db2/V8.1 on all other UNIX-based
systems.
7 On Windows platforms, instances are migrated during installation, 7 and
the installation will prompt you to run db2ckmig. 7 It is located on the
DB2 UDB CD, in db2/Windows/Utilities.
To verify the state of a database:
1. Log on as the instance owner.
2. Issue the db2ckmig command.
3. Check the log file.
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.
Related tasks
Verifying that your databases are ready for migration
This topic can be found in: Command Reference.
"David W Nobles "
<db2udbdba-ezmlms
hield-x49185797.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
07/27/2005 11:43
AM Subject
DB2 - v7 to v8 migration -
application scripts
It is my understanding that IBM has scripts that you can run against
application tables to get a heads up on potential issues that might
Arise after moving from v7 to v8.
I have been unable to location a point of contact and/or link to this
information.
Has anyone out there heard of these or better yet, used them?
Thanks,
David Nobles
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page