When the old and new releases are in the same DB2 for VSE and VM server

When the old and new QMF releases are in the same DB2® for VSE and VM 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.

Procedure

To list all QMF packages for a particular release, run the following statement.

In place of X, substitute the version-specific character of the package identifier that is associated with the QMF release you want to remove.

Follow this statement with a DROP statement for each package you want to remove.

SELECT SUBSTR(PROGNAME,1,10) 
FROM SYSTEM.SYSPROGAUTH
WHERE PROGNAME LIKE 'DSQX%'

Example

For example, to list QMF Version 9 packages from DB2 for VSE and VM server, issue the following statement:

SELECT SUBSTR(PROGNAME,1,10) 
FROM SYSTEM.SYSPROGAUTH
WHERE PROGNAME LIKE 'DSQF%'