Purging the Cache & DB data

[rajesh]

Hi,

Can any one let me know how to delete the Cache & DB data both at once in bulk. we have almost 7 years of data that need to purged where i can delete the data from Database but not from Cache. Can any one help me with the below issue or any hint that helps me to purge the data using command.

Command that i use to purge the data from folder.
/opt/ondemand/bin/arsdoc delete -h archive -i where rdate between 15401 and 15431  -f folder name -v

[kbsiva]

Hi Rajesh -  arsdoc delete will only delete the index records from the Database it will leave the cache file system as it is. arsmaint is the way to go.  I am not sure what your requirement is looks like you need more of an archiving strategy rather than trying to delete documents.


Thanks,
Siva

[Justin Derrick]

You'll want to read about arsmaint:

http://www-01.ibm.com/support/knowledgecenter/SSEPCD_8.5.0/com.ibm.ondemand.administeringmp.doc/dodma002.htm

-JD.

[B.Rivers]

We use the unload command in shell script to do this from testing environments.

arsadmin unload -h localhost -u USER -p PASS -g AA1_AG47_DF -L 20724-0-0-1601FAA-20160930000000-20160930000000-20923

This will clear both database and arscache.

Brian