Question

An administrator asks: The guide for installing Process Commander Version 5.5 SP1 on WebSphere Application Server indicates that the following custom properties must be added for the DB2 Connection Pool if DB2 Universal Database is being used:

Name: currentSchema Value: <user schema name>

Name: currentFunctionPath Value:SYSIBM, SYSFUN, <user schema name>

Name: webSphereDefaultIsolationLevel Value:2

Do these properties also apply to DB2 in the z/OS mainframe environment?

 

Answer

Yes. If you are using WebSphere Application Server Version 6.0, 6.1, or 7.0, you must add the custom properties for the DB2 UDB Connection Pool listed above when you create data sources during installation.

In addition to the properties listed above, you must also add the following custom properties for the DB2 UDB Connection Pool:

fullyMaterializeLobData=true

fullyMaterializeInputStreams=true

progressiveStreaming=2

progressiveLocators=2

Add these properties to the custom properties page of the data source you specified for the jdbc/PegaRULES JNDI location. 

For example, in the WebSphere Administration console, go to JDBC Providers > Pega - UDB JDBC Driver > Data sources > PegaRULES > Custom properties > New.

Best Practice

In addition to specifying the properties listed above, consider making the following changes for all WebSphere environments regardless of the host operating system:

1. Add the following custom property:

   Name:accountingInterval=COMMIT.
   Note:  The “I” in interval is upper case.

2. Increase the minimum number of connections from 1 to 20 and the maximum number of connections to 100.  These two new values should be considered a minimum.
3. If the application server is connecting to the database using an alternate userid, that is, the JAAS setting is not the same as the database owner used at database creation time, it may be necessary to use the alternate userid  instead of the database owner for the user schema name parameters listed above.

 

Related Topic

PegaRULES Process Commander Release V5.5 SP1, Installing on WebSphere 6.1 Application Servers