IBM Support

LI74909: GATEWAY TRAPS IN SQLJSSYNCREQCOMMIT When CONNECTION CONCENTRATOR is ON

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Gateway is trapping with the following stack when Connection
    Concentrator is ON:
    
    0000020001030F02 _Z18sqljsSyncReqCommitP14db2UCinterface +
    0x00ca
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    000002000103651A
    _Z17sqljs_ddm_syncctlP14db2UCinterfaceP13sqljDDMObject
    + 0x01c2
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    00000200010134A8
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterfa
    ce + 0x03a8
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    0000020001012706 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface
    +
    0x0246
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    000002000100C1D2 address: 0x000002000100C1D2 ; dladdress:
    0x000002000000C000 ; offset in lib: 0x00000000010001D2 ;
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    0000020001010678 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
    0x02e4
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    0000020000DB1CD2 _ZN8sqeAgent6RunEDUEv + 0x014e
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    0000020002CE5DFC _ZN9sqzEDUObj9EDUDriverEv + 0x0198
      (/dbc/home/dbctib01/sqllib/lib64/libdb2e.so.1)
    0000020002CE5E16 _Z10sqlzRunEDUPcj + 0x0016
    
    Reproduction steps:
    
    enable concentrator, set num_poolagents 0 in dbm cfg file. Run
    any db2 coordinated application through gateway.
    
    In customer environment num_poolagents can be set to some value.
    Example of settings where customer experienced the issue:
    
     Agent pool size                        (NUM_POOLAGENTS) = 75
     Initial number of agents in pool       (NUM_INITAGENTS) = 0
     Max number of coordinating agents     (MAX_COORDAGENTS) = 300
     Max number of client connections      (MAX_CONNECTIONS) = 301
    

Local fix

  • Disable connection concentrator.
    

Problem summary

  • User's Affected: All that use db2 connect product
    Problem summary: Gateway is trapping with the following stack
    when Connection Concentrator is ON:
    
    
    sqljsSyncReqCommitP14db2UCinterface
    

Problem conclusion

  • First fixd in v9.1fp9
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74909

  • Reported component name

    DB2 CUE LINUX

  • Reported component ID

    5724B6204

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-08-28

  • Closed date

    2010-04-16

  • Last modified date

    2010-04-16

  • APAR is sysrouted FROM one or more of the following:

    LI74907

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CUE LINUX

  • Fixed component ID

    5724B6204

Applicable component levels

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 October 2021