Migrating from QMF Version 2.4

Run this step if the DB2 UDB for OS/390 subsystem you selected for QMF Version 7.2 currently contains QMF Version 2.4.

This install step contains three jobs:

• DSQ1TBD1 stops the index space
• DSQ1TBA1 allocates VSAM files
• DSQ1TBJ0 recreates Control Tables

Stopping the index space (DSQ1TBD1)

This job stops the QMF profile index space so that it can be redefined in the next step.

1. Determine whether the server is in the local DB2 UDB for OS/390. Run this job only if the server is in the local DB2 UDB for OS/390.

   Issue the STOP command in QMF720.SDSQSAPE(DSQ1TBD1) to stop the index space at the server.

2. Edit QMF720.SDSQSAPE(DSQ1TBD1).
3. Verify the installation parameters in the instream procedure of the job match your tailoring specifications. If they do not, return to Step 2--Tailor the jobs and correct your installation parameters.

   //DSQ1TBD1 PROC RGN='2048K',        Job-step region size
   //     QMFTPRE='QMF720 ',            Prefix for QMF  target libraries
   //     DB2EXIT='DSN710 .SDSNEXIT',  Exit DB2 UDB for OS/390  library name
   //     DB2LOAD='DSN710 .SDSNLOAD'   DB2 UDB for OS/390 program
                                       library name

4. Submit QMF720.SDSQSAPE(DSQ1TBD1).
5. Check that you received a return code of 0. Review SYSTERM for completion messages.

   Do not proceed if the return code is other than zero. Examine SYSTSPRT or SYSPRINT for error messages. Perform corrective actions and then rerun this job.

Allocating the VSAM Files (DSQ1TBA1)

This job allocates VSAM files for the QMF index space for Q.PROFILEX. The job works through a series of IDCAMS statements.

1. Tailor DSQ1TBA1 for distributed data.

   If DB2 UDB for OS/390 is Version 2 Release 3 and the server system is remote ( not in local system), you must insert a /*ROUTE XEQ JCL statement for JES2 and //*ROUTE XEQ JCL statement for JES3 after the jobcard. These statements are required. You must allocate the alias and VSAM data sets at the remote server system by executing this job through the ROUTE card at the remote server system.

2. Edit QMF720.SDSQSAPE(DSQ1TBA1).
3. Verify the installation parameters in the instream procedure of the job match your tailoring specifications. If they do not, return to Step 2--Tailor the jobs and correct your installation parameters.

   //DSQ1TBA1 PROC RGN='2048K',  Job-step region size
   //          QMFTPRE='QMF720 '  Prefix for the target libraries

4. Submit QMF720.SDSQSAPE(DSQ1TBA1).
5. Check for a return code of 0.

   Examine SYSPRINT for error messages. You can ignore the following message if you receive it on the DELETE and PURGE of the cluster:

   IDG3012I Entry QMFDSN.DSNDBC.DSQDBCTL.PROFILEX I001,A001.

Recreating control tables

DSQ1TBJ0 alters a control table, drops and recreates a control table index, creates the Q.DSQ_RESERVED table space and control table, and creates the QMF catalog views. The job works through a series of DB2 UDB for OS/390 statements and has several members.

1. Edit QMF720.SDSQSAPE(DSQ1TBJ0).
2. Verify the installation parameters in the instream procedure of the job matches your tailoring specifications. If they do not, return to Step 2--Tailor the jobs and correct your installation parameters.

   //DSQ1TBD1 PROC RGN='2048K',        Job-step region size
   //     QMFTPRE='QMF720 ',            Prefix for QMF  target libraries
   //     DB2EXIT='DSN710 .SDSNEXIT',  Exit DB2 UDB for OS/390  library name
   //     DB2LOAD='DSN710 .SDSNLOAD'   DB2 UDB for OS/390 program
                                       library name

3. Determine whether your user catalog is password protected. If it is, add the password clause to the STOGROUP statement in member DSQ1VSTB.

   CREATE STOGROUP PASSWORD(password)

4. Submit QMF720.SDSQSAPE(DSQ1TBJ0).
5. Check that you received a return code of 0 or 4. Review SYSTERM for completion messages.

   Do not proceed if the return code is other than zero or four. Examine SYSTSPRT or SYSPRINT for error messages. Perform corrective actions and rerun this job.