View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
I want to create 3 types of Tablespaces,
1. Simple Tablespace
2. Segmented Tablespace
3. Partitioned Tablepspace
I know the difference between each of them theoretically. But while creating them in practical, i don't know what are parameters needed to be given, What differentiates them from each other.
Can you provide me examples for each type.
That would be very Helpful.
Thank You Very Much, |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You might talk with your dba for guidance on how this would be done on your system or you mioght use the "IBM Manuals" link above, find the material for the version of db2 your system uses, and look up the specifics there.
If you have problems with the manuals, post what you found that is not clear and your question about it and someone here will be able to offer suggestions. |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
SIMPLE TABLE SPACE
CREATE TABLESPACE TBSNAME
IN DBNAME
USING STOGROUP STGNAME PRIQTY 10 SECQTY 10 TRACKMOD NO
BUFFERPOOL BPNAME
LOCKSIZE PAGE/ROW
CLOSE YES
COMPRESS NO ;
SEGMENTED table space
CREATE TABLESPACE TBSNAME
IN DBNAME
USING STOGROUP STGNAME PRIQTY 10 SECQTY 10 TRACKMOD NO
BUFFERPOOL BPNAME
SEGSIZE 4-64
LOCKSIZE PAGE/ROW
CLOSE YES
COMPRESS NO ;
Partioned table space
CREATE TABLESPACE TBSNAME
IN DBNAME
NUMPARTS 1
(PART1 USING
STOGROUP STGNAME PRIQTY 10 SECQTY 10 TRACKMOD NO
)
BUFFERPOOL BPNAME
LOCKSIZE PAGE/ROW
CLOSE YES
COMPRESS NO ; |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Thank You. |
|
Back to top |
|
|
|