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":"LOB59","label":"Sustainability Software"},"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