IBM C2090-311 dumps - 100% Pass Guarantee!

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

workloads?

A. db2setDB2_WORKLOAD=ANALYTICS

B. db2set DB2_WLM_DISP_CONCUR=START

C. UPDATE DBM CFG USING WLM_DISPATCHER YES

D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL

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

A. To install and configure DB2 Advanced Copy Services.

B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.

C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.

D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.

An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE.

If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:

RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY

Which command will create a statistics profile on the EMPLOYEE table?

A. RUNSTATS ON TABLE employee USE PROFILE

B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1

C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL

D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE

When does space reclamation for a column-organized table normally occur?

A. Whenever an individual row is deleted.

B. Whenever an individual row is updated.

C. After all rows in an extent have been updated.

D. After all rows in an extent where updates took place have been deleted.

What type of table can be converted into a column-organized table with the db2convert command?

A. A range partitioned table

B. A materialized query table

C. A row-organized user table

D. A declared global temporary table