Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2007

Tip: Looking for answers? Try searching our database.

db2 leaves inactive  logs in logdirectory although they are archived     logs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cristizaharioiu - 13 Dec 2007 15:27 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.