RE: Strange DASD Utilization Issue

Stop people from querying your database on non keyed fields.  Temporary
access path, temporary copies of partial data are the two biggest uses
of temporary space.  You will see a max and a current temporary space in
wrksyssts.  How much DASD do you have?  Large % jumps generally happen
on low space machines.  If you have something like 4x17GB drives raid 5,
that is around 50 GB usable and 5% is only 2.5GB.  Where as a larger
DASD pool such as our 637 GB usable, 5% = 31.8 GB not so easy for temp
storage to use. 


Christopher Bipes
Information Services Director
CrossCheck, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DebbieKelemen
Sent: Monday, February 27, 2006 2:58 PM
To: 'Midrange Systems Technical Discussion'
Subject: Strange DASD Utilization Issue

I need some help trying to figure out a DASD utilization issue that is
plaguing me.

After an IPL, my system is at a nice 38.64% utilization.  Within a day
it
has grown to 42.98%.  I can guarantee within a few weeks I will be up to
50
or more percent and I will need to IPL to get my DASD down for the mid
60%
within a 6 week period or so.

When I run a GO DISKTASK, it shows that Temporary space is 5% of my
system.
That is what my system grew by.  How do I keep my temporary space under
control?