Migrating QMF on the Same DB2 subsystem

Read this section to migrate when both releases of QMF are on the same DB2 subsystem.

Providing a QMF profile on OS/390

At the start of a QMF session, a user's QMF profile comes from some row of the Q.PROFILES table. With both releases of QMF in the same DB2 subsystem, the two releases use the same Q.PROFILES table.

If a user has a primary authorization ID different from the TSO logon ID, the DSQSPRID parameter should have a value of TSOID when you start QMF. Otherwise, insert a user row in Q.PROFILES with CREATOR set to the primary authorization ID.

For QMF Version 3.1.1 Users

There are no new columns in the Q.PROFILES table if you are migrating from Version 3.1.1.

For QMF Version 3.1 Users

There are no new columns in the Q.PROFILES table if you are migrating from Version 3.1.

For QMF Version 2.4 Users

The Q.PROFILES table now has one more column, ENVIRONMENT, which carries a profile parameter that applies to only the new release. This column has a single default value for its entry, as shown in Table 101. The new column has no effect on the execution of Version 2.4; the new column is invisible to the Version 3 releases.

Important
The new column is not invisible unless QMF Version 2.4 users have installed the fix for APAR PL77029.
For QMF Version 2.2 and Version 2.3 Users

The Q.PROFILES table now has two more columns, MODEL and ENVIRONMENT, which carry profile parameters that apply to only the new release. These columns have single default values for their entries, as shown in Table 101. The two new columns have no effect on the execution of QMF Version 2.2 and Version 2.3; the new columns are invisible to these releases.

Important
The new columns are not invisible unless users have installed the fix for APAR PL77028.

MODEL and ENVIRONMENT columns added to existing rows contain NULLS. Through SET or SAVE PROFILE, users can supply only the MODEL column. You need to assign the ENVIRONMENT column.

Table 101. Columns added to the Version 2.3 profiles table
Column Name Purpose
MODEL Identifies each user's conceptual view of the data that Prompted Query utilizes to access the data. Default value is REL. .
ENVIRONMENT Identifies the execution environment of the QMF session.

Migrating Q.OBJECT__DIRECTORY

Version 3.2 added three new columns to the Q.OBJECT__DIRECTORY table. If you are migrating from an older release of QMF, these three columns have no effect on the previous tables. Table 102 shows the three new columns.

Table 102. Columns added to the Version 3.2 Q.OBJECT__DIRECTORY table
Column name Data type Length (bytes) Nulls allowed? Function/Values
CREATED TIMESTAMP Yes Shows the timestamp value for when an object was created. The value is recorded after SAVE or IMPORT commands.
MODIFIED TIMESTAMP Yes Shows the timestamp value for when an object was last modified. The value is recorded after SAVE or IMPORT commands.
LAST__USED DATE Yes Shows the date value for when an object was last used. The value is updated only once a day.

Migrating DPRE in ISPF from Version 2.4

If you are migrating from QMF Version 2.4 to QMF Version 7.2 and you plan to run both QMF Version 2.4 and Version 7.2 on the same database, you need to use the QMF Version 2.4 version of DPRE for both versions of QMF. To provide the QMF Version 2.4 version after installing QMF Version 7.2:

  1. Rename or save the QMF Version 7.2 version of DSQABR13 for use when upgrading DPRE to Version 7 level.
  2. Move the following CLISTs from QMF Version 2.4 library QMF240.DSQCLSTE to the QMF Version 7.2 library QMF720.SDSQCLTE:
  3. From a QMF Version 2.4 session that has an authorization ID of Q, IMPORT and save the Version 2.4 version of QMF procedure Q.DSQAER1P. To do this, issue the QMF command: 
    IMPORT PROC Q.DSQAER1P FROM 'QMF240.DSQSAMPE(DSQAER1P)'

When you are no longer using QMF Version 2.4, restore DPRE to the Version 7.2 level as follows:

  1. Restore the QMF Version 7.2 version of DSQABR13 that was saved or renamed in step 1 above to QMF Version 7.2 library QMF720.SDSQCLTE
  2. From a QMF Version 7.2 session that has an authorization ID of Q, IMPORT and save the Version 7.2 version of QMF procedure Q.DSQAER1P. To do this issue the QMF command: 
    IMPORT PROC Q.DSQAER1P FROM 'QMF720.SDSQSAPE(DSQAER1P)'

Making objects from the earlier release available under QMF Version 7.2

If both releases of QMF are on the same DB2 subsystem, all the DB2 objects (tables and views, for example), are available under QMF Version 7.2 if they are available under the earlier release. All the queries, forms, and procedures are also available, but some might be unusable under QMF Version 7.2. This topic is discussed in Migrating QMF objects.

[ Previous Page | Next Page | Contents | Index ]