Which table configuration CANNOT utilize multi-temperature storage?
What is the preferred method for reclaiming unused storage in a DMS table space?
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?
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?
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/fsystem5Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
