migratedb utility (database migration script)
If migrating the WebSphere Commerce database using the command line, review this information to understand the parameters required for the migratedb command.
The following section describes the syntax to use for the database migration script. Some optional parameters might not be applicable to the migration path. Read the detailed parameter descriptions to see which ones apply.
Cloudscape database tier migration is only available for the WebSphere Commerce development environment.
- dbtype database_type
- The database type you are migrating. Any of the following values can be assigned to database_type:
- db2
- Specifies that you are migrating a DB2 database.
- oracle
- Specifies that you are migrating an Oracle database.
- os400
- Specifies that you are migrating a DB2 for i5/OS database.
- -dbname database_name
- Specifies the database you are migrating.
- database_name is the relational database where the WebSphere Commerce schema runs, as displayed in the relational database directory (as viewed from the WRKRDBDIRE command).
- For a remote database tier migration, (where you specify the -remoteDB true parameter), database_name represents the host name of the system where the WebSphere Commerce database is located.
- database_name is the WebSphere Commerce database that you are migrating (for example, mall).
- database_name is a file path to the database. For example, WCDE_INSTALL\db\mall, where WCDE_INSTALL represents the installation path for WebSphere Commerce Developer.
- -dbuser database_user_ID
- Specifies the database user ID.
- database_user_ID is the instance user profile of the previous WebSphere Commerce version database that you are migrating. This should be the same as the schema name.
- database_user_ID is the user ID to connect to the previous WebSphere Commerce version database that you are migrating (for example, mydbuser for DB2 databases or oracle for Oracle databases).
- If you do not use the -dbuser parameter, the database tier migration script creates a default value for it.
- -dbpass database_password
- Specifies the database user ID password. If you do not enter this parameter, the migration script will prompt you to enter it.
- database_password is the password for the instance user profile of the WebSphere Commerce database that you are migrating. If you do not supply it on the command line, the migration script will prompt you to enter it in.
- database_password is the password for the user ID to connect to the WebSphere Commerce database that you are migrating (for example, mypasswd for DB2 databases or oraclepw for Oracle databases). If you do not supply it on the command line, the migration script will prompt you to enter it in.
- If you do not use the -dbpass parameter, the database tier migration script will use a WebSphere Commerce default value for it.
- -from version
- Specifies the version of the WebSphere Commerce database from which you are migrating. For WebSphere Commerce databases, enter 55, 56, or 561.
- -instanceName instance
- Specifies the 55, 56, or 561 WCS instance name for the database that you are migrating.
If you do not use this parameter, the script uses "WC_DE_default_instance",
where:
- WCDE_INSTALL
- Represents the installation path for WebSphere Commerce Developer, v6.0. The default installation path is:
- drive:\WCToolkitEE60.
- drive:\WCToolkitPro60.
- drive:\WCToolkitExpress60.
- If you use the -instanceName parameter, it creates a subdirectory under the WCDE_INSTALL\logs\WCIM\ instance directory.
- -defaultLocale locale
- The locale for the system. It can be any of the supported WebSphere Commerce locales such as en_US, fr_FR, and so on. If this parameter is not specified, the locale of the operating system that is found by the JVM is used as the default.
- -ldap true | false
- This parameter specifies whether the LDAP server is being used with WebSphere Commerce to store user information. The default is false.
- -schema schema_name
- Specifies the database schema name. This parameter is mandatory when the schema name is not the same as the database user ID. If this parameter is not specified, the migration script assumes the schema name is the same as the database user ID.
- If the -schema parameter is not used, the database tier migration script uses " APP" as the default.
- -hostname host_name
- Specifies the fully qualified host name of the system where the database resides. (for example, myhost.montreal.ca). If - remotedb is true, this parameter is required.
- -port port_number
- Specifies the Oracle listener port number. Typically, this is port 1521 by default.
- -TABDEF tabdef_name
- The table space containing the tables that uses the default page size (typically 4K); the default is USERSPACE1.
- -INDEXDEF indexdef_name
- The table space containing the indexes of those tables in tabdef, the default is USERSPACE1.
- -TAB8K tab8k_name
- The table space containing the tables that use an 8K page size; the default is TAB8K.
- -INDEX8K index8k_name
- The table space containing the indexes of those tables in tab8k, the default is TAB8K.
- -TAB16K tab16k_name
- The table space containing the tables that use a 16K page size; the default is TAB16K.
- -INDEX16K index16k_name
- The table space containing the indexes of those tables in tab16k, the default is TAB16K.
The custom table spaces specified must exist in the current DB2 system.
Use these parameters if the DB2 database uses customized table spaces as opposed to the default table spaces, USERSPACE1, TAB8K, and TAB16K. For example, if you have customized the WebSphere Commerce database to use say, MYUSERSPACE, MYTAB8K, MYTAB16K, then specify:
- -INDEXDEF MYUSERSPACE
- -TAB8K MYTAB8K
- -TAB16K MYTAB16K
The following parameters are not applicable for migrations from WebSphere Commerce v5.5 or from WebSphere Commerce - Express:
- -ldapHost ldap_host_name - the ldap host name.
- -ldapPort ldap_port_number - the ldap port number.
- -ldapAdminId ldap_admin_Id - the ldap administrator ID.
- -ldapAdminPassword ldap_admin_password - the ldap administrator password.
- -baseDN base_DN - the domain name.
The following parameters are required only to modify the default log directory or file name:
- -logDir log_directory
- Specifies the directory where the database tier migration log file will be generated. The default directory is...
- WC_INSTALL/instances/instance/migration/logs
- WC_USER/instances/instance/migration/logs
- -logFile log_file_name
- Specifies the database tier migration log file name. The default log file name is migratedbxx_yyyy.mm.dd_hh.mm.ss.log. Where xx is either 55, 56, or 561.
- -logLevel level
- Specifies the amount of information about the database tier migration that is logged. The valid log levels are:
- None
- No information or error messages are logged.
- Error
- Only error messages are logged.
- Normal
- All error messages and events are logged. It is the recommended option for most database tier migrations as it only requires in the order of 10 KB of storage for most migrations.
- Verbose
- All errors, events, and other information is logged, including all SQL statement information. This option is recommended if you encounter errors and need to debug them. It requires in the order of one or two MB of storage for most migrations. This is the default.
- Debug
- Similar to the Verbose option, but includes some additional debug information. Recommended if you encounter errors and need to debug them. It requires in the order of one or two MB of storage for most migrations.
- -precheck
- Runs the database pre-migration checker to check the status of the database before migrating. Running the database pre-migration checker before performing the database tier migration is recommended.
- -remoteDB true
- Specifies that the database is on a system that is remote from the system where you run the migratedb command.