Creating control tables without a previous QMF release

Run this step if the DB2 UDB for OS/390 subsystem for QMF does not contain an earlier release of QMF.

This step contains two install jobs:

• DSQ1TBAJ allocates alias. (Skip this if your system already has the alias defined.)
• DSQ1TBLJ creates and loads QMF control tables and catalog views.

Allocating alias and VSAM files

DSQ1TBAJ allocates the alias for the QMF control tables and views. The job does its work through a series of IDCAMS statements.

1. Edit QMF720.SDSQSAPE(DSQ1TBAJ).
2. Verify the installation parameters in the instream procedure of the job and the job steps match your tailoring specifications. If they do not, return to Step 2--Tailor the jobs and correct your installation parameters.

   //DSQ1TBAJ PROC RGN='2048K',  Job-step region size
   //         QMFTPRE='QMF720 ',  Prefix for QMF target libraries

3. Tailor the job for distributed data, if applicable.

   If DB2 UDB for OS/390 is at Version 2 Release 3 and the server system is remote (not in local system), you must insert a /*ROUTE XEQ JCL statement for JES2 and //*ROUTE XEQ JCL statement for JES3 after the jobcard. These statements are required. You must allocate the alias and VSAM data sets at the remote server system by executing this job through the ROUTE card at that remote server system.

   DSQ1TBLR

   The job step defines the alias for QMF in the DB2 UDB for OS/390 VSAM catalog. It contains this statement:

   DEFINE ALIAS   -
    (NAME('QMFDSN') RELATE('DSNC7101.USER.CATALOG'))

4. Verify that this statement matches your tailoring specifications.
5. Submit QMF720.SDSQSAPE(DSQ1TBAJ).
6. Check for a return code of 0.

   If the first step fails, examine SYSPRINT for error messages and rerun the job after you correct the error. If the second step fails, restart DSQ1VSTA. If you receive an SQLCODE 203 on the location, then see the section Appendix A. Miscellaneous.

Creating and loading QMF control tables and catalog views

DSQ1TBLJ creates and loads QMF control tables and catalog views by working through a series of DB2 UDB for OS/390 statements.

1. Edit QMF720.SDSQSAPE(DSQ1TBLJ).
2. Verify the installation parameters in the instream procedure of the job and the job steps match your tailoring specifications. If they do not, return to Step 2--Tailor the jobs and correct your installation parameters.

   //DSQ1TBLJ PROC RGN='2048K',        Job-step region size
   //     QMFTPRE='QMF720 ',            Prefix for QMF  target libraries
   //     DB2EXIT='DSN710 .SDSNEXIT',  Exit DB2 UDB for OS/390 library name
   //     DB2LOAD='DSN710 .SDSNLOAD'   DB2 UDB for OS/390 program
                                       library name

3. Determine whether your user catalog is password protected. If it is, add the password clause to the STOGROUP statement in member DSQ1VSTB.

   CREATE STOGROUP PASSWORD(password)

4. Verify that the installation parameter for the QMF Catalog Alias (default QMFDSN) matches your tailoring specifications in the following members:
   • DSQ1VSTD
   • DSQ1TBLB
   • DSQ1TBLI
   • DSQ1TBLU
   • DSQ1TBLE
   • DSQ1TBLN
   • DSQ1TBLG
5. Submit QMF720.SDSQSAPE(DSQ1TBLJ).
6. Check that you received a return code of 0 or 4. Review SYSTERM for completion messages.

   Do not proceed if the return code is other than zero or four. Examine SYSTSPRT or SYSPRINT for error messages. Perform corrective actions and rerun the job.