IBM Support

LI72569: WHEN USING CONNECTION CONCENTRATOR AND OVERFLOW CONNECTIONS OCCUR, THE CALCULATED NUMBER OF DISPATCHERS MAYBE TOO LOW

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When using connection concentrator and overflow connections
    occur, the calculated number of dispatchers maybe too low.
    
    
    The problem can be observed by the following db2diag.log entry:
    
    2007-09-03-06.17.38.133364-240 I2308129E308       LEVEL: Severe
    PID     : 31577                TID  : 183041501440PROC :
    db2tcpcm 0
    INSTANCE: db2inst1             NODE : 000
    FUNCTION: DB2 UDB, base sys utilities,
    sqeDomainSocketManager::GetDispatcherSoc, probe:10
    RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
    
    
    And assoicated function calls in the stack:
         sqle_panic
         sqeDomainSocketManager::GetDispatcherSocketPair
         sqeConnQueue
         sqeConnQueue::sqeConnQueue
         sqeConnDispatcher
         sqeConnDispatcher::sqeConnDispatcher
         sqeConcentrator::GetDispatcher
         sqeConcentrator::RegisterConcUnknownConn
         sqeConcentrator::XferConnToConcentrator
         sqleGetAgent
    

Local fix

  • Increase MAX_CONNECTIONS to prevent overflow connections from
    being used.
    

Problem summary

  • When using connection concentrator and overflow connections
    occur, the calculated number of dispatchers maybe too low.
    
    
    The problem can be observed by the following db2diag.log entry:
    
    2007-09-03-06.17.38.133364-240 I2308129E308       LEVEL: Severe
    PID     : 31577                TID  : 183041501440PROC :
    db2tcpcm 0
    INSTANCE: db2inst1             NODE : 000
    FUNCTION: DB2 UDB, base sys utilities,
    sqeDomainSocketManager::GetDispatcherSoc, probe:10
    RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown"
    
    
    And assoicated function calls in the stack:
         sqle_panic
         sqeDomainSocketManager::GetDispatcherSocketPair
         sqeConnQueue
         sqeConnQueue::sqeConnQueue
         sqeConnDispatcher
         sqeConnDispatcher::sqeConnDispatcher
         sqeConcentrator::GetDispatcher
         sqeConcentrator::RegisterConcUnknownConn
         sqeConcentrator::XferConnToConcentrator
         sqleGetAgent
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.1, FixPak 5 (s080512).
    

Temporary fix

  • Increase MAX_CONNECTIONS to prevent overflow connections from
    being used.
    

Comments

APAR Information

  • APAR number

    LI72569

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-09-12

  • Closed date

    2008-06-25

  • Last modified date

    2008-06-25

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

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

    LI72652 LI72687

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 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:
16 October 2021