|
Problem IC67948
|
Status: Closed |
GETMNTENT() FUNCTION CAUSING TABLESPACES TO RETURN SQL0290N |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
There is a small timing hole when checking the filesystem info
for the tablespace containers that can result in an ECF_FAILED
error and an SQL0290N error being returned to the user. With
two or more concurrent attempts to access the filesytem
information for the same filesystem, it is possible that one of
these attempts can fail resulting in the ECF_FAILED error. An
example db2diag.log snippet is:
2010-03-24-06.00.05.386590-240 I79218534E575 LEVEL: Severe
PID : 26212 TID : 47639638829376PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-46638 APPID:
11.22.33.44.45187.100324100005
AUTHID : db2inst1
EDUID : 48510 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services,
sqlbFetchAndStoreContainerFSInfo, probe:10
MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED
Failed
DATA #1 : File name, 51 bytes
/db2/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0
2010-03-24-06.00.05.386821-240 I79219110E588 LEVEL: Error
PID : 26212 TID : 47639638829376PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-46638 APPID:
11.22.33.44.45187.100324100005
AUTHID : db2inst1
EDUID : 48510 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir,
probe:815
MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED
Failed
DATA #1 : <preformatted>
Error starting to use directory
/db2/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0.
2010-03-24-06.00.05.386955-240 I79219699E477 LEVEL: Error
PID : 26212 TID : 47639638829376PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-46638 APPID:
11.22.33.44.45187.100324100005
AUTHID : db2inst1
EDUID : 48510 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool,
probe:110
MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED
Failed
2010-03-24-06.00.05.387061-240 E79220177E591 LEVEL: Info
PID : 26212 TID : 47639638829376PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-46638 APPID:
11.22.33.44.45187.100324100005
AUTHID : db2inst1
EDUID : 48510 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools,
probe:30
MESSAGE : ADM6023I The table space "SYSCATSPACE" (ID "0") is in
state 0x"0".
The table space cannot be accessed. Refer to the
documentation for
SQLCODE -290. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* V9.7 users fix pack 2 and earlier *
****************************************************************
* PROBLEM DESCRIPTION: *
* There is a small timing hole when checking the filesystem *
* info *
* for the tablespace containers that can result in an *
* ECF_FAILED *
* error and an SQL0290N error being returned to the user. *
* With *
* two or more concurrent attempts to access the filesytem *
* *
* information for the same filesystem, it is possible that one *
* of *
* these attempts can fail resulting in the ECF_FAILED error. *
* An *
* example db2diag.log snippet is: *
* *
* *
* *
* 2010-03-24-06.00.05.386590-240 I79218534E575 LEVEL: *
* Severe *
* *
* *
* PID : 26212 TID : 47639638829376PROC : *
* *
* db2sysc *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-46638 APPID: *
* *
* 11.22.33.44.45187.100324100005 *
* *
* AUTHID : db2inst1 *
* *
* EDUID : 48510 EDUNAME: db2agent (SAMPLE) *
* *
* FUNCTION: DB2 UDB, buffer pool services, *
* *
* sqlbFetchAndStoreContainerFSInfo, probe:10 *
* *
* MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED *
* *
* Failed *
* *
* DATA #1 : File name, 51 bytes *
* *
* /db2/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0 *
* *
* *
* *
* 2010-03-24-06.00.05.386821-240 I79219110E588 LEVEL: *
* Error *
* PID : 26212 TID : 47639638829376PROC : *
* *
* db2sysc *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-46638 APPID: *
* *
* 11.22.33.44.45187.100324100005 *
* *
* AUTHID : db2inst1 *
* *
* EDUID : 48510 EDUNAME: db2agent (SAMPLE) *
* *
* FUNCTION: DB2 UDB, buffer pool services, sqlbStartUsingDir, *
* *
* probe:815 *
* *
* MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED *
* *
* Failed *
* *
* DATA #1 : <preformatted> *
* *
* Error starting to use directory *
* *
* /db2/db2inst1/db2inst1/NODE0000/SQL00001/SQLT0000.0. *
* *
* *
* *
* 2010-03-24-06.00.05.386955-240 I79219699E477 LEVEL: *
* Error *
* PID : 26212 TID : 47639638829376PROC : *
* *
* db2sysc *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-46638 APPID: *
* *
* 11.22.33.44.45187.100324100005 *
* *
* AUTHID : db2inst1 *
* *
* EDUID : 48510 EDUNAME: db2agent (SAMPLE) *
* *
* FUNCTION: DB2 UDB, buffer pool services, sqlbSMSStartPool, *
* *
* probe:110 *
* *
* MESSAGE : ECF=0x90000002=-1879048190=ECF_FAILED *
* *
* Failed *
* *
* *
* *
* 2010-03-24-06.00.05.387061-240 E79220177E591 LEVEL: *
* Info *
* PID : 26212 TID : 47639638829376PROC : *
* *
* db2sysc *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-46638 APPID: *
* *
* 11.22.33.44.45187.100324100005 *
* *
* AUTHID : db2inst1 *
* *
* EDUID : 48510 EDUNAME: db2agent (SAMPLE) *
* *
* FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, *
* *
* probe:30 *
* *
* MESSAGE : ADM6023I The table space "SYSCATSPACE" (ID "0") is *
* in *
* state 0x"0". *
* *
* The table space cannot be accessed. Refer to the *
* *
* documentation for *
* *
* SQLCODE -290. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to fix pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69249
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.04.2010
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
