RE: Question on Tempspace filling up.

RE: Question on Tempspace filling up.

 

  


I have extracted the SQL and run it from different clients (all Unix
Machines) running
different versions of the UDB client (from Version 7 fixpak 6 to Version 8
fix pak 5 )
they all behave the same way .




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









The client may possibly use a different NULLID.SQL*** package. I am sort of
puzzled as I have never seen it
act like that before.

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




"stephen"
<db2udbdba-ezmlms
hield-x92066271.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
08/31/2004 03:37
PM Subject
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







---------------------------------------------------------------------
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