Create the BIND Member and Submit the BIND Job

Copy hlq.CONF.DATA(IDB2BIND) to a data set that you can edit.

Note: GENFDB2 is no longer used.

Make the following edits to the IDB2BIND member of the data set you can edit.

  1. On line 16, supply the name of your Db2 load library (usually DSNv10.SDSNLOAD).

    For example, change the following line

    000016 //  DSN=<db2 load library>

    to the following if you are using Db2 version 11

    000016 //  DSN=DSNB10.SDSNLOAD
  2. On line 18, supply the name of your Db2 CLIST library (usually DSNv10.SDSNCLST).

    For example, change the following line

    000018 //  DSN=<dsnclst>           

    to the following if you are using Db2 version 11

    000018 //  DSN=DSNB10.SDSNCLST
  3. Change all occurrences of DB2VZPRM to DB2Vv

    where:

    v

    Corresponds to the version of Db2 you are planning to use with FOCUS. Change v to

    9PRM for Db2 v9.

    10PR for Db2 v10.

    11PR for Db2 v11 and Db2 v12.

  4. On line 30, change the high-level qualifier of the CONF.DATA data set to the high-level qualifier for your installed version of FOCUS.

    For example, change the following line

    000030 DATASET('QCSPDS.BF7706M.G971.CONF.DATA(DB2VZPRM)') + 

    to the following, if the high-level qualifier under which FOCUS was installed is HLQ

    000030 DATASET('HLQ.CONF.DATA(DB2V11PR)') +
  5. Change all occurrences of <subsystem> to the name of your Db2 SSID.

    For example, change the following line

    000035 SYSTEM(<subsystem>) +

    to the following, if your Db2 SSID is DBBA

    000035 SYSTEM(DBBA) +
  6. Change all occurrences of <plan name> to the plan name you will use to access Db2.

    For example, change the following line

    000039 PLAN(<plan name>) +

    to the following, if your Db2 PLAN is DSQL

    000039 PLAN(DSQL) + 
  7. Change the OWNER parameter to be the ID of the person who will be running the bind job, and replace the JOB card with a valid JOB card for your site.

The default IDB2BIND process will create a package with the name of IBI_<plan_name> using the <plan_name> that was identified in step 6. If the package name will be something else, lines 40 and 44 will also need to be changed to use the new package name.

Submit the modified IDB2BIND JCL. This job must be run with a USERID that has DBA authority.

The job was successful if it finished with a condition code of 0, and the end of the SYSTSPRT messages shows the following message

DSNT200I  -DBBA  BIND FOR PLAN <plan name> SUCCESSFUL                        
DSNH740I ======= BIND PLAN FINISHED, RC =  0==========================

Information Builders