IBM Support

IC79532: CALL SYSPROC.AUTOMAINT_SET_POLICY() TO SET A NEW AUTO_REORG POLICY MAY RETURN SQL1437N - 'UNTERMINATED END TAG' DB2AUTOREORG

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 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.
    

Local fix

  • Add at least one trailing blank to the XML policy description
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Problem Description above.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 6.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Version 9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79532

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-10-31

  • Closed date

    2012-06-18

  • Last modified date

    2012-06-18

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC99726 IC99727

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79532

Modified date: 18 June 2012