home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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