单项选择题
A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?()
A.Code the application to issue a LOCK TABLE statement.
B.Code the application to issue a LOCK ROW statement.
C.Decrease the number of I/O servers.
D.Increase the locklist parameter.
相关考题
-
单项选择题
IfthesortheapthresholdparameterSHEAPTHRES_SHRissettoavalueof0,whatwillhappen?()
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
