PH50704: ADD DB2OPT APPLCOMPAT_RTN_PKG TO DSNTIJRT / DSNTRIN

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ADD DB2OPT APPLCOMPAT_RTN_PKG TO DSNTIJRT / DSNTRIN
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS and Db2 13 for z/OS                      *
  * users of the following:                                      *
  * o Db2 installation CLIST                                     *
  * o Db2 installation job DSNTIJRT                              *
  *   and program DSNTRIN                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DSNTIJRT/DSNTRIN has no provision                            *
  * for specifying the APPLCOMPAT bind                           *
  * option when binding the Db2-supplied                         *
  * routines packages.                                           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Program DSNTRIN is called by job DSNTIJRT to install and
  configure Db2-supplied routines (stored procedures and UDFs),
  including the Db2 objects, such as databases, used by the
  routines. It also detects and corrects missing and down-level
  SQL objects and packages for Db2-supplied routines.
  
  Currently, DSNTRIN binds the package for a routine when
  any of the following conditions is true:
  o  Package does not exist for current DBRM
  o  Package exists for current DBRM but it is not valid
     (SYSIBM.SYSPACKAGE.VALID not 'Y') or it cannot be
     allocated (SYSIBM.SYSPACKAGE.OPERATIVE not 'Y')
  
  The BIND statements generated and executed by DSNTIJRT/DSNTRIN
  do not specify an APPLCOMPAT bind option. Therefore, the
  APPLCOMPAT bind setting defaults to the APPLCOMPAT subsystem
  parameter setting.
  
  However, customers may prefer that the BIND statements be
  generated with a user-specified APPLCOMPAT bind option.
  

Problem conclusion

Temporary fix

Comments

• This APAR modifies DSNTIJRT/DSNTRIN to enable the following
  new behavior/features:
  o Allow users to specify an APPLCOMPAT bind option which
    DSNTIJRT/DSNTRIN will specify in the BIND statements it
    generates for Db2-supplied routines packages.
  o Ensure that all Db2-supplied routines packages are
    bound with the same user-specified APPLCOMPAT level by
    rebinding the packages with the user-specified APPLCOMPAT
    and PLANMGMT bind options when their APPLCOMPAT setting
    does not match the user-specified APPLCOMPAT bind setting.
  
  The settings for the APPLCOMPAT and PLANMGMT bind options
  are specified using the following two new DSNTIJRT/DSNTRIN
  optional configuration (DB2OPT) keyword parameters
  respectively:
  o RTN_PKG_APPLCOMPAT
    Specifies the APPLCOMPAT setting for the BIND and REBIND
    statements generated by DSNTIJRT/DSNTRIN for packages of
    Db2-supplied routines. Valid values are:
  
    - DEFAULT
      DSNTIJRT/DSNTRIN continues to bind packages without
      specifying an APPLCOMPAT bind option and does not do any
      rebinds. This is the existing DSNTRIN behavior, and it
      remains the default behavior.
  
      DEFAULT is assumed if this parameter is not specified.
  
    - Any of the following valid APPLCOMPAT bind settings, as
      described in the Db2 for z/OS Command Reference manual:
      o V11R1
      o VvvRrMmmm (Valid Db2 function level that is equivalent
                   to or lower than the current function level
                   of the Db2 subsystem)
  o RTN_PKG_PLANMGMT
    Specifies the PLANMGMT rebind option for the REBIND
    statements generated by DSNTIJRT/DSNTRIN for packages of
    Db2-supplied routines. Valid values are:
  
    - DEFAULT
      DSNTIJRT/DSNTRIN does not specify the PLANMGMT rebind
      option in the generated REBIND statements.
  
      DEFAULT is assumed if this parameter is not specified.
  
    - Any of the following valid PLANMGMT rebind settings, as
      described in the Db2 for z/OS Command Reference manual:
      o BASIC
      o EXTENDED
      o OFF
  
    If RTN_PKG_APPLCOMPAT is set to DEFAULT or it is not
    specified, RTN_PKG_PLANMGMT must also be set to DEFAULT
    or not specified.
  
  The example below shows how to specify RTN_PKG_APPLCOMPAT and
  RTN_PKG_PLANMGMT in job DSNTIJRT, with their default
  settings:
  
    //DSNTRIN EXEC PGM=DSNTRIN,COND=(4,LT),
    //             PARM=('Db2SSN(!DSN!) MODE(INSTALL)',
    //             ' AUTHID(!AUTHID!) SECDEFID(!SECDEFID!)',
    //             ' DEFPKOWN(!DEFPKOWN!)')
    . . .
    //DB2OPT   DD  *
      STOGROUP(SYSDEFLT)
      INDEXSTOG(SYSDEFLT)
      BP4K(BP0)
      BP8K(BP8K0)
      BP16K(BP16K0)
      BP32K(BP32K)
      LOBBP8K(BP8K0)
      LOBBP16K(BP16K0)
      LOBBP32K(BP32K)
      IMS_SECURITY(Db2)
      MQ_SECURITY(Db2)
      SOAP_SECURITY(Db2)
      RTN_PKG_APPLCOMPAT(DEFAULT)
      RTN_PKG_PLANMGMT(DEFAULT)
  
  This APAR also modifies the following Db2 installation CLIST
  panels:
  o DSNTIPM5 (Z/OSMF JCL TEMPLATE CUSTOMIZATION)
    - Transfer the following fields to panel DSNTIPG1:
      o STORAGE GROUP FOR DATABASE AND TABLESPACE
      o STORAGE GROUP FOR INDEX
  
  o DSNTIPG1 (INSTALLATION PREFERENCES PANEL 2):
    - Add the following four new fields:
      o DATABASE AND TABLESPACE STORAGE GROUP  (formerly field
        STORAGE GROUP FOR DATABASE AND TABLESPACE on DSNTIPM5)
        - Specifies the DB2OPT parameter STOGROUP setting in
          job DSNTIJRT.
      o INDEX STORAGE GROUP  (formerly field STORAGE GROUP FOR
        INDEX on DSNTIPM5)
        - Specifies the DB2OPT parameter INDEXSTOG setting in
          job DSNTIJRT.
      o PKG APPLCOMPAT
        - Specifies the DB2OPT parameter RTN_PKG_APPLCOMPAT
          setting in job DSNTIJRT.
      o PKG PLANMGMT
        - Specifies the DB2OPT parameter RTN_PKG_PLANMGMT
          setting in job DSNTIJRT.
  

APAR Information

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

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

  UI90767 UI90768

Modules/Macros

• DSNTXAZP DSN@RIN  DSNTIWPC DSNTIDXA DSNTIJRT DSNTINS1 DSNTINST
  DSNTIDXC DSNTIDXB DSNTINM1 DSNTIVMN DSNTIPM5 DSNTIWMN DSNTIVIN
  DSNTIPG1 DSNTIWMS DSNTIVMS DSNTIWIN DSN@XAZP DSNTRIN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI90767

     UP23/03/08 P F303

• RD10 PSY UI90768

     UP23/03/08 P F303

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.