How to use SCDBUTIL to "mass delete" a file

[danstenzel]

Periodically I need to run a mass delete on a couple of files and then run a compress. What I currently do is:

1: have everyone sign off
2: do a hot backup
3: use dbdict to bring up the file (e.g. eventin) - and do a mass delete
4: bring down the system
5: run a scripted compress using SCDBUTIL

What I would like to do is include the mass delete in the script - this would make it easier for someone else to do this periodic maintenance. Is there an easy way to use the “File exerciser (DBEXER)” in the SCDBUTIL to do this?

Thanks - Dan

[harn145]

I've not tried it, but there would be no fundamental issue as far as I can see. If you setup a external file (either predefined or you have your script create on) with the correct command sequence, you can 'feed' that into scdbutil as a paramter set.

[danstenzel]

I had also posted this question on the HP forum - Lars Detmers gave a great response that ended up being the answer to this question.

Lars recommended scheduling a "Reset" from the dbdict tool. A record in schedule record is created with class "report". Make sure that the report background process is running.

How to do this can be found on the help file "How do I reset a database dictionary?"

I then went back to the DBEXER in SCDBUTIL - and when I went to option 2 - there was an "rst" option. So in order to add a "mass delete" before doing a compress, just add these commands to the ".in" file:

2
opn
stathistory
rst
cls
... repeat the " opn <filename> rst cls " for any other files ...
x

then continue with the scripted compress.