IBM P2090-054 - IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Exam

Page:    1 / 14   
Total 69 questions

Consider the scenario of a DB2 pureScale environment with two DB2 members, and assume there is an active connection to "member 3". Due to some maintenance emergency, "member 3" needs to be stopped. Which one of the following commands will stop "member 3"?

  • A. db2stop force member 3
  • B. db2stop immediate member 3
  • C. db2stop node 3 all members
  • D. db2stop member 3


Answer : A

In a DB2 pureScale environment, which of the following statements is NOT a characteristic of the cluster caching facility?

  • A. This component is used to balance the workload through a global workload resource pool.
  • B. This component is used to coordinate locking through a global lock manager to prevent conflicting access to the same table data by different members.
  • C. This component is used to keep page caching consistent across all members through a shared group buffer pool.
  • D. This component provides a global buffer pool.


Answer : A

Which of the following options describes correct cluster caching facility states when both primary and secondary cluster caching facilities are in sync?

  • A. primary: PRIMARY secondary: SECONDARY
  • B. primary: SYNC secondary: SYNC
  • C. primary: PRIMARY secondary: PEER
  • D. primary: PEER secondary: CATCHUP


Answer : C

How does DB2 pureScale handle member(s) failover scenarios?

  • A. All data remains locked until the failover operation is completed.
  • B. Future connections are evenly distributed among the surviving members of the cluster.
  • C. Current connections to the failed member will be on hold until the member recovers and is back online.
  • D. DB2 pureScale requires database administrator intervention to handle failover scenarios.


Answer : B

Consider the scenario that a technical expert accidentally trips over the power cord of a
DB2 pureScale cluster node, bringing the node offline. Assume the cluster contains a
SECONDARY cluster caching facility and other DB2 members. What will be the outcome of this situation if the node was hosting both the PRIMARY cluster caching facility and a DB2 member?

  • A. The secondary cluster caching facility will become the primary. All client transactions sent to be processed by the offline server will be re-routed to the remaining members within the cluster.
  • B. DB2 pureScale cannot host both the cluster caching facility and a member on a single host.
  • C. The cluster will put all transactions on hold until the server is back online.
  • D. The secondary cluster caching facility will be in SYNC state. All client connections will be terminated and will need to re-issued by the client.


Answer : A

Page:    1 / 14   
Total 69 questions