IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

1.

Which command, when executed, will enable workload management for column-organized table workloads?

db2setDB2_WORKLOAD=ANALYTICS db2set DB2_WLM_DISP_CONCUR=START UPDATE DBM CFG USING WLM_DISPATCHER YES UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL

2.

If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?

-1 1 ON ANY

3.

By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

15 percent 20 percent 25 percent 30 percent

4.

What formula can be used to determine the average number of column-organized pages found in each read request?

POOL_COL_READS/
POOL COL READ REQS POOL_COL_P_READS/POOL COL P READ REQS POOL_ASYNC_COL_READS/POOL ASYNC COL READ REQS POOL ASYNC COL P READS/POOL ASYNC COL P READ REQS

5.

Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?

db2pd Routines EXPLAIN tables Snapshot monitor ACTIVITIES event monitors

6.

Which type of compression is typically used with column-organized tables?

BLU compression Value compression Actionable compression Adaptive row compression

7.

Which statement about column-organized tables is true?

Databases with column-organized tables can be federated. Schemas that include column-organized tables can be transported. Sort memory can be automatically tuned in environments containing column-organized tables. Queries that use the Currently Committed semantics can be used with column-organized tables.

8.

What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?

The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed. The number of times a temporary error occurred while trying to queue a column-organized prefetchrequest for a regular table space. The number of times DB2 had to retrieve a page from disk for a temporary column-organized tablebecause the page no longer resided in the buffer pool. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.

9.

Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?

db2iupdt-a db2iupdt-update db2iupdt-commit_level db2iupdt-online_update

10.

What is a DB2 Advanced Copy Services (ACS) script used for?

To install and configure DB2 Advanced Copy Services. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup orrestore operation. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACSAPI vendor library.

IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner