One of the IBM's product has a create command for database with 8K info and table space with 32 k.

Is both suppose to have 32 K ?

or is it ok?

which is best way ?

It would help if you give more information. What DB2 product? What OS? The statement you are using. etc.


Andy

Thanks For quick response.
IBM Process Server is product ( it has multiple databases ( some are 32 K some are 8K)) on AIX 6.1 DB2 9.5 FP4

CREATE DATABASE XXXX AUTOMATIC STORAGE YES ON /data01 USING CODESET UTF-8 TERRITORY US PAGESIZE 8 K

CREATE LARGE TABLESPACE XXXX PAGESIZE 32 K MANAGED BY DATABASE USING (FILE '/data01/XXXXX/OBSRTS' 512M)
AUTORESIZE YES
EXTENTSIZE 32
PREFETCHSIZE AUTOMATIC
INCREASESIZE 512 M
MAXSIZE NONE
BUFFERPOOL BP32k ;

The 8K on the database create statement is for the system info and default size. The pagesize on the create tablespace is for that tablespace only. There is no problem doing this.

Andy

Thank you so much.

I would like to all 32k. is it recommended ?

If you don't create a 8K tablespace, then your tables may go to USERSPACE1 which is created by DB2 when database is created.

db2 list tablespaces show detail

Except Temp syscatalog,

I have three table spaces

USERSPACE1, DATA_TS, IDX_TS

All two of them are 32k (DATA_TS, IDX_TS) USERSPACE1 is 8K.



I would like to have database size is also 32k and along with it all three table spaces are 32k ( 2 of the already 32 K)

CREATE DATABASE XXXX AUTOMATIC STORAGE YES ON /data01 USING CODESET UTF-8 TERRITORY US PAGESIZE 32 K
???