This parameter is relevant where DB2 Query Patroller is installed. If the database configuration parameter dyn_query_mgmt is set to "ENABLE" and the cost of the dynamic query exceeds the trap_threshold for the user or group (as specified in the DB2 Query Patroller user profile table), then this query will be caught by DB2 Query Patroller. The trap_threshold is a cost-based trigger for query catching established in DB2 Query Patroller by the user. When a dynamic query is caught, a dialog will be presented for the user to specify runtime parameters.
If dyn_query_mgmt is set to "DISABLE", then no queries will be caught.