RE: Strange DASD Utilization Issue

I guess I should have set the stage better with giving more background on
our system.  We just purchased it last year.  

We have an i5 model 520. With 351.6 g of usable DASD and 4g of memory.  We
only have about 100 users (if that).  We do have a website directly
accessing us 24X7.  So I can't take the machine down too often.  I have 12
disk drives currently & will be adding 4 more in a few weeks (when I can
schedule the down time).  

We do have some power users.  And the web developer does have some SQL
queries that I need to review because he is doing queries over the database
on the physical files or in ways that would be faster if we made new
logicals for him to use.  I never realized that that would eat up temp
space.

Deb


 

-----Original Message-----
From: midrange-l-bounces+debbiekelemen=hotmail.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+debbiekelemen=hotmail.com@xxxxxxxxxxxx] On Behalf
Of Chris Bipes
Sent: Monday, February 27, 2006 4:17 PM
To: Midrange Systems Technical Discussion
Subject: 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?