- This topic has 4 replies, 2 voices, and was last updated 4 years, 9 months ago by
.
-
Topic
-
Hi,
I’m looking for a script that will automate the clean up of the error and recovery databases. I previously spoke to Infor about it, but I was told they don’t give it out anymore. We currently do the cleanup manually following a guide/document. If anyone has anything to share for me to work with that would be great.
-
Replies
-
-
We have not scripted the database cleanup, but we do run a weekly recycle of all sites (each site one at a time). For each site, it stops all processes, zeros all thread stats, recycles the two daemons and starts all processes. I’ll attach a copy. You would have to change the daemon recycle – instead, stop the daemons, run the database cleanup and start the daemons. Then run the rest of the script to start the processes. I’ll also attach the called subroutines. I tend to use them alot to make the main script more readable. You don’t need the line with the export command at the top. This is for UNIX.
I know some Cloverleaf command line utilities require a specific runtime environment, and that is already there for the ‘hci’ userid. But if you run from cron, you may need more environment setup commands than what I have attached for our cron entry.
Peter Heggie
-
-
-
-
- You must be logged in to reply to this topic.
