Websphere Portal Database Transfer to DB2 v9.7

NOTE: Following article gives detail on how to transfer all schemas to single database instance (most of the times each schema is created under different database instance, but as this is not intended for heavy use , just used single db instance for all schemas. It is also simple to create different schemas under different db instance by just giving proper db names for each schema in datasources section below. WP Cluster guide also details on how to create schemas on separate databases using command line approach )

WebSphere portal database transfer can be done either using the Portal Configuration Wizard or using configengine tasks.

Database Transfer using portal config wizard

Open the portal config wizard from C:\IBM\WebSphere\wp_profile\PortalServer\wizard\configwizard.bat, this wizard will walk you through all required configuration to transfer the db (most of the screens are self-explanatory). 

Optionally you can update the following files to pre-populate information by config wizard.

1. Edit the wkplc_dbtype.properties file and make the following changes:

db2.DbLibrary=C:/IBM/DB2/java/db2jcc4.jar;C:/IBM/DB2/java/db2jcc_license_cu.jar

db2.JdbcProviderName=wpdbJDBC_db2

2. Edit the wkplc_dbdomain.properties file and make the following changes:

feedback.DbType=db2

feedback.DbName=wps7db

feedback.DbSchema=FEEDBACK

feedback.DataSourceName=wpdbDS_db2

feedback.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

feedback.DbUser=db2admin

feedback.DbPassword=Passw0rd

feedback.DbRuntimeUser=db2admin

feedback.DbRuntimePassword=Passw0rd

likeminds.DbType=db2

likeminds.DbName=wps7db

likeminds.DbSchema=likeminds

likeminds.DataSourceName=wpdbDS_db2

likeminds.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

likeminds.DbUser=db2admin

likeminds.DbPassword=Passw0rd

likeminds.DbRuntimeUser=db2admin

likeminds.DbRuntimePassword=Passw0rd

release.DbType=db2

release.DbName=wps7db

release.DbSchema=release

release.DataSourceName=wpdbDS_db2

release.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

release.DbUser=db2admin

release.DbPassword=Passw0rd

release.DbRuntimeUser=db2admin

release.DbRuntimePassword=Passw0rd

community.DbType=db2

community.DbName=wps7db

community.DbSchema=community

community.DataSourceName=wpdbDS_db2

community.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

community.DbUser=db2admin

community.DbPassword=Passw0rd

community.DbRuntimeUser=db2admin

community.DbRuntimePassword=Passw0rd

customization.DbType=db2

customization.DbName=wps7db

customization.DbSchema=customization

customization.DataSourceName=wpdbDS_db2

customization.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

customization.DbUser=db2admin

customization.DbPassword=Passw0rd

customization.DbRuntimeUser=db2admin

customization.DbRuntimePassword=Passw0rd

jcr.DbType=db2

jcr.DbName=wps7db

jcr.DbSchema=jcr

jcr.DataSourceName=wpdbDS_db2

jcr.DbUrl=jdbc:db2://mydbserver.ibm.com:50000/wps7db:returnAlias=0;

jcr.DbUser=db2admin

jcr.DbPassword=Passw0rd

jcr.DbRuntimeUser=db2admin

jcr.DbRuntimePassword=Passw0rd

 Choose the task that you want to perform i.e. " Transfer data to other database"

Provide the WAS admin ID and password

Select the source db (dy default portal uses derby database)

Choose the target database i.e. db2 in my case

Entered the DB version (remaining details are populated from the properties file that entered already)

Provide JDBC provider info for the release database domain if it is not already mentioned in the above properties 

Make sure all properties for the customization database are proper below

Make sure all properties for the community database are proper

Make sure all properties for the JCR database are proper 

Make sure all properties for the Feedback database are proper 

Make sure all properties for the likeminds database are proper 

Following is the consolidate screen for all schemas , validate the details before go further

Click next to start the db transfer.

References

http://www-10.lotus.com/ldd/portalwiki.nsf/xsp/.ibmmodres/domino/openattachment/ldd/portalwiki.nsf/1ce09486e05fc916852577a70072d757/attach/wpv7_clusterguide.pdf