WebSphere brand IBM WebSphere Premises Server, Version 6.1.x

Migrating the database, tablespace, tables, and data

Use this topic to manually migrate the database, tablespace, tables, and populate the data required for WebSphere® Premises Server. If you are using the WebSphere Premises Server installer to migrate the database, you do not need to follow these steps.

Migrating the databases using scripts

Run the scripts provided in the db_script directory on the WebSphere Premises Server disk to migrate the database, tablespace, tables and populate data.

Before you begin

Before running the scripts be aware of the following restrictions and take the appropriate action:

  • You must be a database user (such as db2inst1 or oracle) to run the scripts on Linux®.
  • For Oracle, the sqlplus executable must be added in the PATH on Linux.
  • The specified tablespace directory must exist.
  • You must have the authorization to access the specified tablespace directory if you are using Linux only.
  • The specified tablespace file cannot be used by another database.
Example

For DB2®:

Windows
migrateFrom6.1GA_db2.bat dbName longTablespaceFile longTempTablespaceFile
Linux
migrateFrom6.1GA_db2.sh dbName longTablespaceFile longTempTablespaceFile

For Oracle:

Windows
migrateFrom6.1GA_oracle.bat dbUser dbPassword dbSpec longTablespaceFile 
Linux
migrateFrom6.1GA_oracle.sh dbUser dbPassword dbSpec longTablespaceFile 

The database, tablespace, table and data are created under dbSpec.


Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2008. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.