when I execute a query using the right function in the order by clause as below, select * from table order by right(col1,10) I am getting the following error.
SQL1585N A system temporary table space with sufficient page size does not exist.
The database has a temporary tablespace with 4KB as the page size. In the DB2 manuals to fix this prob it says remove the columns from the temporary table. Could any one tell what is to be done exactly to fix this.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!