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