Web site to hold user-developed tools?, was Automatic Deletion of Log Files in UDB v6.1

Lynne Flatley

Web site to hold user-developed tools?, was Automatic Deletion of Log Files in UDB v6.1
Many months ago, while we were still using American University as the host
of the listserv, some folks had talked about a member of the listserv
building and maintaining their own Web site where we could store members'
REXX, Perl, etc. tools. I would like to volunteer again to do this if no
one has any objections. I've cc'd the owners of this list to confirm that
they don't have a problem with this.

Thanks!

> -----Original Message-----
> From: Philip Nelson [SMTP:[login to unmask email]
> Sent: Thursday, January 06, 2000 6:14 AM
> To: [login to unmask email]
> Subject: Re: Automatic Deletion of Log Files in UDB v6.1
>
> 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.
> >
> >
> >
> the
> >
> >
> >
> >
> >
> the
> >
> >
> >
> >
> >
> the
> >
> >
> >
> >
> >
>
> be reached at
> [login to unmask email]
> >
>
> Philip Nelson
> ([login to unmask email])
>
> Web pages -
>
> http://www.pandp.saltire.org
> http://gulfv.virtualave.net
>
>
>
>
>



David Seibert

Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB
(in response to Lynne Flatley)
Hello Lynne,
I think that's an excellent idea.

Think of the trouble this would have saved Herr Dr. Ebert and others who've
recently had to distribute things like this manually. And think of the
bandwidth it would save on this list from individuals who don't heed the
suggestion to write the distributor individually rather than post their
interest back for the entire list to read.

I hope it happens this time around.
Thanks for offering again.

David Seibert
Compuware Corporation File-AID product planner
[login to unmask email]



Hilton Tina

Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB
(in response to David Seibert)
I thought it had been decided that CBT (http://www.cbttape.org/) was the
best place to submit these to, since they're already set up for it. Or was
that only one of the suggestions?

-----Original Message-----
From: Lynne Flatley [mailto:[login to unmask email]
Sent: Thursday, January 06, 2000 6:45 AM
To: [login to unmask email]
Subject: Web site to hold user-developed tools?, was Automatic Deletion
of Log Files in UDB v6.1


Many months ago, while we were still using American University as the host
of the listserv, some folks had talked about a member of the listserv
building and maintaining their own Web site where we could store members'
REXX, Perl, etc. tools. I would like to volunteer again to do this if no
one has any objections. I've cc'd the owners of this list to confirm that
they don't have a problem with this.

Thanks!

> -----Original Message-----
> From: Philip Nelson [SMTP:[login to unmask email]
> Sent: Thursday, January 06, 2000 6:14 AM
> To: [login to unmask email]
> Subject: Re: Automatic Deletion of Log Files in UDB v6.1
>
> 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.
> >
> >
> >
> the
> >
> >
> >
> >
> >
> the
> >
> >
> >
> >
> >
> the
> >
> >
> >
> >
> >
>
> be reached at
> [login to unmask email]
> >
>
> Philip Nelson
> ([login to unmask email])
>
> Web pages -
>
> http://www.pandp.saltire.org
> http://gulfv.virtualave.net
>
>
>
>
>








Lynne Flatley

Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB
(in response to Hilton Tina)
They offered but nothing seemed to have happened. Once again, if I see no
objections, I will have a site up and available by Tuesday, January 11th.

> -----Original Message-----
> From: Hilton Tina [SMTP:[login to unmask email]
> Sent: Thursday, January 06, 2000 7:50 AM
> To: [login to unmask email]
> Subject: Re: Web site to hold user-developed tools?, was Automatic
> Deletio n of Log Files in UDB v6.1
>
> I thought it had been decided that CBT (http://www.cbttape.org/) was the
> best place to submit these to, since they're already set up for it. Or
> was
> that only one of the suggestions?
>
> -----Original Message-----
> From: Lynne Flatley [mailto:[login to unmask email]
> Sent: Thursday, January 06, 2000 6:45 AM
> To: [login to unmask email]
> Subject: Web site to hold user-developed tools?, was Automatic Deletion
> of Log Files in UDB v6.1
>
>
> Many months ago, while we were still using American University as the host
> of the listserv, some folks had talked about a member of the listserv
> building and maintaining their own Web site where we could store members'
> REXX, Perl, etc. tools. I would like to volunteer again to do this if no
> one has any objections. I've cc'd the owners of this list to confirm that
> they don't have a problem with this.
>
> Thanks!
>
> > -----Original Message-----
> > From: Philip Nelson [SMTP:[login to unmask email]
> > Sent: Thursday, January 06, 2000 6:14 AM
> > To: [login to unmask email]
> > Subject: Re: Automatic Deletion of Log Files in UDB v6.1
> >
> > 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.
> > >
> > >
> > >
> visit
> > the
> > >DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> > >
> > >
> > >
> > >
> visit
> > the
> > >DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> > >
> > >
> > >
> > >
> visit
> > the
> > >DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list can
> be
> > >
> > >
> > >
> > >
> visit
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> > be reached at
> > [login to unmask email]
> > >
> >
> > Philip Nelson
> > ([login to unmask email])
> >
> > Web pages -
> >
> > http://www.pandp.saltire.org
> > http://gulfv.virtualave.net
> >
> >
> >
> > the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the list
> can
> >
>
>
>
> the
>
>
>
>
>
>
>



Jim Harrison

Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB
(in response to Lynne Flatley)
I don't recall the discussions about this, but I think a DB2 specific site
might be better suited to this purpose. I always thought the CBT was for
all purpose/platform type files and I think we could easily flood it with
DB2 specific utilities. I say go with it!

At 10:55 AM 1/6/00 -0500, you wrote:
>They offered but nothing seemed to have happened. Once again, if I see no
>objections, I will have a site up and available by Tuesday, January 11th.
>
>> -----Original Message-----
>> From: Hilton Tina [SMTP:[login to unmask email]
>> Sent: Thursday, January 06, 2000 7:50 AM
>> To: [login to unmask email]
>> Subject: Re: Web site to hold user-developed tools?, was Automatic
>> Deletio n of Log Files in UDB v6.1
>>
>> I thought it had been decided that CBT (http://www.cbttape.org/) was the
>> best place to submit these to, since they're already set up for it. Or
>> was
>> that only one of the suggestions?