ATTACH

Read syntax diagramSkip visual syntax diagram
           .-CAF---.   
>>-ATTACH=-+-RRSAF-+-------------------------------------------><

ATTACH
Specifies which attachment facility is to be used to connect to and use the Db2® subsystem defined by SSID, to process SQL statements, commands or instrument facility interface (IFI) calls.

The properties and requirements of the various Db2 attachment facilities are documented in the Db2 Application Programming and SQL Guide.

CAF
The call attachment facility will be used to connect to and use the Db2 subsystem defined by SSID.

CAF is the default and recommended value. The CAF attachment works concurrently with other Db2 applications that use the DSNELI (DSN) attachment, the DSNALI (CAF) attachment, but not the DSNRLI (RRSAF) attachment.

RRSAF
The Db2 Resource Recovery Services attachment facility (RRSAF) will be used to connect to and use the Db2 subsystem defined by SSID.

RRSAF uses z/OS® Transaction Management and Recoverable Resource Manager Services (z/OS RRS) and this service must be active.

RRSAF should only be used in situations where there will be no conflicts with other Db2 applications that use other attachment facilities, especially the DSNELI attachment. For example, it is not possible to run Db2's SPUFI and ZDT/Db2 on separate ISPF split screens when ZDT/Db2 is using the RRSAF attachment (because of the conflict with the DSN attachment used by Db2's SPUFI).

The default is CAF.