IBM Support

LI75002: LOAD SHOW ERROR MESSAGE IN DB2DIAG.LOG. "SQLUREMOVETEMPDIRS: COULD NOT READ LOC FILE PROPERLY! , -2146107283"

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Load utility may dump the following error message in db2diag.log
    
    2009-11-06-15.23.25.332444-300 I256116038E543      LEVEL: Error
    PID     : 13908                TID  : 212802201952 PROC :
    db2sysc 23
    INSTANCE: nyqxt150             NODE : 023          DB   : WISEQA
    APPHDL  : 1-32857              APPID:
    10.184.12.117.62849.09110620225
    AUTHID  : WISEETLQ
    EDUID   : 234339               EDUNAME: db2agnta (WISEQA) 23
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    MESSAGE : sqluRemoveTempDirs: could not read loc file properly!
    , -2146107283,
              (nil), Detected in file:sqluqagt.C, Line:2175
    
    2009-11-06-15.23.25.330721-300 I256116582E518      LEVEL: Error
    PID     : 14153                TID  : 207022451040 PROC :
    db2sysc 24
    INSTANCE: nyqxt150             NODE : 024          DB   : WISEQA
    APPHDL  : 1-32857              APPID:
    10.184.12.117.62849.09110620225
    AUTHID  : WISEETLQ
    EDUID   : 234340               EDUNAME: db2agnta (WISEQA) 24
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    MESSAGE : open locfile for read failed! , -2045837302, (nil),
    Detected in
              file:sqlulocf.C, Line:274
    
    These errors are caused by incorrect order to delete .loc/temp
    files in sqluRemoveTempDirs function.
    
    This error is informational only, and can be ignored if there's
    no other problems happen at the same time.
    

Local fix

  • n/a
    

Problem summary

  • Problem Description:
    LOAD SHOW ERROR MESSAGE IN DB2DIAG.LOG. "SQLUREMOVETEMPDIRS:
    COULD NOT READ LOC FILE PROPERLY! , -2146107283"
    Problem Summary:
    Load utility may dump the following error message in db2diag.log
    
    
    2009-11-06-15.23.25.332444-300 I256116038E543      LEVEL: Error
    PID     : 13908                TID  : 212802201952 PROC :
    db2sysc 23
    INSTANCE: nyqxt150             NODE : 023          DB   : WISEQA
    APPHDL  : 1-32857              APPID:
    10.184.12.117.62849.09110620225
    AUTHID  : WISEETLQ
    EDUID   : 234339               EDUNAME: db2agnta (WISEQA) 23
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    MESSAGE : sqluRemoveTempDirs: could not read loc file properly!
    , -2146107283,
              (nil), Detected in file:sqluqagt.C, Line:2175
    
    2009-11-06-15.23.25.330721-300 I256116582E518      LEVEL: Error
    PID     : 14153                TID  : 207022451040 PROC :
    db2sysc 24
    INSTANCE: nyqxt150             NODE : 024          DB   : WISEQA
    APPHDL  : 1-32857              APPID:
    10.184.12.117.62849.09110620225
    AUTHID  : WISEETLQ
    EDUID   : 234340               EDUNAME: db2agnta (WISEQA) 24
    FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
    MESSAGE : open locfile for read failed! , -2045837302, (nil),
    Detected in
              file:sqlulocf.C, Line:274
    
    These errors are caused by incorrect order to delete .loc/temp
    files in sqluRemoveTempDirs function.
    
    This error is informational only, and can be ignored if there's
    no other problems happen at the same time.
    

Problem conclusion

  • Problem is first fixed in Version 9.5 Fix Pack 6
    

Temporary fix

  • n/a
    

Comments

APAR Information

  • APAR number

    LI75002

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-15

  • Closed date

    2010-05-13

  • Last modified date

    2010-05-13

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC64520

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 May 2010