Exam C2090-600 All QuestionsBrowse all questions from this exam
Question 32

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?

    Correct Answer: C

    On Linux and Unix systems, the command to set registry variables for a specific DB2 instance involves using the db2set command with the -i flag, which specifies the target instance. The correct command to set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages) for the instance db2inst1 is db2set -i db2inst1 DB2_FMP_COMM_HEAPSZ=256000. The given options indicate that db2set i DB2_FMP_COMM_HEAPSZ=256000 is the closest to the correct syntax, although it misses the hyphen before the 'i'. This makes

Discussion
db2testerOption: D

The correct answer is D. "db2set -i db2inst1 DB2_FMP_COMM_HEAPSZ=256000" The command "db2set -i DB2_FMP_COMM_HEAPSZ=256000" returns the following error : DBI1306N The instance profile is not defined. Explanation: The instance is not defined in the target machine registry. User response: Specify an existing instance name or create the required instance.