DB2 graphic  QMF Version 8

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

QMF support for DB2 UDB for iSeries Database Servers is optional. Run the steps described here 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 z/OS, you must 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 QMF810.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='QMF810', Prefix for QMF target libraries 
     // DB2EXIT='DSN810.SDSNEXIT', Exit DB2 library name 
     // DB2LOAD='DSN810.SDSNLOAD' DB2 program library name
  3. Change in SYSTEM() to your DB2 UDB for z/OS subsystem ID.
  4. Carefully read the comments in the job and make any necessary changes.
  5. Submit job QMF810.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 QMF810.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='QMF810', Prefix for QMF target libraries   
    // DB2EXIT='DSN810.SDSNEXIT', Exit DB2 library name   
    // DB2LOAD='DSN810.SDSNLOAD' DB2 program library name
  3. Change in SYSTEM() to your DB2 UDB for z/OS subsystem ID.
  4. Carefully read the comments in the job and make any necessary changes.
  5. Submit job QMF810.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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004