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?
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:
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.
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
db2tester
5 years ago