A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON
?db2fs1? ?db2fs2? ‘/db2fs3’ Then, a table space named TS1 was created in the storage group
and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a
DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had
been consumed. So, more space was added to the storage group by executing the following
command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD
?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower.
Which statement should be executed to correct the performance problem?
A.
ALTER TABLESPACE ts1 REBALANCE
B.
ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
C.
ALTER STOGROUP med_sg DROP ‘/db2fs4’
D.
ALTER TABLESPACE ts1 ADD ‘/db2fs4’ REBALANCE
Explanation: