cancel
Showing results for 
Search instead for 
Did you mean: 

Transaction Logs - Retention Period

Former Member
0 Kudos

Hi,

Which parameter/bg job is responsible for maintaining the transaction log for <n> number of days?

Regards,

Cs

Accepted Solutions (0)

Answers (1)

Answers (1)

debasissahoo
Active Contributor
0 Kudos

Hello,

Tcode used for deleting log is SLG2

You can check this thread,

Regards,

Debasis.

Former Member
0 Kudos

Hi Debasis,

Thanks for the quick reply...In transaction STAT/STAD i am currently able to see the details(transaction logs) only for the last 3 days,i want to know how to configure this so as to maintain the logs for <n> days.

Regards,

Cs

debasissahoo
Active Contributor
0 Kudos

Hi Cs,

The data is you get from STAD is stored at the OS level file (location given by the parameter stat/file). This parameter points by default to the instance-specific /Data-directory (for example: \usr\sap\<SID>\DVEBMGS00\data) however this can be changed depending on your choice.

For each hour a new stat file is written.

The parameter stat/maxfiles determines how many stat files will be written until the oldest is overwritten.

So depending on your requirement and available disk space size, you can increase these parameters.

Note - these parameters are instance specific. you have to maintain for each instance you may have.

Regards,

Debasis.

Former Member
0 Kudos

Thanks for the valuable answer,since stat/as_max_files parameter value cannot be more than 99 i can't maintain these transaction logs more than 4 days isn't? or is there any way i can maintain these log for say 15 days..

Regards,

Cs

debasissahoo
Active Contributor
0 Kudos

Hi Cs,

True, thats the limit the kernel has. (max 99 files for statistics)

You can have a look on the below blog, similar kind of questions have been discussed in the reply of this blog.

Regards,

Debasis.

Former Member
0 Kudos

Hi Debasis,

Thanks for that link,which was very good. I also have one more query. Is the retention period for the data in ST03n is controlled by the values in Collector & Perfomance ->Monitoring database ->Reorganization?

Regards,

Cs

debasissahoo
Active Contributor
0 Kudos

Hi Cs,

Yes, right, In Collector and Performance DB you control the behavior of data collection.

Regards,

Debasis.