Hi All,
We work with db2v8.2.2 and aix5.2

after tuning sql statement in declare cursor the FETCH part of program became slower than before and I found out this time db2 does not use temporary table space for result table and result table is derived during the excution of FETCH statement.

how can I force db2 to use temporary tablespace?

Thank you in advance for your help.

You could try to add an ORDER BY clause which is not supported by an index. But I don't know if it would run faster.

Thank you Marcus