DB2 graphic  QMF Version 8

Step 4--Tailoring QMF NLF for a Workstation Database Server (optional)

QMF support for Workstation Database Server is optional. Perform the steps described in this step only if you intend to run a Workstation Database Server as an application server for your QMF NLF.

Before you install a QMF NLF into a Workstation Database Server from z/OS, you need to verify that you have followed the steps to install the QMF base product into your Workstation Database Server database. The installation of a QMF NLF requires that the outbound Workstation Database Server ID has SYSADM authority. For more information about installing QMF into a Workstation Database Server, see Configuring remote servers for QMF Compatibility mode.

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.

Step 4A--Create QMF NLF control tables in a Workstation Database Server

This step creates QMF NLF command synonym tables and profile rows in a Workstation Database Server.

  1. Edit QMF810.SDSQSAPE(DSQ1nDJ2).
  2. Verify and change, if necessary, the default values for the installation parameters in the job's instream procedure:
    //DSQ1TBJ4 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 DSN in SYSTEM(DSN) to your DB2 UDB for z/OS subsystem ID.
  4. Submit job QMF810.SDSQSAPE(DSQ1nDJ2).
  5. 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 then re-run this job.

Step 4B--Create QMF NLF sample tables in a Workstation Database Server

This step creates the QMF NLF sample tables in a Workstation Database Server.

  1. Edit QMF810.SDSQSAPE(DSQ1nDJ4).
  2. Verify and change, if necessary, the default values for the installation parameters in the job's instream procedure:
    //DSQ1TBJ4 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 DSN in SYSTEM(DSN) to your DB2 UDB for z/OS subsystem ID.
  4. Submit job QMF810.SDSQSAPE(DSQ1nDJ4).
  5. 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.

Deleting QMF NLF from a Workstation Database Server

This section describes how to delete QMF NLF from a Workstation Database Server.

Deleting QMF from a Workstation Database Server

This step should be run only if you are re-installing QMF into a Workstation Database Server that already contains QMF.

Attention: This step will delete the QMF NLF command synonym tables and system profile rows from a Workstation Database Server.
  1. Edit QMF810.SDSQSAPE(DSQ1nDX1).
  2. Verify and change, if necessary, the default values for the installation parameters in the job's instream procedure:
    //DSQ1TBJ4 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 DSN in SYSTEM(DSN) to your DB2 UDB for z/OS subsystem ID.
  4. Submit job QMF810.SDSQSAPE(DSQ1nDX1).
  5. 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.

Deleting QMF NLF sample tables from a Workstation Database Server

This step should be run only if you are reinstalling the QMF NLF into a Workstation Database Server that already contains the QMF NLF.

This step will drop and create all QMF NLF sample tables and table space from a Workstation Database Server.

  1. Edit QMF810.SDSQSAPE(DSQ1nDX2).
  2. Verify and change, if necessary, the default values for the installation parameters in the job's instream procedure:
    //DSQ1TBJ4 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 DSN in SYSTEM(DSN) to your DB2 UDB for z/OS subsystem ID.
  4. Submit job QMF810.SDSQSAPE(DSQ1nDX2).
  5. Check for a return code of 0 or 4. Review SYSTERM for completion messages.

    Examine SYSTSPRT or SYSPRINT for error messages. Perform corrective actions and then re-run this 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