Topic
  • 5 replies
  • Latest Post - ‏2011-03-08T23:41:12Z by Merrilee.Stiers
CMcGee
CMcGee
12 Posts

Pinned topic Transfer Derby to DB2 iSeries fails - target table not valid for operation

‏2010-07-20T13:36:19Z |
I installed Beta 4 on our iSeries, then ran the configwizard.sh to transfer the database from Derby to DB2 on the iSeries. The process starts, creates the tables (I had to create the libraries/schema) then on the step to transfer the data for the release table I get the following error:

07/20/10 08:21:44.706 CDT Processing table -{ WEB_MOD->WEB_MOD }-
07/20/10 08:21:44.711 CDT SELECT * FROM "RELEASE"."WEB_MOD"
07/20/10 08:21:45.412 CDT INSERT INTO "RELDB"."WEB_MOD" ("OID","FILE_NAME","PATH","CONTEXT_ROOT","WAS_DISPLAY_NAME","IS_ACTIVE","IS_REMOVABLE","GUID","MAJOR_VERSION","MINOR_VERSION","ANON_SESSION","IS_PREDEPLOYED","CREATED","MODIFIED","WEB_MOD_NAME","IS_JSR_TYPE") VALUES( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
07/20/10 08:21:45.422 CDT Transferring table { RELEASE.WEB_MOD} to table {RELDB.WEB_MOD }
07/20/10 08:21:46.616 CDT row {0} COMMIT completed: Table Frequency (250)
07/20/10 08:21:47.339 CDT Nested Exceptions:
07/20/10 08:21:47.339 CDT error.executing.transfer
err.dbtransfer.exception.labelclass java.sql.BatchUpdateException: SQL7008 WEB_MOD in RELDB not valid for operation.
java.sql.BatchUpdateException: SQL7008 WEB_MOD in RELDB not valid for operation.
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeBatch(AS400JDBCPreparedStatement.java:1247)
at com.ibm.wps.config.db.transfer.DefaultTableHandler.execute(DefaultTableHandler.java:134)
at com.ibm.wps.config.db.transfer.TransferEngine.execute(TransferEngine.java:70)
at com.ibm.wps.config.db.transfer.CmdLineTransfer.execute(CmdLineTransfer.java:96)
at com.ibm.wps.config.db.transfer.CmdLineTransfer.main(CmdLineTransfer.java:43)
Updated on 2011-03-08T23:41:12Z at 2011-03-08T23:41:12Z by Merrilee.Stiers
  • koicarer
    koicarer
    7 Posts

    Re: Transfer Derby to DB2 iSeries fails - target table not valid for operation

    ‏2010-07-20T20:17:20Z  
    The problem might have been caused by usage of the wrong driver since WP7 on iseries requires an updated type 4 jdbc driver to be installed manually on the iseries system and referenced in the wkplc_dbtype.properties (except Express where it is done for the Customer). Here is what I mean:

    non-Express iseries has this in wkplc_dbtype.properties:

    #db2_iseries.DbLibrary
    #The directory and name of the zip/jar file containing JDBC version 4 driver class
    #Value: Alphanumeric text string
    #Example: The following are examples:
    #Example: Type 2 driver: db2_iseries.DbLibrary=/QIBM/ProdData/OS400/Java400/ext/db2_classes16.jar
    #Example: Type 4 driver: db2_iseries.DbLibrary=<JDBC driver location>/jt400.jar
    #Example: Type 4 driver iSeries: check the latest jt400.jar in http://sourceforge.net/projects/jt400/files/
    #Example: Type 4 driver iSeries: pick the driver file with "jtopen_x_y_jdbc40_jdk6.zip". x, y: major, minor version.
    #Default: <JDBC driver location>/jt400.jar

    db2_iseries.DbLibrary=<JDBC driver location>/jt400.jar

    Have downloaded the latest version 4 of jt400.jar file and modified the properties file 'wkplc_dbtype.properties'?

    CD
  • CMcGee
    CMcGee
    12 Posts

    Re: Transfer Derby to DB2 iSeries fails - target table not valid for operation

    ‏2010-07-21T13:35:16Z  
    Yes I have downloaded the jt400 and the jt400Native file tried those plus I tried the jt400Native that was installed with Portal. My first attempt was using the configwizard.sh in QSH which fails on the 'target table not valid for operation'. I'am going to try to go through the process manually and see if I get the same issue.
  • tstober
    tstober
    7 Posts

    Re: Transfer Derby to DB2 iSeries fails - target table not valid for operation

    ‏2010-08-02T15:58:19Z  
    hello,
    have you made progress with this attempt?
    >>go through the process manually
  • CMcGee
    CMcGee
    12 Posts

    Re: Transfer Derby to DB2 iSeries fails - target table not valid for operation

    ‏2010-08-02T17:16:21Z  
    I was only able to transfer the database from Derby to DB2 iSeries using the manual process, neither of the wizards (gui and QSH) worked.
  • Merrilee.Stiers
    Merrilee.Stiers
    1 Post

    Re: Transfer Derby to DB2 iSeries fails - target table not valid for operation

    ‏2011-03-08T23:41:12Z  
    koicarer wrote:
    The problem might have been caused by usage of the wrong driver since WP7 on iseries requires an updated type 4 jdbc driver to be installed manually on the iseries system and referenced in the wkplc_dbtype.properties (except Express where it is done for the Customer). Here is what I mean:

    non-Express iseries has this in wkplc_dbtype.properties:

    #db2_iseries.DbLibrary
    #The directory and name of the zip/jar file containing JDBC version 4 driver class
    #Value: Alphanumeric text string
    #Example: The following are examples:
    #Example: Type 2 driver: db2_iseries.DbLibrary=/QIBM/ProdData/OS400/Java400/ext/db2_classes16.jar
    #Example: Type 4 driver: db2_iseries.DbLibrary=<jdbc driver="" location="">/jt400.jar
    #Example: Type 4 driver iSeries: check the latest jt400.jar in http://sourceforge.net/projects/jt400/files/
    #Example: Type 4 driver iSeries: pick the driver file with "jtopen_x_y_jdbc40_jdk6.zip". x, y: major, minor version.
    #Default: <jdbc driver="" location="">/jt400.jar

    db2_iseries.DbLibrary=<jdbc driver="" location="">/jt400.jar

    Have downloaded the latest version 4 of jt400.jar file and modified the properties file 'wkplc_dbtype.properties'?

    CD</jdbc></jdbc></jdbc>

    I understand this part, Thanks for your sharing!