IBM Support

IT36199: POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INFO() WHEN RUNNING FEDERATED QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With multiple Federated queries running it is possible to have a
    db2fmp trap in sqlqg_FMP_Runtime_Object::get_rstate_info().
    
    The signs of this would be a db2fmp A failure that you would see
    reported in the db2diag.log
    A connection failure for example leading to the db2fmp A
    termination.
    The trap might occur a bit later in a db2fmp B with the
    following top stack:
    
      0x00002AAAB670A6B8 sqlqg_FMP_Runtime_Object::get_rstate_info +
    0x0038
      0x00002AAAB6719065 sqlqg_FMP_FindRuntimeObject + 0x0065
      0x00002AAAB67145D7 sqlqgRouter + 0x00e7
      0x00002AAAB6714152 sqlqg_fedstp_hook + 0x0082
      0x00002AAAAC232DE7 sqlqgDyload + 0x00f7
      0x00002AAAABCB6DE2 sqlerFedFmpListener + 0x0f12
      0x00002AAAABCBF0A2 sqlerWorkerThreadEntry + 0x03f2
      ...l
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to 11.5.6 or later                                   *
    ****************************************************************
    

Problem conclusion

  • Upgrade to 11.5.6 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT36199

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-03-12

  • Closed date

    2022-04-18

  • Last modified date

    2022-04-18

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022