We have a development Linux server with 2 databases on it. The databases are in circular log mode. LOGPRIMARY set to 10 and LOGSECOND set to 100 and LOGFILSIZ set to 2000.
We have ran out of space on the server because the log files are not automatically deleted. We had log files from September 2012 still sitting on the server. I would think that since the database is in circular log mode the log files would be deleted automatically.
Is there a db setting/configuration I need to set ?. Any ideas why the files were not deleted ?
At this point I am thinking to setup a cron job to delete the log files that are older than 10 days.
never delete logfiles based on date
check the db cfg
First active log file = S0075891.LOG
maybe some long running transactions..
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be