Expression queue execution leads to latency on PostgreSQL database in Rational Focal Point

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:

  1. Stop Tomcat server

  2. Navigate to <Tomcat Home>/conf

  3. Open the server.xml file in edit mode

  4. 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"/>


  5. Save and close the file

  6. Increase the Java Virtual Memory [JVM] by 1 GB

  7. Launch PostgreSQL database and execute the following commands:

    • vacuumdb -f -h localhost <dbname>
    • ANALYZE

  8. Once done, start Tomcat server

Rate this page:

(0 users)Average rating

Document information


More support for:

Rational Focal Point
General Information

Software version:

6.5, 6.5.0.1, 6.5.0.2, 6.5.1

Operating system(s):

Linux, Solaris, Windows

Reference #:

1577414

Modified date:

2012-04-06

Translate my page

Machine Translation

Content navigation