DB2 - Problem description
Problem IC75345 | Status: Closed |
SOME BOOLEAN TYPE OF DB2 CONFIGURATION PARAMETERS CAN ONLY ACCEPT EITHER YES/NO OR ON/OFF VALUES | |
product: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problem description: | |
A boolean type of database or database manager configuration parameter should accept all the values of [YES,NO,ON,OFF]. However, the following parameters can ONLY accept either YES/NO or ON/OFF values: db cfg parameters: AUTO_DB_BACKUP, AUTO_MAINT, AUTO_PROF_UPD, AUTO_REORG, AUTO_RUNSTATS, AUTO_STATS_PROF, AUTO_TBL_MAINT, AUTORESTART, BLK_LOG_DSK_FUL, DL_UPPER, INDEXSORT, SEQDETECT. dbm cfg parameters: CATALOG_NOAUTH, DATALINKS, DIR_CACHE, FEDERATED, INITDARI_JVM, INITFENCED_JVM, KEEPDARI, KEEPFENCED , DFT_MON_BUFPOOL, DFT_MON_LOCK, DFT_MON_SORT, DFT_MON_STMT, DFT_MON_TABLE, DFT_MON_TIMESTAMP , DFT_MON_UOW. The fix of this APAR will allow these parameters to accept all values of YES,NO,ON,OFF. This APAR also fixes the output values of the database configuration parameter TRACKMOD from the command "get db cfg" and the command "db2pd -dbcfg". The current output values are "NO/OFF", which will be changed to "YES/NO" so they are consistent with the range list [Yes,No] documented in the information center. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.1 Fix Pack 11 or newer * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
Solution | |
Problem was first fixed in Version 9.1 Fix Pack 11 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC76380 IC76381 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 29.03.2011 19.01.2012 19.01.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.1.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.1.0.11 |