DB2 FOR LUW / DB2FORLUW / 970 - 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 Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6.                       * 
****************************************************************

Add at least one trailing blank to the XML policy description

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 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in Version 9.7 Fix Pack 6.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC99726 IC99727 
Nachfolger : 

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

31.10.2011
18.06.2012
18.06.2012

9.7.FP6