IBM

C2090-619 · Question #73

Which option maximizes performance in an Informix Warehouse (DSS) environment?

The correct answer is D. SHMTOTAL set to 0 to allow Informix to access all available physical memory. See the full explanation below for the reasoning.

Question

Which option maximizes performance in an Informix Warehouse (DSS) environment?

Options

AHigher value of LOGBUFF.
BHigher value of PHYSBUFF.
CHigher value of BUFFERPOOL and lower value of DS_TOTAL_MEMORY.
DSHMTOTAL set to 0 to allow Informix to access all available physical memory.

How the community answered

(55 responses)

A
4% (2)
B
7% (4)
C
15% (8)
D
75% (41)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-619 Practice