Confirmation panels

If there is a CONFIRM parameter on a command, you can specify YES or NO (or use the default in your profile). If the command would modify the database and the CONFIRM parameter is YES, a confirmation panel like the following is displayed:

                       RUN CONFIRMATION
 
WARNING:
Your RUN command will modify this number of rows in the
database:         1
 
Do you want to make this change?
1 1. YES - Make the changes permanent in the database.
  2. NO  - Restore the table to what it was before the query
     was run; make no changes.

Many QMF confirmation panels for changes to the database are actually prompting you to do a commit (by entering YES to keep the changes) or a rollback (by entering NO).

Because the changes were already made to the database, the database manager holds locks on the data until you reply YES or NO on the confirmation panel.

If you are using DB2 for VM or VSE, the tables you are working with might be in a nonrecoverable dbspace. If so, any changes you make are committed to the database immediately, and you cannot execute a rollback. Therefore, if a table is in a nonrecoverable dbspace, specifying NO on the confirmation panel really doesn't prevent the changes from taking place.

For more information on dbspace, contact your database administrator or see DB2 Server for VM System Administration.