A. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
B. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
C. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
D. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.
A. Temporal tables are used to model data in the past, present, and future.
B. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.
C. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.
D. Temporal tables are complex to maintain and require major application changes.
A. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
B. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
C. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
D. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
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.
