Step 7A--Update QMF control tables

The substep (7Aa, 7Ab, 7Ac, 7Ad) you perform depends on the type of migration installation you are running:

For all these steps that run TSO batch, check the step completion code in the system messages. Completion messages can be found in the SYSTSPRT or the SYSTERM output, as indicated. SYSPRINT provides additional diagnostic information for IBM support.

Substep 7Aa--without a previous QMF NLF release

Perform this step if you do not have a previous QMF NLF installed.

On this step, you do the following:

Preparation

Change the job statements for DSQ1nUPO and DSQ1nCCS to fit your installation. The value of the USER parameter in the job statement is currently "Q" for the owner of the QMF tables. Change this value to your primary authorization ID if your authorization ID is not Q.

Make the necessary changes to the following parameter values in the job's instream procedure:

Parameter name
Description of value (Default in parenthesis)
QMFTPRE
Prefix of the QMF target libraries (QMF720)
DB2EXIT
Name of the DB2 exit library (DSN710.SDSNEXIT)
DB2LOAD
Name of the DB2 program library (DSN710.SDSNLOAD)
RGN
Job step region size (2048K)
DB2 Authority

If you are the user Q, run the following query to give you enough authority to run the jobs:

GRANT CREATETAB ON DATABASE DSQDBCTL TO Q

You may need the query if the database DSQDBCTL was not created by the user Q.

If you are not the user Q, run the following queries, to give you enough authority to run the jobs:

GRANT INSERT, UPDATE ON TABLE Q.PROFILES TO authid
GRANT CREATETAB ON DATABASE DSQDBCTL TO authid

where authid is your primary authorization ID.

Execution

Run the appropriate jobs:

Review SYSTERM for completion messages. If errors occur then examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

If the job fails, you can correct the error and rerun it.

Substep 7Ab--with QMF NLF 2.2 or 2.3

Perform this step only if you are migrating from QMF NLF 2.2 or 2.3.

This job adds your NLF equivalents of the IRM and LAYOUT command synonyms to the Q.COMMAND_SYNONYM_n table, and update the Q.PROFILES control table.

Preparation

The job used in this step is QMF720.SDSQSAPn(DSQ1nICS). Change the job statement to conform to your installation. Also, make the necessary changes to the following parameters in the job's instream procedure:

Parameter name
Description of value (Default in parenthesis)
QMFTPRE
The prefix name of the QMF target libraries (QMF720)
DB2EXIT
Name of the DB2 exit library (DSN710.SDSNEXIT)
DB2LOAD
Name of the DB2 program library (DSN710.SDSNLOAD)
RGN
Job-step region size (2048K)
DB2 authority

If you are the user Q , you have the necessary authority to run the job.

If you are not the user Q, run the following query, to get the necessary authority:

GRANT INSERT ON TABLE Q.COMMAND_SYNONYM_n TO authid

where authid is your primary authorization ID.

Execution

Run job QMF720.SDSQSAPn(DSQ1nICS).

Review SYSTERM for completion messages. If errors occur then examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

If the job fails, you can correct the error and rerun it.

Substep 7Ac--with QMF NLF 2.4

Perform this step only if you are migrating from QMF NLF V2R4.

This job updates the Q.PROFILES control table.

Preparation

The job used in this step is QMF720.SDSQSAPn(DSQ1nUP1). Change the job statement to conform to your installation. Change, if necessary, the installation parameter values in the job's instream procedure:

Parameter name
Description of value (Default in parenthesis)
QMFTPRE
The prefix name of the QMF target libraries (QMF720)
DB2EXIT
Name of the DB2 exit library (DSN710.SDSNEXIT)
DB2LOAD
Name of the DB2 program library (DSN710.SDSNLOAD)
RGN
Job-step region size (2048 KB)
DB2 authority

If you are the user Q, you have the necessary authority to run the job.

If you are not the user Q, run the following query to get the necessary authority:

GRANT INSERT ON TABLE Q.PROFILES TO authid

where authid is your primary authorization ID.

Execution

Run job QMF720.SDSQSAPn(DSQ1nUP1).

Review SYSTERM for completion messages. If errors occur then examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

If the job fails, correct the error and rerun the job.

Substep 7Ad--with QMF NLF 3.1

Perform this step only if you are migrating from QMF NLF V3R1.

This job updates the Q.PROFILES control table.

Preparation

The job used in this step is QMF720.SDSQSAPn(DSQ1nUP2). Change the job statement to conform to your installation's requirements. Change, if necessary, the installation parameter values in the job's instream procedure:

Parameter name
Description of value (Default in parenthesis)
QMFTPRE
The prefix name of the QMF target libraries (QMF720)
DB2EXIT
Name of the DB2 exit library (DSN710.SDSNEXIT)
DB2LOAD
Name of the DB2 program library (DSN710.SDSNLOAD)
RGN
Job-step region size (2048K)
DB2 authority

If you are the user Q, you have the necessary authority to run the job.

If you are not the user Q, run the following query, to get the necessary authority:

GRANT INSERT ON TABLE Q.PROFILES TO authid

where authid is your primary authorization ID.

Execution

Run job QMF720.SDSQSAPn(DSQ1nUP2).

Review SYSTERM for completion messages. If errors occur then examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

If the job fails, correct the error and rerun the job.

[ Previous Page | Next Page | Contents | Index ]