DB2 10 for z/OS Database Administrator — Question 25

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

Answer options

• A. As the db2 instance owner (db2inst1) execute the command: export DB2_FMP_COMM_HEAPSZ=256000
• B. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000
• C. As the db2 instance owner (db2inst1) execute the command: db2set i DB2_FMP_COMM_HEAPSZ=256000
• D. As the db2 instance owner (db2inst1) execute the command:

Correct answer: C

Explanation

The correct answer is C because the command 'db2set' is specifically designed to set registry variables for a DB2 instance. Option A will not affect the DB2 instance as it only sets an environment variable, while option B modifies the user profile without applying it to the instance. Option D is incomplete and does not provide a valid command.