This section describes how to migrate when both releases of QMF are in different DB2 subsystems.
When the DB2 subsystems are different, migration is complicated by the fact that QMF objects in the database for the earlier QMF release are not available to Version 8.1 users. Nor are these objects in the DB2 QMF Version 8.1 database available to users of the earlier QMF release.
The tables and views required by QMF must be made available in the new subsystem.
The installation process creates a new Q.PROFILES table when QMF Version 8.1 is in a different DB2 subsystem.
This newly created table contains a single SYSTEM row. The values assigned to the columns appear in Table 69
Column | Value |
---|---|
CREATOR | SYSTEM |
CASE | UPPER |
DECOPT | PERIOD |
CONFIRM | YES |
WIDTH | 132 |
LENGTH | 60 |
LANGUAGE | SQL |
SPACE | DSQDBDEF.DSQTSDEF |
TRACE | NONE |
PRINTER | blank |
TRANSLATION | ENGLISH |
PFKEYS | Zero-length string |
SYNONYMS | Q.COMMAND__SYNONYMS |
RESOURCE__GROUP | SYSTEM |
MODEL | REL |
ENVIRONMENT | Null |
If CICS is installed, there is an additional SYSTEM row, in which SYNONYMS is set to null and ENVIRONMENT is set to CICS.
With only the SYSTEM row in the table, users begin their Version 8.1 sessions with the QMF profile provided by this row. This profile can differ from profiles on earlier QMF releases. You can recreate the earlier profiles with a series of INSERT queries, but users can also do this for themselves with SET or SAVE PROFILE.
The PFKEYS, SYNONYMS, and RESOURCE__GROUP parameters play key roles in customizing the QMF environment. For a brief description of each, see Table 69
Users cannot, however, change the values of the PFKEYS, SYNONYMS, and RESOURCE__GROUP parameters with SET or SAVE PROFILE. You must do this with an UPDATE query on the Q.PROFILES table. For an example of this, see Activating new function key definitions.
This section applies to QMF Compatibility mode and New Function mode installations.
DB2 tables and QMF objects can be exported from a subsystem under an earlier QMF release and then imported under QMF Version 8.1.
To migrate DB2 tables, any user with the proper DB2 authority can:
If the two versions of QMF are on different z/OS systems, use the available networking facilities to send the exported objects and unloaded tables to the system containing QMF Version 8.1.
To migrate QMF queries, forms, procedures, and applications, make sure you read the following section, Migrating QMF objects.
If you have DB2 QMF High Performance Option (HPO) installed, you can use the HPO Object Manager for assistance with the migration of QMF objects from one DB2 subsystem to another.
For more information on Data Refresher or the DB2 QMF High Performance Option, see the web site at: http://www.ibm.com/software/data/qmf.
If you use QMF to export tables from a database and import them to a different database, you must create any views, indexes, synonyms, and authorizations on that table at the new database.