|
Problem IC69709
|
Status: Closed |
ON 32 WINDOWS, UPGRADING A DATABASE FROM A PREVIOUS VERSION OF D B2 TO 9.8 FP2 OR HIGHER REPORTS STACK OVERFLOW EXCEPTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem 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>] |
| 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 *
**************************************************************** |
| Local Fix: |
Increase dbm cfg parm AGENT_STACK_SZ to at least 128 and retry
the operation. |
| available fix packs: |
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
|
| Workaround |
Increase dbm cfg parm AGENT_STACK_SZ to at least 128 and retry
the operation. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.07.2010
05.08.2011
09.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.4
|
 |
