Step by Step transferring Portal 6 database from Derby to DB2

1 comments



By default, WebSphere Portal is installed with Derby database to store all Portal information. Portal uses following six databases in total to store different kind of information. Following are the database names.

Portal DB

Portal provides following 3 options for creating and transferring the databases:

1. Create one database and transfer all the databases to this single database.
2. Create separate databases on the same server and transfer the portal data to them.
3. Create separate databases on different server (distributed environment) and transfer the portal data to them.

This article will demonstrate how to transfer the portal databases to other databases on the same server, but you can use the same steps to transfer the database to one database or databases created on separate servers.

After configuring your database server(s) by installing DB2 (or Oracle/MS SQL Server) and creating databases using the DB2 creation script you need to run the following to transfer the databases:

<wp_profile_root>\PortalServer\wizard\configwizard.bat

Running the above batch command will open the following screen:


Portal DB Migration


Click on “Next” to go to next screen.


Portal DB Migration


Select “Transfer data to other databases” and click next to go to next step.


Portal DB Migration


Provide WebSphere Application Server username and password to start WebSphere_Portal server. Click “Next” to go to next screen.


Portal DB Migration


Wizard will check if server is started or not. If server is not started then it will start the server before moving to next screen.


Portal DB Migration


Select “IBM Derby” from the options to select the source database. Click “Next” to go to next screen.


Portal DB Migration


Select “IBM DB2 Universal Database” to select the target database. Click “Next” to go to next screen.


Portal DB Migration


Specify database server name or provide IP address in “DbHostName” and “DbPort”. Also specify complete path for “DbLibrary” files. You need to specify the location for the jar files “db2jcc.jar” and “db2jcc_license_cu.jar”. Click “Next” to go to next screen.



Portal DB Migration

Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “community” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.


Portal DB Migration


Wizard will validate the information provided by you before moving to next screen. You just have to wait for it to finish verification to go to next screen.


Portal DB Migration


Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “customization” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.


Portal DB Migration


Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “Feedback” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.


Portal DB Migration


Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “jcr” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.


Portal DB Migration


Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “likeminds” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.

Portal DB Migration



Specify “DbName”, “DbUser” (having admin access) and “DbPassword” for “release” database. You can specify other custom information as well according to your need. Click “Next” to go to next screen.


Portal DB Migration


Check all the information in that you specified in this screen. If everything is correct then click “Next” to start the transfer of the databases. You will get successful message if everything goes well without any error.

You can now start and stop the servers to propagate the changes. If servers start without any errors and you are able to login successfully using GUI then you have successfully transferred the databases.

1 comment:

Anonymous said...

I was excited to find this great site. I need to to thank you for your time
due to this wonderful read!! I definitely liked every little bit of
it and i also have you book marked to see new things on your blog.


Also visit my web page :: boom beach items

Post a Comment

Recent Posts

Popular Posts

© 2011-2019 Web Portal Club