IBM P2090-018 IBM Information Management DB2 10 Technical Mastery Test v3 Exam Practice Test

This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.

The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.

This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.

STMM allows DBAs to inspect the current memory allocation by buffer pools.

In both DB2 pureScale and HADR environments data is available all the time.

DB2 pureScale transfers log files from a primary database to a standby database.

HADR persists data in the cluster caching facilities (CFs).

In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.

A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as

it is read from the physical media.

A table space is a DB2 component that manages access to databases.

A table space is a space reserved for catalog tables and base table data.

A table space is a logical storage grouping that can be composed of one or more containers.

Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

Table partitioning allows you to partition the table data based on the hash values of the primary key.

Compression allows you to reduce CPU workload because there is less data to process.

Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

Compression allows you to cache more data in the buffer pools using the same amount of space.

Compression allows you to store the same amount of data in less space, which can significantly save storage costs.