Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
ReportCaster Maintenance
 Login/Join
 
Phillip
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, 2008Report This Post
Prarie
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, 2005Report This Post
GinnyJakes
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, 2006Report This Post
Phillip
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, 2008Report This Post
fthompson
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, 2005Report This Post
Phillip
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, 2008Report This Post
GinnyJakes
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, 2006Report This Post
Phillip
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, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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

Copyright © 1996-2020 Information Builders