Re: delete archive log

Re: delete archive log

 

  

Investigate in your docs. the two following commands.
PRUNE HISTORY timestamp [WITH FORCE OPTION] [AND DELETE]

PRUNE LOGFILE PRIOR TO log-file-name

Basically with the NUM_DB_BACKUPS parm. of your config file, and the
recovery history file, you can get DB2 to administer which logs to delete
when.
Hope this helps, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Rahul Yadav"
<db2udbdba-ezmlmshield-x94439338.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, August 30, 2006 10:36 AM
Subject: delete archive log


> Hi All,
>
> i have database with archive loging. We have are storing them in
> another
> folder now this folder has grown to 1GB is it possible to regularly
> delete
> some files from this folder.
>
>
> Thanks,
> Rahul Yadav
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page