PH42008: QUERY RETURNS INCORROUT WHEN ROW IS DELETED DURING LOAD OF THE TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If a row of a table is deleted while the same table is loaded
  with
   SYSPROC.ACCEL_LOAD_TABLES, a subsequent query might return
  incorrect data.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of incremental update who load tables  *
  *                 with LOCKMODE=ROW                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: If rows are deleted from a table while  *
  *                      the same table is loaded using          *
  *                      SYSPROC.ACCEL_LOAD_TABLES with          *
  *                      LOCKMODE=ROW and DETECTCHANGES=DATA     *
  *                      some rows will not be loaded onto the   *
  *                      accelerator nor will they be            *
  *                      replicated with the incremental update  *
  *                      feature.                                *
  ****************************************************************
  * RECOMMENDATION: Install the PTF.                             *
  ****************************************************************
  In a rare scenario the data stored on the accelerator may
  differ from the data stored in Db2 for z/OS.
  

Problem conclusion

• The problem has been fixed.
  

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:

  UI78031

Modules/Macros

•    AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10
  AQTDBDBI AQTDBDYN AQTDBQIT AQTDBTRC AQTDBTRN AQTDBUNL AQTDBZPR
  AQTDEFTR AQTENV   AQTHFSCL AQTNILIC AQTNOTE  AQTSCALL AQTSCI01
  AQTSCI02 AQTSJI00 AQTSJI01 AQTSJI02 AQTSJI03 AQTSJI04 AQTSJI05
  AQTSSCHK AQTSSCPY AQTSXADD AQTSXALT AQTSXCN0 AQTSXCN1 AQTSXCN2
  AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI AQTSXSD1 AQTSXTCO AQTSXTSL
  AQTSXTSU AQTSXTS0 AQTTIJSP AQTTRIN  AQTXM313 AQT02AAC AQT02ALT
  AQT02ART AQT02ATB AQT02CAC AQT02CDC AQT02CRT AQT02ENQ AQT02FGV
  AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI AQT02GTR AQT02ISP
  AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT AQT02RRT AQT02RTB
  AQT02RTR AQT02STA AQT02SYN AQT02TCO AQT02UCR AQT02USW
  

Fix information

• Fixed component name

  IDAA FOR ZOS

• Fixed component ID

  5697AQT00

Applicable component levels

• R510 PSY UI78031

     UP21/11/13 P F111

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.