000030757 - L&G: How to Increase max-pool-size for WPDS Data Source

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000030757
Applies ToRSA Product Set: RSA Via Lifecycle and Governance (L&G)
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9+ and 6.9.1+
 
IssueThe file aveksa-ds.xml that is shipped with 6.9 and 6.9.1 all patch levels has the max-pool-size connection setting for the Workpoint data source (WPDS) set to 90 which is too low. Engineering recommends a minimum setting of 150.
TasksIn order to increase this setting to 150, modify aveksa-ds.xml as follows:
1) Shutdown acm
 $ acm stop

2) As the 'oracle' user, edit aveksa-ds.xml
$ cd /home/oracle/jboss/server/default/deploy
$ vi aveksa-ds.xml

<xa-datasource>
        <jndi-name>jdbc/WPDS</jndi-name>

                                CHANGE FROM 90 to 150:
                              
                                FROM:
                                <max-pool-size>90</max-pool-size>
                                TO:
                                <max-pool-size>150</max-pool-size>

User-added image
3) Start acm
$ acm start
 
ResolutionOn a system with heavy workflow usage, this value may need to be increased above 150.
 

Attachments

    Outcomes