Chat with us

Read online free dumps for IBM- C2090-311

Here you can read online questions and answers for IBM Exam C2090-311 (IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam ) 100% free...

Question ID 20857

If the DB2_WORKLOAD registry variable has not been set which database manager
configuration parameter must be modified, before a query that accesses a column-
organized table can be executed?

Option A

 INTRA_PARALLEL

Option B

QUERY_HEAP_SZ

Option C

MAXIMUM DEGREE

Option D

SHEAPTHRES SHR

 

Correct Answer A
Description
Update Date and Time 2018-03-02 06:25:14

Question ID 20858

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

Option A

db2setDB2_WORKLOAD=ANALYTICS

Option B

db2set DB2_WLM_DISP_CONCUR=START

Option C

UPDATE DBM CFG USING WLM_DISPATCHER YES

Option D

UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL

Correct Answer C
Description
Update Date and Time 2018-03-02 06:28:19