Easily/automating Deleting Validation Rules results in IA

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
Derrickfn
Participant
Posts: 11
Joined: Fri Jul 18, 2008 4:07 pm
Location: Alexandria

Easily/automating Deleting Validation Rules results in IA

Post by Derrickfn »

Is there a easy way to delete all of the validate rule results. I have been going to view output and maunally deleting the rows. We now have over 500 validation rules and its extremly time consuming to do this. I do use iajobs to execute all of the rules from a batch file. I was hoping there was a equally simple way of deleting all of the results and cleaning up the IADB database.


I also have thousands of the following table definitions in my IADB. It does not seem to remove these when I manually delete the resutls. Can I just delete them?

"ec1481df.f92d8a7c.fq1iqc9ml.enjj2gf.38jhk9.or4a3mnjqj4psv6tq3ouh_DATA"
"ec1481df.f92d8a7c.fq1iqc9ml.enjj2gf.38jhk9.or4a3mnjqj4psv6tq3ouh_devscores"
"ec1481df.f92d8a7c.fq1iqc9ml.enjj2gf.38jhk9.or4a3mnjqj4psv6tq3ouh_scoredist"
"ec1481df.f92d8a7c.fq1iqc9ml.enjj2gf.38jhk9.or4a3mnjqj4psv6tq3ouh_violations"
Post Reply