SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 01:09 PM
| ||||
| ||||
 db2 leaves inactive logs in logdirectory although they are archivedlogs 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      |
|
02-27-2008, 01:09 PM
| ||||
| ||||
| Re: db2 leaves inactive logs in logdirectory although they arearchived logs On Dec 13, 10:27 am, cristizaharioiu <cristizahari...@gmail.com> wrote: > 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 Try reactivate your database, if it is still there, safe to delete. |
Linear Mode
