Step 11--Tailoring QMF NLF for a DB2 UDB for iSeries server (optional)

QMF support for DB2 UDB for iSeries Database Servers is optional. You need to perform the steps described in this step only if you intend to run a DB2 UDB for iSeries Database Server as an application server for your QMF NLF. Before you install a QMF NLF into a DB2 UDB for iSeries Database Server from OS/390, you need to verify that you have followed the steps needed to install the QMF base product into your DB2 UDB for iSeries Database Server database.

Check the step completion codes in the system messages. Completion messages can be found in the SYSTSPRT or the SYSTERM output, as indicated. SYSPRINT provides additional diagnostic information for IBM support.

Create QMF NLF control table updates in a DB2 UDB for iSeries server.

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

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

3. Change in SYSTEM() to your DB2 for OS/390 subsystem ID.
4. Carefully read the comments in the job and make any necessary changes.
5. Submit job QMF720.SDSQSAPE(DSQ1nAS2).
6. Check for 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.

Create QMF NLF sample tables in a DB2 UDB for iSeries server

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

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

3. Change in SYSTEM() to your DB2 for OS/390 subsystem ID.
4. Carefully read the comments in the job and make any necessary changes.
5. Submit job QMF720.SDSQSAPE(DSQ1nAS4).
6. Check for 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.