Name the different types of Table spaces.

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

What is the difference between cursor and select statement?

615


Why db2 is called db2?

593


i want to maintain uniqueness on pdf without make lf??????????

1635


How to check sequence on a table in db2?

600


List out the buffer pools in db2

632






In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

644


How to resolve deadlock issue

17978


Define predicate?

643


What is copy pending status in db2?

636


what is the responsibility of the construction superintendent

1664


What is null value in db2?

567


What does a deadlock mean in DB2?

653


What is node in db2?

608


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6854


Explain the contents that are a part of dclgen.

659