DB2 FOR LUW / DB2FORLUW / A50 - 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 10.5 on Linux, Unix and Windows         * 
* platforms.                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 10.5 Fix Pack 3 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.

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
 

First fixed in DB2 LUW Version 10.5 Fix Pack 3.

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.

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

08.11.2013
27.02.2014
27.02.2014