> ### Changing database control settings

> From the Database Details page you can access the Control page. The Control page provides information about the current database and database agent settings and allows you to start and stop a managed database and agent. For a scripted database, the page allows you to see the database status and the remote monitoring agent status, and to copy the command line that you use to start the dbagent on the remote machine. You can also stop the remote monitoring agent from a scripted database's Control page.

> Figure 3–2 shows a sample Database Control page for a managed database. Figure 3–3 shows a sample Database Control page for a scripted database.

> Figure 3–2: Managed Database Control page

> Figure 3–3: Scripted Database Control page

> From the Control page of a managed database, you can:

> - Stop the database by clicking Stop Database; the status is updated to Not Running. To restart the database, click Start Database. (This is the same button; the button's text changes to display the opposite status of the one that is currently set.)
> Note: The database agent, or monitoring agent, works only if the database is running. Therefore, when you stop a database, the monitoring agent status automatically changes to Not Running. However, when you start the local database, the agent does not automatically start.

> - Change the status of a database monitor from Enabled to Disabled by clicking Edit and clearing the Enabled check box. If you disable database monitors, the database still appears under Databases in the list frame. However, the database is not being monitored by Fathom.
> Consider the following points as they relate to deleting databases rather than disabling them:

> - If you delete a database from within Fathom, you have permanently removed it from Fathom. It is preferable to disable the database because you have more options to use the resource at a later time. For example, you could elect to copy and reuse the database's configuration for a new database you create, or you could migrate the database using the Database Migration Utility. Alternatively, you can delete it and add it again in the future if necessary.
> - Similarly, if you delete a managed database through the Progress Explorer, the database's status within Fathom, by default, becomes scripted, and the database is disabled. As with a database that you directly disable from within Fathom, a disabled database continues to display in the Fathom Management console list frame with a disabled status circle preceding it. It is not permanently removed from Fathom. You can elect to copy the configuration at a later date, migrate the database using the Database Migration Utility, or delete it in Fathom.
> Note that you can still continue to run historical reports against a database after you have deleted it from Fathom.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095