Increase the size of the bufferpool.
From:
"Senjith.K.K " <db2udbdba-ezmlmshield-x80833477.[Email address protected]
To:
"LazyDBA Discussion" <[Email address protected]
Date:
04/15/2008 08:36 AM
Subject:
Problem in transfering data from cloudscape to DB2
Hi
I am using Webshpere Portal 6.0, in linux platform.
I am trying to change the database from Cloudscape (default) to IBM DB2
9.1.
I updated all the configuration files and started transferring manually.
Transferring works fine with release, community, customization domains.
When it comes to JCR, tables are created successfully. But error occurs
during transfer. Shown below
[echo] Transfer Data :: MaxMemory is 512M
[java] [04/15/08 17:53:16.389 IST] Attempting to make connection
using:
jdbc:db2:wpsdb;create=true :: db2inst1 :: PASSWORD_REMOVED
[java] [04/15/08 17:53:16.427 IST] Connection successfully made
[java] [04/15/08 17:53:16.431 IST] Attempting to make connection
using:
jdbc:db2j:wpsdb;create=true :: db2admin :: PASSWORD_REMOVED
[java] [04/15/08 17:53:16.870 IST] Connection successfully made
[java] [04/15/08 17:53:16.879 IST] Transfer started
[java] [04/15/08 17:53:26.553 IST] Transferring table --{
JCR.ICMUT01559001}-- to table --{JCR.ICMUT01559001 }--
[java] [04/15/08 17:53:27.160 IST] Transferring table --{
JCR.ICMUT01481001}-- to table --{JCR.ICMUT01481001 }--
[java] [04/15/08 17:53:27.627 IST] Transferring table --{
JCR.ICMUT01488001}-- to table --{JCR.ICMUT01488001 }--
[java] [04/15/08 17:53:27.952 IST] Transferring table --{
JCR.ICMUT01593001}-- to table --{JCR.ICMUT01593001 }--
[java] [04/15/08 17:53:28.088 IST] error.executing.transfer
[java] err.dbtransfer.exception.labelclass
java.sql.BatchUpdateException: [IBM][CLI Driver][DB2/LINUX] SQL1476N The
current transaction was rolled back because of error "-1218".
SQLSTATE=40506
Any suggestions will be very helpful..
Thanks & Regards
Senjith K.K
Persistent Systems Ltd.
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page