DB2 - Problem description
Problem IC91883 | Status: Closed |
SYSIBMADM.DBCFG NOT DISPLAYING FLAGS AND DEFERRED FLAGS VLAUE COMPUTED | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
When you set database memory to COMPUTED the flags and deferred flags value returned by administrative view SYSIBMADM.DBCFG is displayed as NONE instead of COMPUTED. # db2 connect to SAMPLE # db2 update db cfg using database_memory COMPUTED # db2 "SELECT substr(NAME,1,20) as name, value_flags, deferred_value_flags FROM TABLE(SYSPROC.DB_GET_CFG()) where name = 'database_memory'" NAME VALUE_FLAGS DEFERRED_VALUE_FLAGS -------------------- ----------- ----------- database_memory NONE NONE | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 Fix Pack 3 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 version 10.1 Fix Pack 3 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC95279 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.04.2013 27.09.2013 27.09.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.3 | |
10.1.0.3 |