Hi,

I'm having one sql query. If I'm running on the server it comes with expected rows. But the same query if I'm running remotely on the same db, it fills temp file systems. Can any one have any idea?

My environment is,

OS : AIX

db2level:
DB21085I Instance "db2d013" uses DB2 code release "SQL07024" with level
identifier "03050105" and informational tokens "DB2 v7.1.0.60", "s020313" and
"U481406".

If more details required pls let me know

With Regards

Bala

Check the online APAR database to see if this is a known problem and if yes, when it was fixed. You may have to apply that fixpak

HTH

Sathyaram