IBM Support

IT26262: ENHANCEMENT TO JDBC CONNECTION SERVICE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Enhancement to JDBC Connection Service
    

Local fix

  • STRRTC - 574115
    MA / MA
    Circumvention: None
    

Problem summary

  • Users Affected:
    ALL
    
    Problem Description:
    Enhancement to the JDBC connection service to improve the
    performance.
    
    Platforms Affected:
    ALL
    

Problem conclusion

  • Resolution Summary:
    
    A code fix is provided.
    
    The enhancement sets the default settings for the number of
    threads able to concurrently access the connection hash to 128
    threads.
    
    
    
    This setting can be increased as needed to further improve
    performance. We recommend starting out with small increases and
    doubling this number with every performance/load test until
    customers find the proper configuration for their environments.
    
    This should be carefully tested with production like volumes.
    There will be a point where performance continues to increase
    but beyond that point performance will degrade and careful
    testing is required to determine this spot.
    
    This setting is individual to each system based on CPU and
    memory usage as well as the data load. We cannot recommend a
    specific setting. The best setting will be unique to each
    customer?s environment.
    
    The out of the box setting of 128 should be similar to the
    performance the customer is seeing currently without this
    enhancement.
    
    
    
    Modification of this setting can be done by adding the following
    to customer_overrides.properties and adjusting it as needed.
    
    jdbcService.conHashConcurrentThreads=128
    
    
    
    Delivered In:
    5020603_9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT26262

  • Reported component name

    STR B2B INTEGRA

  • Reported component ID

    5725D0600

  • Reported release

    525

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-18

  • Closed date

    2019-01-11

  • Last modified date

    2021-12-28

  • 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

    STR B2B INTEGRA

  • Fixed component ID

    5725D0600

Applicable component levels

[{"Line of Business":{"code":"LOB02","label":"AI Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS3JSW","label":"Sterling B2B Integrator"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.5"}]

Document Information

Modified date:
29 December 2021