By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,018 Members | 901 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,018 IT Pros & Developers. It's quick & easy.

Define tablespaces with different size paging into DB2

P: 3
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.
Jun 20 '07 #1
Share this Question
Share on Google+
4 Replies


10K+
P: 13,264
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?
Jun 20 '07 #2

P: 3
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.
Jun 21 '07 #3

P: 3
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.
Jun 21 '07 #4

10K+
P: 13,264
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.
Jun 21 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.