SEO

#1 (**permalink**) 02-27-2008, 07:34 AM

I have a question about DB2 ver 7.2

We are run out space and Network guys like to delete the old log files
of db2
Last week we had a problem in developer because they deleted the old
log files and DB2 was try to used it

My question is what is the best way for clean up old log files

thanks in advance

Adrian

#2 (**permalink**) 02-27-2008, 07:34 AM

adrian.alek@gmail.com wrote:
> I have a question about DB2 ver 7.2
>
> We are run out space and Network guys like to delete the old log files
> of db2
> Last week we had a problem in developer because they deleted the old
> log files and DB2 was try to used it
>
> My question is what is the best way for clean up old log files
>
> thanks in advance
>

Assuming this is DB2 for LUW:

1. First find out what is the oldest log that is still active:
a. db2 connect to <your db-id>
b. db2 get db cfg for <your db-id>
Search for 'First active log file'.
This should give you something similar to S0000100.LOG
2. Issue the 'Prune' command as follows:
db2 prune logfile prior to <output from step 1>

Note: you should also consider off-loading inactive logs to tape or
some other secondary media.

HTH.
--
Jeroen

#3 (**permalink**) 02-27-2008, 07:34 AM

Thank you

I will try !

Jeroen van den Broek wrote:
> adrian.alek@gmail.com wrote:
> > I have a question about DB2 ver 7.2
> >
> > We are run out space and Network guys like to delete the old log files
> > of db2
> > Last week we had a problem in developer because they deleted the old
> > log files and DB2 was try to used it
> >
> > My question is what is the best way for clean up old log files
> >
> > thanks in advance
> >
>
> Assuming this is DB2 for LUW:
>
> 1. First find out what is the oldest log that is still active:
> a. db2 connect to <your db-id>
> b. db2 get db cfg for <your db-id>
> Search for 'First active log file'.
> This should give you something similar to S0000100.LOG
> 2. Issue the 'Prune' command as follows:
> db2 prune logfile prior to <output from step 1>
>
> Note: you should also consider off-loading inactive logs to tape or
> some other secondary media.
>
> HTH.
> --
> Jeroen

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode