DB2 - Problem description
Problem IC75956 | Status: Closed |
SNAPDB AND OTHER SNAPSHOT ADMINISTRATIVE VIEWS RETRIEVE INFO FOR ALL ACTIVE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
SNAPDB administrative view retrieves snapshot information from the dbase logical group for the currently connected database, and the information for the database other than the currently connected database should not be retrieved. However, when the registry variable DB2_COMPATIBILITY_VECTOR is set to ORA and the database is created using this setting, the snapshot administrative view retrieves the information for all the active databases. This is also applicable to other snapshot administrative views as well. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All who use SNAPDB and other snapshot administrative views * * with DB2_COMPATIBILITY_VECTOR set to ORA * **************************************************************** * PROBLEM DESCRIPTION: * * As same as Error description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 9.7 FixPack 5. * **************************************************************** | |
Local Fix: | |
Not available. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 5. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.04.2011 28.12.2011 28.12.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.5 |