Search results for query: *

Have you possibly tried executing RUNSTATS without the WITH DISTRIBUTION clause? Perhaps the data distribution is affecting the optimizer. We have experienced unexpected results in the past when including and/or excluding the clause. Good luck,

Greg: Additional tweaking of the SORTHEAP/SHEAPTHRES parameters appears to have addressed the problem. Thanks for your input, AO

Greg: No sir, no ORDER BY or GROUP BY clause. AO

Greg: The select is part of a cursor . . . the process is executing a proprietary product (SQR) that creates dynamic SQL based on it's coding language. The basic syntax of the SQL statement that is being prepared/executed is not too complex and looks something like this: SELECT A.FLDA ...

Environment: DB2-UDB for AIX version 7.2.4 Have a process that encounters SQL0955C errors on occasion when executing a SELECT from an empty table while nothing much else is going on in the database instance. The table in question has NEVER been populated with data. The table resides in a...

Jeff: If you have access to pside, 8.4 still supports the old File/Print from PS Query from the Windows development side. I haven't seen the same ability from the web side. AO atoi@compuserve.com