Obtaining a list of exception providers

You can use the database administration tool to obtain a list of hosts, projects, jobs, or stages that provide exceptions to the exceptions database.

Procedure

  1. On the computer that hosts the client tier or engine tier, switch to the /InformationServer/ASBNode/bin directory on Linux® and UNIX, or \InformationServer\ASBNode\bin on Windows.
  2. Run the exceptions database administration tool with the required parameters, and include one of the following parameter options:
    • -listHosts
    • -listProjects -DSQShost hostname
    • -listJobs -DSQShost hostname -projectName projectname
    • -listStages -DSQShost hostname -projectName projectname -jobName jobname

Example

On Linux and UNIX:
./ESDBAdmin.sh -user username -password password -ESDBhost hostname -port portnumber -dbName databasename -listProjects -DSQShost hostname
On Windows:
ESDBAdmin.bat -user username -password password -ESDBhost hostname -port portnumber -dbName databasename -listStages -DSQShost hostname -projectName projectname -jobName jobname