db2=>create user temporary tablespace pdb_temp_space_name
pagesize same_pagesize_as_pdb managed by automatic storage bufferpool
pdb_buffer_name
where
pdb_temp_space_name is the tablespace name,
same_pagesize_as_pdb is the page size at the primary
database, and
pdb_buffer_name is the buffer name.
Note: You can determine what the DB2 UDB page size is with the LIST
TABLESPACES SHOW DETAIL command.
For example, to create
a temporary tablespace named deep13 with a 16KB page size and buffer pool named
tom_servo,
enter:
create user temporary tablespace deep13 pagesize 16K managed
by automatic storage bufferpool tom_servo