DB2 graphic  QMF Version 8

Step 1A Update QMF control tables

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 1Aa--without a previous QMF NLF release

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

On this step, perform these tasks:

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 (QMF810)
DB2EXIT
Name of the DB2 exit library (DSN810.SDSNEXIT)
DB2LOAD
Name of the DB2 program library (DSN810.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, examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

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


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004