PM28648: GENERIC BIND OPTION ENHANCEMENTS FOR REPLICATOR

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• DB2DDF defect pm28648 dpm28648
  Generic bind option enhancements for replicator
  **************************************
  Additional symptoms and keywords:
   SQLCODE20 SQLCODE+20 +20 SQLC20 SRC20
   SQLCODE-30104 SQLCODE30104N SQL30104N SRCN30104 -30104
   GENERIC BIND option
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Distributed Data Facility (DDF) users.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: One of the following symptoms may       *
  *                      occur:                                  *
  *                      . When performing a remote bind from a  *
  *                        DB2 for z/OS requester, it is         *
  *                        impossible to specify bind options    *
  *                        supported by the target server unless *
  *                        they are also supported by DB2.       *
  *                      . DB2 for z/OS server returns SQLCODE   *
  *                        -30104 and terminates bind processing *
  *                        for unrecognized options during       *
  *                        remote bind processing.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Two requirements are addressed by this APAR:
  
  1. DB2 for z/OS requester validates all options for remote binds
  before sending the bind request to the server.  This prevents
  DB2 from sending bind options supported by the target server
  unless those same options are also recognized by DB2.  A new
  function is needed to allow specification of BIND and REBIND
  options supported by the target server without requiring DB2 to
  recognize them.
  
  2. DB2 for z/OS server returns SQLCODE -30104 and terminates
  bind processing for unrecognized bind options during remote bind
  processing.  This behavior is inconsistent with other DB2 family
  members which return SQLCODE +20 for unrecognized bind options.
  

Problem conclusion

Temporary fix

Comments

• Two new functions are provided by this APAR:
  
  1. DB2 for z/OS requester adds a new GENERIC keyword to the
  BIND PACKAGE and REBIND PACKAGE commands.  This allows the
  specification of bind options that are defined and supported by
  the target server, but which are not supported by DB2 for z/OS
  as BIND or REBIND PACKAGE command options.
  
  2. DB2 for z/OS server is changed to return SQLCODE +20 and
  continue processing the bind or rebind command when unrecognized
  options are received for consistency with DB2 family behavior.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK74929

Modules/Macros

• DSNECP00 DSNECP08 DSNECP44 DSNECP45 DSNLXRCM
  DSNLXRCS DSNLZOBO DSNTBAP  DSNTBAR  DSNTBAS2 DSNTBCM  DSNTBSPL
  DSNTBTRG DSNTIAM  DSNTIA1  DSNTZSCA DSNXEFDA DSNXESQL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK74929

     UP12/01/04 P F201

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.