IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
4 replies Latest Post - ‏2012-10-17T06:37:52Z by andy__clifton
9 Posts

Pinned topic Recreate Results tables

‏2012-10-15T22:39:36Z |
Hi all, second post in one week!
I'm using Information Analyzer v8.7 (IA)
i have a bunch of data rules and rule set running in my environemnt.
However, in my naivety or dumbness i cleared down some results from some of the earlier tests I had run that were taking up too much space and were meaningless. This included deleting the results and the underlying results tables that store the actual values that were rejected or failed the rule.

How do I recreate results tables? I read something in the help menu about exporting the results to a table but I cannot see that option anywhere.

Updated on 2012-10-17T06:37:52Z at 2012-10-17T06:37:52Z by andy__clifton
  • RobertDickson
    72 Posts

    Re: Recreate Results tables

    ‏2012-10-16T11:17:30Z  in response to andy__clifton
    Hi Andy,

    The results table should be re-created upon your next run. Go to the 'Investigate' pillar and select 'Table Management' to see a list of tables. Sort by 'Created Date' to see the most recent. The category will be 'Data Rules' for data rule tables.

  • smithha
    162 Posts

    Re: Recreate Results tables

    ‏2012-10-16T12:36:35Z  in response to andy__clifton
    Hi Andy,

    As Robert noted, results tables will be recreated the next time you run.
    However, for the earlier results, unless you either did a database backup or exported the results, then those results are gone.
    For export options of the actual results, there are the following options:
    1) Via the API/CLI, you can retrieve the detail results in the rule output see: -- this will produce XML output, though via the CLI option you can apply a stylesheet to configure the output (e.g. as a .csv)
    2) From the rule output Result tab, there is an Export button in the bottom right corner. This will produce .csv output.
    3) Use database utilities to dump the relevant xxxx_DATA table