IBM Support

LI74743: INCORRECT DAYS OF MONTH REPORTED IN NOTIFY LOG WHILE INSERTING THE POLICY FOR OFFLINE WINDOW

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 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 )
    

Local fix

Problem summary

  • Incorrect days of month reported in notify log while inserting
    the policy for offline window
    

Problem conclusion

  • First Fixed in DB2 V9.5 FP5
    

Temporary fix

  • N/A
    

Comments

APAR Information

  • APAR number

    LI74743

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-16

  • Closed date

    2010-02-05

  • Last modified date

    2010-02-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC64069

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 February 2010