idsdbmigr

Edit online

Use the idsdbmigr command to migrate the database instance for an existing directory server instance.

Description

The idsdbmigr command does migration of the DB2® database instance for an existing directory server instance. By using this command, user data can be migrated from a previous supported version of DB2 while successfully converting it to a fully functioning DB2, Version 11.5.7.0 instance and database.

Note:
  • You cannot migrate DB2, Version 9.1 or 9.5 directly to DB2, Version 11.5.7.0. You must first migrate to DB2, Version 9.7 and migrate to DB2, Version 11.5.7.0.
  • The version of the directory server instance must be IBM® Security Directory Server, Version 6.3 or later. Migration from Version 6.1 and 6.2 to Version 6.4 is not supported.
  • The directory server instance name must be specified by using the -I parameter, which is a required parameter.
  • If you drop an existing directory server instance by using the idsidrop command after you migrate a database instance, the temporary files that are created by DB2 during migration are not deleted.

Synopsis

idsdbmigr [-I instance_name [-N db2_install_location]] [-u db2_userid] [-w db2_password]]|-h | -?

Options

-I instance_name
Specifies the directory server instance name.
-N db2_install_location
Specifies the DB2 installation location for the migration and postmigration tasks.
-u db2_userid
Specifies the DB2 User ID of the directory server instance (Windows only).
-w db2_password
Specifies the DB2 password of the directory server instance (Windows only).
-h | -?
Specifies to show the syntax help.
Note: The options -u and -w are applicable only to Windows.

Examples

Example 1:
To run only premigration tasks on DB2 database, run the following command:
idsdbmigr -I instance name
Example 2:
To run a complete migration from a previous version of DB2 database to a DB2, Version 11.5.7.0 database, run the idsdbmigr command.
Note: The -N parameter specifies the DB2, Version 11.5.7.0 installation location.
On Windows systems
idsdbmigr -I instance name -N "C:\Program Files\IBM\SQLLIB" -u instance db2 username -w instance db2 Password
On AIX®, Linux®, and Solaris systems
idsdbmigr -I instance name -N /opt/IBM/db2/V10.5.0.4