DB2 v9.7 Issues faced and while doing Websphere Portal DB Transfer

Got the following errors while doing the DB transfer 

     

1. Failed with following error .

Error Details

2012-03-13 05:22:59 cmcfgls: TRACE ->  source --> C:/IBM/WP72/WebSphere/wp_profile/PortalServer/jcr\config\icmplsct.ddl

2012-03-13 05:22:59 cmcfgls: DEBUG -> Executing:

  CREATE TABLE jcr.ICMSTADMINDOMAINS ( DOMAINID            INTEGER        NOT NULL, PRIMARY KEY         (DOMAINID) ) IN ICMSFQ04

2012-03-13 05:22:59 cmcfgls: ERROR ->Fail to execute:

 CREATE TABLE jcr.ICMSTADMINDOMAINS ( DOMAINID            INTEGER        NOT NULL, PRIMARY KEY         (DOMAINID) ) IN ICMSFQ04

com.ibm.cm.dbutil.ICMDBUtilsException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ICMSFQ04, DRIVER=4.8.87

at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:1110)

at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:999)

at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:306)

at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1160)

at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:2119)

at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:154)

at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:278)

at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:295)

com.ibm.cm.dbutil.ICMDBUtilsException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ICMSFQ04, DRIVER=4.8.87

at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:1135)

at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:999)

at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:306)

at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1160)

at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:2119)

at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:154)

at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:278)

at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:295)

com.ibm.cm.dbutil.ICMDBUtilsException: Fail to create database

at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:326)

at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1160)

at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:2119)

at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:154)

at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:278)

at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:295)

Reason/Solution:

This is caused when I didn't executed/created the tablespaces for the JCR .

2. Failed with following error 

Error Details
C:\IBM\WebSphere\wp_profile\ConfigEngine\log\portal-database-transfer.log

[sqlproc] Error during statement execution!

  [sqlproc] com.ibm.db2.jcc.am.vo: DB2 SQL Error: SQLCODE=-286, SQLSTATE=42727, SQLERRMC=8192;DB2ADMIN, DRIVER=4.8.87

  [sqlproc]         at com.ibm.db2.jcc.am.gd.a(gd.java:676)

…….

  [sqlproc]         at com.ibm.wps.config.launch.ConfigEngineLauncher.main(ConfigEngineLauncher.java:311)

  [sqlproc] (ErrCode=-286, SqlState=42727)

Reason/Solution

This error occurred  before I use proper SQL's to create the database instance . 

Problem is with page size on database , need to set the higher pagesize and SQLERRMC generally gives what need to be the actual page size (Pagesize is SQLERRMC i.e. 8192).

To solve this , delete the database that is already created and recreate with larger page size.  For example, enter the command CREATE DB database_name PAGESIZE size

http://www-01.ibm.com/support/docview.wss?uid=swg21414318