Free IBM 000-612 Exam Dumps Questions & Answers

What WLM action will establish performance objectives for DDF threadsand their related address space?

• A.  Execute the WLM_REFRESH stored procedure for the DDF application environment.
• B.  Createa WLM service definition that assigns service classes to the DDF threads.
• C.  Insure the NUMTCB is set to a value greater than 10.
• D.  Specify DDF for the value of APPLENV to the name of the WLM environment.

Which clone table statement iscorrect?

• A.  The clone and base tables must have different schema names.
• B.  A clone table has its own catalog statistics.
• C.  A clone table can have its own indexes.
• D.  The clone and base tables share a table space.

DB2 workfiles are critical to performance of applications. Which of the following will NOT assist withachieving best performance for workfile usage?

• A.  Assign workfiles to their own DASD volumes.
• B.  Assign workfiles to their own bufferpools.
• C.  Create one large workfile for the data sharing group.
• D.  Create several 4K and 32K workfiles.

A unique index (IX1) currently exists on COL1, COL2 and COL3 of the table. There is a request to be able to have an index on these three columns and COL4 to achieve the optimal access path. The addition of COL4 will not support the uniqueness requirement of the index. In order to add this column to the index while still preserving the unique constraint of the first three columns, which option should be taken?

• A.  Add a new index on COL4.
• B.  Perform an ALTER INDEX IX1 ADD INCLUDE COLUMN (COL4).
• C.  Add a new UNIQUE index on COL1, COL2, COL3, COL4.
• D.  Perform a ALTER INDEX IX1 ADD COLUMN (COL4).

What START TRACE command provides detailed lock suspend and lock contention trace information?

• A.  START TRACE(STATS) CLASS(1)
• B.  START TRACE(ACCTG) CLASS(1,2,3) DEST(SMF)
• C.  START TRACE(PERFM) CLASS(30) IFCID(44,45)
• D.  START TRACE(AUDIT)