QMF Version 7.2 and a previous release are in different DB2 UDB for OS/390 subsystems

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

Attention: This job removes all traces of QMF from the DB2 UDB for OS/390 subsystem and should be run only if the current release of QMF does not exist in the DB2 UDB for OS/390 subsystem.
  1. Edit QMF720.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='QMF720',             QMF prefix
    // DB2EXIT='DSN710.SDSNEXIT',    DB2 UDB for OS/390 exit library
    // DB2LOAD='DSN710.SDSNLOAD'     DB2 UDB for OS/390 program library 
  4. Edit member QMF720.SDSQSAPE(DSQ1DEL1).
  5. Replace DSN with the name of the DB2 UDB for OS/390 subsystem and replace QMF720 with the name of the application plan of the previous release.
    DSN SYSTEM(DSN)
    FREE PLAN(QMF720)
    Table 13. QMF release defaults
    Previous Release Default
    QMF Version 6.1 QMF610
    QMF Version 3.3 QMF330
    QMF Version 3.2 QMF320
    QMF Version 3.1.1 QMF311
    QMF Version 3.1 QMF310
  6. Edit member QMF720.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 ( Step 17), delete the following statement:

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

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

  8. Submit job QMF720.SDSQSAPE(DSQ1DELA).

    If the job fails, correct the error and rerun the job.

If you are performing a requester or server database installation, go to Step 38--Clean up security.

[ Previous Page | Next Page | Contents | Index ]