Re: Portal 6.0 trasfering the databases from Cloudscape to DB2 --- running long time

[gabrie...@sdhc.k12.fl.us]

Similar Problem trying to migrate from Cloudscape to a remote DB2 on z/OS :

action-process-constraints:
Tue Apr 17 13:04:46 EDT 2007
[java] [04/17/07 13:04:49.891 EDT] Attempting to create a new Instance of com.ibm.db2.jcc.DB2Driver
[java] [04/17/07 13:04:50.013 EDT] Instance of com.ibm.db2.jcc.DB2Driver created successfully
[java] [04/17/07 13:04:50.015 EDT] Attempting to make connection using: jdbc:db2:IB1A :: WASPRTL :: PASSWORD_REMOVED
[java] [04/17/07 13:04:51.279 EDT] Connection successfully made
[java] [04/17/07 13:04:51.381 EDT] EJPCA3340E: Error occurred gathering data from the source database
[java] com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE: 55023, SQLERRMC: SYSIBM.SQLTABLES;00E7900C
[java] at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
[java] at com.ibm.db2.jcc.a.db.l(db.java:366)
[java] at com.ibm.db2.jcc.a.db.e(db.java:102)
[java] at com.ibm.db2.jcc.a.r.e(r.java:72)
[java] at com.ibm.db2.jcc.a.sb.i(sb.java:194)
[java] at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
[java] at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
[java] at com.ibm.db2.jcc.b.bd.U(bd.java:188)
[java] at com.ibm.db2.jcc.b.s.a(s.java:7833)
[java] at com.ibm.db2.jcc.b.s.a(s.java:6337)
[java] at com.ibm.db2.jcc.b.s.getTables(s.java:6247)
[java] at com.ibm.wps.config.db.Database.getTablesList(Database.java:266)
[java] at com.ibm.wps.config.db.transfer.ConstraintHandler.process(ConstraintHandler.java:146)
[java] at com.ibm.wps.config.db.transfer.ConstraintHandler.main(ConstraintHandler.java:259)
[java] [04/17/07 13:04:51.387 EDT] EJPCA3342E: Error processing configuration 1 (All Schemas on the same source DB)
[java] err.dbtransfer.exception.labelclass com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE: 55023, SQLERRMC: SYSIBM.SQLTABLES;00E7900C
[java] com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -471, SQLSTATE: 55023, SQLERRMC: SYSIBM.SQLTABLES;00E7900C
[java] at com.ibm.db2.jcc.b.zc.d(zc.java:1351)
[java] at com.ibm.db2.jcc.a.db.l(db.java:366)
[java] at com.ibm.db2.jcc.a.db.e(db.java:102)
[java] at com.ibm.db2.jcc.a.r.e(r.java:72)
[java] at com.ibm.db2.jcc.a.sb.i(sb.java:194)
[java] at com.ibm.db2.jcc.b.zc.q(zc.java:1319)
[java] at com.ibm.db2.jcc.b.ad.d(ad.java:2281)
[java] at com.ibm.db2.jcc.b.bd.U(bd.java:188)
[java] at com.ibm.db2.jcc.b.s.a(s.java:7833)
[java] at com.ibm.db2.jcc.b.s.a(s.java:6337)
[java] at com.ibm.db2.jcc.b.s.getTables(s.java:6247)
[java] at com.ibm.wps.config.db.Database.getTablesList(Database.java:266)
[java] at com.ibm.wps.config.db.transfer.ConstraintHandler.process(ConstraintHandler.java:146)
[java] at com.ibm.wps.config.db.transfer.ConstraintHandler.main(ConstraintHandler.java:259)

action-drop-constraints:
Tue Apr 17 13:04:55 EDT 2007
[java] Reading file /opt/IBM/WebSphere/PortalServer/config/DBTransfer/wps/disableConstraints.sql
[java] Could not read /opt/IBM/WebSphere/PortalServer/config/DBTransfer/wps/disableConstraints.sql
[java] java.io.FileNotFoundException: /opt/IBM/WebSphere/PortalServer/config/DBTransfer/wps/disableConstraints.sql (No such file or directory)
[java] at java.io.FileInputStream.open(Native Method)
[java] at java.io.FileInputStream.<init>(FileInputStream.java:129)
[java] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
[java] at com.ibm.wps.config.SqlProcessor.process(Unknown Source)
[java] at com.ibm.wps.config.SqlProcessor.main(Unknown Source)

BUILD FAILED
file:../config/actions/dbt_dbcfg.xml:391: Java returned: 3

Total time: 33 minutes 14 seconds

Any ideas anyone?