Hello there,

I have an issue, that a big select statement causes the followong
error:"SQL1585N  Es ist kein temporärer Systemtabellenbereich mit
einer ausreichenden Seitengröße vorhanden"
So I created one using:

CREATE  SYSTEM TEMPORARY  TABLESPACE SMOTBSMSST32 PAGESIZE 32 K
MANAGED BY SYSTEM
  USING ('D:\DB2\NODE0000\SQL00001\SMOTBSMSST32' )
  EXTENTSIZE 16
  OVERHEAD 12.67
  PREFETCHSIZE AUTOMATIC
  TRANSFERRATE 0.18
  BUFFERPOOL  SMOBP32 ;

The used Bufferpool was created with "CREATE BUFFERPOOL "SMOBP32"  SIZE
100 PAGESIZE 32 K NOT EXTENDED STORAGE;"

So I think I have done all necessary work to get my big SQL Statement
working. The result set contains about 140 columns, containing some
columns of a table which itself needs to have a tablspace with 32k
pagesize. So, if I ever want to use this tabel in a select, I have to
look, that a record in the result set is not bigger than 32k. Am I
right?
Im using "DB2 v8.1.7.445", "s040812", "WR21342" und FixPak "7"
Oracle doesn't have any problems on the same big SQL Statement.

Can I define a temporary tabelspace bigger tha 32k pagesize? I don't
want to change the SQL statement, because it is dynamically generated
inside an EJB application using an intellibo library.

Thanx for your help

Matthias
Stuttgart, Germany