A fix is available
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 number
PH42008
Reported component name
IDAA FOR ZOS
Reported component ID
5697AQT00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-11-10
Closed date
2021-11-11
Last modified date
2021-12-01
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.
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"510"}]
Document Information
Modified date:
02 December 2021