WebSphere brand IBM WebSphere Premises Server, Version 6.1.x

Tuning the databases to improve performance

Use the steps in this topic to improve your WebSphere® Premises Server database performance.

Note: If you have installed Location Awareness Services for WebSphere Premises Server, the default installation can support small scenarios, using between 100 and 200 tags. To use Location Awareness Services for WebSphere Premises Server in a production environment or to use it with more tags, tune your ATLASDB database for additional buffer pools, and add more hard drives to avoid bottlenecks.

Tuning DB2 for Linux®, UNIX®, and Windows®

To tune your WebSphere Premises Server DB2® database, you can either run a script or issue the commands from the DB2 command line.

If you are using a local DB2 database, use the scripts provided on the DVDs. The scripts are located in these paths:

Before installation:

  • Windows On CD 2 in db_script\performance_tuning_db2.bat
  • Linux On CD 3 in db_script/performance_tuning_db2.sh

After installation:

  • Windows IBM_RFID_HOME\premises\install\db\performance_tuning_db2.bat
  • Linux IBM_RFID_HOME/premises/install/db/performance_tuning_db2.sh
If you have a remote DB2 database, you may prefer to run the commands from the DB2 command line:
db2 connect to IBMRFID
db2 update database configuration using locklist 50000 immediate
db2 update database configuration using maxlocks 95 immediate
db2 update database configuration using maxappls 75 immediate
db2 update database configuration using avg_appls 40 immediate
db2 alter bufferpool IBMDEFAULTBP immediate size 20000 

Library | Support | Terms of use

(c) Copyright IBM Corporation 2004, 2008. All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.