单项选择题
If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）
A.All sorts will be done in a temporary table space.
B.The shared sort memory allocation will be calculated by DB2
C.No shared memory is allocated for sorting.
D.All sorts will be done in shared memory.
相关考题
-
多项选择题
GivenaSHEAPTHRESvalueof2560,inwhichtwocaseswillaSHEAPTHRES_SHRvalueof1024bemeaningful?（）
A.INTRA_PARALLEL NO
B.MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
C.MAX_AGENTS 100, MAX_CONNECTIONS 2000
D.MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
E.INTRA_PARALLEL YES -
多项选择题
Inwhichtwoenvironmentswouldintra-partitionparallelismbeused?（）
A.Single database partition, single processor
B.Single database partition, multiple processors
C.Multiple database partitions, single processor
D.Multiple database partitions, multiple processors -
单项选择题
AdatabaseadministratorwouldliketoexaminerepartitioningoptionsforapartitioneddatabasenamedPRODDB.Aworkloadhasbeencapturedonthesystem(Windows)andisstoredinafilenamedWORKLOAD.SQL.WhatisthepropercommandtoruntheDesignAdvisorsothatitwillevaluatetheinformationstoredinthefileandgiveadviceonre-partitioning?（）
A.db2advis -d proddb -i workload.sql -P
B.db2advis -d proddb -i workload.sql -partitioning
C.db2advis -d proddb -i workload.sql -m P
D.db2advis -d proddb -i workload.sql -m ALL
