hello,
our aix db2 server is having full disk space problems.
I have recognised that the below files are so large in size
Can i clean them with simply doing "rm"? Will the database and instance work properly without them?
ıf simply removing the files won't work, how can i clean it??
tnks all


-rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000000.LOG

-rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000001.LOG

-rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000002.LOG

-rw------- 1 db2dvlp2 db2iadm1 16785408 25 Feb 15:05 /home/db2inst1/NODE0000/SQL00010/SQLOGDIR/S0000003.LOG

These are database log files ... Please do not remove them ...

I wish they hadn't used the extention .LOG - it's very confusing for sysadmins not familiar with databases, they assume it's just a traditional informational log file. I've seen more than one occasion where the database was failing to start, then you look in the transaction log directory and see:
S0000001.LOG.gz

Argh! :P

S0000001.DO.NOT.TOUCH would be preferable.

you're right
so what cleans up transaction log file in db2?? will an offline backup of the database clean the log files, as it works for sybase and sqlserver??

AFAIK, the offline backup will not delete these log files ... They will be on the disk ... When you restart the db, these files will be formatted ...

You may delete these files after an offline backup ...

Cheers
Sathyaram

stop instance , rm all *.LOG files from NEWLOGPATH , re-start the instance

That is OK, if it is development instance


Lekharaju Ennam

thanks guys