Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster Maintenance
Go
New
Search
Notify
Tools
Reply
  
ReportCaster Maintenance
 Login/Join
 
Member
posted
Hi,

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).


Thank you
Phillip du Plooy


WebFocus 7.1 On win2000 (webfocus admin)
Oracle 9i Aix (dba)
Oracle 10g RedHat (dba)
MsSql (dba)
Adabas 4 OpenVMS (dba + sysadmin)
 
Posts: 12 | Location: Potchefstroom South Africa | Registered: July 17, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
Phillip,

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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Thank you Ginny,

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".

Thank you
Phillip du Plooy


WebFocus 7.1 On win2000 (webfocus admin)
Oracle 9i Aix (dba)
Oracle 10g RedHat (dba)
MsSql (dba)
Adabas 4 OpenVMS (dba + sysadmin)
 
Posts: 12 | Location: Potchefstroom South Africa | Registered: July 17, 2008Reply With QuoteReport This Post
Member
posted Hide Post
Hey Phillip,
When creating a schedule go under advanced and there is an option to "Delete this schedule if it is not scheduled to run again." That sounds like what you are looking for.


Production/Test: WF 7.1.4, WIN2K3 Server
 
Posts: 12 | Location: Wilson, NC | Registered: November 14, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Thank you,

But I want to automate the proses. And this still leaves me with a reorg of the botsched table once a month.

Phillip du Plooy


WebFocus 7.1 On win2000 (webfocus admin)
Oracle 9i Aix (dba)
Oracle 10g RedHat (dba)
MsSql (dba)
Adabas 4 OpenVMS (dba + sysadmin)
 
Posts: 12 | Location: Potchefstroom South Africa | Registered: July 17, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Phillip,

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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Hi,

As fthompson said you can do a delete via the report caster front end. I had a look at the RC api manual but cant find any mention of this there.

If I have to write something it feels like reinventing the wheel .

What does other sites do for their maintenance on these tables?

thank you
Phillip du Plooy


WebFocus 7.1 On win2000 (webfocus admin)
Oracle 9i Aix (dba)
Oracle 10g RedHat (dba)
MsSql (dba)
Adabas 4 OpenVMS (dba + sysadmin)
 
Posts: 12 | Location: Potchefstroom South Africa | Registered: July 17, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     ReportCaster Maintenance

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.