WPS--Clean the events in WPS CEI Database

The CEI Events in WPS CEI Database will be increasing with more and more business transactions were processed and will take a lot of hard disk.

Here is how to Clean the events in CEI Database.

1) run the command

wsadmin.sh -f eventbucket.jacl -change -serverName server1

this command will switch the event bucket from 0 to 1 or 1 to 0 depending on which one is current event bucket.

To check the current event, use the following command

wsadmin.sh -f eventbucket.jacl -status -serverName server1

2) log on to the database server (here the database is DB2), then issue the command with the db2 instance owner.

fastpurge.sh CEIDB db2instance1 password=password

(3) run reorg.sh to reorganize the database

reorg.sh CEIDB db2instance1 password=password

(4) run runstats.sh to run statistics on database

runstats.sh CEIDB db2instance1 password=password
Note:

1) when you run eventbucket.jacl in cluster environment, you may see the following errors:

WASX7017E: Exception received while running
file "$WAS_HOME/util/event/eventpurge.jacl"; exception
information: javax.management.InstanceNotFoundException: *:*)

this bug will be fixed in WPS7.0.0.17 (http://www-01.ibm.com/support/docview.wss?uid=swg1PM21539). However, you can ask IBM to provide the updated com.ibm.events.client.jar, and then you will run it like the following command

wsadmin.sh -f eventbucket.jacl -status -clusterName SupportCluster

2) fastpurge.sh, reorg.sh and runstats.sh can be found at the directory <profileDir>/dbscripts/CEI/DB2/CEIDB on stand-alone server, and can be found at the directory <profileDir>/databases/event/clusterName/dbscripts/db2 on cluster environment.