When the old and new releases are in the same remote server
When the old and new QMF releases are in the same remote server, remove the earlier QMF release by dropping all QMF packages from the earlier release. QMF control tables and sample tables are still needed for QMF Version 13.1 in this case.
About this task
Table 1 lists the version-specific characters of the package identifiers that are associated with the QMF release from which migration to QMF Version 13.1 is supported.
Follow this statement with a DROP statement for each package you want to remove.
- For Db2® for Linux®, UNIX, and Windows servers:
SELECT SUBSTR(PKGNAME,1,10) FROM SYSCAT.PACKAGES WHERE PKGNAME LIKE 'DSQX%'
- For DB2® for iSeries servers:
SELECT SUBSTR(PACKAGE_NAME,1,10) FROM QSYS2.SYSPACKAGE WHERE PACKAGE_NAME LIKE 'DSQX%'
SELECT SUBSTR(PACKAGE_NAME,1,10) FROM QSYS2.SYSPACKAGE WHERE PACKAGE_NAME LIKE 'DSQF%'