WebSphere

Purging the inactive bucket for a SQL Server event database

The database purge utility for a SQL Server event database is implemented as a stored procedure.

Before you begin

To use the utility for a SQL Server database, you must have the osql utility installed on the SQL Server client. Refer to the SQL Server documentation for more information.
Note: Do not use the isql utility for running the database purge stored procedure.
Procedure
To purge the inactive bucket, run the stored procedure using the osql utility:
osql -Sserver_name -Udbuser -Pdbpassword -deventdb -Q"fast_purge"

The fast_purge file is stored in the same location as the other scripts generated during database configuration (the default location is profile_root/databases/event/node/server/dbscripts/sqlserver).

The parameters of this command are as follows:

server_name
The database server name.
dbuser
The database user ID to use when connecting to the event database.
dbpassword
The password to use for the specified user ID. This parameter is optional; if you do not specify the password, the osql utility prompts you for it.
eventdb
The name of the event database (typically event).

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.z.620.doc/doc/tcei_purge_inactive_bucket_sqlserver.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).