Step 7B--Delete earlier QMF NLF sample tables

Do this step if you are installing QMF 7 NLF into a DB2 subsystem that also contains a previous release of QMF NLF. Otherwise, skip to Step 7C--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 7 NLF.

Preparation

The job used in this step is QMF720.SDSQSAPn(DSQ1nDSJ). If the tailoring performed in Step 3--Install QMF NLF in the foreground was not sufficient, 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)

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 QMF720.SDSQSAPn). 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. It may, however, fail because the tables it attempts to drop have already been dropped.