|
Problem IC87390
|
Status: Closed |
FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97 |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 Version 9.7 and Fix Pack 8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC89736
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2012
01.04.2013
01.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
