Not a big fan of reinventing the wheel and I can't find anything useful after hours of Googling and I'm not used to Windows and windows scripting so I'm wondering how other people automate the pruning of Transaction Logs?
Easily done in AIX but seems to be a real pain in Win :/
you mean the archived logs ?
cygwin can also be used to simulate a unix shell
we do it in a rexx script after the backup - we decide how many backups to keep and clean the logs. but we use tsm for the archive so it is easy todo with db2adutl
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