DB2 graphic  QMF Version 8

Deleting QMF Version 7.2 and earlier from a DB2 subsystem

Run this step only if DB2 QMF Version 8.1 and the earlier release are on different DB2 UDB for z/OS subsystems. The step frees the earlier application plan and drops various DB2 UDB for z/OS entities that belong to the earlier QMF release.

Attention: This job removes all traces of QMF from the DB2 UDB for z/OS subsystem and should be run only if the current release of QMF does not exist in the DB2 UDB for z/OS subsystem.
  1. Edit QMF810.SDSQSAPE(DSQ1DELA).
  2. Change the job statement to conform to your site's conventions.
  3. Verify, or change if necessary, the values of the parameters in the instream procedure of the job.
    // DSQ1DELA PROC RGN='2048K',    Job-step region size
    // QMFTPRE='QMF810',             QMF prefix
    // DB2EXIT='DSN810.SDSNEXIT',    DB2 Universal Database for z/OS
    //                                   exit library
    // DB2LOAD='DSN810.SDSNLOAD'     DB2 Universal Database for z/OS
    //                                program library 
  4. Edit member QMF810.SDSQSAPE(DSQ1DEL1).
  5. Replace DSN with the name of the DB2 UDB for z/OS subsystem and replace QMF810 with the name of the application plan of the previous release.
    DSN SYSTEM(DSN)
    FREE PLAN(QMF810)
    Table 21. QMF release defaults
    Previous Release Default
    QMF Version 7.2 QMF720
    QMF Version 7.1 QMF710
    QMF Version 6.1 QMF610
    QMF Version 3.3 QMF330
  6. Edit member QMF810.SDSQSAPE(DSQ1DEL2).

    This member contains SQL statements to drop views, table spaces, databases, and storage groups.

    If the previous QMF release does not have the receiving table space for the users' SAVE DATA commands and the IVP, delete the following statement:

    DROP STOGROUP DSQSGDEF
    QMF810
  7. Edit member QMF810.SDSQSAPE(DSQ1DEL13)

    This member contains statements to delete user managed data sets for QMF control tables. There is no need to run this step if it is managed by DB2.

  8. Submit job QMF810.SDSQSAPE(DSQ1DELA).

    If the job fails, correct the error 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