PH42713: FEATURE TO LOCATE LOGICAL UNLOADS RUN IN NATIVE MODE THAT INVOLVES CHAR(DECIMAL)/VARCHAR(DECIMAL)

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• In order to move from the BIF_COMPATIBILITY(V9), it is necessary
  to update the applications that exploit SELECT statement
  involving SQL expression containing CHAR(decimal_value) or
  VARCHAR(decimal_value) where decimal_value stands for any SQL
  expression which results has a DECIMAL type. For applications
  passing the SELECT statements to Db2, IFCID (376) Trace Records
  can be used to identify the application that require an update
  before moving to BIF_COMPATBILITY(CURRENT).
  This is applicable to identify the Db2 HPU logical unloads to
  update if they are run in SQL mode but does not work if they are
  run in native mode.
  Db2 HPU should offer a feature that allows to locate the unloads
  run in native mode involving SQL expression containing
  CHAR(decimal_value) or VARCHAR(decimal_value) with the
  following design.
  A parmlib parameter would allow to request that Db2 HPU issue
  messages to the MVS console as well as to the SYSPRINT dataset
  with information to locate such logical unloads.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In order to move from the               *
  *                      BIF_COMPATIBILITY(V9), it is necessary  *
  *                      to update the applications that exploit *
  *                      SELECT statement involving SQL          *
  *                      expression containing                   *
  *                      CHAR(decimal_value) or                  *
  *                      VARCHAR(decimal_value) where            *
  *                      decimal_value stands for any SQL        *
  *                      expression which results have a DECIMAL *
  *                      type. For applications passing the      *
  *                      SELECT statements to Db2, IFCID (376)   *
  *                      Trace Records can be used to identify   *
  *                      the application that require an update  *
  *                      before moving to                        *
  *                      BIF_COMPATBILITY(CURRENT).              *
  *                      This is applicable to identify the Db2  *
  *                      HPU logical unloads to update if they   *
  *                      are run in SQL mode  but does not work  *
  *                      if they are run in native mode.         *
  *                                                              *
  *                      Db2 HPU should offer a feature that     *
  *                      allows to locate the unloads run in     *
  *                      native mode involving SQL expression    *
  *                      containing CHAR(decimal_value) or       *
  *                      VARCHAR(decimal_value). with the        *
  *                      following design.                       *
  *                                                              *
  *                      A parmlib parameter would allow to      *
  *                      request that Db2 HPU issue messages to  *
  *                      the MVS console as well as to the       *
  *                      SYSPRINT dataset with information to    *
  *                      locate such logical unloads.            *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Feature to locate logical unloads run in native mode that
  involve CHAR(decimal)/VARCHAR(decimal)
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• INZ$$PRM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI79279

     UP22/03/01 P F202

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.