DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 Fix Pack 9                        * 
****************************************************************

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 version 9.7 Fix Pack 9

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91883 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.04.2013
23.12.2013
23.12.2013

9.7.FP9