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.

Procedure

To list all QMF packages for a particular release, run the statement that is appropriate for your server.

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.

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%'

Example

For example, to list QMF Version 9 packages on a DB2 for iSeries server, issue the following statement:

SELECT SUBSTR(PACKAGE_NAME,1,10) 
FROM QSYS2.SYSPACKAGE
WHERE PACKAGE_NAME LIKE 'DSQF%'