Step 7C--Create the NLF sample tables

This step creates the NLF sample tables.

Preparation

The job for this step is QMF720.SDSQSAPn(DSQ1nIVS). If the tailoring performed in step 3 was not sufficient, change the job statement to fit your installation requirements. Change, if necessary, 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 (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)

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 was installed:

• For a period, leave the current values as they are.
• For a comma, change CDS to 6 and CDP to 7.

For more information on the DECPOINT option, see the DB2 UDB for OS390 Installation Guide.

DB2 authority

If you are the user Q, you need, as a minimum, 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 QMF720.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 the job.

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

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

• For information on tailoring QMF NLF for TSO, see the next section.
• For information on tailoring QMF NLF for CICS, see Step 9--Tailor NLF/QMF for CICS.