Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC69420 Status: Closed

ON 32 WINDOWS, UPGRADING A DATABASE FROM A PREVIOUS VERSION OF D B2 TO 9.7
FP2 REPORTS STACK OVERFLOW EXCEPTION

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Upgrading ( migrating ) a database from a previous version to 
9.7 FP2 fails with the error: 
 
MESSAGE : ADM0501C  A stack overflow exception has occurred. 
The DB2 instance has terminated abnormally. 
 
The error occurs because DB2 v9.7.2 requires more memory from 
the stack than is available. 
A portion of code used by database migration in v9.7.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>]
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Upgrading ( migrating ) a database from a previous version   * 
* to 9.7 FP2 fails with the error:                             * 
*                                                              * 
* MESSAGE : ADM0501C  A stack overflow exception has occurred. * 
*                                                              * 
* The DB2 instance has terminated abnormally.                  * 
*                                                              * 
* The error occurs because DB2 v9.7.2 requires more memory     * 
* from the stack than is available.                            * 
* A portion of code used by database migration in v9.7.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>]                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7.3                                            * 
****************************************************************
Local Fix:
Increase dbm cfg parm AGENT_STACK_SZ to at least 128 and retry 
the operation.
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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

Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC69709 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.06.2010
23.09.2010
23.09.2010
Problem solved at the following versions (IBM BugInfos)
9.7.3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.