PI54678: ADD PARMLIB PARM TO FORCE THE QUIESCE YES OPTION WHEN UNLOAD OF A LOB COLUMN RATHER THAN ABENDU1133

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ABENDU1133 may occur in unload of a LOB column, that has had
  recent updates, if QUIESCE YES was not specified.
  
  When unloading a LOB column, if the QUIESCE NO option applies
  (explicitly specified or via the DB2 HPU settings), ABENDU1133
  might occur because of a lack of consistency affecting the LOB
  index.
  
  This occurs if the object has recently been updated
  especially if LOB data has been inserted.
  
  For a reliable unload of LOB columns, the QUIESCE YES
  is needed.
  
  Therefore, DB2 HPU should have a parameter to force the
  safe behavior/processing, so invoke the QUIESCE
  utility when the unload of a LOB column is requested.
  
  PB12930 ABENDU1133 U1133 ABEND 1133
  

Local fix

• Specify QUIESCE YES to ensure consistency and avoid the U1033
  ABEND.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload z/OS.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When unloading a LOB column, if the     *
  *                      QUIESCE NO option applies (explicitly   *
  *                      specified or via the DB2 HPU settings), *
  *                      ABENDU1133 might occur because of a     *
  *                      lack of consistency affecting the LOB   *
  *                      index.  This occurs if the object has   *
  *                      recently been updated especially if     *
  *                      LOB adata has been inserted. For a      *
  *                      reliable unload of LOB columns, the     *
  *                      QUIESCE YES is needed. Therefore, DB2   *
  *                      HPU should have a parameter to force    *
  *                      the safe behavior/processing, i.e.      *
  *                      invoking the QUIESCE utility when the   *
  *                      unload of a LOB column is requested.    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  N/A (enhancement)
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

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$$CCQ INZ$$PRM INZCHECK INZQRYV8 INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI37094

     UP16/04/20 P F604

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.