IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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: udb600               NODE : 004
    HOSTNAME: db2host
    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: udb600               NODE : 004         HOSTNAME:
    db2host
    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: udb600               NODE : 004         HOSTNAME:
    db2host
    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: udb600               NODE : 004            DB   :
    DB2IXP06
    APPHDL  : 1-80                 APPID: *N1.udb600.170809135016
    AUTHID  : UDB600               HOSTNAME: db2host
    EDUID   : 287                  EDUNAME: db2agntp (DB2IXP06) 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 number

    IT22051

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-18

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2018