DB2 FOR LUW / DB2FORLUW / 950 - DB2

If you change value for configuration parameter MIRRORLOGPATH 
for an active database, you will receive following message: 
============================================ 
DB20000I  The UPDATE DATABASE CONFIGURATION command completed 
successfully. 
SQL1363W  One or more of the parameters submitted for immediate 
modification 
were not changed dynamically. For these configuration 
parameters, all 
applications must disconnect from this database before the 
changes become 
effective. 
============================================ 
which tells you that you need to deactivate the database and 
reactivate it to have the change take effect. 
 
However after you deactivate the database and reactivate it, you 
would see the "get database configuration" command has incorrect 
output: the value on column "Current Value" is wrongly set to 
NULL for MIRRORLOGPATH, while the column "Delayed Value" has 
correct value. 
In "db2pd -dbcfg" output you would see similar problem: the 
value of "MIRRORLOGPATH (memory)" is wrongly set to NULL, while 
the value of "MIRRORLOGPATH (disk)" is correct. 
 
The change on MIRRORLOGPATH actually have taken effect after you 
reactivate the database, which means you would see log files 
created in the new mirror log path. 
The only problem is the incorrect value in "get database 
configuration" output and "db2pd -dbcfg" output.

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.5 on Linux, Unix and Windows          * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 9.5 Fix Pack 10 or higher levels.  * 
****************************************************************

There are 2 means that help you see the correct value for 
parameter MIRRORLOGPATH: 
 
1. Recycle the DB2 instance by "db2stop" command and "db2start" 
command, and then you would see the correct value. 
 
2. Deactivate and reactivate the database *twice*, then after 
you reactivate the database for the 2nd time you would see the 
correct value.

First fixed in DB2 LUW Version 9.5 Fix Pack 10.

There are 2 means that help you see the correct value for 
parameter MIRRORLOGPATH: 
 
1. Recycle the DB2 instance by "db2stop" command and "db2start" 
command, and then you would see the correct value. 
 
2. Deactivate and reactivate the database *twice*, then after 
you reactivate the database for the 2nd time you would see the 
correct value.

forerunner  : APAR is sysrouted TO one or more of the following: IC83910 IC87884 IC97520 
follow-up : 

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

04.05.2012
22.08.2012
22.08.2012

9.5.FP10