Online Access Free 000-614 Practice Test

A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?

• A.db2diag
• B.db2fmcu
• C.db2caem
• D.db2dart

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 STOGROUP med_sg DROP '/db2fs4'
• B.ALTER TABLESPACE ts1 REBALANCE
• C.ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
• D.ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE

If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

• A.Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.
• B.Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.
• C.Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.
• D.Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

Which statement about IBM WebSphere Information Integrator Q Replication is correct?

• A.It reads the DB2 recovery log and converts committed transactional data to SQL statements.
• B.It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.
• C.It reads the DB2 recovery log and stores committed transactional data in staging tables.
• D.It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.

Which operation can be performed by executing an ALTER STOGROUP statement?

• A.Change the name of an existing storage group.
• B.Make an existing storage group the default storage group.
• C.Reduce the current high water mark of all table spaces that have been assigned to a storage group.
• D.Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.