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

How would you find out the total number of rows in a db2 table?

574


Explain what are the various isolation levels possible?

606


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2685


How can record locking be achieved in those DB2 versions which do not support it?

621


What language is db2 written in?

593






If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1574


How can deadlocks be resolved?

538


What db2 400?

673


What is cursor stability in db2?

805


What are the full forms of spufi and dclgen and why are they used?

654


How to test SQL -911 error while developing COB-DB2 program

6706


Can one database have multiple instances?

579


Is db2 a mainframe database?

563


What is cursor with hold option in db2?

608


How do you select a row using indexes in db2?

641