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

MON_GET_HADR CRASHES MEMBER

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
When user calls MON_GET_HADR() monitor function after upgrading 
from fix packs prior to v105fp4 to v105fp4, without running 
db2updv105, they will get a trap as following: 
 
On member 0 I call the table function mon_get_hadr and it 
crashes my member.  An FODC trap file is generated. 
 
 db2inst1> db2 "select * from table(mon_get_hadr(-2)) as t" 
SQL1224N  The database manager is not able to accept new 
requests, has 
terminated all requests in progress, or has terminated the 
specified request 
because of an error or a forced interrupt.  SQLSTATE=55032 
 
 
From the trap file: 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000000C3FF9C 
monFormatHadrInfo__FPCcP13sqlrwHadrInfoR14hadrParametersUiP5sqlc 
a + 0x69C 
0x0900000000C3F3AC monGetHadr + 0x72C 
0x090000000FDACF7C sqloInvokeFnArgs + 0x6338 
Stack traceback unavailable. 
</StackTrace> 
 
 
db2inst1> db2level 
DB21085I  This instance or install (instance name, where 
applicable: "db2inst1") 
uses "64" bits and DB2 code release "SQL10054" with level 
identifier 
"0605010E". 
Informational tokens are "DB2 v10.5.0.4", "s140813", "IP23616", 
and Fix Pack 
"4". 
Product is installed at "/opt/IBM/db2/V10.5_1". 
 
db2diag.log, FODC files, and db2trc have been copied to 
/TMP/test/HADR and attached to this defect.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* MON_GET_HADR CRASHES MEMBER                                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* First fixed in fix pack 10.5 fp 5                            * 
****************************************************************
Local Fix:
N/A
Solution
First fixed in fix pack 10.5 fp 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
03.09.2014
09.03.2015
09.03.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.5 FixList