I believe you are correct.  We are in the process of migrating (August 1) to
an Intel based platform.  I got a call yesterday that the "cleanup" they do
prior to migration failed because of the "messiness" you are talking about
so I think they are going to clean it up. Hopefully.
Tks for your help
Gary

-----Original Message-----
From: Johnson, Tracy [mailto:[log in to unmask]] 
Sent: Thursday, May 03, 2007 6:58 AM
To: Gary Sielaff
Subject: RE: [HP3000-L] log files

Then I can only think of database messiness on some of your Image
Masters.

I assume you are using Image databases.

A poorly hashed Image key can ruin your whole day, especially Integer
keys.  

Image uses an algorithm to populate new data as it comes in.  In a
perfect database entries fall into the Primary Path, however when data
is hashed to the same place they fall into Secondary locations degrading
efficiency of the database.  

There could be too many delete chain head entries.  Datasets should be
unloaded and reloaded to fix it.

A dataset could be getting full.

Sometimes ensuring an Image Master is on one disc while an Image Detail
is on another disc can improve things.

Some tools to fix this problem:

1)  Adager, the oldest and most widely used.  Written and run by one of
the guys that wrote Image.

2)  DBGeneral, similar but menu driven.  Also more expensive.  Password
protected at run time.

3)  DBUNLOAD and DBLOAD.  Comes with the operating system, ancient and
manual.  Needs a tape drive to work.

3a)  DICTDBU old free utility that works with #3.  Hard to find but lets
you unload to disc instead of tape.

Tracy Johnson
Measurement Specialties, Inc. 

BT







NNNN


> -----Original Message-----
> From: Gary Sielaff [mailto:[log in to unmask]] 
> Sent: Wednesday, May 02, 2007 6:28 PM
> To: Johnson, Tracy
> Subject: RE: [HP3000-L] log files
> 
> 
> Okay Tracy, did that and nothing over 48%.
> Doesn't seem to be slow right now.  ??  
> Its one report that one of the accountants ran that took 1 
> 1/2 hours and normally should have taken 2 minutes.
> 
> Gary
> 
> -----Original Message-----
> From: HP-3000 Systems Discussion 
> [mailto:[log in to unmask]] On Behalf Of Johnson, Tracy
> Sent: Wednesday, May 02, 2007 12:15 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] log files
> 
> Oh, there are many reasons for a slowdown.
> 
> Two Quick items to check:
> 
> RUN DISCFREE with the C option to see if any discs are getting full.
> 
> Nearly full or mangled Image databases could also be the 
> issue.  You should have a 3rd party tool for that, presuming 
> it is an old system and your predecessors bought one.
> 
> 
> Tracy Johnson
> Measurement Specialties, Inc. 
> 
> BT
> 
> 
> 
> 
> 
> 
> 
> NNNN 
> 
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> 
> 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *