Deleting QMF sample tables from a DB2 DRDA AS

This step should be run only if you are reinstalling QMF into a DB2 DRDA AS application server that already contains QMF.

This step drops all the QMF sample tables from the DB2 DRDA AS.

  1. Edit QMF720.SDSQSAPE(DSQ1EDX2).
  2. Verify and change, if necessary, the default values for the installation parameters in the job's instream procedure:
        //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
  3. Change <ssid> to your DB2 UDB for OS/390 subsystem ID.
  4. (Optional) Review the Comments in the JOB for further tailoring opportunities.
  5. Submit job QMF720.SDSQSAPE(DSQ1EDX2).
  6. Check Stepname DSQCDROP 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 rerun the job.

[ Previous Page | Next Page | Contents | Index ]