The DB2 system environment

Which profile registry stores environment variable settings for a workstation?

Choose an option.

DB2 Global Level Profile Registry This was the correct option
DB2 Instance Level Profile Registry This was not the correct option
DB2 Instance Node Level Profile Registry This was not the correct option




Suppose you want to check the contents of the DBM configuration file, enable the AUTORESTART parameter of the CLIENTS database, and then display the instances available on a system. Which commands do you use to do configure the DB2 environment in this way?

Choose more than one option.

DASLIST This was not a correct option

DB2SET -L This was a correct option

GET DBM CFG This was a correct option

UPDATE DB CFG USING CLIENTS AUTORESTART ON This was a correct option

Which command do you use to check which registry variables a system supports?

Choose an option.

DB2SET - ALL This was not the correct option
DB2SET -LR This was the correct option
DB2SET - U This was not the correct option
DB2SET - UR This was not the correct option



Which command resets the profile registry for the DB2 instance?

Choose an option.

DB2SET -G This was not the correct option
DB2SET -H This was not the correct option
DB2SET -I This was not the correct option
DB2SET - R This was the correct option





Suppose you want to disable sequential detection for a database called SALES. The change must take effect instantly. Which command do you run from the Command Center to do this?

Choose an option.

UPDATE DB CFG FOR SALES USING SEQDETECT NO DEFERRED This was not the correct option
UPDATE DB CFG FOR SALES USING SEQDETECT NO IMMEDIATE This was the correct option

UPDATE DBM CFG FOR SALES USING SEQDETECT NO This was not the correct option
UPDATE DBM CFG FOR SALES USING SEQDETECT NO IMMEDIATE This was not the correct option