This issue is with the automatic maintenance and the use of an
offline maintenance window.
Given the following XML policy file say m1.xml:
<?xml version="1.0" encoding="UTF-8"?>
<DB2MaintenanceWindows
xmlns="http://www.ibm.com/xmlns/prod/db2/autonomic/config" >
<!-- Online Maintenance Window -->
<OnlineWindow Occurrence="During" startTime="18:00:00"
duration="14" >
<DaysOfWeek>Mon Tue Wed Thu Fri Sat</DaysOfWeek>
<DaysOfMonth>All</DaysOfMonth>
<MonthsOfYear>All</MonthsOfYear>
</OnlineWindow>
<!-- Offline Maintenance Window -->
<OfflineWindow Occurrence="During" startTime="16:39:53"
duration="01"
<DaysOfWeek>Tue</DaysOfWeek>
<DaysOfMonth>23</DaysOfMonth>
<MonthsOfYear>Jun</MonthsOfYear>
</OfflineWindow>
</DB2MaintenanceWindows>
If we insert the policy into the database using:
db2 "call
sysproc.automaint_set_policyfile('MAINTENANCE_WINDOW','m1.xml')"
In the notify log it says:
ADM10515I The automatic maintenance policy "MAINTENANCE_WINDOW"
has
been updated in database "BCUDB". The policy options have been
updated
from "Online window: Start Date: Current Date End Date: none
Maintenance occurs inside window Time: 18:00:00 - 08:00:00
Days of
week: MON, TUE, WED, THU, FRI, SAT, Days of month: All Month
of year:
All Offline window: Start Date: Current Date End Date: none
Maintenance occurs inside window Time: 16:39:53 - 17:39:53
Days of
week: TUE, Days of month: 22, Month of year: JUN, " to "Online
window: Start Date: Current Date End Date: none Maintenance
occurs
inside window Time: 18:00:00 - 08:00:00 Days of week: MON,
TUE, WED,
THU, FRI, SAT, Days of month: All Month of year: All
Offline
window: Start Date: Current Date End Date: none Maintenance
occurs
inside window Time: 16:39:53 - 17:39:53 Days of week: TUE,
Days of
month: 22, Month of year: JUN, ".
Days of month is reported as 22 instead of 23.
This behavior observed in V9.5 on all platforms (
Unix/Linux/Windows ) |
