Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    2

    Unanswered: errors during loading

    Hi all, I m trying to load the data exported from DB2 v5 Os/2 to DB2 v 8 .1 and getting the following error in the process..
    SQL03089N A non D record was found where a D record was expected......
    ANy idea?????

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    loading the data exported from DB2 v5 Os/2 to DB2 v 8 .1 ?? Is it allowed?
    DB2s are incompatible.
    mota

  3. #3
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Aren't there any useful LOAD parameters to be set, so that the data becomes compatible?
    Sorry for not being more helpful; I'm not fully familiar with LOAD params on non-z/OS, and neither do I know the data format of OS/2 ...
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  4. #4
    Join Date
    Aug 2006
    Posts
    2
    hi,,, i have the exports file in IXF format . i am already done with some 58 tables,. This error is coming only in one of the tables. and infact that table ois the largest one with some 63K records.
    I think i should try it out with the DEL format.....
    what do u say!!!

  5. #5
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    You could check the correctness of the exported data by loading it back into the OS/2 system (of course into a different table).
    If that works, a possible problem could be (just guessing) a difference in codepages, with a certain character from the source codepage missing in the target codepage.
    If that's the case, try loading into a UNICODE-encoded table.

    An other problem could be the "physical" transfer of the data file between the two systems: did you make sure to copy it (with FTP or whatever) in BINARY mode?
    Or did you ZIP it? In that case, using GNU zip instead of winzip could solve the problem...
    Last edited by Peter.Vanroose; 08-11-06 at 05:04.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

Posting Permissions

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