home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC87390 Status: Geschlossen

FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When executing Non Federated stored procedures the FMP thread 
might crash with the following stack showing on 
nonEDU.app_trap.txt file: 
 
<StackTrace> 
-----FUNC-ADDR---- ------FUNCTION + OFFSET------ 
0x00002AAAACBDF407 ossDumpStackTraceEx + 0x01ef 
                (/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAACBDA1C6 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 
0x00cc 
                (/db2home/db2inst1/sqllib/lib64/libdb2osse.so.1) 
0x00002AAAAB9521F2 sqlo_trce + 0x040a 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB953ED2 sqlo_db2fmp_trca_nokill + 0x013e 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAD0A8D60 address: 0x00002AAAAD0A8D60 ; dladdress: 
0x00002AAAAD09B000 ; offset in lib: 0x000000000000DD60 ; 
                (/lib64/libpthread.so.0) 
0x00002AAAAB163A23 sqloxltc_app + 0x0039 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB783096 
_Z17sqlerTakeLibLatchP27SQLER_LOADED_LIB_HASH_TABLEii + 0x0066 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB78F969 sqlerLibraryLoad + 0x0189 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB790476 sqlerRoutineLoad + 0x013c 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB77EBA1 sqlerFmpListener + 0x0ab9 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAB78134B _Z22sqlerWorkerThreadEntryPv + 0x020d 
                (/db2home/db2inst1/sqllib/lib64/libdb2.so.1) 
0x00002AAAAD0A1193 address: 0x00002AAAAD0A1193 ; dladdress: 
0x00002AAAAD09B000 ; offset in lib: 0x0000000000006193 ; 
                (/lib64/libpthread.so.0) 
0x00002AAAAD6D70DD __clone + 0x006d 
                (/lib64/libc.so.6) 
</StackTrace> 
 
 
The calling agent will show in the db2diag.log errors like: 
 
EDUID   : 43034                EDUNAME: db2agntp (DW) 0 
FUNCTION: DB2 UDB, routine_infrastructure, 
sqlerInvokeFencedRoutine, probe:88 
DATA #1 : String, 37 bytes 
Routine failed with termination error 
 
Other Stored procedures might be affected.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description.                                       * 
*                                                              * 
* This is due to a timing whole in which the non Federated     * 
* Stored procedure gets executed on a Federated FMP which will * 
* not have the same internal structures initialized.           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 8.                       * 
****************************************************************
Local-Fix:
Retry execution of the Stored procedure as this is due a timing 
hole and next execution will be likely successful.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in DB2 Version 9.7 and Fix Pack 8
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC89736 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.10.2012
01.04.2013
01.04.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP8
Problem behoben lt. FixList in der Version
9.7.0.8 FixList