BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

AL_Statistics table size issue


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
Dvn
Senior Member
Senior Member



Joined: 24 Nov 2012

Posts: 67



PostPosted: Fri Apr 22, 2016 10:02 am 
Post subject: AL_Statistics table size issue

Friends,

My production job performance is getting deteriorated due to AL_Statistics table size issue.

Is there any option in CMC or the designer where we can limit the data retention in al_statistics to last 7 to 10 days or any way to do auto clean up of all the al_statistics, al_history tables on a weekly basis etc ?

Thanks.
Back to top
avandeweghe
Senior Member
Senior Member



Joined: 25 Apr 2012

Posts: 38
Location: Ontario


flag
PostPosted: Fri Apr 29, 2016 9:31 am 
Post subject: Re: AL_Statistics table size issue

Login to the Central Management Console then go to Application > Data Services Applications

There are values for setting the Retention and how often the Cleanup Job runs.


-Adam
Back to top
Dvn
Senior Member
Senior Member



Joined: 24 Nov 2012

Posts: 67



PostPosted: Wed May 04, 2016 7:06 am 
Post subject: Re: AL_Statistics table size issue

We had already made that change few months back by changing History and Log retention period to 20 days but we still have entries in value column in al_statistics table having date greater than 30 days.

There is another field "Job History Cleanup Period", is this linked to al_statistics ? Its ask to enter values in seconds, any idea what does this field exactly does ?
Back to top
manoj_d
Forum Addict
Forum Addict



Joined: 01 Jan 2009

Posts: 2944



PostPosted: Tue May 17, 2016 10:31 pm 
Post subject: Re: AL_Statistics table size issue

you should first find out why the history is not getting deleted
if you want to cleanup the data manually, check the following post
http://www.forumtopics.com/busobj/viewtopic.php?t=145031

if you are seeing lots of statistics getting generated then you can disable that by making the following changes to %DS_COMMON_DIR%\conf\DSConfig.txt file on the jobServer

first try the following
Enable_Statistics = TRUE
Disable_Transform_Statistics = TRUE

if you still see large amount of stats, then set the values as below
Enable_Statistics = FALSE
Disable_Transform_Statistics = TRUE

if the log deletion is not working properly, I would suggest opening a case with support
Back to top
jlynn73
Forum Associate
Forum Associate



Joined: 27 Oct 2009

Posts: 571
Location: DesMoines Iowa


flag
PostPosted: Fri Dec 07, 2018 10:53 am 
Post subject: Re: AL_Statistics table size issue

If you use the Data Quality reports, disabling statistics will also disable all of the reports.

We've been having serious issues trying to get reports to export, so tried this with some not so pleasant results.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0482 seconds using 17 queries. (SQL 0.0233 Parse 0.0009 Other 0.0240)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo