IT31398: DB2FMP SPORADICALLY TERMINATING WITH SQL1224

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Timing issue which causes intermittent abnormal termination of
  db2fmp process used to run non-SQL routines (stored procedures /
  user defined functions).  This results in non-SQL routines
  failing intermittently with SQL1224 because db2sysc thinks there
  is something wrong with db2fmp process, but in reality db2fmp
  process is fine.
  
  db2diag.log will show:
  
  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1224   sqlerrml: 22
  sqlerrmc: 0 * * * *  serverSend
  sqlerrp : SQLJCMN
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Non-SQL routines which are run inside db2fmp proces.         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix to DB2 database server.                            *
  ****************************************************************
  

Problem conclusion

• First fixed in v11.1 Mod 4 Fixpack 6
  

Temporary fix

• See LOCAL FIX
  

Comments

APAR Information

• 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

• RB10 PSN

     UP