Page 1 of 1

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

Posted: Thu May 22, 2014 1:45 pm
by truenorth
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.

Posted: Fri May 23, 2014 6:33 pm
by qt_ky
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.

Posted: Sat May 24, 2014 3:29 pm
by ray.wurlod
Beat me to it! :D

Posted: Sat May 24, 2014 5:35 pm
by qt_ky
:o

Posted: Tue May 27, 2014 9:23 am
by truenorth
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.

Posted: Tue May 27, 2014 5:57 pm
by stuartjvnorton
This gives you some options to manage rules execution results with IAAdmin:

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