What are two supported methods for providing a low latency, high speed interconnect between DB2 members and th
What are two supported methods for providing a low latency, high speed interconnect between
DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose
two.)
which two operating systems can DB2 pureScale run?
On which two operating systems can DB2 pureScale run? (Choose two.)
Which statement about data type mappings is true in a federated system?
Which statement about data type mappings is true in a federated system?
Which statement about IBM WebSphere Information Integrator Q Replication is correct?
Which statement about IBM WebSphere Information Integrator Q Replication is correct?
Which table configuration CANNOT utilize multi-temperature storage?
Which table configuration CANNOT utilize multi-temperature storage?
What is the preferred method for reclaiming unused storage in a DMS table space?
What is the preferred method for reclaiming unused storage in a DMS table space?
What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?
If the following statements are executed: CREATE STOGROUP sg_hot ON ‘/path1’, ‘/path2’,
‘/path3’; CREATE STOGROUP sg_med ON ‘/path4’, ‘/path5’, ‘/path6’; CREATE TABLESPACE
tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1
from storage group SG_HOT to storage group SG_MED?
When will a default storage group be defined for this database?
A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1.
When will a default storage group be defined for this database?
Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?
The following statement was used to create a table space named USER_TMP in a non-partitioned
database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM
USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP
table space with an ALTER TABLESPACE statement?
What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?
A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have
been assigned to this group. What kind of table spaces must the DBA assign to the storage group
before the desired tables can be created?