DB2 - Problem description
Problem IT15879 | Status: Closed |
DB2 MIGHT CRASH FOR AN ALTER STORAGE GROUP | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
This crash is specific to an error handling code path where there are inconsistencies between storage groups contained in the catalog tables and storage groups contained in SQLSGF.1 and SQLSGF.2. An example of this condition is when an attempt is made to drop a storage group and the storage group exists in the catalog tables, but not in SQLSGF.1 and SQLSGF.2. The stack will look similar to the following: sqloEDUCodeTrapHandler sqlbAlterDatabaseStorage sqlbLockAndAlterStorageGroup sqlrlAlterDatabase sqlnq_alter_stogroup_end sqlnq_alter_stogroup_stmt sqlnp_smactn | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fix Pack 8 * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 10.5 Fix Pack 8 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.06.2016 13.03.2017 13.03.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |