IT22051: BLU/CDE SQL STATEMENT MIGHT FAIL WITH SQL1225N IN A DPF INSTANCE.

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• BLU/CDE SQL Statement might fail with SQL1225N in a DPF
  Instance.
  
  db2diag.log:
  
  2017-08-09-15.51.14.592627+120 I41738E446            LEVEL:
  Severe
  PID     : 40582                TID : 47242811533056  PROC :
  db2sysc 4
  INSTANCE: db2inst1               NODE : 004
  HOSTNAME: myhost1
  FUNCTION: DB2 UDB, oper system services,
  sqlo_waitlist::initialize, probe:10
  MESSAGE : SysV semget failed with errno:
  DATA #1 : Hexdump, 4 bytes
  0x00002AF792FFDB48 : 1C00 0000
  ....
  
  2017-08-09-15.51.14.594579+120 I42185E448            LEVEL:
  Severe
  PID     : 40582                TID : 47242811533056  PROC :
  db2sysc 4
  INSTANCE: db2inst1               NODE : 004         HOSTNAME:
  myhost1
  FUNCTION: DB2 UDB, oper system services, sqloGetShrEDUWaitElem,
  probe:70
  MESSAGE : waitlist initialization failed, zrc=
  DATA #1 : Hexdump, 4 bytes
  0x00002AF792FFDC00 : 8100 0F85
  ....
  
  2017-08-09-15.51.14.595634+120 E42634E510            LEVEL:
  Severe
  PID     : 40582                TID : 47242811533056  PROC :
  db2sysc 4
  INSTANCE: db2inst1               NODE : 004         HOSTNAME:
  myhost1
  FUNCTION: DB2 UDB, oper system services, sqloEDUEntry, probe:10
  RETCODE : ZRC=0x850F0081=-2062614399=SQLO_SSEM_EXCEED_MAX
            "Requesting too many semaphores"
            DIA8336C Requested too many semaphores.
  ...
  2017-08-09-15.51.14.616465+120 I49286E634            LEVEL:
  Severe
  PID     : 40582                TID : 46915454494464  PROC :
  db2sysc 4
  INSTANCE: db2inst1               NODE : 004            DB   :
  MYDB1
  APPHDL  : 1-80                 APPID: X.X.X.X.0000
  AUTHID  : DB2INST1               HOSTNAME: myhost1
  EDUID   : 287                  EDUNAME: db2agntp (MYDB1) 4
  FUNCTION: DB2 UDB, CDE query runtime, cdeDispatchReq, probe:115
  RETCODE : ZRC=0x80580054=-2141716396=SQLKD_PROC_LIMIT
            "Mapping for SQLE_RC_PROC_LIMIT"
  DATA #1 : String, 31 bytes
  Error dispatching CDE subagents
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Platforms                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3                     *
  ****************************************************************
  

Problem conclusion

• First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP