mike_dba wrote:
Can anyone tell me why a EEE system might be created to have two
separate tablespaces with the same 4k pagesize ? They both appear to
be in use as I can see the underlying files being modified.
Yes, that's entirely possible.
These were created with SMS and reside on the same disk and filesystem
(separate directory on filesystem). One is called temp_4k and the
other temp_sys. I would assume that the temp_sys was intended for use
by the db2 catalog. I know of no way to tell db2 to use a specific
tablespace - like use temp_sys for catalog and temp_4k for operations
like sort,etc.
The catalog tablespace can be defined at CREATE DATABASE time. See the
CREATE DATABASE command for more details:
http://tinyurl.com/zwac4
Other tablespaces are created with the CREATE TABLESPACE statement
(
http://tinyurl.com/edsh4) and you have to define which tables go to a
particular tablespace using the CREATE TABLE statement
(
http://tinyurl.com/csp4u). That leaves the temporary tablespaces. If I
remember correctly, then it is recommended to have just a single system or
user temporary tablespace for each page size.
You can use the LIST TABLESPACES command to determine the type of the two
tablespaces.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany