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