IC87390: FMP TRAP ON SQLOXLTC_APP EXECUTING SYSPROC.SNAP_GET_DB_V97

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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.
    

Local fix

  • Retry execution of the Stored procedure as this is due a timing
    hole and next execution will be likely successful.
    

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.                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 Version 9.7 and Fix Pack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87390

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-22

  • Closed date

    2013-04-01

  • Last modified date

    2013-04-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC89736

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC87390

Modified date:

2013-04-01

Translate my page

Machine Translation

Content navigation