000030757 - How to Increase max-pool-size for Workpoint data source (WPDS) in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support on Oct 29, 2018
Version 5Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000030757
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9+ and 6.9.1+ (JBoss), 7.0+ (WildFly)
 
IssueThe max-pool-size connection setting for the Workpoint data source (WPDS) may be set to 90, which is too low for heavy workflow usage. Engineering recommends a minimum setting of 150.
Tasks

JBoss steps (6.x versions)


In order to increase this setting to 150, modify aveksa-ds.xml as follows:

  1. Shutdown acm


$ acm stop


  1. As the oracle user, edit the aveksa-ds.xml


$ cd /home/oracle/jboss/server/default/deploy
$ vi aveksa-ds.xml


  1. Change <max-pool-size>90</max-pool-size> to <max-pool-size>150</max-pool-size>:User-added image
  2. Start acm


$ acm start

 

WildFly steps (7.0+)



  1. Shutdown acm


$ acm stop


  1. As the oracle user, edit the aveksa-standalone-full.xml


$ cd home/oracle/wildfly/standalone/configuration/aveksa-standalone-full.xml
$ vi aveksa-ds.xml


  1. Change <max-pool-size>90</max-pool-size> to <max-pool-size>150</max-pool-size>:


                <xa-datasource jndi-name="java:/jdbc/WPDS" pool-name="WPDS" enabled="true" use-java-context="true" use-ccm="true">
                    <xa-datasource-property name="URL">
                        jdbc:oracle:thin:@//localhost:1555/AVDB
                    </xa-datasource-property>
                    <driver>OracleXADriver</driver>
                    <xa-pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>150</max-pool-size>


  1. Start acm


$ acm start
ResolutionOn a system with heavy workflow usage, this value may need to be increased above 150.

 

Attachments

    Outcomes