DB2 - Problembeschreibung
Problem IC67948 | Status: Geschlossen |
GETMNTENT() FUNCTION CAUSING TABLESPACES TO RETURN SQL0290N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69249 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.04.2010 24.09.2010 24.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.3 | |
9.7.0.3 |