|
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
|
 |
| 9.7.0.3
|
|
