DB2 - Problembeschreibung
Problem IC66585 | Status: Geschlossen |
SYSPROC.AUTOMAINT_SET_POLICY DOES NOT ALLOW TO SET DAYSOFMONTH INCLUDE 8 OR 18 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * AUTOMAINT_SET_POLICYFILE stored procedure when invoked for * * maintenance window setting. * **************************************************************** * PROBLEM DESCRIPTION: * * SYSPROC.AUTOMAINT_SET_POLICY DOES NOT ALLOW TO SET * * DAYSOFMONTH INCLUDE 8 OR 18. It gives the following error * * for this case : * * * * 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 * **************************************************************** * RECOMMENDATION: * * upgrade to v95fp6 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Fixed the schema which validate the input xml for day of month. Now it will allow the customer to set the 8 or 18 as "Days of Month" of maintenance window policy xml with out any error. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC66591 IC66592 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.02.2010 05.04.2010 05.04.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |