Technote (troubleshooting)
Problem(Abstract)
Attempts to execute the expression queue with large number expressions leads to latency on the PostgreSQL database in IBM Rational Focal Point.
Symptom
Latency being observed during the execution of expression queue.
Cause
You might notice the reported problem during one of the following operations:
Cause 1: Importing a new workspace from template
Cause 2: Importing elements
Cause 3: Database execution plans not adapting to the changed expression queue load
Resolving the problem
In order to resolve the reported problem; apply the steps below:
- Stop Tomcat server
- Navigate to <Tomcat Home>/conf
- Open the server.xml file in edit mode
- Change the value of the entry maxActive to 30 in the following section
<Resource connectionProperties="SetBigStringTryClob=true;deferPrepares=false" defaultAutoCommit="true" driverClassName="org.postgresql.Driver" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="10" maxIdle="30" maxWait="60000" name="jdbc/focalpoint" password="xxxx" type="javax.sql.DataSource" url="jdbc:postgresql://127.0.0.1:5433/fp6502" username="postgres"/>
- Save and close the file
- Increase the Java Virtual Memory [JVM] by 1 GB
- Launch PostgreSQL database and execute the following commands:
vacuumdb -f -h localhost <dbname>
- ANALYZE
- Once done, start Tomcat server
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.