What is the FIMS Database Health Audit Feature and how do I Use it?

In Tools\System Utilities\Admin Utilities there is a feature called, "DB Health Audit", what is that and how I can use it?
The Database Health Audit is for self-hosted customers to assist with managing your data. The tool will show you when your last FIMS database back up was and will show you information regarding your database structure.

1. When you first launch the DB Health Audit, you will see an informational message that will tell you when your last database backup was taken. This message is generated from the latest file date in npo\found\dbbackup on your FIMS server. What this means is that this is the last time an actual FIMS database backup was done. You may have a process in place to backup your database files or the entire server, but this message is specific to the actual database backup process itself which is not the same as making a copy of the database files or the NPO directory. It is recommended that you create regular database backups so that in case of emergency you can restore to a recent data backup if needed:

You can verify the information in the window by going to \npo\found\DBBackup and noting the last date of your database backup. See the following articles on making a FIMS database backup:

2. After you click OK on the message regarding the database backup you may see a message regarding the database buffer:

This is an informational message about the current state of your database files. When you click on the message above, you will see a report as shown below. This report shows any database areas that have increased beyond the allotted indexed file space.

If you do not see any message as shown above, or a report below, then that means that the DB Health Audit Utility did not identify any database files needing to be restructured. If you do see areas in your database listed in the DB Health Audit report that need to be restructured, Progress can complete this work for a fee. Please contact Progress customer support and provide them a copy of your DB Health Audit report.





Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.