IBM DB2 Example

When you use a DB2 database as your catalog database, you must append the database name to the catalog.url parameter, using the following syntax:

database tag://hostname:port;databaseName=database name

DB2 users must also include the schema name in the catalog.db parameter, using the following syntax:

catalog.db=catalog database name.schema name

The following is an example configuration for server.properties using a DB2 database:

catalog.url=db2\://cypress\:50000;databaseName=BPM_Db
server.css.URL=http\://aspen2.xyzco.com\:28080/interop/framework/getCSSConfigFile
catalog.db=bpm.ROOT
catalog.username=root
catalog.password=A627FC9A6DEA834C1FA777217871D09E
server.hss.bpmApplication=BPM\:29696
server.datafile.dir=$USER_HOME/data/FlatFileDir
server.essbase.streamingCubeBuilding=true 
server.timeoutPeriod=7200
server.queueSize=250
server.threadCount=50
server.resourceCount=35
server.sql.fetchSize=500
server.tempDir=$USER_HOME/Temp
server.readLockTimeOut=150
server.writeLockTimeOut=150
db2.pool.maxsize=20
db2.cache.size=15
server.essbase.uniqueMemberFromCaptionBinding=true