IBM
A2090-614 · Question #16
If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP…
The correct answer is A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option. See the full explanation below for the reasoning.
Question
If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?
Options
- AIssue an ALTER TABLESPACE statement with the 'USING sg_med' option.
- BIssue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
- CPerform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
- DUse the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.
How the community answered
(47 responses)- A77% (36)
- B4% (2)
- C13% (6)
- D6% (3)
Community Discussion
No community discussion yet for this question.