nerdexam
IBM

A2090-614 · Question #39

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…

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

How the community answered

(51 responses)
  • A
    80% (41)
  • B
    6% (3)
  • C
    2% (1)
  • D
    12% (6)

Community Discussion

No community discussion yet for this question.

Full A2090-614 Practice