What are simple, segmented and partitioned table spaces ?
Answer / 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 |
Explain the use of the WHERE clause.
what are the max. & min. no. of partitions allowed in a partition tablespace?
What's the difference between DB2 active log and archive log? Thanks a lot...
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How would one remove old reorg information from the DB2 catalog?
cobol-db2 runjcl please?
What is plan in cobol db2?
How do you retrieve the data from a nullable column?
i have a db2 variable how do u declare tht into working storage section ?
How does db2 sample database connect?
How do I start db2 in windows?
How do I delete a table in db2?