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.
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.
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:
Make no other modifications to the job.
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.
Run job DSQ1nDSJ (in the library QMF810.SDSQSAPn). Review SYSTERM for completion messages. If errors occur, examine SYSTSPRT and SYSPRINT for error messages.
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.
This step creates the NLF sample tables.
The job for this step is QMF810.SDSQSAPn(DSQ1nIVS). If necessary, change the values for the installation parameters in the job's instream procedure:
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.
Run job DSQ1nIVS in the library QMF810.SDSQSAPn. Review SYSTERM for completion messages. If errors occur, examine SYSTSPRT and SYSPRINT for error messages.
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.