Want to pass your IBM Information Management DB2 10.5 pureScale Technical Mastery Test v3 P2090-054 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Consider a scenario where your DB2 pureScale cluster caching facilities are in PEER state. What would be the state of the secondary cluster caching facility upon failure of the primary cluster caching facility and a successful takeover?
A. ERROR
B. PEER
C. PRIMARY
D. NEW_PRIMARY
Consider the scenario where a server "pscale1" hosts a DB2 member and one cluster caching facility. In a situation where a database administrator wants to perform an operating system update on "pscale1", which one of the following options will ensure that both the member and cluster caching facility won't be automatically restarted by DB2 cluster services while the system is upgraded?
A. Log in to any of the hosts as a root user. Stop the member and cluster caching facility. Remove the member and cluster caching facility from the cluster.
B. Log in to any of the hosts as root user. Bring the member on "pscale1" to quiesce mode. Bring the member on "pscale1" to maintenance mode. Bring cluster caching facility on "pscale1" to maintenance mode.
C. Log in to "pscale1" as a DB2 instance user. Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility. Stop the instance on "pscale1". Log in as DB2 cluster services administrator. Bring "pscale1" host to maintenance mode.
D. Log in as a cluster services administrator. Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility. Bring the member on "pscale1" to maintenance mode. Bring cluster caching facility on "pscale1" to maintenance mode.
How does automatic storage work in DB2?
A. Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.
B. Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.
C. Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.
D. Automatic storage allows automatic allocation of free space in memory for optimizing query execution.