Question & Answer
Question
Is there a formula for estimating the space requirements for Information Analyzer DataBase repository and file system to use in APT_CONFIG_FILE?
Answer
The attached document -- Information Analyzer Storage Planning -- contains the information to plan for database storage.
Here are some additional considerations for cleaning up the IADB database.
Delete Analysis Results
You can delete Analysis Results if you are defined as an Information Analyzer Business Analyst (user role). Here is an excerpt from the Information Analyzer (IA) User Guide:
When you no longer need published summaries of analysis results, you can delete them from the metadata repository. To delete analysis results:
- On the Investigate navigator menu, select Analysis Results Publication.
- In the Publish Analysis Results workspace, select the analysis results that you want to delete.
- In the Tasks pane, click Delete Analysis Results.
- Click OK to confirm the deletion.
Cleaning up Frequency Distribution information for IADB database. The following information is copied from the IA User Guide:
Note: Frequency distribution tables can be very large and take up a lot of space. You can delete a frequency distribution to reduce the amount of space that is used on a system. However, if you delete a frequency distribution, you lose the results from the column analysis job that created it and you will not be able to run subsequent analyses that use the frequency distribution as input, such as primary key analysis and baseline analysis.
If a frequency distribution table is deleted, you can no longer view any details for the associated column, such as the frequency distribution, domain, or format analyses results.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21388711