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 IC75205 Status: Geschlossen

THE INSTANCE MAY CRASH WHEN TRYING TO ADD A TABLE SPACE CONTAINER THAT HAS
BEEN USED PREVIOUSLY BY THE SAME DATABASE

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When attempting to add a table space using a file or path 
container, and the container has previously been used by the 
same database, the instance may crash a similar stack as below: 
 
 
0      sqlbDMSAddContainerRequest 
1      sqlbDMSCreatePool 
2      sqlbSetupPool 
3      sqlbCreatePool 
4      sqldPoolCreate 
5      sqlrlcts 
6      sqlnq_create_tablespace_end 
7      sqlnq_create_tablespace_stmt 
8      sqlnp_smactn 
9      sqlnp_parser 
10      sqlnp_main 
 
This happens when the user attempts to use either a path 
containing a stale container tag file (SQLNAM.TAG), or a file 
container that has previously been used by the database, but is 
not in use any longer (for example old tablespace container 
restored from a filesystem backup).
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* THE INSTANCE MAY CRASH WHEN TRYING TO ADD A TABLE SPACE      * 
* CONTAINER THAT HAS BEEN USED PREVIOUSLY BY THE SAME DATABASE * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When attempting to add a table space using a file or path    * 
* container, and the container has previously been used by the * 
* same database, the instance may crash a similar stack as     * 
* below:                                                       * 
*                                                              * 
*                                                              * 
* 0      sqlbDMSAddContainerRequest                            * 
* 1      sqlbDMSCreatePool                                     * 
* 2      sqlbSetupPool                                         * 
* 3      sqlbCreatePool                                        * 
* 4      sqldPoolCreate                                        * 
* 5      sqlrlcts                                              * 
* 6      sqlnq_create_tablespace_end                           * 
* 7      sqlnq_create_tablespace_stmt                          * 
* 8      sqlnp_smactn                                          * 
* 9      sqlnp_parser                                          * 
* 10      sqlnp_main                                           * 
*                                                              * 
* This happens when the user attempts to use either a path     * 
* containing a stale container tag file (SQLNAM.TAG), or a     * 
* file                                                         * 
* container that has previously been used by the database, but * 
* is                                                           * 
* not in use any longer (for example old tablespace container  * 
* restored from a filesystem backup).                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Problem first fixed in DB2 UDB 9.7 FixPack 5.                * 
****************************************************************
Local-Fix:
For path containers, remove the old tag file (SQLTAG.NAM). For 
file containers, avoid using old container files containing a 
stale tag. Use a brand new file instead.
verfügbare FixPacks:
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
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.03.2011
23.12.2011
23.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP5
Problem behoben lt. FixList in der Version
9.7.0.5 FixList