IBM P2090-054 - IBM Information Management DB2 10 pureScale Technical Mastery Test v3 Exam
Page: 3 / 14
Total 69 questions
Question #11 (Topic: )
Which of the following statements is INCORRECT regarding backup operations in a DB2
pureScale environment?
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.
Answer: C
Question #12 (Topic: )
Which of the following statements is FALSE when monitoring the high usage of lock
memory in a DB2 pureScale environment?
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.
Answer: A
Question #13 (Topic: )
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?
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.
Answer: D
Question #14 (Topic: )
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?
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
Answer: D
Question #15 (Topic: )
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.
Answer: A
