IBM C2090-612 Exam Questions & Answers

DB2 does not take system checkpoints in which circumstance?

A. During an application rollback.

B. At the end of a successful restart.

C. When switching from one active log data set to another.

D. When a specified number of log records are created or after a specified number of minutes, whichever occurs first.

Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?

A. Does not apply to threads that were defined with RELEASE(COMMIT).

B. Does not apply to threads that were defined with RELEASE(DEALLOCATE).

C. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next COMMIT point.

D. Applies to RELEASE(COMMIT) at the next COMMIT point and to RELEASE(DEALLOCATE) at thread end.

The performance of BP5 is being evaluated. The Page residency time is being used to see if VPSIZE should be changed. The statistics that are available are VPSIZE of 90,000 and VPSEQT of 15 %. There are 4458 synch I/O per second and 1696 async I/O per second. 6154 total pages read. The system page residency time is 14.6 seconds. Based on a system page residency time of 14.6 seconds, what should be done to increase page residency time?

A. Increase DWQT to 10.

B. Decrease VPSIZE by 45,000 pages.

C. Increase VPSIZE to 180,000 pages.

D. Change the buffer pool to use PGFIX(YES).