WebSphere

 

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

 

Transferring DB2 for i5/OS manually

This section provides information on how to manually transfer data to the IBM® DB2® for i5/OS® database you have set up.

Follow these steps to transfer IBM WebSphere® Portal Express, Member Manager, and DB2 Content Manager Runtime Edition databases to .

Notes: If you choose to transfer from the default database to a different supported database, there is no option to transfer back to the default database.

Before beginning the transfer tasks, complete the preparation steps, including changing the database property values, and creating the database names and schemas.

  1. Open a command prompt, and change to the UserData directory portal_server_root_user/config.

  2. Enter the following commands to validate configuration properties.

    Use SBMJOB to submit the Qshell script as a batch job to run in *BASE pool when *INTERACT pool does not have 1GB or more of allocated memory. For example: 

    SBMJOB CMD(STRQSH CMD(WPSconfig.sh -profileName profile_root validate-database-connection-wps -Drelease.DbPassword=password -Dcommunity.DbPassword=password -Dcustomization.DbPassword=password -Djcr.DbPassword=password))

    where profile_root is the name of the WebSphere Application Server profile where WebSphere Portal Express is installed; for example, wp_profile.

  3. From the same command prompt as the previous steps, be sure you are in the UserData directory portal_server_root_user/config.

  4. Stop both the WebSphere Application Server administrative server and the WebSphere Portal Express server before running the database-transfer task. See Starting and stopping WebSphere Application Server and WebSphere Portal Express for information about stopping servers.

  5. To transfer the database, type the following command to run the configuration task:

    Use SBMJOB to submit the Qshell script as a batch job to run in *BASE pool when *INTERACT pool does not have 1GB or more of allocated memory. For example: 

    SBMJOB CMD(STRQSH CMD(WPSconfig.sh -profileName profile_root database-transfer -Drelease.DbPassword=password 
-Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password  -Dwmm.DbPassword=password -Dfeedback.DbPassword=password 
-Dlikeminds.DbPassword=password))

    WPSconfig.sh -profileName profile_root database-transfer -Drelease.DbPassword=password 
-Dcustomization.DbPassword=password -Dcommunity.DbPassword=password -Djcr.DbPassword=password  -Dwmm.DbPassword=password -Dfeedback.DbPassword=password 
-Dlikeminds.DbPassword=password
    After running this task, a message indicating success should appear. Check the log files to verify that this task was successful. If the configuration fails, verify the values in the wpconfig.properties, wpconfig_dbdomain.properties, and wpconfig_dbtype.properties files, and then repeat this step.

  6. Change to the directory app_server_root/bin.

  7. Enter the following command: 

    startServer WebSphere_Portal -profileName profile_root
    where profile_root is the name of the WebSphere Application Server profile where WebSphere Portal Express is installed; for example, wp_profile.

 

Next steps

You have completed this step. Continue to the next step:

.

 

Parent topic:

Transferring all domains