Choose an Installation Option

In this section:

There are two options for the first step in installing the adapter. The preferred method uses an EDASERVE configuration file. The alternative method requires you to create an RRSET member. Both methods then require you to do a bind, as described in Create the BIND Member and Submit the BIND Job.

Create the EDASERVE Configuration File for Access to Db2 Using CAF

How to:

You can access Db2 using CAF by creating an EDASERVE configuration file that you must place in the concatenation of data sets allocated to DDNAME ERRORS. You can place this member directly in the hlq.CONF.CFG data set or in another data set that you concatenate in front of hlq.CONF.CFG in the allocation for DDNAME ERRORS.

Syntax: How to Configure the EDASERVE Member for Access to Db2 Using CAF

If you are using the RRSET module, omit this step.

The EDASERVE member must contain the following attributes:

db2_caf = y                 
db2_rel = v       
db2_access = y 

where:

v

Is your release of Db2.

Create the RRSET Member (Alternative Method)

If you are using the EDASERVE configuration file, omit this step.

Create a new load library called hlq.USE.FOCSQL.LOAD, where hlq is the high-level qualifier for your installed version of FOCUS. This library should have the same DCB attributes as hlq.FOCSQL.LOAD:

Organization  . . . : PO      
Record format . . . : U       
Record length . . . : 0       
Block size  . . . . : 27998 

Copy hlq.FOCSQL.LOAD(RRSETv) to hlq.USE.FOCSQL.LOAD(RRSET).

where:

v

Is your version of Db2, for example, 11 or 12.


Information Builders