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 IC66591 Status: Closed

SYSPROC.AUTOMAINT_SET_POLICY DOES NOT ALLOW TO SET DAYSOFMONTH INCLUDE 8
OR 18

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
SYSPROC.AUTOMAINT_SET_POLICY returns SQL1437 if 8 or 18 is part 
of <DaysOfMonth>. 
 
SQL1437N  The XML in the automatic maintenance policy file or 
LOB parameter 
passed to SYSPROC.AUTOMAINT_SET_POLICY or 
SYSPROC.AUTOMAINT_SET_POLICYFILE is 
not valid at line number "1" and column number "250". 
Validation error 
message: "Datatype error: Type: InvalidDatatypeValueExcepti". 
SQLSTATE=5U0ZZ 
 
See attachment. Easy to reproduce (also on DB2 9.7).
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* automaint_set_policyfile stored procedure                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* SYSPROC.AUTOMAINT_SET_POLICY returns SQL1437 if 8 or         * 
* 18ispartof <DaysOfMonth>.                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install v97fp2                                               * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
With the changes to the schema, no longer we are returning 
 
 
SQL1437 error.
Workaround
No temp fix is available
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.02.2010
31.05.2010
31.05.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.2 FixList