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

DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

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