多项选择题
Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful?（）
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 -
单项选择题
Adatabaseadministratorwantstodesignamulti-partitiondatabasethatcantakeadvantageofbothintra-partitionparallelismandinter-partitionparallelism.Whichconfigurationwillallowtheuseofthesetypesofparallelismwhileusingtheleastnumberofhardwarecomponents(servers,processors)?（）
A.one server having at least two processors
B.two servers having one processor and one logical database partition
C.one server having four processors and two logical database partitions
D.two servers each having four processors and two logical database partitions
