Portal Express, Version 6.0
Operating systems: i5/OS, Linux, Windows

---

 

Transferring using the configuration wizard

This file provides information on how to transfer your data between databases using the configuration wizard.

• You must create all databases and users for the database you are transferring to before you can begin transferring your data.

• Both the database you are transferring from and the database you are transferring to must be running in order to support the data transfer.

Perform this task on the computer hosting IBM^® WebSphere^® Portal Express. For additional help during transfer, use the Help button located in the configuration wizard window.

Data can only be transferred to a DB2 for z/OS database using the configuration wizard when using a JDBC type 2 connection. If you are transferring to a DB2 for z/OS database with a JDBC type 4 connection, transfer your data using the command line.  See Transferring DB2 for z/OS for more information on transferring manually.

Before you begin
Before configuring databases, ensure that the following prerequisites are met:

• Supported database software is installed.

• Databases and users are correctly setup for use by IBM WebSphere Portal Express.

• If you are using one of the following fix packs complete the steps below prior to database transfer. Failure to follow these steps will cause the database transfer to hang at the task action-process-constraints.

  • DB2 8.1 Fix Pack 10

  • DB2 8.1 Fix Pack 11

  • DB2 8.1 Fix Pack 12

  • DB2 8.1 Fix Pack 13

  • DB2 8.1 Fix Pack 14

  • DB2 9.1 Fix Pack 1

  1. Locate the following file:

     • Linux:

       /home/db2inst1/sqllib/cfg/db2cli.ini

     • Windows:

       db2home/sqllib/db2cli.ini

  2. Edit the file by adding the following to the end of the file:

     • For Fix Pack 10 or Fix Pack 11:

       [COMMON]
       DYNAMIC=1
       

       An empty line is required after the dynamic=1 at the end of the file.

     • For all other Fix Packs listed above:

       [COMMON]
       DYNAMIC=1
       ReturnAliases=0
       

       An empty line is required after the ReturnAliases=0 at the end of the file.

  Notes:

  • This fix should be applied to both the client side and server side of the DB2 installation.

  • If you are using DB2 type 4 JDBC driver at the client side, the fix should be applied to the server side only.

1. Start server1 and stop WebSphere Portal Express. See Starting and stopping WebSphere Application Server and WebSphere Portal Express for instructions.

2. Switch to the configuration wizard window.

   See Configuring WebSphere Portal Express with the configuration wizard for information on how to start the configuration wizard.

3. In the Select the configuration task that you want to perform dialog box, select Transfer Data to Another Database, and then click Next.

4. If the WebSphere Application Server global security is enabled... dialog box appears, type the IBM WebSphere Application Server administrative user name and password in the appropriate fields, and then click Next.

   Passwords should not contain spaces.

5. In the Source domain dialog box, select the database type that you want to transfer from, and then click Next. You may choose to transfer all domains, or select any combination of the following domains:

   • Community

   • Customization

   • Feedback

   • Java Content Repository

   • LikeMinds

   • Release

   • Member Manager

6. In the Target domain dialog box, select the database type that you want to transfer to, and click Next.

7. In the properties dialog box, review the properties and values for the database(s) that you are transferring to. Modify the values for your environment, and click Next. Repeat this step for each database you are transferring.

8. In the properties dialog box, review the properties and values for the domains that you are transferring to. Modify the values for your environment, and click Next. Repeat this step for each domain you are transferring.

9. In the summary dialog box, review the settings for the database transfer. If changes are necessary, click Back, otherwise, click Next to begin transferring data.

10. In the Running task dialog box, the status bar will show the progress of the transfer. To view the log file for the transfer, click Open. Once the transfer has completed, click Next.

11. If the task runs successfully, the message The wizard ran the task successfully will be displayed. Click Finish to exit the wizard.

12. If the task runs with errors, the message The wizard ran the task with errors will be displayed. For more information, click Open Message File. To perform additional configuration, click Run Wizard Again. Click Finish to exit the wizard.

 

Parent topic:

Transferring all domains

---