Using DBProtocol(DRDA) on a Plan

Greg Jonas

Using DBProtocol(DRDA) on a Plan
If a plan is bound with DBPROTOCOL(DRDA) coded, will that override packages
that have been bound which picked up our default of private protocol? If
DB2 does use the plan definition, how does it determine that a package
explicitly was bound with private protocol, or just picked up the default?
Both appear in SYSPackage with DBPROTOCOL = 'P' with nothing apparent that
tells you if it was coded explicitly. Does DB2 use the directory to resolve
what was coded explicitly vs. picked up by default?

Thanks
Greg



Mike Turner

Using DBProtocol(DRDA) on a Plan
(in response to Greg Jonas)
Greg

Package always overrides plan. Following is an extract from the V7 Command
Reference description of the DBPROTOCOL bind option:

'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.'

Regards
Mike Turner
Email: [login to unmask email]
Web: www.michael-turner.ltd.uk

Message text written by DB2 Data Base Discussion List
>If a plan is bound with DBPROTOCOL(DRDA) coded, will that override
packages
that have been bound which picked up our default of private protocol? If
DB2 does use the plan definition, how does it determine that a package
explicitly was bound with private protocol, or just picked up the default?
Both appear in SYSPackage with DBPROTOCOL = 'P' with nothing apparent that
tells you if it was coded explicitly. Does DB2 use the directory to
resolve
what was coded explicitly vs. picked up by default?

Thanks
Greg
<