Choose all the correct options

Question

if the opthints subsystem parameter is set to yes, and you issue the following db2 command relating to optimization parameter hints: bind query lookup (yes) what is the result of the execution of this command?

Accepted Answer

Updated values are placed in SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

Answer

A list of queries that are in error is produced.

Answer

New values are inserted into the SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN tables.

Answer

Messages containing only the status of rows in catalog tables SYSIBM.SYSQUERY and SYSIBM.SYSQUERYPLAN.

If the OPTHINTS subsystem parameter is set to YES, and you issue the following DB2 command relating to optimization parameter hints:

0 Discussions

Trending Exams