Portal Server database(Derby) transfer to DB2 database

Before transfer of database take backup of following files :

wp_profile_root/ConfigEngine/properties/wkplc.properties
wp_profile_root/ConfigEngine/properties/wkplc_dbdomain.properties
wp_profile_root/ConfigEngine/properties/wkplc_dbtype.properties

Open wkplc_dbdomain.properties file and perform the following changes :
a. feedback.DbType=db2
b. feedback.DbName=
[e.g. feedback.DbName=portaldb]
c. feedback.DbSchema=FEEDBACK
d. feedback.DataSourceName=wpdbDS_feedback
e. feedback.DbUrl=jdbc:db2://:/
[e.g. jdbc:db2://111.111.1.111:50000/portaldb]
f. feedback.DbPassword=test123
[Enter your database password]
g. feedback.DbRuntimeUser=db2admin
[Enter your database User]
h. feedback.DbRuntimePassword=test123
I. feedback.DBA.DbUser=db2admin
j. feedback.DBA.DbPassword=test123
k. feedback.AdminUrl=jdbc:db2://111.111.1.111:50000/portaldb

NOTE :
Same changes should be made for all database properties in the same (wkplc_dbdomain.properties) file.
Properties of following database should be changed :
LikeMinds, Release, Community, Customization and JCR.
We need to make sure DataSourceName value should be different for each database mentioned above.
[e.g. release.DataSourceName=wpdbDS_release].


2.Open wkplc_dbtype.properties file and perform the following changes :
a. db2.DbLibrary=
[ e.g. db2.DbLibrary=C:/ProgramFiles/db2jars/db2jcc_license_cu.jar;C:/ProgramFiles/db2jars/db2jcc4.jar ]

Following changes should be made in DB2 :
Whenever we create database in DB2, We have to select UTF-8
Charset and Page size shuould be more than 4k. (We can kept 32k).

4. After database creation execute following script in Command Query
in DB2 :
CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 PAGESIZE 4 K
CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 16000 PAGESIZE 4 K
CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 16000 PAGESIZE 32 K
CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 PAGESIZE 4 K
CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLFQ32') BUFFERPOOL ICMLSMAINBP32
CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLNF32') BUFFERPOOL ICMLSMAINBP32
CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMVFQ04') BUFFERPOOL ICMLSVOLATILEBP4
CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMSFQ04') BUFFERPOOL ICMLSFREQBP4
CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('CMBINV04') BUFFERPOOL CMBMAIN4
CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('icmlssystspace32') BUFFERPOOL ICMLSMAINBP32
CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlssystspace4') BUFFERPOOL ICMLSVOLATILEBP4
CREATE USER TEMPORARY TABLESPACE ICMLSUSRTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlsusrtspace4') BUFFERPOOL ICMLSVOLATILEBP4
UPDATE DB CFG FOR portaldb USING DFT_QUERYOPT 2
UPDATE DB CFG FOR portaldb USING PCKCACHESZ 16384





Open command prompt and go to
C:\Program Files (x86)\IBM\WebSphere\wp_profile\ConfigEngine> location and execute following commmand :
ConfigEngine.bat validate-database -DwasPassword=
[ e.g.
ConfigEngine.bat validate-database -DWasPassword=wpsadmin
]
We have to make sure build is successful.
In Command Prompt Open go to following location :
C:\Program Files (x86)\IBM\WebSphere\wp_profile\bin>
and execute following command:
stopServer.bat WebSphere_Portal -username admin_userid -password admin_password
[e.g. stopServer.bat WebSphere_Portal -username wpsadmin -password wpsadmin ]

7. In command prompt go to location [C:\Program Files (x86)\IBM\WebSphere\wp_profile\ConfigEngine>] we have to execute following command:
ConfigEngine.bat database-transfer -DwasPassword=
[e.g.
ConfigEngine.bat database-transfer -DwasPassword=wpsadmin
]
through above command all database will be transfer.
Note :
If you want to transfer specific database than use following command :
ConfigEngine.bat database-transfer -DTransferDomainList= -DwasPassword=
[e.g.
ConfigEngine.bat database-transfer -DTransferDomainList=jcr -DWasPassword=wpsadmin
]
Reference URL :
http://www-10.lotus.com/ldd/portalwiki.nsf/dx/Windows_standalone_Configuring_your_portal_to_use_DB2_wp8