Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What are the default tablespaces available

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Wed Aug 13, 2003 8:11 am    Post subject: What are the default tablespaces available
Reply with quote

Hello,

When creating the database, What are the default tablespaces available ready to use....
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Wed Aug 13, 2003 10:04 am    Post subject:
Reply with quote

Hello Priya,

From your question, I was not able to figure out what you wanted to ask?

1) What types of Tablespaces available?
to gte the information about this, ,look at the following link.

http://vsbabu.org/oracle/sect03.html

2) How much table space is allocated available to user?
This is decided by the admin user. Depends on the site's configuration

Let me know in case any more help you require.

Regards

Mayuresh
Back to top
View user's profile Send private message
mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Thu Aug 14, 2003 12:51 pm    Post subject:
Reply with quote

Hello Priya,

The question may be like this:

Q) What are the different types of tablespaces available?

Ans:
-----
1) Simple Tablespace
2) Segmented Tablespace
3) Partitioned Tablespace

For the detail explanation...refer to any DB2 manual.

Hope this helps.

Regards

Mayuresh
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1202
Location: India

PostPosted: Fri Aug 15, 2003 2:37 pm    Post subject: Hai PRIYA
Reply with quote

While creating a database, the system will create SYSCATSPACE, TEMPSPACE1 & USERSPACE1.
Back to top
View user's profile Send private message
deepak.venkataraman

New User


Joined: 07 Sep 2005
Posts: 8
Location: Bangalore

PostPosted: Wed Sep 07, 2005 12:19 pm    Post subject: DEFAULT TABLESPACE
Reply with quote

HI PRIYA,

SIMPLE TABLESPACE IS AVAILABLE BY DEFAULT WHILE CREATING A DATABASE
Back to top
View user's profile Send private message
mallik-ibm
Currently Banned

New User


Joined: 28 Jul 2006
Posts: 7

PostPosted: Thu Mar 08, 2007 11:03 pm    Post subject:
Reply with quote

hi all
default table spaces are
catalog table space
temp table space
and
user table space
these r the table spaces available by default

thanks

mallik
Back to top
View user's profile Send private message
vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Fri Mar 09, 2007 3:39 pm    Post subject:
Reply with quote

Yes, When you create a DB2 Database by default there would be 3 tablespaces created for you.

1. System table space, where catalog table reside
2. User table space wher user data could be stored.
3. Temporary Table space which will be used by system to resolve your query. ex. ORDER BY, etc. It sorts the data in that region and will give you the result.

If you are preparing for 700/730 exam, then i would suggest you to go thru ROGER .E . Sanders. I had this question in 700 exam. Hope this helps you.
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Thu Apr 05, 2007 11:06 am    Post subject:
Reply with quote

Hi all ,


Previous answer is applicable for DB2 LUW only. But in case of DB2 for Z/OS, when you create database, no default tablespaces are created. Only entry will be put it over on catalog tables that new database has been created.

If you are not mention the table space name in create table statement, it will create one table space with name same as table name with type of Simple Table space.

Code:
CREATE TABLE SAMPLE_TAB (COL1 INT NOT NULL,
COL2 CHAR (5)) IN DATABASE SAMPLEDB;


Correct me if I am wrong

Thanks and Regards
Senthil
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts force windows ftp client user to defa... meykh2014 All Other Mainframe Topics 0 Sun Feb 14, 2016 12:57 pm
No new posts change z/os default 1047 ccsid tp 1097 meykh2014 All Other Mainframe Topics 4 Sat Sep 05, 2015 5:21 pm
No new posts Question: REORG on LOB tablespaces rakesh1155 DB2 1 Fri Aug 14, 2015 2:14 pm
No new posts Initializing filler default value whe... dsivapradeep COBOL Programming 6 Thu Feb 13, 2014 11:17 am
No new posts Overriding the default Code page rikdeb PL/I & Assembler 2 Fri Aug 09, 2013 12:12 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us