Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    26

    Unanswered: Facing the problem while loading the data (SQL2038N)

    Hi All,

    We are facing the issue while loadin data from one database which in version 8.2 FP9
    collecting the .ixf file from the Dabase which is in 8.2 and loading the ixf file to table which is in 9.5 FP 5

    we are getting the following error
    SQL2038N A database system error "SQLUIIGN" occurred during processing.
    table is is going to load pending state

    then if i start the load with restart option after this
    load completing

    Please suggest us why this happning

    Thanks
    Prasadv18

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    could you specify your load command , please?
    Are you using the same OS for both databases?

    nvk

  3. #3
    Join Date
    Nov 2007
    Posts
    26
    load from AAA.ixf of ixf replace into wsdiwref.reft_establishment nonrecoverable

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    Have you tried one of the other file-formats?
    With del format you wont run into issues with the binary-ixf-files.

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    any additional info in db2diag.log file ?
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.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
  •