Unloading/Deleting multiple load ids

[abdeshpa]

Hi,

2 criteria provided by the user to delete/unload reports -

1) List of 4500 load ids that needs to be unloaded
OR
2) Delete any reports prior to Nov 2014. In this case, there are millions of reports that are loaded since year 2000.

For
#1) Not sure how I can do this. May be by using Parm file but never used it before.

#2) I used arsdoc delete -h -f -i "where RPTDATE < 16359" -u -p -v.
But this is taking a lot of time (1 Hour and still running) and there are another couple of folders that need to be cleaned off.

How do I achieve this asap or is there any other better way to do this?

Thanks in advance!

Thanks
AD

[Justin Derrick]

If you have a list of Load ID's, and you're on one of the UNIX/Linux platforms, and all the Load ID's are for one Application Group, you can iterate over the list with a 'for' command in the shell:

for LOADID in `cat LoadIDs.txt`
do
   arsadmin unload -u admin -p password -g ApplicationGroup -L $LOADID
done


If you have more than 1 Application Group to unload, you'll have to break up the LoadIDs.txt into many files, each specific to one Application Group, then run the 'for loop' for each.  (If you're adventurous, you can put a database query inside the loop, and automatically determine the Application Group name for each Load ID.)

[abdeshpa]

Thanks for your help JD.
Although, I was able to unload all the load ids, I still see there are thousand of reports present in the folder for which I don't have the load ids. Could you help with this?

Thanks
AD.

[abdeshpa]

To add to it, the previous arsdoc delete command I ran (which was still going on for long), ended up abruptly as putty session timed out.

[jeffs42885]

Thanks for your help JD.
Although, I was able to unload all the load ids, I still see there are thousand of reports present in the folder for which I don't have the load ids. Could you help with this?

Thanks
AD.
[/quote

87 record search the system log, put it into excel and do some massaging.