IBM Support

Managing the IBM Infosphere Information Analyzer analysis database

Technote (FAQ)


What are some best practices for maintaining the Infosphere Information Analyzer analysis database?


The analysis database is the database where InfoSphere Information Analyzer stores all the results of column analysis and execution of data rules. The default name of this database is IADB.

The following are some best practices to maintain this database:

  1. Set the Update Existing Table option to No. Setting the "Update existing table" option to No ensures that when you rerun column analysis and data rules, the existing results table in the analysis database is deleted and a new table is created. If the Update existing table is set to Yes, the results of column analysis and data rule execution are appended to the existing tables (tables that contain the results from previous analyses). As a result, the space consumption in the database will increase.

    To set the Update Existing Tables option to No, follow these steps:
    1. From the Investigate navigator menu in the console, select Column Analysis.
    2. From the Column Analysis workspace, select the columns that you want to analyze.
    3. In the Tasks pane, click Run Column Analysis.
    4. On the Options tab, for Update Existing Tables, select No.

  2. Periodically clean the analysis database by deleting the old results of column analysis and data rules execution. If you do not need results of old column analysis and data rule jobs, you can remove these results to increase space in the database. Follow the instructions in Managing the space consumed by historical output of data rule and rule set executions in InfoSphere Information Analyzer to remove these older results.

  3. You can configure different analysis databases for different InfoSphere Information Analyzer projects. To do this, update the project properties tab of each InfoSphere Information Analyzer project with details of the new analysis database. Follow the instructions at the appropriate link below, depending on the version of InfoSphere Information Analyzer that you are using:
    Configuring IBM InfoSphere Information Analyzer version 8.7.0
    Configuring IBM InfoSphere Information Analyzer version 9.1.2

  4. If you are running column analysis and data rules on A large number of records you might need incremental space in the analysis database. Regularly check for free space in the analysis database. If you see the message "Unable to allocate communication resources" in the job log, and this entry corresponds a to column analysis or data rule jobs failure, check the amount of free space remaining in the analysis database. This message indicates that there is low free space in the analysis database, causing incomplete job execution.

  5. To save disk space, you might be able to compress the analysis database. Check with your database administrator or refer to the documentation for your database type.

Document information

More support for: InfoSphere Information Analyzer

Software version: 8.5, 8.7, 9.1,

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1683705

Modified date: 23 September 2014