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 IC74846 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 / 950 - 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:                                              * 
* Any adding containers to a tablespace                        * 
**************************************************************** 
* 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                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.5 fixpack 8 or later                           * 
****************************************************************
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.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This problem was first fixed in V9.5 Fixpack 8
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75205 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
04.03.2011
12.07.2011
12.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList