Automatic Deletion of Log Files in UDB v6.1

[login to unmask email]

Automatic Deletion of Log Files in UDB v6.1
I've just compiled, linked, and enabled the "db2uext2" exit in UDB v6.1 for one
of our databases to archive and retrieve database log files through ADSM.
Unfortunately, this procedure does not seem to delete the log file from the log
directory once it has been archived through ADSM.

How are other people handling some sort of automated deletion of log files in
UDB? I would like to set something up in our environment so that we wouldn't
start filling up our disks with log files if they're being archived somewhere
else, and I would like to see this as an automated process.

Our environment is UDB v6.1 running on AIX.

TIA for any info.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT



Tom Decabooter

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to BILL_GALLAGHER@PHL.COM)
In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
the backups/logs managed by ADSM.

Tom Decabooter
Honda Europe N.V.



[login to unmask email]

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to Tom Decabooter)
Tom,

Thanks for the info about this command. We were not aware of it, and it looks
like it will be very helpful.

But it does not really solve my original question: once log files have been
backed to ADSM, we would like to automatically delete them from the disk where
they currently reside in order to free up space for new log files as they are
created. Otherwise, we will have to periodically do this as a manual process or
run the risk of running out of disk space and have UDB crash.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT





Tom Decabooter <[login to unmask email]> on 01/05/2000 03:07:31 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
the backups/logs managed by ADSM.

Tom Decabooter
Honda Europe N.V.








Tom Decabooter

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to BILL_GALLAGHER@PHL.COM)
I thought the log files were reused, a kind of 'wrap around' : if the last one
is full,
the first one is 'activated' again.
I am still setting up the archiving on our NT system, so i am not 100% sure.

Tom Decabooter
Honda Europe N.V.








[login to unmask email] on 05/01/2000 15:58:17

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tom Decabooter/HE/EU/HONDA)



Subject: Re: Automatic Deletion of Log Files in UDB v6.1









Tom,

Thanks for the info about this command. We were not aware of it, and it looks
like it will be very helpful.

But it does not really solve my original question: once log files have been
backed to ADSM, we would like to automatically delete them from the disk where
they currently reside in order to free up space for new log files as they are
created. Otherwise, we will have to periodically do this as a manual process or
run the risk of running out of disk space and have UDB crash.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT





Tom Decabooter <[login to unmask email]> on 01/05/2000 03:07:31 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
the backups/logs managed by ADSM.

Tom Decabooter
Honda Europe N.V.













Danny Creed

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to Tom Decabooter)
I archive utilizing ADSM on AIX at DB2/6000 2.1.2 (yeah I know out of support),
but it does the archive and does not keep the log files on the AIX side. The
number keeps increasing for the LOG files, but I utilize the
db2adutl command to clean up old backups. I actually need to go read back up on
the syntax of the
log deletions, but I redid some "db2adutl delete full keep 9 DAYS db dname" for
a test. I use the "db2adutl query db dbname" to verify what is actually
usuable.
Perhaps I need to prune the history but not really sure, to eliminate the
log files.
Summary, I do not see the problem that you are describing at an older
release. I have to investigate how to clean up the log files on the ADSM host
side of things.
Regards
Danny




[login to unmask email] on 01/05/2000 10:43:37 AM

Please respond to [login to unmask email]

To: [login to unmask email]
cc: (bcc: Daniel S Creed/HI/CSC)
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



I thought the log files were reused, a kind of 'wrap around' : if the last one
is full,
the first one is 'activated' again.
I am still setting up the archiving on our NT system, so i am not 100% sure.

Tom Decabooter
Honda Europe N.V.








[login to unmask email] on 05/01/2000 15:58:17

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tom Decabooter/HE/EU/HONDA)



Subject: Re: Automatic Deletion of Log Files in UDB v6.1









Tom,

Thanks for the info about this command. We were not aware of it, and it looks
like it will be very helpful.

But it does not really solve my original question: once log files have been
backed to ADSM, we would like to automatically delete them from the disk where
they currently reside in order to free up space for new log files as they are
created. Otherwise, we will have to periodically do this as a manual process or
run the risk of running out of disk space and have UDB crash.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT





Tom Decabooter <[login to unmask email]> on 01/05/2000 03:07:31 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
the backups/logs managed by ADSM.

Tom Decabooter
Honda Europe N.V.


















[login to unmask email]

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to Danny Creed)
Tom,

The logs are reused in a "wrap-around" fashion, but only if you are doing
circular logging (logretain parameter = 0). When using circular logging,
forward recovery of the database is not possible.

