|
Problem IC95279
|
Status: Closed |
SYSIBMADM.DBCFG NOT DISPLAYING FLAGS AND DEFERRED FLAGS VLAUE COMPUTED |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.08.2013
28.02.2014
28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
