A fix is available
APAR status
Closed as program error.
Error description
XML issue was found concerning DOCiD column in a redirected recovery scenario. If recovering to an alternate space that contains an XML column and if INSERT is done to it after a redirected recovery - an error occurs. The table is available for select processing - but INSERTs are not possible. This will also fix an issue with SYSTRING when recovering across different DB2s.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: XML issue was found concerning DOCiD * * column in a redirected recovery * * scenario. If recovering to an * * alternate space that contains an XML * * column and if INSERT is done to it * * after a redirected recovery - an error * * occurs. The table is available for * * select processing - but INSERTs are * * not possible. This will also fix an * * issue with SYSTRING when recovering * * across different DB2s. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI84411
Reported component name
DB2 REC EXPERT
Reported component ID
5697H7400
Reported release
320
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-12
Closed date
2017-08-07
Last modified date
2017-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI49367
Modules/Macros
ARY#AMIN ARY#ASYS ARY#CARD ARY#CHKR ARY#CNTL ARY#CPNT ARY#CPOL ARY#DSPL ARY#ENQS ARY#FCPY ARY#ICAL ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRDR ARY#LRD6 ARY#MAIN ARY#MLOG ARY#OBRP ARY#PRNG ARY#RANG ARY#RPRP ARY#RUNT ARY#SUBD ARY#SUBX ARY#SYSC ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLS ARY#XMLU ARY@RDCL ARYBIND1 ARYEQUAL H30R320J
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI49367
UP17/08/30 P F708
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":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQTW","label":"Db2 Recovery Expert"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 September 2017