Migrating Portal 6.0 database to DB2

[Anantha]

I m having problem when running configwizard task for migrating portal
database to db2 from cloudscape.

I found thos in configtrace.log file

[sqlproc] CREATE TABLE release.WSRP_PROD_LOD (
[sqlproc] WSRP_PROD_OID CHAR(18) FOR BIT DATA NOT NULL,
[sqlproc] LOCALE VARCHAR(64) NOT NULL,
[sqlproc] TITLE VARGRAPHIC(255),
[sqlproc] DESCRIPTION VARGRAPHIC(1024),
[sqlproc] CONSTRAINT PK560 PRIMARY KEY (WSRP_PROD_OID, LOCALE),
[sqlproc] CONSTRAINT FK560 FOREIGN KEY (WSRP_PROD_OID) REFERENCES
release.WSRP_PROD (OID) ON DELETE CASCADE
[sqlproc] )

[sqlproc] Error during statement execution!
[sqlproc] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT]
SQL1216N Graphic data and graphic functions are not supported for this
database. SQLSTATE=56031

[sqlproc] at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)
[sqlproc] at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown
Source)
[sqlproc] at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown
Source)
[sqlproc] at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown
Source)
[sqlproc] at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown
Source)
[sqlproc] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
[sqlproc] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
[sqlproc] at
com.ibm.wps.config.SqlProcessorTask.executeSqlScript(Unknown Source)
[sqlproc] at com.ibm.wps.config.SqlProcessorTask.execute(Unknown
Source)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at
org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:117)
[sqlproc] at com.ibm.wps.config.If.execute(Unknown Source)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at
org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at
org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at
org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at com.ibm.wps.config.ForTask.execute(Unknown Source)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at
org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:397)
[sqlproc] at
org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:143)
[sqlproc] at org.apache.tools.ant.Task.perform(Task.java:341)
[sqlproc] at org.apache.tools.ant.Target.execute(Target.java:309)
[sqlproc] at
org.apache.tools.ant.Target.performTasks(Target.java:336)
[sqlproc] at
org.apache.tools.ant.Project.executeTarget(Project.java:1339)
[sqlproc] at
org.apache.tools.ant.Project.executeTargets(Project.java:1255)
[sqlproc] at org.apache.tools.ant.Main.runBuild(Main.java:609)
[sqlproc] at org.apache.tools.ant.Main.start(Main.java:196)
[sqlproc] at com.ibm.wps.config.WpsConfigMain.process(Unknown
Source)
[sqlproc] at com.ibm.wps.config.WpsConfigMain.main(Unknown Source)
[sqlproc] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[sqlproc] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)
[sqlproc] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)
[sqlproc] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)
[sqlproc] at java.lang.reflect.Method.invoke(Method.java:391)
[sqlproc] at
com.ibm.ws.bootstrap.WSLauncher.run(WSLauncher.java:219)
[sqlproc] at java.lang.Thread.run(Thread.java:570)
[sqlproc] (ErrCode=-1216, SqlState=56031)
[sqlproc] _________________________________________________________

Please help me out to clear this problem..

Thanks & Regs
Anantha

[Anantha]

Thanks guys, I have found the solution for the above problem.

Actually the DB has to be created with Pagesize 8k rather be 4k. then
only its supports for the VARGRAPHIC datatypes.