Define tablespaces with different size paging into DB2

[RobertoRigoli]

Hi,

I should create a new tablespaces with a page size to 32K, with e buffer pool dedicated with the same page size.
The temporary tablespaces page size is 4K, I have to modify the temporary tablespaces to the max page size defined into database (32K ) ?

Thanks for your help
Roberto.

[r035198x]

Hi,

I should create a new tablespaces with a page size to 32K, with e buffer pool dedicated with the same page size.
The temporary tablespaces page size is 4K, I have to modify the temporary tablespaces to the max page size defined into database (32K ) ?

Thanks for your help
Roberto.

Hi and welcome to TSDN. Hope you have a great time here. I've moved your question to the DB2 forum.
... and yes you can specify the tablespace size to be 32K. which version are you using and are you using control center for this?

[RobertoRigoli]

Hi and welcome to TSDN. Hope you have a great time here. I've moved your question to the DB2 forum.
... and yes you can specify the tablespace size to be 32K. which version are you using and are you using control center for this?

Hi,

Thanks for you help,
I'm working with DB2/UDB in Unix/Aix with this level :
DB21085I Instance "db2prd" uses "64" bits and DB2 code release "SQL08023" with
level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
"10".
Product is installed at "/usr/opt/db2_08_01".
Normally I use command line in kshell to create tablespaces or through Appication SAP, but I have also control center.

I have defined a DMS tablespaces with two kind of paging size: 4K and 16K and i have defined two SMS temporary tablespaces one for each paging size.

I think, if db2 use temporary tablespaces per page must exist temporary tablespaces with the same paging size, if not it not necessary.

Do you know how work DB2 witk temporary tablespaces.

[RobertoRigoli]

Hi,

Thanks for you help,
I'm working with DB2/UDB in Unix/Aix with this level :
DB21085I Instance "db2prd" uses "64" bits and DB2 code release "SQL08023" with
level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
"10".
Product is installed at "/usr/opt/db2_08_01".
Normally I use command line in kshell to create tablespaces or through Appication SAP, but I have also control center.

I have defined a DMS tablespaces with two kind of paging size: 4K and 16K and i have defined two SMS temporary tablespaces one for each paging size.

I think, if db2 use temporary tablespaces per page must exist temporary tablespaces with the same paging size, if not it is not necessary.

Do you know how work DB2 witk temporary tablespaces.

[r035198x]

Hi,

Thanks for you help,
I'm working with DB2/UDB in Unix/Aix with this level :
DB21085I Instance "db2prd" uses "64" bits and DB2 code release "SQL08023" with
level identifier "03040106".
Informational tokens are "DB2 v8.1.1.96", "s050811", "U803920", and FixPak
"10".
Product is installed at "/usr/opt/db2_08_01".
Normally I use command line in kshell to create tablespaces or through Appication SAP, but I have also control center.

I have defined a DMS tablespaces with two kind of paging size: 4K and 16K and i have defined two SMS temporary tablespaces one for each paging size.

I think, if db2 use temporary tablespaces per page must exist temporary tablespaces with the same paging size, if not it is not necessary.

Do you know how work DB2 witk temporary tablespaces.

I only know as much as that on v8 and below you have to create the tablespaces for pade sizes larger than 4K while v9 creates them dynamically for you. And as for temporary tablespaces I only know that DB2 uses those for joins and other complex queries to store data in temporary tables before computing the final result.