I am very new to DB2.have installed Express C version and facing some problem while running a simple query.
SELECT A,B,C,D,E,F,G, H FROM TABLE_NAME where A=9999 ORDER BY D
H are the only columns in the table.
When I do this, I get this exception:
DB2 SQL error: SQLCODE: -1585, SQLSTATE: 54048, SQLERRMC: null Message: A temporary table could not be created because there is no available system temporary table space that has a compatible page size.
More exceptions ...
DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-1585;54048;
This is just a simple query with
order by clause. Why am I getting this error?