Online Tutorials & Training Materials | STechies.com
Register Login

how to set the retention period for logs?

Guest || 13 Apr 2009 1:48 pm || 5

Hello Gurus

How are you?

Can you please let me know how to set the retention period for logs such as developer logs, system log, spool, etc.


Comments

  • 13 Apr 2009 1:48 pm

    The log retention policy should be decided on your requirement however maximum period of 30 days should be enough for all logs.

    However it may varies for diff jobs like e.g. backup ( the policy depends on your backup cycle)

    With 640 the default period of 30 days is set in init.dba file for cleaup job in DB13. Howerver you can change it. Prior to version 640 the default was 15 days.

  • 13 Apr 2009 1:48 pm

    Thanks for your response.

    We are using MS SQL server and I do not know which configuration file to check so is there anyway that I can see the db parameters from SAP GUI. I tried in DB13 but could not get it.

  • 13 Apr 2009 1:48 pm

    For MSSQL you need to start the database administrator on the local machine. You configure MSSQL through stored procedures (start Query Analyzer and use the apropriate sp_ procedure).

  • 13 Apr 2009 1:48 pm

    Hi,

    Simplest way for any troubleshooting in MSSQL is to use the books online that come along with MSSQL installation.Here you will be able to get the exact command to see the parameter.

  • 13 Apr 2009 1:48 pm

    Hi,

    The log retention period for say spool request can be decided your self with the report RSPO1041,this report deletes old spool requests,you only have to create a variant and run this report

    For application logs,6604 for other logs.This way you can make the log retention period according to your own need.Please dont confuse between the logs such as bkgnd job logs and the MSSQL .ldf(log) file which is a different log altogether.