PH28442: ALLOW TO CHOOSE BETWEEN FAST AND SECURE PROCESSING OF INPUT IMAGE COPIES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The correct processing of an image copy requires to take into
  account some information on how it was created. The needed
  information can be specified by the user with the INLINE or
  COPYTOCOPY or FLASHCOPY options. It is retrieved from the Db2
  catalog when the COPYDDN LAST_IC/-integer option is specified.
  It can also be retrieved from the Db2 catalog if the CHECK
  option is specified. The processing of regular image copies - an
   image copy created by the Db2 IBM COPY or any compliant utility
   - is faster than the processing of other kinds of image copies
  that usually require a sort before the actual unload process.
  
  When Db2 HPU does not have the needed information, it always
  process the image copy as a regular one which can lead to an
  improper processing with potential ABENDs or incorrect unloaded
  data.
  
  Db2 HPU should allow to specify how to process the image copy if
  the information needed to determine the correct process is
  neither provided by the user nor retrieved from the Db2 catalog.
  -------------------
  
  The planned implementation is as follows.
  
  A new option at the GLOBAL level whould be added :
  --------------
  
    +- IC_PROCESSING -- value of Vxxxnnn/ICPROCES --+
  >-+- IC_PROCESSING--+-----------------------------+->
                      +- SAFE ----------------------+
                      +- FAST ----------------------+
  
  IC_PROCESSING
  
  The correct processing of an image copy requires to take into
  account some information on how it was created. The needed
  information can be specified by the user with the INLINE or
  COPYTOCOPY or FLASHCOPY options. It is retrieved from the Db2
  catalog when the COPYDDN LAST_IC/-integer option is specified.
  It can also be retrieved from the Db2 catalog if the CHECK
  option is specified. The processing of regular image copies - an
  image copy created by the Db2 IBM COPY or any compliant utility
  - is faster than the processing of other kinds of image copies
  that usually require a sort before the actual unload process.
  This option allows to specify how to process the image copy if
  the information needed to determine the correct process is
  neither provided by the user nor retrieved from the Db2 catalog.
  Specify either of the following value:
  
  - FAST: the fastest process is chosen.
  - SAFE: a process valid for any kind of image copy but not the
  optimal one in terms of performance is chosen to guarantee a
  correct processing of the image copy.
  --------------
  
  A new parmlib parameter would be added.
  
  --------------
  Process to apply to image copies of undetermined origin
  (Vxxxnnn/ICPROCES)
  
  The correct processing of an image copy requires to take into
  account some information on how it was created. The needed
  information can be specified by the user with the INLINE or
  COPYTOCOPY or FLASHCOPY options. It is retrieved from the Db2
  catalog when the COPYDDN LAST_IC/-integer option is specified.
  It can also be retrieved from the Db2 catalog if the CHECK
  option is specified. The processing of regular image copies - an
  image copy created by the Db2 IBM COPY or any compliant utility
  - is faster than the processing of other kinds of image copies
  that usually require a sort before the actual unload process.
  This optional parameter applies if the IC_PROCESSING option is
  not specified and allows to specify how to process the image
  copy if the information needed to determine the correct process
  is neither provided by the user nor retrieved from the Db2
  catalog. Specify either of the following value:
  
  - FAST: the fastest process is chosen.
  - SAFE: a process valid for any kind of image copy but not the
  optimal one in terms of performance is chosen to guarantee a
  correct processing of the image copy.
  
  The default value is FAST.
  The corresponding SYSIN parameter is IC_PROCESSING in the GLOBAL
  OPTIONS block.
  This parameter is also referred to as Vxxxnnn/ICPROCE.
  --------------
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The correct processing of an image copy *
  *                      requires to take into account some      *
  *                      information on how it was created. The  *
  *                      needed information can be specified by  *
  *                      the user with the INLINE or COPYTOCOPY  *
  *                      or FLASHCOPY options. It is retrieved   *
  *                      from the Db2 catalog when the COPYDDN   *
  *                      LAST_IC/-integer option is specified.   *
  *                      It can also be retreived from the Db2   *
  *                      catalog if the CHECK option is          *
  *                      specified. The processing of regular    *
  *                      image copies - an image copy created by *
  *                      the Db2 IBM COPY or any compliant       *
  *                      utility - is faster than the processing *
  *                      of other kinds of image copies that     *
  *                      usually require a sort before the       *
  *                      actual unload process.                  *
  *                                                              *
  *                      When Db2 HPU does not have the needed   *
  *                      information, it always process the      *
  *                      image copy as a regular one which can   *
  *                      lead to an improper processing with     *
  *                      potential ABENDs or incorrect unloaded  *
  *                      data.                                   *
  *                                                              *
  *                      Db2 HPU should allow to specify how to  *
  *                      process the image copy if the           *
  *                      information needed to determine the     *
  *                      correct process is neither provided by  *
  *                      the user nor retreived from the Db2     *
  *                      catalog.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Allow to choose between fast and secure processing of input
  image copies.
  

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 INZBIND  INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI75101

     UP21/05/07 P F105

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.