Accessing QMF profiles in a different database

To use profiles from an earlier release that does not reside in the same database as the newly installed release, re-create the profiles.

About this task

To access QMF, users need a QMF profile. Profile information is stored in the Q.PROFILES control table.

Procedure

To use profiles from an earlier release that does not reside in the same database as the newly installed release, re-create the profiles in one of the following ways:

  • If the earlier release is QMF Version 8.1 or Version 9.1 New Function Mode or QMF Version 10, Version 11.1 or Version 12.1, you can use the QMF EXPORT and IMPORT commands to migrate the profiles by exporting a copy of the Q.PROFILES table from the database that contains the earlier QMF release and importing it into the database that contains the new release of QMF.
  • For any release of the prior installation of QMF, you can issue multiple INSERT statements from the SQL Query panel to re-create the appropriate data in the Q.PROFILES table.