IBM Support

IC69709: ON 32 WINDOWS, UPGRADING A DATABASE FROM A PREVIOUS VERSION OF D B2 TO 9.8 FP2 OR HIGHER REPORTS STACK OVERFLOW EXCEPTION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • Upgrading ( migrating ) a database from a previous version to
    9.7 FP2 or higher fails with the error:
    
    
    MESSAGE : ADM0501C  A stack overflow exception has occurred.
    The DB2 instance has terminated abnormally.
    
    The error occurs because DB2 v9.8.2 requires more memory from
    the stack than is available.
    A portion of code used by database migration in v9.8.2 requires
    a very large local variable.
    These local variables are allocated from from an agent's
    available stack memory.  Only windows databases are affected by
    this issue
    
    To remedy this problem, you may increase the default stack size
    for db2syscs.exe using the db2hdr utility as follows:
    db2hdr \sqllib\bin\db2syscs.exe
    /s:<stackreserve>[,<stackcommit>]
    

Local fix

  • Increase dbm cfg parm AGENT_STACK_SZ to at least 128 and retry
    the operation.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Windows                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Upgrading ( migrating) a database to version 9.8.2 or higher *
    * fails with stack overflow                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.8.4                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

  • Increase dbm cfg parm AGENT_STACK_SZ to at least 128 and retry
    the operation.
    

Comments

APAR Information

  • APAR number

    IC69709

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    980

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-07-06

  • Closed date

    2011-08-05

  • Last modified date

    2011-08-09

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

    IC69420

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

Fix information

Applicable component levels

  • R980 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.8

Reference #: IC69709

Modified date: 09 August 2011