Step 12--Create the QMF sample tables

DSQ1EIVS creates the QMF sample tables. For more information about these tables, see Appendix B. QMF Objects Residing in DB2.

Tip: Sample tables are authorized to PUBLIC AT ALL LOCATIONS so that users can use three-part names to reference sample tables in another DB2 UDB for OS/390 subsystem.

QMF users at locations within the network are authorized to use all the sample tables created at the location into which you are installing QMF.

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

   //DSQ1EIVS 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
   //     CDS='2',                    punctuation for decimal point
   //     CDP='4'                       default is period (comma is CDS 6
   //*                                                   CDP 7)

3. If you are migrating from another level of QMF, comment out job step 1.

   //*STEP1   EXEC PGM=IKJEFT01,REGION=&RGN

4. Edit member QMF720.SDSQSAPE(DSQ1VSTC).

   This file creates a storage group, database, and table space for the sample tables.

5. Verify that the following parameters are correct:

   CREATE STOGROUP DSQ1STBG
       VOLUMES (DSNVOL)   QMF  tables volume
       VCAT QMFDSN;       QMF  Catalog Alias in VCAT

6. Determine whether or not your user catalog is password protected. If it is, add the password clause to the STOGROUP statement in member DSQ1VSTC.

   CREATE STOGROUP PASSWORD(password)

7. Submit job QMF720.SDSQSAPE(DSQ1EIVS).
8. Check that you received a return code of 0. Review SYSTERM for completion messages.

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