Solutions

• Question 1:
  The correct answer is (2). Option (3) displays all of the supported registry variables. Option (4) is a Db2 copy validation command, and option (1) is invalid.
• Question 2:
  The correct answers are (2) and (4). Option (3) needs an instance attachment before running the SHOW DETAIL clause of the GET DBM CFG command. Option (5) is a global registry display command. Option (1) is invalid.
• Question 3:
  The correct answer is (3). Options (1), (2), and (4) are monitoring table functions, and will be discussed in the monitoring chapter.
• Question 4:
  The correct answers are (1) and (5). The parameter database_memory specifies the amount of shared memory that is reserved for the database shared memory region. When you set this parameter to AUTOMATIC, the initial memory requirement is calculated based on the underlying configuration settings:
  • Buffer pools: This specifies...