|
Problem IT02818
|
Status: Closed |
WHEN LOGPATH INCLUDES "NODEXXXX/LOGSTREAMXXXX" IN THE PATH, NEWLOGPATH MAY NOT BE CHANGED. |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
When LOGPATH includes "NODExxxx/LOGSTREAMxxxx" in the path,
setting NEWLOGPATH to not including the string will be ignored.
MIRRORLOGPATH and OVERFLOWLOGPATH have the same problem. Once
updating it to another path, the change is reflected correctly.
Here is the repro scenario:
$ db2 update db cfg using newlogpath
/actlogs/NODE0000/LOGSTREAM0000
$ db2 update db cfg using mirrorlogpath
/mirrorlogs/NODE0000/LOGSTREAM0000
$ db2 update db cfg using overflowlogpath
/overflowlogs/NODE0000/LOGSTREAM0000
$ db2 terminate ; db2 connect to sample
$ db2 get db cfg | grep -i log | grep -i path
Changed path to log files (NEWLOGPATH) =
Path to log files =
/actlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
/overflowlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
Mirror log path (MIRRORLOGPATH) =
/mirrorlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
$ db2 update db cfg using newlogpath /actlogs
$ db2 update db cfg using mirrorlogpath /mirrorlogs
$ db2 update db cfg using overflowlogpath /overflowlogs
$ db2 terminate ; db2 connect to sample
$ db2 get db cfg | grep -i log | grep -i path
Changed path to log files (NEWLOGPATH) =
Path to log files =
/actlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
/overflowlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
Mirror log path (MIRRORLOGPATH) =
/mirrorlogs/NODE0000/LOGSTREAM0000/NODE0000/LOGSTREAM0000/
$ db2 update db cfg using newlogpath /actlogs2
$ db2 update db cfg using mirrorlogpath /mirrorlogs2
$ db2 update db cfg using overflowlogpath /overflowlogs2
$ db2 terminate ; db2 connect to sample
$ db2 get db cfg | grep -i log | grep -i path
Changed path to log files (NEWLOGPATH) =
Path to log files =
/actlogs2/NODE0000/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
/overflowlogs2/NODE0000/LOGSTREAM0000/
Mirror log path (MIRRORLOGPATH) =
/mirrorlogs2/NODE0000/LOGSTREAM0000/
$ db2 update db cfg using newlogpath /actlogs
$ db2 update db cfg using mirrorlogpath /mirrorlogs
$ db2 update db cfg using overflowlogpath /overflowlogs
$ db2 terminate ; db2 connect to sample
$ db2 get db cfg | grep -i log | grep -i path
Changed path to log files (NEWLOGPATH) =
Path to log files =
/actlogs/NODE0000/LOGSTREAM0000/
Overflow log path (OVERFLOWLOGPATH) =
/overflowlogs/NODE0000/LOGSTREAM0000/
Mirror log path (MIRRORLOGPATH) =
/mirrorlogs/NODE0000/LOGSTREAM0000/ |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
Update the path to a dummy path first and change it back to the
path. |
| Solution |
First fixed in DB2 Version 10.1 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.06.2014
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
