Professional Web Applications Themes

Oracle 8 to DB2 migration problem. - IBM DB2

Hi Sy, If you look at the METHOD L clause of the LOAD statement, you'll see that the 6th column is expected to be of 26 characters length (from 172 to 197). That's exactly the length of the TIMESTAMP datatype (for example, "2003-01-01-00.00.00.000000"). On the other hand, you're saying that it contains "2003-06-26" for the DATE column. Since I don't know your table structure, I don't know whether the problem is in the OracleCatalog_JAMESD2_NB_CONTACTDETAILS.out file, or in NB_CONTACTDETAILS DB2 table, but they should be aligned. I used extensively IBM Migration ToolKit, and I think it's still in Beta phase for ...

  1. #1

    Default Re: Oracle 8 to DB2 migration problem.

    Hi Sy,

    If you look at the METHOD L clause of the LOAD statement, you'll see
    that the 6th column is expected to be of 26 characters length (from
    172 to 197). That's exactly the length of the TIMESTAMP datatype (for
    example, "2003-01-01-00.00.00.000000"). On the other hand, you're
    saying that it contains "2003-06-26" for the DATE column.

    Since I don't know your table structure, I don't know whether the
    problem is in the OracleCatalog_JAMESD2_NB_CONTACTDETAILS.out file, or
    in NB_CONTACTDETAILS DB2 table, but they should be aligned.

    I used extensively IBM Migration ToolKit, and I think it's still in
    Beta phase for the Oracle->DB2 conversion, so it may be not perfect.

    I'll be glad to assist you to fix this and other problems related to
    your migration project.

    Best Regards,

    Dmitry Balin

    ***********************************************
    OCP, MCP, IBM Certified Solutions Expert
    DB Best Technologies LLC - Principal Colsultant
    Database Migration is Our Expertise
    web: [url]www.dbbest.com[/url]
    email: [email]dmitrydbbest.com[/email]
    tel: (408)202-4567
    ***********************************************



    [email]sy.phanaiaa.com.au[/email] (sy phan) wrote in message news:<515b8514.0307201558.17d4b3eaposting.google. com>...
    > Hi all,
    >
    > I used IBM Migration ToolKit to do the migration and got problem with
    > converting a date to a date. DB2 tables are created as I wanted but
    > there is no data because of error SQL3405N. The log is as below.
    >
    > LOAD CLIENT FROM C:\MTK_ora\projects\Test_jamesd2\DataOutScripts\Or acleCatalog_JAMESD2_NB_CONTACTDETAILS.out
    > of ASC MODIFIED BY reclen=500 striptblanks METHOD L(1 68,70 137,139
    > 143,145 149,151 170,172 197,199 216,218 247,249 278,280 299,301
    > 317,319 327,329 330,332 351,353 372,374 393,395 414,416 465) NULL
    > INDICATORS (0,468,470,472,474,476,478,480,482,484,486,488,490 ,492,494,496,498,500)
    > INSERT INTO NB_CONTACTDETAILS
    >
    > SQL3501W The table space(s) in which the table resides will not be
    > placed in
    > backup pending state since forward recovery is disabled for the
    > database.
    >
    > SQL3109N The utility is beginning to load data from file
    > "C:\MTK_ora\projects\Test_jamesd2\DataOutScripts\O racleCatalog_JAMESD2_".
    >
    > SQL3500W The utility is beginning the "LOAD" phase at time
    > "07-21-2003
    > 09:32:03.082378".
    >
    > SQL3405N The beginning-ending location pair for inserting into column
    > "6" is
    > not valid for a date.
    >
    > Number of rows read = 0
    > Number of rows skipped = 0
    > Number of rows loaded = 0
    > Number of rows rejected = 0
    > Number of rows deleted = 0
    > Number of rows committed = 0
    >
    > How should this problem be fixed?
    > I check the out file, it contains "2003-06-26" for the date column.
    >
    > Thanks
    Dmitry Balin Guest

  2. #2

    Default Re: Oracle 8 to DB2 migration problem.

    Whenever you have problems with the MTK send a note to
    [email]mtkus.ibm.com[/email]
    These guys have a very fast turnaround to improve/fix especially while in
    beta-mode.

    Cheers
    Serge


    Serge Rielau Guest

Similar Threads

  1. Help Needed Regarding Oracle Migration
    By Azhar Bilgrami in forum PERL Modules
    Replies: 0
    Last Post: December 31st, 09:32 AM
  2. Oracle to DB2 migration
    By Prakash in forum IBM DB2
    Replies: 5
    Last Post: October 9th, 07:08 PM
  3. Replies: 3
    Last Post: August 27th, 12:48 PM
  4. DB2 migration problem
    By Damir Wilder in forum IBM DB2
    Replies: 0
    Last Post: August 22nd, 11:52 AM
  5. Migration oracle V7 oracle V8
    By Paul Brewer in forum Oracle Server
    Replies: 1
    Last Post: December 6th, 08:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139