home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList
9.7.0.3 FixList