IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need 2 create 3 types of tablespace, help me in parameters


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Tue Sep 09, 2008 12:00 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Sep 09, 2008 12:13 pm
Reply with quote

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
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Tue Sep 09, 2008 12:21 pm
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Tue Sep 09, 2008 1:26 pm
Reply with quote

Thank You.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to create a list of SAR jobs with... CA Products 3
No new posts force tablespace using LISTDEF input DB2 1
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts create rexx edit Macro that edits the... CLIST & REXX 3
No new posts COBOL - create and write to output fi... COBOL Programming 0
Search our Forums:

Back to Top