A. HADR persists data in the cluster caching facilities (CFs).
B. In both DB2 pureScale and HADR environments data is available all the time.
C. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.
D. DB2 pureScale transfers log files from a primary database to a standby database.
A. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the secondary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.
B. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, the primary cluster caching facility monitors the memory configuration and propagates any configuration changes to all members.
C. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will remain off until the member is activated. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON
D. When Self-Tuning Memory Manager is enabled in a DB2 pureScale environment, if the member on which the memory manager is running deactivates, the memory manager will automatically start up on another member that is currently able to run the memory manager. In order for a member to run the memory manager, the database must be active on that member and that member must have SELF_TUNING_MEM set to ON.
A. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.
B. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
C. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.
D. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBACprotected column.
A. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.
B. Verification is completed by the DBA using the database verification toolkit.
C. Verification is automatically performed by the AUTO_CONFIGURE feature.
D. Verification is performed by running the VERIFY INSTALL command.
A. This component is used to coordinate locking through a global lock manager to prevent conflicting access to the same table data by different members.
B. This component is used to balance the workload through a global workload resource pool.
C. This component provides a global buffer pool.
D. This component is used to keep page caching consistent across all members through a shared group buffer pool.
A. A single setup image is required for installing both members and cluster caching facilities. A single invocation of the Setup Wizard from the installation-initiating host installs all of the components of the DB2 pureScale feature across all hosts that you specify as part of the DB2 pureScale environment.
B. Different setup images are required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.
C. A single setup image is required for installing both members and cluster caching facilities. The DB2 pureScale Setup Wizard must be invoked on each host to install all of the components of the DB2 pureScale feature.
D. Different setup images are required for for installing both members and cluster caching facilities. An invocation of the Setup Wizard is required to install all of the DB2 Members of the DB2 pureScale feature. Another invocation of the Setup Wizard is required to install all of the Cluster Caching Facilities.
A. Connections must be directed to the shared storage.
B. Connections can be directed to any of the members in the system.
C. Connections must be directed to the primary cluster caching facility in the system.
D. Connections must be directed to all members in the system, so that all members stay in sync.
