home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 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
DB2 Version 9.5 Fix Pack 10 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 FixList