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 IT05370 Status: Closed

DB2 PRIMARY INSTANCE MAY CRASH DURING EXECUTION OF DB2STOP IN HADR

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
There is a limitation in the protocol used during shutdown 
that can lead to this problem and affect db2stop only. 
 
1. db2diag.log 
 
2014-10-21-00.57.13.842019+480 I447685308A1644    LEVEL: Event 
PID     : 44762284             TID  : 1           PROC : db2stop 
INSTANCE: db2inst1             NODE : 000 
EDUID   : 1 
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, 
probe:1130 
DATA #1 : String, 34 bytes 
/home/db2inst1/sqllib/adm/db2stop2 
DATA #2 : Hexdump, 256 bytes 
0x0FFFFFFFFFFF4B80 : 2F68 6F6D 652F 6462 3269 6E73 7064 2F73 
/home/db2inst1/s 
0x0FFFFFFFFFFF4B90 : 716C 6C69 622F 6164 6D2F 6462 3273 746F 
qllib/adm/db2sto 
0x0FFFFFFFFFFF4BA0 : 7032 004E 4F4D 5347 0053 4E00 0000 0000 
p2.NOMSG.SN..... 
0x0FFFFFFFFFFF4BB0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4BC0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4BD0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4BE0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4BF0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C00 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C10 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C20 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C30 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C40 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C50 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C60 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x0FFFFFFFFFFF4C70 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
 
<strip> 
 
2014-10-21-00.57.18.858613+480 E447693878A376     LEVEL: Warning 
PID     : 41551002             TID  : 76333       PROC : db2sysc 
0 
INSTANCE: db2inst1             NODE : 000         DB   : 
P012BAND 
APPHDL  : 0-3 
EDUID   : 76333                EDUNAME: db2agent (P012BAND) 0 
FUNCTION: DB2 UDB, data protection services, sqlpterm, probe:100 
MESSAGE : Posting HDR_RTYPE_HARD_CHK 
 
2. Stack. 
 
-------Frame------ ------Function + Offset------ 
0x09000000092D717C sqloCrashOnCriticalMemoryValidationFailure + 
0x34 
0x0900000006C44440 
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb + 
0x2B8 
0x0900000006C440B0 
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb@glue8 
0C + 0x7C 
0x090000000780B8FC 
.MemTreePut.fdpr.clone.224__13SQLO_MEM_POOLFP8SMemNodeUlP17SqloC 
hunkSubgroup + 0x14 
0x09000000078126EC sqlofmblkEx + 0x288 
0x09000000077EF55C sqlofmblkEx@glue801 + 0x78 
0x0900000006B40118 
sqlpterm__FP16sqeLocalDatabaseP8sqeAgentP5sqlcab + 0x38C 
0x090000000770B9D0 CleanDB__16sqeLocalDatabaseFP5sqlca + 0x2BC 
0x090000000777E174 
TermDbConnect__16sqeLocalDatabaseFP8sqeAgentP5sqlcai + 0x1A0 
0x090000000777AAE4 
AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0xCF0 
0x0900000007A45DE0 
AppLocalStart__14sqeApplicationFP14db2UCinterface + 0xF4 
0x090000000796E3FC sqlelostWrp__FP14db2UCinterface + 0x4C 
0x090000000796E4B0 sqleUCengnInit__FP14db2UCinterfaceUs + 0x60 
0x0900000007A4BE1C sqleUCagentConnect + 0x2A0 
0x0900000007EE4994 
@72@sqleDeactivateOneDB__FP14db2UCconHandleP8sqeAgent + 0x164 
0x0900000007619440 DeactivateDBs__8sqeDBMgrFP8sqeAgentb + 0x52C 
0x0900000007618D7C sqleDeactivateDBs__FP8sqeAgentb + 0xB4 
0x0900000006AA9E40 RunEDU__8sqeAgentFv + 0x224 
0x090000000776A114 EDUDriver__9sqzEDUObjFv + 0xDC 
0x0900000007788D94 sqloEDUEntry + 0x250
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply DB2 V9.7.11                                            * 
****************************************************************
Local Fix:
N/A.
Solution
Problem was first fixed in DB2 UDB version 9.7 fix pack 11.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.11.2014
07.10.2015
07.10.2015
Problem solved at the following versions (IBM BugInfos)
9.7.11,
9.7.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.11 FixList