What are the default tablespaces available

priya · Posted: Wed Aug 13, 2003 8:11 am

Hello,

When creating the database, What are the default tablespaces available ready to use....

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

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

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 237 Location: USA

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

mcmillan · Site Admin Joined: 18 May 2003 Posts: 1210 Location: India

While creating a database, the system will create SYSCATSPACE, TEMPSPACE1 & USERSPACE1.

deepak.venkataraman · New User Joined: 07 Sep 2005 Posts: 8 Location: Bangalore

HI PRIYA,

SIMPLE TABLESPACE IS AVAILABLE BY DEFAULT WHILE CREATING A DATABASE

mallik-ibm · New User Joined: 28 Jul 2006 Posts: 7

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

vini_srcna · Posted: Fri Mar 09, 2007 3:39 pm

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.

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

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.