A fix is available
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