This step leads you through the final testing of QMF, called the installation verification procedure (IVP). To test QMF for OS/390 installation, you need to start QMF and issue a few QMF commands. 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 OS/390 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 OS/390 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 TABLESPACE 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 in Step 10-- Create a table space for the QMF IVP, 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 Step 17--Start QMF.
The QMF Home panel displays.
Licensed Materials - Property of IBM
5675-DB2 5697-F42 (C) Copyright IBM Corp. 1982, 2000
All Rights Reserved.
IBM is a registered trademark of International Business Machines
_________________________________________________________________________________
QMF HOME PANEL Query Management Facility
Version 7 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 for OS/390 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.
The installation verification for interactive mode is now complete.
[ Previous Page | Next Page | Contents | Index ]