Exam C2090-600 topic 1 question 1 discussion

The correct answer is C. A:SQL5146W error occurd

The correct answer is C. Because DB CFG not have "LOOCKLIST"

Error in my previous answer, I do not read the key word " will dynamically change " in the question. Then you need a connection to change dynamically the parameter. Otherwise, you have the following warning : DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully. SQL1363W One or more of the parameters submitted for immediate modification were not changed dynamically. For these configuration parameters, the database must be shutdown and reactivated before the configuration parameter changes become effective.

Reference : https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001987.html Required connection : Instance. An explicit attachment is not required, but a database connection is recommended when the database is active. If the database is listed as remote, an instance attachment to the remote node is established for the duration of the command. To change a parameter online, you must be connected to the database. Here, the question says "no database connections exist".

The correct answer is A. If you want change a database configuration parameter, you do not need to connect to database, only the instance Db2 have to start before changing the database configuration parameter.