Pre-Installation Requirements

Before you install the adapter, please review the following list of software requirements:

• Db2 must be installed and working. If it is not, contact your Db2 database administrator. The adapter may be used with any version of Db2 supported by IBM.
• FOCUS must be installed on your system. If it is not, contact your FOCUS database administrator or consult your FOCUS installation guide for instructions on installing FOCUS.

  You also need to know your FOCUS release and Service Pack level. Every time you invoke FOCUS, the banner displays the release.

• Your FOCUS and Db2 maintenance must be up to date.

z/OS Requirements

You need to know how to allocate your adapter libraries on z/OS. You may need to acquire additional space to accommodate the adapter.

In addition, you need to know the data set in which the Db2 software resides. This data set is usually qualified, with names of the form:

DSNv10.SDSNnnnn

where:

v

Is the Db2 release.

nnnn

Is a name indicating the contents of the library.

For example, DSNB10.SDSNLOAD is the data set containing Db2 Version 11 Release 1 run-time software.

UNIX Requirements

For FOCUS for Distributed Systems, your PATH must include the directories that are needed to access your Db2 client libraries.

GRANT is a native SQL command that authorizes users to access Db2 objects such as tables and Db2 application plans. As a run-time requirement, this command must be issued after the adapter is installed. It is also required for the AUTODB2 facility in order to allow access to the Db2 catalog tables.

You need to know the command syntax and have authorization for the tables or views and plans or modules in question. If you are unfamiliar with the GRANT command, contact your Db2 database administrator for assistance.

On FOCUS for Distributed Systems, you install the adapter to use the Call Level Interface (CLI).

On z/OS FOCUS, you can install the adapter to call Db2 using one of two methods:

• Call Level Interface (CLI).

  If you install the adapter to use CLI, FOCUS will connect to a Db2 client, and that client will communicate with Db2. The client will also set up the environment, so that you do not have to select a PLAN in your FOCUS session or batch job. In this environment, you can also call Db2 stored procedures. However, this environment does require an extra communications layer.

• Call Attachment Facility (CAF).

  If you install the adapter to use CAF, FOCUS will connect directly to Db2. The following adapter features require CAF:

  • Static SQL for MODIFY.
  • Enhanced COMMIT, connection, and thread control. The AUTOCLOSE and AUTODISCONNECT features require CAF.
  • CALLDB2 for invoking subroutines with embedded SQL.

  Using CAF offers other advantages:

  • The ability to change plans (ENGINE DB2 SET PLAN) or Db2 subsystems (ENGINE DB2 SET SSID) within the FOCUS session. Users may wish to switch to a plan with a different isolation level, or from a test to a production Db2 subsystem, without exiting FOCUS. The ability to switch plans is critical to the CAF-specific features.
  • Users can disconnect from Db2 while in a FOCUS session. They may also use FOCUS when Db2 is not available.