DB2 graphic  QMF Version 8

Step 1B and 1C--Establish the QMF NLF sample tables

Skip steps 3B and 3C if either of the following conditions apply:

These two steps establish the QMF NLF sample tables. The first step drops previously created tables, the second step installs new ones. In the event of a failure, you can restart both of these steps because database changes are not committed until the job that was run by the step ends.

Step 1B--Delete earlier QMF NLF sample tables

Run this step if you are installing QMF 8 NLF into a DB2 subsystem that also contains a previous release of QMF NLF. Otherwise, skip to Step 1C--Create the NLF sample tables

This step deletes the sample tables that were created when the earlier version was installed. The QMF NLF sample tables have been modified for QMF 8 NLF.

Preparation

The job used in this step is QMF810.SDSQSAPn(DSQ1nDSJ). If the tailoring performed was not sufficient, change the job statement to conform to your installation's requirements. If necessary, change 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 (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)

Make no other modifications to the job.

DB2 authorization

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

GRANT SYSADM TO authid

where authid is your primary authorization ID.

Execution

Run job DSQ1nDSJ (in the library QMF810.SDSQSAPn). 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. However, the job may fail because the tables it is trying to drop have already been dropped.

Step 1C--Create the NLF sample tables

This step creates the NLF sample tables.

Note:
QMF NLF users at locations within the network are authorized to use all the sample tables created at the location on which you are installing the QMF NLF.
Preparation

The job for this step is QMF810.SDSQSAPn(DSQ1nIVS). If necessary, change the values for the installation parameters in the job's instream procedure:

Parameter name
Description of value (Default in parenthesis)
QMFTPRE
The prefix for 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)
CDS, CDP
Identify the punctuation mark for the decimal point used in decimal fractions. This must match the DECPOINT option that was specified when DB2 UDB was installed: For more information on the DECPOINT option, see the DB2 UDB for z/OS Installation Guide.
DB2 authority

If you are the user Q, you will need DB2 authority granted by the following SQL statements:

GRANT SELECT ON SYSIBM.SYSTABLES TO Q WITH GRANT OPTION
GRANT SELECT ON SYSIBM.SYSTABAUTH TO Q WITH GRANT OPTION
GRANT SELECT ON SYSIBM.SYSCOLUMNS TO Q WITH GRANT OPTION

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

GRANT SYSADM TO authid

where authid is your primary authorization ID.

Execution

Run job DSQ1nIVS in the library QMF810.SDSQSAPn. Review SYSTERM for completion messages. If errors occur, examine SYSTSPRT and SYSPRINT for error messages.

Rerunning the job

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

If you are installing a QMF NLF into another database, go to Step 6--Set Up NLF batch job to run batch IVP (optional).

You are now ready to tailor NLF QMF for TSO or CICS.


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