What are simple, segmented and partitioned table spaces ?
Answer Posted / s
Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.
Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.
Partitioned tablespace, only one table can be defined and
rows are spread across partitions.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What does runstats do in db2?
What is a db2 table?
What is host variable?
Mention data types used in db2 ?
What is the meaning concurrency in the db2 database?
How do you stop a db2 database in linux?
What is the difference between bind and rebind in db2?
What is the physical storage length of timestamp data type?
What happens in bind step in a db2 program?
What os does db2 run on?
What is iseries database?
How to find schema of a table in db2?
How to get the ddl of a table in db2?
How do I delete a table in db2?
What is dbrm in db2 database?