Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Name the different types of Table spaces.

Question Posted / siva

Answer Posted / siva

A table space is a logical storage structure used to control where the data for a database physically is stored. Generally in db2 there are 3 types they are:
Catalog tablespace
User tablespace
Temporary tablespace
these are the default tablespaces

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When reorg is used?

1070

Explain package in db2 and its advantages?

1134

How to execute stored procedures?

1062

What is the reason behind not using select * in embedded sql programs?

1044

How to get the ddl of a table in db2?

1072

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

Explain what are the various isolation levels possible?

988

What is the difference between cursor and select statement?

1052

How can you do the explain of a dynamic sql statement?

1013

Explain the benefits you can get from mainframe connect?

910

What is the use of dclgen in db2?

1011

What is ibm db2 database?

951

How can you classify the locks in db2?

1032

How can you find out the # of rows updated after an update statement?

1050

What are the uses of db2 optimizer?

1223