PK71993: INEFFICIENT 'UPDATE NOT IN PLACE' LOG RECORD BY DSNIREPR. CHANGED LENGTH IS ZERO CAUSING ERRORS IN LOG ANALYSIS TOOLS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DSNIREPR inefficently writes an UPDATE NOT IN PLACE log record
  with a changed data length of zeroes:
  0123B0EF4A71  URID(0123B0EF459D)  LRSN(C2D821B19705)  DBID(010B)
                OBID(000F)  PAGE(00013904)  TYPE( UNDO  REDO )
                SUBTYPE(UPDATE NOT IN-PLACE , DATA PART ONLY IN A
  DATA PAGE)
                CLR(NO)  PROCNAME(DSNIREPR)    COMPRESSED DATA
       *LRH* 0046002F 06000001 0E800123 B0EF459D 0123B0EF 4A420526
  0123B0EF 4A42C2
  *LG** 88010B00 0F000139 04000123 B0EF472D 2D00
       0000  000E6101 0010C200 005D0000 0000
   --------------------------------    --------------
                                   zero length at +A
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of update triggers on varying length   *
  *                 records                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: INEFFICIENT 'UPDATE NOT IN PLACE' LOG   *
  *                      RECORD BY DSNIREPR. CHANGED LENGTH IS   *
  *                      ZERO CAUSING ERRORS IN LOG ANALYSIS     *
  *                      TOOLS.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  A before update trigger set values for columns in the row being
  updated. If the values from the trigger were the same as the
  current column data, an update log record was written, even
  though there was no other data changed in the row.
  

Problem conclusion

• DSNIREPR is changed to bypass logging, for varying length rows,
  if a before trigger that requests changes to columns in the
  current row results in no change to the data values in the row.
  
  Also, in this apar internal error codes that were duplicated
  are modified to eliminate the duplication.
  

Temporary fix

Comments

• ž**** PE09/01/29 PTF IN ERROR. SEE APAR PK79695  FOR DESCRIPTION
  

APAR Information

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

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

  UK41937 UK41938

Modules/Macros

• DSNDREP  DSNILREP DSNIRELK DSNIREPR
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK41937

     UP08/12/11 P F812

• R910 PSY UK41938

     UP08/12/11 P F812

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.