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 ?



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