Any add-on utility that can erase analysis results in IADB?

truenorth · Post by **truenorth** » Thu May 22, 2014 1:45 pm

Our user community originally requested the DB2 group for 100GB of diskspace for IADB. Anticipating growth, they gave us 400GB. It has ballooned to 420GB and still growing.

We're looking for a clean-up procedure for IADB: maybe a command line utility that can delete IA results en masse, as opposed to individually erasing them. Normally, we use IA's table management to delete analysis results but it can be tedious having to do it one at a time.

Can anyone help?

Thanks in advance.

qt_ky · Post by **qt_ky** » Fri May 23, 2014 6:33 pm

The IA 8.7 table management workspace allows deletion of multiple tables at once by using standard Windows selection methods of holding down Shift while clicking to select a range or Ctrl to pick and choose multiples.

ray.wurlod · Post by **ray.wurlod** » Sat May 24, 2014 3:29 pm

Beat me to it! :D

qt_ky · Post by **qt_ky** » Sat May 24, 2014 5:35 pm

truenorth · Post by **truenorth** » Tue May 27, 2014 9:23 am

Thank you, mates. We have been encouraging all users to do this, but the infrastructure group is still looking for a utility say, to erase all results in an entire project, e.g., TEST. If the table management screen is the only way, we will use it. We were just hoping someone may have built some utility they can share.

stuartjvnorton · Post by **stuartjvnorton** » Tue May 27, 2014 5:57 pm

This gives you some options to manage rules execution results with IAAdmin:

http://www-01.ibm.com/support/docview.w ... wg21593395