Board index » database » db2 leaves inactive logs in logdirectory although they are archived logs
cristizaharioiu
 Registered User |
db2 leaves inactive logs in logdirectory although they are archived logs
2007-12-13 11:27:09 PM
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 Quotedb2 get db cfg | grep -i "first active" 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 - |