多项选择题
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-partitionparallelismbe...
多项选择题In which two environments would intra-partition parallelism be used? ()
A.Single database partition, single processor B.Single database partition, multiple processors C.Multiple database partitions, single processor D.Multiple database partitions, multiple processors
Adatabaseadministratorwouldliketoexaminerepartitioningo...
单项选择题A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-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-partitiondata...
单项选择题A database administrator wants to design a multi-partition database that can take advantage of both intra-partition parallelism and inter-partition parallelism. Which configuration will allow the use of these types of parallelism while using the least number of hardware components (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