DB13 - Cleanup logs query

[former_member759680]

Hello,

DB13 job - Cleanup Logs takes the retention period from the paramter file - init<sid>.sap

But in our init<sid>.sap the parameters for cleanup are all hashed out (disabled)

# cleanup_brarchive_log = 30
# retention period in days for brbackup log files
# default: 30
# cleanup_brbackup_log = 30
# retention period in days for brconnect log files
# default: 30
# cleanup_brconnect_log = 30
# retention period in days for brrestore log files
# default: 30
# cleanup_brrestore_log = 30
# retention period in days for brrecover log files
# default: 30
# cleanup_brrecover_log = 30
# retention period in days for brspace log files
# default: 30
# cleanup_brspace_log = 30
# retention period in days for archive log files saved on disk
# default: 30
# cleanup_disk_archive = 30
# retention period in days for database files backed up on disk
# default: 30
# cleanup_disk_backup = 30
# retention period in days for brspace export dumps and scripts
# default: 30
# cleanup_exp_dump = 30

So, from where is it taking the paramter

Also, can I change the parameter file option for this job so that it takes another parameter file - init<sid>_new.sap

How do I do that?

[Former Member · Accepted solution]

Hi Gautam,

What I feel is the value which is default is hardcoded and if you need something different you need to un-comment it and use that value.. why you wana create a new initSID.sap file... try it...

all the best !

[former_member759680]

Yes, seems the obvious thing. Will check it on some system later