As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
This is my fisrt post here so please bear with me,
I want to know a few things about reportcaster database maintenance (focus db) :
What exactly does the parameter log purge period do in ReportCaster - Server Configuration, does it only remove old entries out of botlog and botlog2 or does it also remove old entries out of botsched. Is it possible to call this "function" from the command line to do a manual clean?
Is there a way to call a function that will clean entries out of botched (and all other relevant tables) that have a next runtime of never and that is older then a set time (like a week).
Welcome to the Forum. Please Update your Signature with what verion your are on so we will better know how to help you.
** Update signature 1) Logon to Focal Point and go into your complete profile. 2) Scroll down the page until you see the “Signature” field. 3) Fill in the signature you want to use. Here is a sample to model:
Prod: WebFOCUS 5.2.3 on Win 2K/IIS 6/ISAPI Mode Test: WebFOCUS 7.1 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode
4) Once all changes are made/added, scroll down to the bottom of the page and click on the Submit button.
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005
The auto log purge function only deletes rows from BOTLOG and BOTLOG2 that are prior to the number of days specified.
As far as I know, there are not any 'canned' procedures to do what you need to do. However, you can write focexecs against the tables to isolate the schedules that you want to delete and feed them to an SQL statement making sure that you pay attention to referential integrity as many tables have relationships. The rcadmin manual has the layouts of the tables for you and you can generate synonyms for them using the reporting server console.
But as far as I know this is not supported by Informationbuilders.
The reason why I want to clean botsched is because we have lots of reports running only once via reportcaster. And a few once running daily.
The best solotion that I came across is to create a clean botsched table, schedule all the daily jobs, than make a backup copy of the file. And copy it over the excisting file when botsched gets to big.
But then I lose all the jobs that have been scheduled that have not yet ran "once".
Regardless of whether what you want to do is supported by IBI, if you want to do stuff for which there is no canned process, you will have to develop your own. If you want to automate it, you are going to have to write something.