Ahhh, the simplicity and ease of gently correcting an errant ingres database under BrightStor from CA. The best method that I have found (and had to use OFTEN) is simply the 'rm -rf *' command. Yes, delete the entire database folder structure, from the /ingresii folder upward. Then re-install! Takes about an hour, and gives BrightStor a shiny new database with no nasty data to corrupt. Of course, given a few weeks, that changes, but then we just cleanse it again!
No, CA BrightStor is not my favorite program. :)