Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named
SAMPLE to AUTOMATIC?
Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named
SAMPLE to AUTOMATIC?
To dynamically change the LOCKLIST database configuration parameter for a database, you must ensure that the database is connected or the instance is attached. The correct command syntax for this operation is 'UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC'. Since no database connections exist as per the question, attaching to the instance (db2inst1) and then updating the database configuration parameter would be the appropriate approach. Therefore, the best choice is to attach to the instance and then run the update command.
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.