Maintaining the exceptions database
You can manage the records in the exceptions database with the exceptions database administration tool.
You can use the database administration tool to complete the following tasks:
- Determine which hosts, projects, jobs, and stages are providing exception records to the exceptions database.
- Delete exceptions that are older than a specific date.
- Delete exceptions that are older than a specific number of weeks or months.
- List all of the exception descriptors in the database by their record IDs.
- Delete specific exception descriptors by specifying their record IDs.
The database administration tool is in the Information Server directory under InformationServer/ASBNode/bin/ESDBAdmin.sh on Linux and UNIX, or InformationServer\ASBNode\bin\ESDBAdmin.bat on Windows. You can access the tool and view a full list of available parameters and usage information by running the tool without specifying any parameters.
The following parameters are required by the exceptions database administration tool:
- -authFile
- The path and file name for your database authorization file. You must specify an authorization file if you do not include the -user and -password parameters.
- -user
- The user name that you use to access the database on the specified host. You must specify the -user and -password parameters if you do not include the -authFile parameter.
- -password
- The password for the user that is accessing the specified database. Use this parameter only with the -user.
- -ESDBhost
- The host name where the exceptions database is located.
- -port
- The port number for the exceptions database.
- -dbName
- The name of the exceptions database.