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 db2fs4ALTER STOGROUP med_sg ADD db2fs4Shortly afterwards, queries against tables in the TS1 table space began to run slower.Which statement should be executed to correct the performance problem?
A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?
Which statement about compression dictionaries is FALSE?
Which would not significantly benefit from having the RUNSTATS command run on it?
Which tool provides the simplest method for monitoring buffer pool hit ratios?
Which is NOT a valid method for prefetching data?
