HP3000-L Archives

January 2001, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Larry Barnes <[log in to unmask]>
Reply To:
Larry Barnes <[log in to unmask]>
Date:
Thu, 4 Jan 2001 20:03:46 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (86 lines)
I believe they are only free to those who have paid the higher subcription
dues.  If I wrong please advise ... nicely.

Art Bahrs wrote:

> Hi Tom :)
>    Ok... so a bit of a <PLUG> for the Interex CSL... are the free utils in
> there? if so what are the names so I can give 'em a try too :)
>
> Art "Free is a very good Price! (tm Tom Peterson) Portland Icon hehe" Bahrs
>
> ----- Original Message -----
> From: "Tom Renz" <[log in to unmask]>
> To: <[log in to unmask]>
> Sent: Friday, January 05, 2001 7:06 AM
> Subject: Re: [HP3000-L] Transact database program getting slower
>
> > Chris,
> >
> > We have a no cost (f r e e) utility that will map any master data set
> > showing a graph of the Primaries and Secodaries and the percentages of
> > each within each percent of the set's capacity.  We will be happy to
> > send you a copy to see what your distribution and where your peaks are
> > within the data set(s) in question.  Let us know.
> >
> > Also we have a couple of other no cost utilities that set vars with the
> current version of TurboIMAGE and if desired each db intrinsic.
> > Basically the same list as listed in QUERY but setting variables.  And
> > the second no cost utility lists all data sets within a data set
> > and almost all the info you would like to see for each data set
> > (name, set number, MPE file name, Extent names if jumbo, the number of
> > sectors used, the record length, media length, the data sets tied via
> > Image Keys, average chain lengths, and more).  Let us know if you are
> > also interested in any of these other no cost (f r e e) utilities.
> >
> > <Plug>
> >
> > Now for the plug.  We also have a tool that can measure each db call
> > made and provide statistics on the calls to provide you information
> > such as longest call in CPU & wall time.  This could answer how long
> > it takes for each DBPUT to complete as well as any other db call.
> > Let us know if you would be interested in a demo.
> >
> > </Plug>
> >
> > Tom Renz
> >
> > ---------------------
> > On Wed, 3 Jan 2001 at 05:46:49 you wrote:
> > >Hello everyone
> > >
> > >Thanks for the replies.
> > >
> > >My master set is 3 million records in a capacity of 6 million.  The
> > >set is therefore only 50 percent full.
> > >
> > >The key item (SYGEKSNR) X10 is a 10 digit number built as follows
> > >DDMMYYNNNN.  The whole thing satisfies some modulo 11 arithmetic.  It
> > >could be possible that I am getting secondaries.  How can I check ?
> > >Are there tools available for checking ?
> > >
> > >I am splitting my program into updating and adding and will perform
> > >some timing tests.  I really don't know where the bottleneck is.
> > >
> > >The updates to the database are received every 15 minutes.  How safe
> > >would output deferred mode be in this case ?
> > >
> > >I am using entry level locking to update existing records.
> > >
> > >We have 37 machines with varying memory configurations and Operating
> > >system versions, but the majority are 6.0 or higher.
> > >
> > >Thanks again for the help
> > >
> > >Chris

--
Larry Barnes
Director of I.T.
Mitek Corp.
602-438-4545 x1366
Phoenix, AZ 85040

Check Us Out !
http://www.mitekcorp.com

ATOM RSS1 RSS2