Step 32--Create QMF sample tables in a DB2 UDB for iSeries server

This step creates the QMF sample tables in DB2 UDB for iSeries.

1. Edit QMF720.SDSQSAPE(DSQ1EAS4).
2. Verify and change, if necessary, the default values for the installation parameters in the both of the job's instream procedures:

       //DSQEXSQL PROC RGN='2048K',   Job-step region size        
       //  QMFTPRE='QMF720',          Prefix for QMF target libs
       //  DB2EXIT='DSN710.SDSNEXIT', Exit DB2 library name
       //  DB2LOAD='DSN710.SDSNLOAD'  DB2 program library name
    
       //DSQINSQL PROC RGN='2048K',   Job-step region size
       //  QMFTPRE='QMF720',          Prefix for QMF target libs
       //  DB2EXIT='DSN710.SDSNEXIT', Exit DB2 library name
       //  DB2LOAD='DSN710.SDSNLOAD'  DB2 program library name

3. Change to your DB2 Universal Database for OS/390 subsystem ID.
4. Optional: Review the comments in the job to determine whether further tailoring is needed.
5. Submit job QMF720.SDSQSAPE(DSQ1EAS4).
6. Check Stepname DSQSINS for a return code of 0 or 4. Review SYSTERM for completion messages.

   If the return code is other than 0 or 4, examine SYSTSPRT and SYSPRINT for error messages. Perform corrective actions and run the job again.