PM30928: ABEND0C4-10 IN IKJEF02R+EC WHEN USING THE DB2 BIND COMMAND WITH THE GENERIC AND A LONG PARAMETER VALUE 11/01/20 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Issuing a BIND command with the GENERIC keyword causes a storage
  overlay and an ABEND0C4 RC00000010 in IKJEF02R  OFFSET00EC 00EC
  An overlay is caused any time the GENERIC keyword is used, but
  an ABEND occurs only when lengthy parameters are coded, such as
  this:
  BIND PACKAGE(ABC) OWNER(DEF) ENCODING(EBCDIC)
  KEEPDYNAMIC(YES) MEMBER(GHI) RELEASE(COMMIT)
  ACTION(REPLACE) ISOLATION(CS) VALIDATE(RUN)
  GENERIC('OPT1 VAL1 OPT2 VAL2 OPT3 VAL3 OPT4 VAL4 OPT5 VAL5
  OPTC VALC OPTD VALD OPTE VALE')
  A loop can also occur if the passed parms are greater than
  4096 bytes (the maximum length allowed)
  
  Keywords: SMCOVERLAY DB2OVRLAY/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who use BIND/REBIND PACKAGE    *
  *                 command with the GENERIC option.             *
  *                 The problem affects those who have           *
  *                 PM15908/UK63208 applied.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR addresses 3 problems when     *
  *                      using the GENERIC bind option:          *
  *                       1. Issuing a BIND or REBIND PACKAGE    *
  *                          command with the GENERIC keyword    *
  *                          causes a storage overlay in DB2,    *
  *                          and may cause the following abend:  *
  *                            ABEND0C4 RC10 in IKJEF02R         *
  *                            OFFSET00EC 00EC                   *
  *                       2. DB2 only reads the first 256 bytes  *
  *                          of the GENERIC input parameter if   *
  *                          the parameter is greater than 256   *
  *                          bytes.                              *
  *                       3. DB2 may also hang if the input      *
  *                          parameter of the GENERIC option is  *
  *                          greater than 4096 bytes.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There are three problems identified:
   1. When BIND or REBIND a package with the GENERIC option, DB2
      fails to allocate storage for the option, and may abend
      afterwards.
   2. If the GENERIC option parameter is greater than 256 bytes,
      DB2 may only take the first 256 bytes of the parameter, and
      ignore the rest due to an incorrect move of the input.
   3. Finally, DB2 fails to check the maximum length of the passed
      in parameter of the GENERIC option which results in a DB2
      hang if the parameter has a length greater than the maximum
      value.
  

Problem conclusion

• DB2 has been fixed to allocate storage for the GENERIC option,
  check the maximum length of the input parameter, and
  correctly copy the complete parameter.
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK65465

Modules/Macros

• DSNECP00 DSNECP08 DSNECP44 DSNECP45 DSNTBAP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK65465

     UP11/03/22 P F103 ®

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.