Canceling a query with the Query Governor

 

When a query is expected to take more resources than the set limit, the governor issues inquiry message CPA4259.

You can respond to the message in one of the following ways:

• Enter a C to cancel the query. Escape message CPF427F is issued to the SQL runtime code. SQL returns SQLCODE -666.

• Enter an I to ignore the exceeded limit and let the query run to completion.

 

Parent topic:

Set resource limits with the Predictive Query Governor