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.
// 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
DSN SYSTEM(DSN) FREE PLAN(QMF810)
Previous Release | Default |
---|---|
QMF Version 7.2 | QMF720 |
QMF Version 7.1 | QMF710 |
QMF Version 6.1 | QMF610 |
QMF Version 3.3 | QMF330 |
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 DSQSGDEFQMF810
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.
If the job fails, correct the error and rerun the job.