IBM
C2090-312 · Question #28
When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?
The correct answer is D. DB2 places the table space in AREOR (Advisory Reorg). See the full explanation below for the reasoning.
Question
When a table space defined as both partitioned-by-growth (PBG) and MEMBER CLUSTER YES is altered to MEMBER CLUSTER NO by the ALTER TABLESPACE command. Which statement is correct?
Options
- ADB2 does not allow the command.
- BDB2 applies the changes immediately.
- CDB2 allows the command only if the table is empty.
- DDB2 places the table space in AREOR (Advisory Reorg).
How the community answered
(41 responses)- A5% (2)
- B10% (4)
- C2% (1)
- D83% (34)
Community Discussion
No community discussion yet for this question.