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
shenanwei@gmail.com - 13 Dec 2007 20:10 GMT
On Dec 13, 10:27 am, cristizaharioiu <cristizahari...@gmail.com>
wrote:
> Hello everybody,
>
[quoted text clipped - 66 lines]
> Thank you,
> Cristi
Try reactivate your database, if it is still there, safe to delete.