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