home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC66707 Status: Closed

SYSPROC.AUTOMAINT_GET_POLICY AND CC INCONSITENT REGARDING
"INCLUDE LAST DAY OF MONTH"

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
If setting "Include last day of month" with Control Center 
AUTOMAINT_GET_POLICY returns "-31" in <DaysOfMonth> 
 
According to DB2MaintenanceWindowPolicySample.xml from 
samples/automaintcfg the last day of month should be returned as 
"-1". 
 
Same behavior seen also on DB2 9.7.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All v9.5 users who is using AUTOMANT_GET_POLICY and          * 
* AUTOMAINT_GET_POLICYFILE stored                              * 
* procedures.                                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SYSPROC.AUTOMAINT_GET_POLICY AND CC INCONSITENT REGARDING    * 
* "INCLUDE LAST DAY OF MONTH". This is was due improper        * 
* mappings.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5 fixpack 6a or higher.             * 
****************************************************************
Local Fix:
No known Workaround.
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First Fixed in DB2 Version 9.5 Fixpack 6a.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC66708 IC66709 IC67068 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
26.02.2010
05.04.2010
20.12.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)