Install QMF base into DB2 database

Run DSQ3EDBI, the database installation job, for each SQL database that you are connecting to QMF.

Skip this procedure if you have a DB2 guest sharing environment and have installed QMF for VM. Under these conditions, you can continue with Tailor QMF for NLF, if you have an NLF to install, or skip to Link-edit jobs for QMF for a base installation.

DSQ3EDBI

• Creates QMF control tables
• Loads QMF packages
• Defines and loads sample tables

1. Edit DSQ3EDBI (first use of the job only).
   1. Delete the first line of the file, starting with CATALOG.
   2. Change all instances of ..* to * with the following command:

      ch /..*/*/ *

   3. Delete the last two lines of the file, leaving the end-of-job statement.
2. Ensure that the first three job steps are set to YES.

   // SETPARM STEP1=YES    -- CREATE QMF CONTROL TABLES IN SQL DB
   // SETPARM STEP2=YES    -- LOAD QMF PACKAGES INTO SQL DB
   // SETPARM STEP3=YES    -- LOAD QMF SAMPLES INTO SQL DB 

   For subsequent installations, or under error conditions, some of the job steps might need to be set to NO. Changing the setparm to NO will skip the step.

3. Locate the

   // SETPARM DBNAME=SQLDS

   parameter and verify or change SQLDS to the name of the database that you are using. DBNAME is the database name that is specified in the SQL DBNAME directory.
4. Determine whether this database has an earlier version of QMF for VSE installed. Possible earlier versions are Version 3.3, Version 6.1, or Version 7.1.

   If an earlier version is installed, located the following statement and change the value from NO to Version 3.3, Version 6.1, or Version 7.1:

   // SETPARM MIGRATE=NO
   //

   Using this parameter will prevent duplicate control tables from being created.

5. Verify or change all instances of the QMF library and sublibray names. If QMF was installed to a library other than PRD2.PROD, change the library and sublibrary names.
6. Ensure that DB2 is up and running in multiple user mode.
7. Ensure the SQLDBA's password is set to SQLDBAPW.

   The QMF installation procedures assume that the password for SQLDBA is set to SQLDBAPW. IF the password is set to anything else, DSQ3SETQ.A must be updated and re-cataloged into the QMF installation library.

   To update DSQ3SETQ.A:

   1. Punch the member DSQ3SETQ.A to an editor, such as ICCF.
   2. Modify the CONNECT statement by replacing SQLDBAPW with the existing password for SQLDBA:

      CONNECT SQLDBA IDENTIFIED BY 'new-SQLDBAPW'

   3. Recatalog DSQ3SETQ.A into the QMF installation library (PRD2.PROD).
8. File and run DSQ3EDBI. As the job runs, the system console displays messages that indicate which job step is executing. At the end of the job, check the system console to ensure that job completed with a return code of 0. Those who are migrating from an earlier version of QMF for VSE, might get a return code of 6 in job step; in this case, the return code can be ignored.

   To install QMF into additional DB2 databases, repeat the procedure for each database, starting with step 3.