IT26262: ENHANCEMENT TO JDBC CONNECTION SERVICE

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 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