单项选择题
Which registry variable should be set to keep the buffer pools in memory on AIX and Linux?（）
A.DB2_KEEP_BP
B.DB2_PINNED_BP
C.DB2MEMDISCLAIM
D.DB2MEMMAXFREE
点击查看答案
相关考题
-
单项选择题
Whatwouldindicateintra-partitionparallelisminanOptimizerPlan?（）
A.BTQ
B.LTQ
C.IP
D.DTQ -
单项选择题
TableTAB1wascreatedusingthefollowingstatement:CREATETABLEtab1(c1INT,c2INT,c3INT,c4INT,c5INT);IfcolumnC1isuniqueandqueriestypicallyaccesscolumnsC1andC2together,whichstatement(s)willcreateindex(es)thatwillprovideoptimalqueryperformance?（）
A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) include (c2)
B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c3) INCLUDE (c2)
C. CREATE UNIQUE INDEX xtab1 ON tab1 (c2, c1)
D. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1） -
单项选择题
Whenistheconnectionconcentratorenabled?（）
A.When the value of MAX_CONNECTIONS is greater than the value of MAX_COORDAGENTS.
B.When the value of MAX_AGENTS is greater than the value of MAX_CLIENTS.
C.When the value of NUM_AGENTS is greater than the value of MAX_AGENTS.
D.When the value of NUM_CONNECTIONS is greater than the value of NUM_COORDAGENTS.
