PH69802: MORE RIGOROUS HANDLING OF RETURN CODE FROM QUIESCE FROM 0 TO 4

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 HPU invokes the Db2 QUIESCE utility when it needs to make
  sure the Db2 dataset(s) from the tablespace being unloaded
  contain(s) consistent data. The QUIESCE utility, run with the
  WRITE YES option, against the involved tablespace complies with
  this requirement only if it ends with a return code 0. An end of
  the QUIESCE with return code 4 can mean that the utility did not
  succeed in externalizing the DB2 buffers to the VSAM datasets.
  
  As DB2 HPU initial design considered return codes less than or
  equal to 4 as sufficient to ensure the QUIESCE had completed
  normally and externalized the Db2 buffers to the VSAM datasets,
  the requirement regarding the completion of the QUIESCE must be
  changed so that any return code greater than 0 is considered as
  an error and makes the unload fail.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: Db2 HPU invokes the Db2 QUIESCE utility *
  *                      when it needs to make sure the Db2      *
  *                      dataset(s) from the tablespace being    *
  *                      unloaded contain(s) consistent data.    *
  *                      The QUIESCE utility, run with the WRITE *
  *                      YES option, against the involved        *
  *                      tablespace complies with this           *
  *                      requirement only if it ends with a      *
  *                      return code 0. An end of the QUIESCE    *
  *                      with return code 4 can mean that the    *
  *                      utility did not succeed in              *
  *                      externalizing the DB2 buffers to the    *
  *                      VSAM datasets.                          *
  *                                                              *
  *                      As DB2 HPU initial design considered    *
  *                      return codes less than or equal to 4 as *
  *                       sufficient to ensure the QUIESCE had   *
  *                       completed normally and externalized    *
  *                       the Db2 buffers to the VSAM datasets,  *
  *                       the requirement regarding the          *
  *                       completion of the QUIESCE must be      *
  *                       changed so that any return code        *
  *                       greater than 0 is considered as an     *
  *                       error and makes the unload fail.       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  More rigourous handling of return code from QUIESCE from 0 to 4
  

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

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UO07025

     UP26/03/06 P F603  

• R610 PSY UO07026

     UP26/03/06 P F603  

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.