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 db2 mean?
What is precompiler in db2?
what is a corelated subquerry?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are the rules for db2 programming?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is meant by explain?
How do I connect my db2 database to ibm?
What language is db2 written in?
How many types of page locks can be held in db2?
What are iseries servers?
What is the difference between nvl and coalesce?
Explain various types of locks in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well