IBM Support

JR49563: DB2FMP MAY LEFT FOREVER WHEN "CONNECT RESET" HAPPENED AND THE DB2FMP IS IN THE HEADER OF THE FED FMP PRCOCESS LIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The Non-threaded federated db2fmp process may be left and never
    be reused even the corresponding connection is closed when
    following conditions are satified:
    1. It is in the header of the federated fmp proc list
    2. One or more federated fmp process(es) is/are in abnormal
    status before its connection is closed.
    
    To reproduce:
    
    1) Open Two sessions and query a nicname
        session 1   --> db2fmp  pid_1
        session 2   --> db2fmp  pid_2
    
    2)  db2fmpterm  pid_2   ( flag becomes to 0x00000154)
        session 2:  db2 connect reset     (db2fmp  pid_2  terminated
    )
        session 1:  db2 connect reset     (db2fmp  pid_1  left )
    
    3)  Open some other sessions:   pid_1 left but can never be
    resued
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Refer to APAR description for details.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 for LUW V9.7FP10 or higher level.             *
    ****************************************************************
    

Problem conclusion

  • The problem is firstly fixed on V9.7FP10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR49563

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-09

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

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

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

    IT00319 IT00327

Fix information

  • Fixed component name

    FEDERATED RUNTI

  • Fixed component ID

    5724N9703

Applicable component levels

  • R970 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 November 2014