Which tool should be used to give you lock wait information from the DB2 memory sets?
Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?
A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO What is the recommended way to convert the database MYDB to an automatic storage database?
What is the MAX_LOG database configuration parameter used for?
Which statement about insert time clustering tables (ITC) is true?
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command can be used to recover the database and repair the corruption in table space TBSP_1?
