Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    22

    Arrow Unanswered: Failed to set temporary file path, WHY??

    DB2 V8 ,FP6 ,LINUX AS3 .

    When I do LOAD ,I've got the following messages from db2diag.log . I dont know why. (Does tempsapce get its filesystem limited, I means the disk was full at that time.)
    thanks a lot !!

    LOADID: 24303.2004-06-30-07.37.30.962907.0 (3;10)
    Failed to set temporary file path. -3508, (nil), Detected in file: sqluvtld.C,line 3046
    **************************************
    Make progress everyday
    Mail: hoo.jimmy@gmail.com
    **************************************

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by huyuhui
    DB2 V8 ,FP6 ,LINUX AS3 .

    When I do LOAD ,I've got the following messages from db2diag.log . I dont know why. (Does tempsapce get its filesystem limited, I means the disk was full at that time.)
    thanks a lot !!

    LOADID: 24303.2004-06-30-07.37.30.962907.0 (3;10)
    Failed to set temporary file path. -3508, (nil), Detected in file: sqluvtld.C,line 3046
    What's your LOAD command? This sounds like a permissions problem, or a directory not existing. Do you get an error at the command line, or just in the db2diag?
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Apr 2004
    Posts
    22
    The LOAD command just like " load from filename of del modified by modified by coldel0x09 NOROWWARNINGS insert into tablename NONRECOVERABLE CPU_PARALLELISM 16 DISK_PARALLELISM 30 "

    The following message was in db2diag.log

    LOADID: 24303.2004-06-30-07.37.30.962907.0 (3;10)
    Failed to set temporary file path. -3508, (nil), Detected in file: sqluvtld.C,line 3046
    **************************************
    Make progress everyday
    Mail: hoo.jimmy@gmail.com
    **************************************

  4. #4
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by huyuhui
    The LOAD command just like " load from filename of del modified by modified by coldel0x09 NOROWWARNINGS insert into tablename NONRECOVERABLE CPU_PARALLELISM 16 DISK_PARALLELISM 30 "

    The following message was in db2diag.log

    LOADID: 24303.2004-06-30-07.37.30.962907.0 (3;10)
    Failed to set temporary file path. -3508, (nil), Detected in file: sqluvtld.C,line 3046
    Try the option TEMPFILES PATH <path>, point it to something you have write access to.

    I think the default is under the database directory.
    --
    Jonathan Petruk
    DB2 Database Consultant

Posting Permissions

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