Step 7--Run the batch-mode IVP (optional): DSQ2EBAT

If you plan to run QMF procedures in batch mode, run this IVP to ensure that QMF for batch mode processing has been successfully installed. The same files and DB2 for VM authorization used in QMF interactive mode are also required to run QMF procedures in batch mode.

The Installation Verification Procedure (IVP) tests the following batch-mode operations:

1. Reaching and initializing QMF
2. The existence of QMF control tables
3. The operation of the QMF database modules and issuing the SAVE DATA command
4. The operation of the QMF PRINT, EXPORT, IMPORT, and CMS commands and the trace facility

The IVP procedures are in the sample files on the QMF distribution disk.

Your CMS PROFILE EXEC should define a print file (DSQPRINT) and a message file (DSQDEBUG).

As a result of the IVP:

• A query is printed.
• A trace file is saved in a file DSQDEBUG.
• A query is exported to file "QMFIVP QUERY A1".
• A query is imported from file "QMFIVP QUERY A1".
• File "QMFIVP QUERY A1" is erased using the CMS command.

During the IVP, you might receive QMF error messages. For the text of the error messages, see the DSQDEBUG file. For more information on these error messages, you can use the QMF HELP command to view the message help panels.

DB2 for VM authorization

If you (the installer) do not have DB2 for VM DBA authority or an authorization ID of "Q", the minimum DB2 for VM authorization required is:

• SELECT authority for all QMF control tables. The following are examples of SQL GRANT statements to give SELECT authority for Q.PROFILES and Q.ERROR_LOG:

  GRANT SELECT ON Q.PROFILES TO installerid
  GRANT SELECT ON Q.ERROR_LOG TO installerid
  GRANT RESOURCE TO installerid 

• DELETE and UPDATE authority for Q.OBJECT tables. The following are examples of SQL GRANT statements to give all authority to the Q.OBJECT tables:

  GRANT ALL ON Q.OBJECT_DIRECTORY TO installerid
  GRANT ALL ON Q.OBJECT_DATA TO installerid
  GRANT ALL ON Q.OBJECT_REMARKS TO installerid

To run the batch mode IVP, use the QMF invocation exec specifying the parameters for batch mode and the QMF procedure Q.DSQ2EBAT:

DSQ2EINV MODE(B) PROC(Q.DSQ2EBAT)
      or
DSQ2EINV MODE(B) PROC(Q.DSQ2EBAT) CMSSUB(NO)
 

If QMF was not installed correctly, QMF does not initialize, and you receive error messages. For the text of the error messages, see the DSQDEBUG file. For more information on these error messages, you can use the QMF HELP command to view the message help panels.

Restarting the batch IVP

This IVP starts the DSQ2EINV exec with the appropriate parameters.

Expected results from executing the batch IVP

The output looks like the following example. (The dots indicate the beginning and ending of trace records.)

---------------------------------------------------------
YOU MAY ENTER A COMMAND.
---------------------------------------------------------
RUN PROC Q.DSQ2EBAT
---------------------------------------------------------
SET (CONFIRM=NO)
SET PERFORMED. PLEASE PROCEED.

·
·
·

SAVE DATA AS QMF_IVPDATA
DATA WAS SAVED AS QMF_IVPDATA IN THE DATABASE.

·
·
·

OK, YOUR PROCEDURE WAS RUN.
---------------------------------------------------------
EXIT       THE EXIT COMMAND TERMINATES QMF