Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC64520 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem 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.
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.
Local Fix:
n/a
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem is first fixed in Version 9.7 Fix Pack 2
Workaround
n/a
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.11.2009
13.05.2010
13.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList