DBPROTOCOL bind option

The DBPROTOCOL option specifies the protocol to be used when connecting to a remote site.

Command option Option values Used with
DBPROTOCOL
  • (DRDA )
  • (DRDACBF ) 1
Note:
  1. The DBPROTOCOL(DRDACBF) is not valid for BIND PLAN or REBIND PLAN.
  2. The DBPROTOCOL bind option is not valid for REBIND of packages for native REST services,native SQL procedures, or advanced triggers.

A copy of the package must be bound to each remote site that is referenced by a three-part name statement or a CONNECT statement.

Option descriptions for DBPROTOCOL

DBPROTOCOL(DRDA)
DBPROTOCOL(DRDA) is passed on BIND PACKAGE, BIND PLAN, REBIND PACKAGE, or REBIND PLAN invocation.
DBPROTOCOL(DRDACBF)
Connections from a Db2 for z/OS® requester to a Db2 for z/OS server use package-based continuous block fetch to retrieve read-only result sets from the server.

Package-based continuous block fetch can provide a performance advantage for an application in which all remote SQL statements are read-only queries.

When DRDACBF is specified, the SQL queries in the package that access remote sites must be read-only. Remote UPDATE, DELETE, INSERT and MERGE statements are not allowed. If the application executes a remote statement that creates a unit of recovery on a remote server, the SQL statement fails.

Specify DRDACBF only for packages that meet both of the following conditions:

  • The packages are bound on Db2 for z/OS requesters, when application compatibility is set to V11R1 or later.
  • The packages connect to Db2 for z/OS servers. When DRDACBF is specified for packages that connect to other types of servers, unpredictable behavior might occur.

Default values for DBPROTOCOL

Process Default value
BIND PLAN DRDA
BIND PACKAGE DRDA
REBIND PLAN DRDA
REBIND PACKAGE DRDA

Catalog records for DBPROTOCOL

See the DBPROTOCOL columns in SYSPACKAGE catalog table and SYSPLAN catalog table.