IBM
A2090-614 · Question #52
You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
The correct answer is D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified. See the full explanation below for the reasoning.
Question
You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
Options
- ASet the dynamic instance registry variable UTIL_IMPACT_LIM to 0.
- BSet the dynamic instance registry variable UTIL_IMPACT_LIM to 100.
- CIssue a LIST UTILITIES statement with the 'SUSPEND <utility ID>' option specified.
- DIssue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.
How the community answered
(46 responses)- A4% (2)
- B9% (4)
- C15% (7)
- D72% (33)
Community Discussion
No community discussion yet for this question.