You might want to cancel a query while it is running. For example, you might realize that your query will take too long to run. While a query is running, a database status panel like the one in Figure 52 shows you the relative "cost" for your query in terms of computer resources.
DATABASE STATUS PANEL Your request is currently being processed by the Database Manager. The relative cost estimate for your request is: 1
Canceling a query using the QMF command interrupt
To cancel a query using the QMF Command Interrupt:
See your QMF administrator if you need help finding this key on your terminal.
The following message displays:
DSQ50465 QMF command interrupted! Clear screen and press ENTER.
The QMF Command Interrupt panel displays, as shown in Figure 53.
DSQ50547 QMF command interrupted! Do one of the following: ==> To continue QMF command, type CONT ==> To cancel QMF command, type CANCEL ==> To enter QMF debug, type DEBUG
QMF cancels the query.
Canceling a query by using the QMF governor prompt panel
Your installation might have a governor interrupt routine that automatically attempts to cancel a query that takes a long time to run or tries to retrieve too many rows. If a QMF Governor Prompt panel similar to the one in Figure 54 displays while you are trying to run a query, follow the instructions on the panel to cancel the query or continue.
If you continue, the QMF governor can still cancel your command.
DSQnnnnn QMF governor prompt: Command has executed for xxxxxxxxx minutes and fetched yyyyyyyy rows of data. ==> To continue QMF command press the "ENTER" key. ==> To cancel QMF command type "CANCEL" and then press the ENTER key. ==> To turn off prompting type "NONPROMPT" then press the ENTER key.