单项选择题

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

What would indicate intra-partition parallelism in an Optimizer Plan?（）

A.BTQ
B.LTQ
C.IP
D.DTQ

单项选择题

Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1 and C2 together, which statement(s) will create index(es) that will provide optimal query performance? （）

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）

单项选择题

When is the connection concentrator enabled?（）

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.