IBM Support

JR32196: DB2 FAILS WITH SQL1224N ON WINDOWS 32 WHEN ENABLNG AN XML SCHEMA FOR DECOMPOSITION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On Windows 32, when there is not enough storage to complete
    enablement of an XML schema for decomposition, DB2 fails with
    SQL1224N and message ADM0501C is logged in the db2diag.log.
    

Local fix

  • To avoid stack overflow exceptions during schema registration, i
    ncrease the agent_stack_sz.
    For example, db2 update dbm cfg using agent_stack_sz 64
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Windows 32                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * On Windows 32, when there is not enough storage to complete  *
    *                                                              *
    * enablement of an XML schema for decomposition, DB2 fails     *
    * with                                                         *
    * SQL1224N and message ADM0501C is logged in the db2diag.log.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Version 95 Fix Pack 5                             *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 95 Fix Pack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32196

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-02-26

  • Closed date

    2010-01-04

  • Last modified date

    2010-01-04

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

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 January 2010