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

John Clark

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

A months ago I wrote a REXX to interogate package token id's and received
several requests for the code. I eventually put the code on our web site
www.connection42.co.za under our IEFSHARE section. Unfortunatly as we do not
as yet have an FTP site this means a bit of cutting and pasting.

Wewill eventully have an FTP site (the web site itself is new), but we if
there is a general site as you suggest Lynn, we are ahppy to put anything
pertinent there also. Given that of course, it would be nice to be ble to
put a link to our own web site.

On that subject, I do not know if the original nessage I received from the
DB2 or Datacom lists, but someone wantd to know about Datacom/DB to DB2
conversions. To help I have written a DSF COBOL program to generate DB2 DDL
and load cards from the Datacom/DB datadictionary table definition. It is
fairly simple and assumes n original ly normalizedtale, but does work nicely
and I will put this on IEFSHARE by 16/01/2000.

Regards


John Clark - Connection 42 South Africa

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Lynne Flatley
Sent: 06 January 2000 17:15
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
>
>
>
>
>








Adam Flinton

Re: Web site to hold user-developed tools?, was Automatic Deletio n of Log Files in UDB
(in response to John Clark)
On Thu, 6 Jan 2000 07:41:47 -0500, Seibert, Dave wrote:

>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.

I second that. I've got a bunch of Rexx scripts which may be of use.....

Adam