We are using forward recovery logging (logretain parameter = 1) because we want
to have the ability to retain our log files indefinitely. In this case, when
all allocated logs are filled up, more log files are allocated. Previous
experience has shown us that the number of allocated log files can grow
excessively if not cleaned up periodically. That is why we are looking to
automate this process.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT





Tom Decabooter <[login to unmask email]> on 01/05/2000 11:43:37 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



I thought the log files were reused, a kind of 'wrap around' : if the last one
is full,
the first one is 'activated' again.
I am still setting up the archiving on our NT system, so i am not 100% sure.

Tom Decabooter
Honda Europe N.V.








[login to unmask email] on 05/01/2000 15:58:17

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tom Decabooter/HE/EU/HONDA)



Subject: Re: Automatic Deletion of Log Files in UDB v6.1









Tom,

Thanks for the info about this command. We were not aware of it, and it looks
like it will be very helpful.

But it does not really solve my original question: once log files have been
backed to ADSM, we would like to automatically delete them from the disk where
they currently reside in order to free up space for new log files as they are
created. Otherwise, we will have to periodically do this as a manual process or
run the risk of running out of disk space and have UDB crash.

Bill Gallagher, DBA
Phoenix Home Life
Enfield, CT





Tom Decabooter <[login to unmask email]> on 01/05/2000 03:07:31 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
Subject: Re: Automatic Deletion of Log Files in UDB v6.1



In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
the backups/logs managed by ADSM.

Tom Decabooter
Honda Europe N.V.


















Philip Nelson

Re: Automatic Deletion of Log Files in UDB v6.1
(in response to BILL_GALLAGHER@PHL.COM)
I wrote a REXX script to do this on our OS/2 DB2 servers and am rewriting it in Perl for AIX.

When its done I can share it with you.

Phil

On Wed, 5 Jan 2000 15:50:39 -0500, [login to unmask email] wrote:

>Tom,
>
>The logs are reused in a "wrap-around" fashion, but only if you are doing
>circular logging (logretain parameter = 0). When using circular logging,
>forward recovery of the database is not possible.
>
>We are using forward recovery logging (logretain parameter = 1) because we want
>to have the ability to retain our log files indefinitely. In this case, when
>all allocated logs are filled up, more log files are allocated. Previous
>experience has shown us that the number of allocated log files can grow
>excessively if not cleaned up periodically. That is why we are looking to
>automate this process.
>
>Bill Gallagher, DBA
>Phoenix Home Life
>Enfield, CT
>
>
>
>
>
>Tom Decabooter <[login to unmask email]> on 01/05/2000 11:43:37 AM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>
>To: [login to unmask email]
>cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
>bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
>Subject: Re: Automatic Deletion of Log Files in UDB v6.1
>
>
>
>I thought the log files were reused, a kind of 'wrap around' : if the last one
>is full,
>the first one is 'activated' again.
>I am still setting up the archiving on our NT system, so i am not 100% sure.
>
>Tom Decabooter
>Honda Europe N.V.
>
>
>
>
>
>
>
>
>[login to unmask email] on 05/01/2000 15:58:17
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>
>
>
>
>
>
>
> To: [login to unmask email]
>
> cc: (bcc: Tom Decabooter/HE/EU/HONDA)
>
>
>
> Subject: Re: Automatic Deletion of Log Files in UDB v6.1
>
>
>
>
>
>
>
>
>
>Tom,
>
>Thanks for the info about this command. We were not aware of it, and it looks
>like it will be very helpful.
>
>But it does not really solve my original question: once log files have been
>backed to ADSM, we would like to automatically delete them from the disk where
>they currently reside in order to free up space for new log files as they are
>created. Otherwise, we will have to periodically do this as a manual process or
>run the risk of running out of disk space and have UDB crash.
>
>Bill Gallagher, DBA
>Phoenix Home Life
>Enfield, CT
>
>
>
>
>
>Tom Decabooter <[login to unmask email]> on 01/05/2000 03:07:31 AM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>
>To: [login to unmask email]
>cc: (bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance)
>bcc: BILL GALLAGHER/Phoenix Home Life Mutual Insurance
>Subject: Re: Automatic Deletion of Log Files in UDB v6.1
>
>
>
>In UDB on WinNT there is a command DB2ADUTL that allows to list and delete
>the backups/logs managed by ADSM.
>
>Tom Decabooter
>Honda Europe N.V.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> reached at
[login to unmask email]
>

Philip Nelson
([login to unmask email])

Web pages -

http://www.pandp.saltire.org
http://gulfv.virtualave.net