RE: Question on Tempspace filling up.

RE: Question on Tempspace filling up.

 

  


Question is why should the access path change when run from the Client ?
This is a vendor application which generates a huge sql which I captured .
Changing that code is not a straight forward issue .



"Lekharaju Ennam "
<db2udbdba-ezmlmshield-x6643797.[Email address protected] To:
om> "LazyDBA Discussion"
<[Email address protected]
cc:
Tuesday August 31, 2004 03:22 PM Subject: RE: Question on Tempspace
filling up.






sql statement has any sort activity , like distinct , group by or orader by
clause


run explain on it , check access path.


based on it take good option.


--Lekharaju Ennam
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x32051980.[Email address protected]
Sent: Tuesday, August 31, 2004 12:15 PM
To: LazyDBA Discussion
Subject: Re: Question on Tempspace filling up.






Find out what node you are connecting to from the client as opposed to what
node you log on to on the AIX machine.

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"stephen"
<db2udbdba-ezmlms
hield-x5218845.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
08/31/2004 12:08
PM Subject
Question on Tempspace filling up.










UDB Gurus,


I' m having this strange situation where I'm running a query on the
database server it takes
about 10 mins and hardly uses any temp space . When we run this same query
from a client
machine, It takes about 1hour 30 mins and chews up all the temp space (
Currently it's 6GB of temp )
the size of the database is about 2.5 GB and It's UDB EEE version 8 fix
pak 5 with 5 partions runing on AIX .
Any ideas on any registry values or config parameters to change ?




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






DB2 & UDB email list listserv db2-l LazyDBA home page