IBM Support

JR40504: RUN NNSTAT ON NICKNAMES FOR DB2 DATASOURCE THAT ACTING AS A STANDBY SERVER MAY CAUSE FEDERATED DB CRASH

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • You have two db2 databases running as HADR pair. You have a
    federated database that federates tables from the standby
    database.
    The federated database will crash when NNSTAT is running for the
    nicknames, while at the same time, runstats is running on the
    primary database.
    
    The call stack should look like below:
    
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00002AAAB019DE2F ossDumpStackTraceEx + 0x01ef
      (/home/ininst4/sqllib/lib64/libdb2osse.so.1)
    0x00002AAAB0198BEE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00cc
      (/home/ininst4/sqllib/lib64/libdb2osse.so.1)
    0x00002AAAAD2A4CAB sqlo_trce + 0x03fb
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAD2EA392 sqloEDUCodeTrapHandler + 0x0266
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00000032CA60E7C0 address: 0x00000032CA60E7C0 ; dladdress:
    0x00000032CA600000 ; offset in lib: 0x000000000000E7C0 ;
      (/lib64/libpthread.so.0)
    0x00002AAAABEEAE72
    _Z24sqleUCpushTrustedConnectP15sql_static_dataP18sqleUCtrustedSt
    ackP8sqlrr_cb + 0x0104
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAD72D950
    _Z22sqlriFedInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf
    + 0x007e
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAD72DB3D
    _Z21sqlriFedInvokeInvokerP10sqlri_ufobP14sqlqg_Fmp_Info + 0x00d9
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAD3FFD83
    _Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply
    + 0x01d3
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAD3FC144 _Z12sqlqgFedRbk1P13SQLQG_TRAN_CB + 0x041a
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABD8539D
    _Z8sqlpxrbkP8sqeAgentP15SQLXA_CALL_INFOPiP9SQLP_GXIDPP11sqlo_xla
    tch + 0x0c05
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABDFE09D
    _Z12sqlrrbck_dpsP8sqlrr_cbiiiP15SQLXA_CALL_INFOP9SQLP_GXIDb +
    0x013b
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABDFCBFE _Z8sqlrrbckP8sqlrr_cbiiiiP15SQLXA_CALL_INFO +
    0x0546
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABDEB124 _Z14sqlrr_rollbackP14db2UCinterface + 0x009e
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABA14414
    _Z19sqljs_ddm_rdbrllbckP14db2UCinterfaceP13sqljDDMObject +
    0x01ac
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAADFE7354
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x037a
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9FF823
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x035b
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9F4413 address: 0x00002AAAAB9F4413 ; dladdress:
    0x00002AAAAAABA000 ; offset in lib: 0x0000000000F3A413 ;
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9F3DD9
    _Z19sqljsDrdaAsSPDriverP14db2UCconHandleP17SQLCC_COMHANDLE_TPPhl
    + 0x026f
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB973F5A _Z24sqlerInvokeFencedRoutineP13sqlerFmpParms
    + 0x06e6
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABEDF5BF _Z9sqlricallP8sqlrr_cb + 0x0f43
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAE055C1B _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    + 0x00e5
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABDFA977 _Z29sqlrr_process_execute_requestP8sqlrr_cbi
    + 0x1aa7
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABDF1D42 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo
    + 0x0116
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABA187DF
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
    0x04e7
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAADFE7057
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x007d
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9FF823
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x035b
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9F4413 address: 0x00002AAAAB9F4413 ; dladdress:
    0x00002AAAAAABA000 ; offset in lib: 0x0000000000F3A413 ;
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9FB6D9 address: 0x00002AAAAB9FB6D9 ; dladdress:
    0x00002AAAAAABA000 ; offset in lib: 0x0000000000F416D9 ;
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9F9062 address: 0x00002AAAAB9F9062 ; dladdress:
    0x00002AAAAAABA000 ; offset in lib: 0x0000000000F3F062 ;
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB9F8DD0 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
    0x0102
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAAB92E6EF _ZN8sqeAgent6RunEDUEv + 0x09e5
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABFFD91C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABFFD873 _Z10sqlzRunEDUPcj + 0x0009
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00002AAAABD6CE3A sqloEDUEntry + 0x02f4
      (/home/ininst4/sqllib/lib64/libdb2e.so.1)
    0x00000032CA6064A7 address: 0x00000032CA6064A7 ; dladdress:
    0x00000032CA600000 ; offset in lib: 0x00000000000064A7 ;
      (/lib64/libpthread.so.0)
    0x00000032C9ED3C2D clone + 0x006d
      (/lib64/libc.so.6)
    

Local fix

  • Do not run NNSTAT on federated db and run runstats on primary
    server at the same time.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * The user run NNSTAT on nicknames for db2 datasource that     *
    * acting as a standby server.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Federation Server V97FP6 or later.                *
    ****************************************************************
    

Problem conclusion

  • Firstly fixed in Federation Server V9.7 FP6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR40504

  • Reported component name

    DRDA WRAPPER

  • Reported component ID

    5724N9706

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-08-28

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

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

Fix information

  • Fixed component name

    DRDA WRAPPER

  • Fixed component ID

    5724N9706

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: InfoSphere Federation Server
Data Sources and Wrappers - DRDA

Software version: 9.7

Reference #: JR40504

Modified date: 06 June 2012