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 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:
Running the above batch command will open the following screen:
Click on “Next” to go to next screen.
Select “Transfer data to other databases” and click next to go to next step.
Provide WebSphere Application Server username and password to start WebSphere_Portal server. Click “Next” to go to next screen.
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.
Select “IBM Derby” from the options to select the source database. Click “Next” to go to next screen.
Select “IBM DB2 Universal Database” to select the target database. Click “Next” to go to next screen.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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:
Click on “Next” to go to next screen.
Select “Transfer data to other databases” and click next to go to next step.
Provide WebSphere Application Server username and password to start WebSphere_Portal server. Click “Next” to go to next screen.
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.
Select “IBM Derby” from the options to select the source database. Click “Next” to go to next screen.
Select “IBM DB2 Universal Database” to select the target database. Click “Next” to go to next screen.
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.
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.
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.
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.
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.
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.
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.
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.
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.
No comments:
Post a Comment