Hello everybody,

Why db2 doesn't remove(rename) inactive logs after they were archived
on TSM ? Documentation said the logs that become inactive ( doesn't
contain active transaction) and if they are archive logs will be
renamed (removed).

Logs which are in logdirectory at this moment:

-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:43 S0002939.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:45 S0002940.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:47 S0002941.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:49 S0002942.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:51 S0002943.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:54 S0002944.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:56 S0002945.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 12 12:58 S0002946.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:00 S0003718.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:02 S0003719.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:03 S0003720.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:26 S0003721.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:28 S0003722.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:32 S0003723.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:34 S0003724.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:34 S0003725.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:39 S0003726.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:39 S0003727.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:43 S0003728.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:46 S0003729.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:46 S0003730.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:47 S0003731.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:52 S0003732.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:52 S0003733.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 16:53 S0003734.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:00 S0003735.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:01 S0003736.LOG
-rw------- 1 db2bwp dbbwpadm 536748032 Dec 13 17:01 S0003737.LOG

> db2 get db cfg | grep -i "first active"
First active log file =
S0003718.LOG

Why those logs from 2939 to 2946 was not renamed and they are still
leaves in logdirectory ? All those logs are archived logs :

$ for i in `seq 2939 2946` ; do cat /db2/BWP/db2dump/db2diag.log |grep
-i S000$i.LOG; done
MESSAGE : Successfully archived log file S0002939.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002940.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002941.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002942.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002943.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002944.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002945.LOG to TSM chain 0
from
MESSAGE : Successfully archived log file S0002946.LOG to TSM chain 0
from

Can I move(delete) those logs(2939-2946) manually ? IBM said "Never
delete log files manually " !


Thank you,
Cristi