Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2008
    Posts
    29

    Arrow Unanswered: Import fails...SQLCODE: -3319

    Guys

    I am trying to restore schemas into a DB from a set of *.msg ,*.ixf and db2move.lst files.

    It restored for 4 schemas out of 5 properly but in the 5th schema ,for 5 diffrent tables it failed like this:

    * IMPORT: table "<SCHEMA> "."<TABLE_NAME>"
    ***ERROR -3319. Check message file tab75.msg!
    *** SQLCODE: -3319 - SQLSTATE:
    *** SQL3319N An SQL error "-286" occurred while creating the table

    Any quick guidance on this would be appreciated.

    Regards
    Abhi

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    So, did you "Check message file tab75.msg"?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2008
    Posts
    29
    oh !!

    didn't i see that?

    thanks for reminding sir....that was an eye-opener

Posting Permissions

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