Consider the scenario where a database administrator (DBA) would like to apply operating system updates on the host machine that contains one of the DB2 pureScale members. The primary cluster caching facility and other members are located on different physical machines. Which of the following tasks should be performed by the DBA on the host machine before applying the operating system updates, so that the member will not be restarted?
A. Place the member into maintenance mode.
B. Place the host machine into maintenance mode.
C. Place the member into quiesce mode.
D. Place the cluster caching facility in standby mode.
Consider a scenario where a database administrator (DBA) requires an overview of the pureScale cluster database. After issuing a "db2instance -list" command, the DBA notices that one of the members is in WAITING_FOR_FAILBACK state. What does WAITING_FOR_FAILBACK mean in a pureScale environment?
A. The member is waiting for a connection to be established with a failed Cluster Caching Facility.
B. The member is waiting to failback to its home host.
C. The member is waiting to failback to a remote host.
D. The member is waiting to failback to the failed Cluster Caching Facility .
A database administrator executed a db2iupdt command in order to drop a cluster caching facility from a DB2 pureScale cluster. Which command can be used to verify that the cluster caching facility is no longer part of the cluster?
A. db2instance -display -cluster -modifications
B. db2instance -list -cfs -details
C. db2instance -all -cfs
D. db2instance -list
What is the purpose of the tiebreaker disk in a DB2 pureScale environment?
A. Tiebreaker is used to determine which half of the DB2 pureScale instance should remain online upon a communication failure.
B. Tiebreaker is used to determine which clients are accessing the data on the storage.
C. Tiebreaker is used to determine which databases are currently active and can be accessed by the clients directly in graphical user interface (GUI).
D. Tiebreaker is used by DB2 to transfer data when packets collide.
Which of the following options justifies why you should be actively monitoring buffer pool hit ratios on your DB2 pureScale environment?
A. Attaining high local buffer pool (LBP) and global buffer pool (GBP) hit ratios are in general an indication of overall good performance as more pages are found in memory than having to fetch from I/O.
B. Attaining low local buffer pool (LBP) and global buffer pool (GBP) hit ratios are in general an indication of overall good performance as more pages are found in memory than having to fetch from I/O.
C. High local buffer pool (LBP) hit ratios are the only important metric that must be monitored since it indicates that there are a higher number of pages fetched from physical storage than from the local buffer pool.
D. Low local buffer pool (LBP) hit ratios are the only important metric that must be monitored since it indicates that there are a higher number pages fetched directly from physical storage than from the local buffer pool.
Consider the scenario where two members, "M1" and "M2", intend to update two different rows on the same data page: 1."M1" is doing an update on row R1 within a data page. It is granted exclusive access to the page containing that row of data. 2."M2" requires an exclusive lock to the same page to update row R2. It passes this request to the cluster caching facility. "M2" waits while the request is processed. 3.The cluster caching facility sees that member "M1" already has an exclusive access to the page. It issues a request to "M1" for the page. In the meantime, "M2" waits. 4."M1" processes the request by writing the page back to the global buffer pool and then releasing the page lock. ("M1" retains any row or table locks it might have had). 5.The cluster caching facility grants "M2" access to the page. "M2" reads the page from the global buffer pool to perform whatever operations for which the page is needed. Which of the following DB2 pureScale monitoring elements can be used to monitor the above scenario?
A. Lock escalation.
B. Lock contention.
C. Log Retain.
D. Page reclaiming.
Which of the following is NOT a reason for a database administrator to place a DB2 pureScale node into maintenance mode?
A. To update the DB2 Cluster Services software.
B. To be able to perform software and hardware updates on both cluster caching facilities (primary and secondary) at the same time.
C. When moving a server to a different location and requiring to disconnect it from the cluster.
D. To ensure that the system does not reboot when installing new software on the system.
A DB2 pureScale environment has fourteen DB2 members and one cluster caching facility. Having each of the members and cluster caching facility hosted on a separate physical machine, what is the recommended number of redundant cluster caching facilities necessary so that the DB2 pureScale environment could be available if the primary cluster caching facility fails?
A. 0
B. 1
C. 2
D. 3
Which of the following statements is INCORRECT regarding backup operations in a DB2 pureScale environment?
A. Only one backup image is produced for the entire cluster.
B. Issuing a single backup/restore database command on any member initiates a backup or restore operation on behalf of all members.
C. Database metadata and transaction logs from the members are not included in the backup image.
D. A backup operation can be performed even if one member is inconsistent.
Which of the following statements is FALSE when monitoring the high usage of lock memory in a DB2 pureScale environment?
A. Performance will not be affected due to high usage of Lock Memory.
B. Data concurrency issues can arise due to a high number of lock escalations.
C. Lock escalations can take place if there is insufficient memory.
D. Request for locks might be denied.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-054 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.