PH41241: UNEXPECTED BEHAVIOR OF PARMLIB PARAMETER VUU028/ULQSCEBH TRY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The HPU behavior when the following conditions are fulfilled is
  not the documented :
  - Unload in native mode
  - QUIESCE is requested either by the QUIESCE parameter in the
  SYSIN command or by the VUU013/ULQSCE parameter
  - The parmlib parameter VUU028/ULQSCEBH is set to TRY
  - The tablespace to be unloaded has a Db2 status that prohibit
  the QUIESCE utility (COPY PENDING for example)
  
  The expected behavior is as following :
  If LOCK NO is coded in SYSIN (or in PARMLIB and not overridden
  by the SYSIN), and if the QUIESCE is not possible, then HPU will
  issue a warning message and do the unload without doing the
  QUIESCE.
  If LOCK YES is coded and if the QUIESCE is not possible, then
  HPU will issue an error message and terminate.
  
  The incorrect behavior is :
  - in 5.1
  If LOCK NO is requested : return code 8 and error message
  INZU406E
  INZU406E THE REQUESTED QUIESCE OF THE TABLESPACE COULD NOT BE
  PERFORMED.
  CHECK DB2 STATUS OF THE TABLESPACE AND RELATED INDEXES
  
  If LOCK YES is requested : the QUIESCE is not processed and data
  is unloaded and the error message INZU406E is issued
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU incorrectly handles the         *
  *                      exception where the QUIESCE utility     *
  *                      requested by an unload cannot be        *
  *                      performed and the VUU028/ULQSCEBH       *
  *                      parmlib parameter is set to TRY.        *
  *                                                              *
  *                      The erroneous behavior, described       *
  *                      below, depends on whether LOCK NO or    *
  *                      LOCK YES applies to the concerned       *
  *                      unload:                                 *
  *                      - case 1) if LOCK NO aplies, the unload *
  *                      issues the INZU406E THE REQUESTED       *
  *                      QUIESCE OF THE TABLESPACE COULD NOT BE  *
  *                      PERFORMED error message, stops in error *
  *                      (completion code 8) and thus unloads    *
  *                      no data.                                *
  *                      - case 2) if LOCK YES applies, the      *
  *                      unload issues INZU406E THE REQUESTED    *
  *                      QUIESCE OF THE TABLESPACE COULD NOT BE  *
  *                      PERFORMED error message and stops in    *
  *                      error (completion code 8) as expected   *
  *                      but unduly unloads data                 *
  *                                                              *
  *                      The expected behavior is the following  *
  *                      one:                                    *
  *                      - case 1) the unload issues the ????    *
  *                      xxxxxxxxx warning message, unloads the  *
  *                      data and completes with code 4          *
  *                      - case 2) the unload issues INZU406E,   *
  *                      stops in error and thus unloads no data *
  *                                                              *
  *                      The issue occurs when all the following *
  *                      conditions are fullfiled is not the     *
  *                      documented :                            *
  *                      - the parmlib parameter VUU028/ULQSCEBH *
  *                      is set to TRY QUIESCE YES is requested  *
  *                      for the unload - either through         *
  *                      - the QUIESCE option or the             *
  *                      VUU013/ULQSCE parmlib parameter         *
  *                      - the unload is run in native mode      *
  *                      - the tablespace to be unloaded has a   *
  *                      Db2 status that prohibits the QUIESCE   *
  *                      utility (COPY PENDING for example)      *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Unexpected behavior if parmlib parameter VUU028/ULQSCEBH TRY and
  QUIESCE cannot be performed
  

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:

  UI78345

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI78345

     UP21/12/10 P F112

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.