Hello Senjith,

Can you please send us following information for further analysis :

1. Db2 daignostic log information related to this error.
2. O/p of following command db2mtrk -i -d
3. Information about your buffer pools.
4. Bit size of OS and DB2

Thanks,
Mac




"Senjith.K.K " <db2udbdba-ezmlmshield-x80833477.[Email address protected]
15/04/2008 13:36

To
"LazyDBA Discussion" <[Email address protected]
cc

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





http://www.rac.co.uk
http://www.rac.co.uk/business
http://www.bsm.co.uk

Any opinions expressed in this e-mail are those of the individual and not necessarily the company. This e-mail and any attachments are confidential to RAC and/or BSM and are solely for use by the intended recipient.

If you are not the intended recipient you must not disclose, copy or distribute its contents to any other person nor use its contents in any way.
If you have received this e-mail in error please forward a copy of this e-mail to "[Email address protected]

RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902
VAT Reg No. GB 239505847
RAC Financial Services Limited: Registered England & Wales 5171817
VAT Reg No. GB 238640945
Registered Office(s): 8 Surrey Street, Norwich, NR1 3NG

RAC Motoring Services and RAC Financial Services Limited are authorised and regulated by the Financial Services Authority, both companies are members of the Aviva group.

This e-mail and any attachments has been scanned for the presence of computer viruses. RAC/BSM accept no responsibility for computer viruses once this e-mail has been transmitted.

DB2 & UDB email list listserv db2-l LazyDBA home page