A table space is a logical storage structure used to control where the data

Name the different types of Table spaces.

Question Posted / siva

5 Answers
15601 Views
IBM, I also Faced
E-Mail Answers

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 nvl and coalesce?

1110

What is the result of open cursor statement?

1129

What is page size in db2?

1027

How does cobol compile db2 program?

1130

What do you mean by commit and rollback?

1090

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

1237

Is ibm db2 open source?

1132

What is the picture clause of null indicator variable?

1183

What is difference between rollback and commit?

1206

How do I connect my db2 database to ibm?

1087

What are catalog tables in db2?

1109

Explain the function of data manager.

1098

What is a db2 cursor?

1111

What is null in db2?

1071

Are view updateable?

1093