DB2 10.1 Advanced DBA for Linux UNIX and Windows

108 Questions

You can start the exam to practice all questions related to this exam.

Question No. 1

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? 

Choose the correct option from the given list.
01 / 108

0 Discussions

Trending Exams