DB2 FOR LUW / DB2FORLUW / A50 - DB2

Calling SYSPROC.AUTOMAINT_SET_POLICY() to set a AUTO_REORG 
policy with an xml policy description may fail with error 
SQL1437N despite a correct xml policy file is being used. 
 
SQL1437N  The XML in the automatic maintenance policy file or 
LOB parameter passed to AUTOMAINT_SET_POLICY or 
AUTOMAINT_SET_POLICYFILE is not valid at line number "8" 
and column number "21".  Validation error 
message: "Unterminated end tag, ' DB2AutoReorg 
 
Sample db2diag.log message: 
 
2011-10-19-08.02.21.241939+120 I2275125E366        LEVEL: 
Warning 
PID     : 421                 TID  : 1105262912   PROC : db2fmp 
( 
INSTANCE: db2inst1               NODE : 000 
FUNCTION: DB2 UDB, Policy, sqlpiValidateAutomaintPolicy, 
probe:40 
DATA #1 : <preformatted> 
Validation Error at Line number: 8 Column: 21 Message: 
Unterminated end tag, '.DB2AutoReorgPolicy.' 
 
This happens if the XML description that is passed as argument 
strictly fits within the string, i.e. there are no leading or 
trailing blanks enclosed.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 5.                      * 
****************************************************************

Add at least one trailing blank to the XML policy description

First fixed in DB2 Version 10.5 Fix Pack 5.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

27.02.2014
15.12.2014
15.12.2014