What are simple, segmented and partitioned table spaces ?
- 1 Answers
- 12735 Views
- TCS, I also Faced
- E-Mail Answers
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 are db2 objects?
What is view db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How is the value function used?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the advantage in De-normalizing tables in DB2?
How to fetch the last row from the table in SQL (db2)?
What is the max length of sqlca?
What is cursor stability in db2?
Explain what are the various isolation levels possible?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a db2 cursor?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What language is db2 written in?
What is cursor with hold option in db2?
