Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    9

    Unhappy Unanswered: import do not respond

    the sentence not respond and not giving me an error message.

    IMPORT FROM c:\codesarrollo\credito.txt
    OF DEL MODIFIED BY coldel| chardel"" decpt.
    COMMITCOUNT 100
    MESSAGES c:\codesarrollo\error5.txt
    INSERT INTO DB2ADMIN.CREDITO;

    The file from which I would like to import has text format.
    I have db2 version 9.1, but on a server with RHEL 4 it works but on another server with RHEL 5 is not working the instruction IMPORT.

    Any suggestion.
    Thanks

    Fredd Minda

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Set DIAGLEVEL to 4 and see if there are any insights in the log file. Also, make sure the file is readable by the instance owner uid and is not locked by any other process.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jun 2006
    Posts
    471
    do list applications - check the status - do create snapshot for this agent to see what he is doing
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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