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.
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.
Use the logon procedure or CLIST to invoke QMF, as in Start QMF.
The QMF Home panel displays.
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.
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.
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.