DB2 - Problem description
Problem IC77321 | Status: Closed |
DB2LOOK CAN CAUSE A SERVER ABEND DUE A MEMORY CORRUPTION WHEN THE DDL FOR A TABLE EXCEEDS 2MB | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
If the data definition of a table exceeds 2 Mb, db2look might cause the server to crash. Since this is a memory corruption, its manifestation may change signature in the trap file generated. Here are some generated stacks observed: _Z25sqlri_hsjnDoneBuildTuplesP8sqlrr_cbP11sqlri_hsjno + 0x01c8 _Z9sqlrihsjnP8sqlrr_cb + 0x0cff _Z15sqlriExecThreadP8sqlrr_cbP12sqlri_opparm + 0x004a _Z9sqlrihsjnP8sqlrr_cb + 0x0a67 or sqloEDUCodeTrapHandler + 0x026c address: 0x00002AAAAABD4D60 ; dladdress: 0x00002AAAAABC7000 ; offset in lib: 0x000000000000DD60 ; _Z24sqlnn_free_invocation_cbP19sqlnn_invocation_cb + 0x0007 _Z21sqlnn_globals_refreshP3locP19sqlrr_invocation_cbP8sqlrr_cbi + 0x0329 _Z19sqlrr_agent_refreshP8sqeAgentP5sqlcai + 0x010c _ZN8sqeAgent8AssocAppEP14sqeApplicationi + 0x0521 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * see error description * **************************************************************** * RECOMMENDATION: * * Upgrade to version 9.5 Fixapak 9 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
First fixed in version 9.5 fixpack 9 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC77361 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.07.2011 09.03.2012 09.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.0., 9.5., 9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |