IBM Support

LI74909: GATEWAY TRAPS IN SQLJSSYNCREQCOMMIT When CONNECTION CONCENTRATOR is ON

Fixes are available

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

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
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback