IBM
A2090-614 · Question #39
A2090-614 Question #39: Real Exam Question with Answer & Explanation
The correct answer is A. ALTER TABLESPACE ts1 REBALANCE. See the full explanation below for the reasoning.
Question
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?
Options
- AALTER TABLESPACE ts1 REBALANCE
- BALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
- CALTER STOGROUP med_sg DROP '/db2fs4'
- DALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE
Community Discussion
No community discussion yet for this question.