A.DB2_KEEP_BP B.DB2_PINNED_BP C.DB2MEMDISCLAIM D.DB2MEMMAXFREE
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.
A.PARTITION BY HASH and ORGANIZE BY B.PARTITION BY RANGE and ORGANIZE BY KEY SEQUENCE C.PARTITION BY HASH and ORGANIZE BY KEY SEQUENCE D.PARTITION BY RANGE and ORGANIZE BY
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.
A. IBM System p5 570 B. IBM System p5 575 C. IBM System p5 590 D. IBM System p5 595
