DB2 graphic  QMF Version 8

Run the IVP (TSO)

This step leads you through the final testing of QMF, called the installation verification procedure (IVP). To test a DB2 QMF for TSO/CICS installation, you need to start QMF, connect to your server or DB2 UDB for z/OS database, validate the existence of Help panels, and issue the command:

LIST TABLES (OWNER=Q)

. Most of the QMF product installation is tested by simply starting QMF. If you plan to run QMF in batch mode, there is a separate IVP, which follows the interactive IVP.

  1. Complete all the installation and tailoring for the base product, as outlined in this book.
  2. Ensure you have proper authority.

    If you start the QMF transaction with the authorization ID of Q, you already have the necessary DB2 UDB for z/OS authority. If you do not use the authorization ID Q, you need, at a minimum, the authority granted by the following SQL statements:

    GRANT SELECT ON Q.PROFILES TO authid
    GRANT SELECT ON Q.ERROR_LOG TO authid
    GRANT ALL ON Q.OBJECT_DIRECTORY TO authid
    GRANT ALL ON Q.OBJECT_DATA TO authid
    GRANT ALL ON Q.OBJECT_REMARKS TO authid

    where authid is your primary authorization ID.

    You must also have enough DB2 UDB for z/OS authority to exercise the IVP's SAVE DATA command. If you created the receiving database and table space, you already have this authority. If not, you need, at a minimum, the authority granted by the following SQL statements:

    GRANT CREATETAB ON DATABASE dbname TO authid
    GRANT USE OF TABLE SPACE dbname.table space TO authid

    where dbname is the database name, table space is the table space name, and authid is your primary authorization ID.

    If you chose the default values when you created the table space and database, the database is named DSQDBDEF, and the table space DSQTSDEF. If not, the names might be from the IVP on an earlier QMF release.

  3. Start QMF

    Use the logon procedure or CLIST to invoke QMF, as in Start QMF.

    The QMF Home panel displays.

    Figure 6. QMF Home panel
    Licensed Materials - Property of IBM
    5625-DB2 (C) Copyright IBM Corp. 1982, 2003
    All Rights Reserved.
    IBM is a registered trademark of International Business Machines
    _________________________________________________________________________________
     
      QMF HOME PANEL                       Query       Management    Facility
      Version 8 Release 1
                                          ******     **    **      ********* ____
      Authorization ID                  **     **   ***   ***     **        ____
        Q                              **     **   ****  ****    *******   ____
                                      **     **   ** ** ** **   **        ____
      Connected to                   **   * **   **  ****  **  **        ____
        SQLDS                         ******    **   **    ** **        _______
                                           ** _______________________________________
     
    Enter a command on the command line or press a function key.
    For help, press the Help function key or enter the command HELP.
    _________________________________________________________________________________
     1=Help        2=List        3=End         4=Show       5=Chart        6=Query
     
     7=Retrieve    8=Edit Table  9=Form       10=Proc      11=Profile     12=Report
     OK, you may enter a command.
     COMMAND ===>

    If the location name has not been defined for the database, Connected to <location_name> will not appear on the QMF Home panel.

    Be sure you are connected to the Workstation Database Server or DB2 UDB for z/OS database in which you just installed QMF. If necessary, you can use the QMF CONNECT command to connect to the correct location.

    If QMF does not start correctly, you might receive an error message. See Appendix A. Miscellaneous for descriptions of common error conditions and corrective actions. Correct the problem and begin the IVP again.

  4. Press the Help function key from the Home panel to validate the existence of help panels.
  5. Exit from the help panel by pressing either F3 or F12.
  6. Obtain a list of QMF-supplied sample tables.

    Type the QMF command LIST TABLES (OWNER=Q) on the command line and press Enter.

    If you press F8, additional panels are shown. Return to the QMF Home panel by pressing the Cancel function key. End the QMF session by pressing F12.

  7. Run the QMF Installation Verification Procedure

    Replace QMF810 with the actual prefix you used for the QMF data sets, then issue this command from the QMF command line:

    IMPORT PROC FROM'QMF810.SDSQSAPE(DSQ1EIVP)'

    This will display the Installation Verification Procedure; comments at the beginning tell you how to run it. Before you run the IVP, replace every occurrence of QMF810 with the actual prefix that you used for the QMF data sets. If the procedure does not run successfully, use the QMF messages and message help panels to fix the problem.

The installation verification for interactive mode is now complete.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004