DBPROTOCOL bind option
The DBPROTOCOL option specifies the protocol to be used when connecting to a remote site that is identified by a three-part name statement. The only value allowed is DRDA.
| DBPROTOCOL |
|
On: BIND and REBIND
PLAN and PACKAGE
|
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.
If you specify either OPTIONS(COMPOSITE)
or OPTIONS(COMMAND) on the BIND PACKAGE COPY command, DB2® always uses DBPROTOCOL(DRDA) to create the target package, regardless
of the DBPROTOCOL option that was used to create the source package
that you specified in the COPY parameter.
If you specify an option on the BIND PACKAGE command, DB2 uses that remote access method for the package statements, regardless of the BIND PLAN option. For remote bind, the default is the system default at the remote site.
If you specify an option on the BIND PLAN statement, that information is stored in table SYSPLAN.
- (DRDA)
- DBPROTOCOL(DRDA) is passed
on BIND PACKAGE, BIND PLAN, REBIND PACKAGE, or REBIND PLAN invocation.
| Process | Default value |
|---|---|
| BIND PLAN | DRDA |
| BIND PACKAGE | DRDA |
| REBIND PLAN | DRDA |
| REBIND PACKAGE | DRDA |
Catalog record: Column DBPROTOCOL of tables SYSPACKAGE and SYSPLAN.