PH39300: LOAD INLINE COPY ENHANCEMENT FOR SEQUENTIAL IMAGE COPIES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• A sequential image copy produced during LOAD REPLACE will not
  contain updates made to the table space to correct unique index
  violations during INDEXVAL phase or referential constraint
  violations during the ENFORCE phase.
  LOAD will be changed to include the changed data pages caused by
  updates in the INDEXVAL and ENFORCE phases, and therefore
  keeping the sequential image copy consistent with the database
  objects affected by the LOAD statement.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users for LOAD REPLACE                   *
  * SHRLEVEL NONE or REFERENCE with COPYDDN                      *
  * or RECOVERDDN.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A sequential image copy produced                             *
  * during a LOAD REPLACE utility                                *
  * operation does not contain updates                           *
  * made to the table space to correct                           *
  * unique index violations during                               *
  * INDEXVAL phase or referential                                *
  * constraint violations during the                             *
  * ENFORCE phase.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Currently it is not recommended to use the sequential image
  copy produced by LOAD REPLACE  as a recovery point. A
  sequential inline image copy is created before the INDEXVAL
  and ENFORCE phases are executed, and any deletion of records
  because of unique index or referential integrity constraint
  violations are not in the sequential image copy.
  

Problem conclusion

Temporary fix

Comments

• LOAD REPLACE SHRLEVEL NONE or REFERENCE is modified so that
  requested sequential inline image copies include any changed
  data pages caused by updates during the INDEXVAL and ENFORCE
  phases. Sequential image copies are requested by the existing
  LOAD options COPYDDN and RECOVERYDDN. For the case where
  ENFORCE YES and INDEXDEFER NONE is specified, this full
  image copy can be used safely as a recovery point. This
  enhancement does not require any new keyword to be
  specified.
  This APAR also introduces a new TTYPE column value in
  SYSIBM.SYSCOPY. When ICTYPE=F and STYPE=R, a new TTYPE value
  of V indicates that this inline sequential image copy
  created by LOAD contains pages updated during the INDEXVAL
  and ENFORCE phases. Rows that were loaded with unique index
  violations, referential constraint violations, or index
  evaluation errors were removed from pages in the image copy.
  The image copy can be safely used with point-in-time
  recovery and RECOVER will no longer issue warning message
  DSNU527I in this scenario.
  ×**** PE23/06/23 FIX IN ERROR. SEE APAR PH53119  FOR DESCRIPTION
  

APAR Information

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

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

  UI78743

Modules/Macros

• DSNURELD DSNURENF DSNURILD DSNURVAL DSNURVIX DSNUGRAR DSNUGUTC
  DSNURRRI DSNUCATO DSNURCCP DSNURECS DSNUGUCA DSNURCRI DSNUCASA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI78743

     UP21/12/31 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.