Using set process_limit_action

The process_limit_action option to the set command lets you monitor the use of adjusted query plans at a session or stored procedure level. When you set process_limit_action to “abort,” Adaptive Server records Error 11015 and aborts the query, if an adjusted query plan is required. When you set process_limit_action to “warning,” Adaptive Server records Error 11014 but still executes the query.

For example, this command aborts the batch when a query is adjusted at runtime:

set process_limit_action abort

By examining the occurrences of Errors 11014 and 11015 in the error log, you can determine the degree to which Adaptive Server uses adjusted query plans instead of optimized query plans. To remove the restriction and allow runtime adjustments, use:

set process_limit_action quiet

See set in the Adaptive Server Reference Manual for more information about process_limit_action.