A fix is available
APAR status
Closed as program error.
Error description
Miscellaneous improvements and bugfixes: 1) Support of DDL "CREATE OR REPLACE" syntax for Db2 V12 FL507. 2) Support of Huffman compression for log analysis operations. 3) Performance improvements for advanced/redirected recovery. 4) Control file reports are improved to include more detailed information. 5) Incorrect plans were generated for some scenarios including ALTER ADD PARTITION. 6) Other infrastructure improvements for recovery plan and JCL generation.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Miscellaneous improvements and * * bugfixes: * * * * 1- Support of DDL "CREATE OR REPLACE" * * syntax for Db2 12 function level * * 507. * * 2- Support of Huffman compression for * * log analysis operations. * * 3- Performance improvements for * * advanced/redirected recovery. * * 4- Control file reports are improved to * * include more detailed information. * * 5- Incorrect plans were generated for * * some scenarios including * * ALTER ADD PARTITION. * * 6- Other infrastructure improvements * * for recovery plan and JCL generation * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
PH28295
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
2020-08-11
Closed date
2020-08-28
Last modified date
2020-10-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71307
Modules/Macros
ARY#A001 ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP ARY#ADIS ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALLO ARY#AMIN ARY#ASYS ARY#AUMX ARY#CARD ARY#CHKR ARY#CLLS ARY#CMET ARY#CMTS ARY#CNTL ARY#CPNT ARY#CPOL ARY#DSA ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENCR ARY#ENQS ARY#ENVF ARY#FCPY ARY#HSA ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA ARY#IERR ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP ARY#ILRA ARY#ILRS ARY#ILSA ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPL ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#LGAA ARY#LGAC ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#MAIN ARY#MDRV ARY#MLOG ARY#MMGR ARY#MREP ARY#MTIO ARY#OBRP ARY#OS ARY#PRNG ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP ARY#RUNT ARY#STAT ARY#SUBD ARY#SUBX ARY#SYSC ARY#TRS ARY#TUTL ARY#UTLS ARY#VERS ARY#VSM ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$ACCS ARY$BOOT ARY$MREP ARY$ZPAR ARY3MEPI ARY3MEPL ARY@FD28 ARY@FFN8 ARY@FSP ARY@MNT ARYA00 ARYA01 ARYA02 ARYA03 ARYA04 ARYA05 ARYA06 ARYA07 ARYA08 ARYA09 ARYA10 ARYA11 ARYA12 ARYA13 ARYA14 ARYA15 ARYA16 ARYA17 ARYA18 ARYA19 ARYA20 ARYA21 ARYA22 ARYA23 ARYA30 ARYA31 ARYA32 ARYA33 ARYA34 ARYA35 ARYA36 ARYA40 ARYA41 ARYA42 ARYA43 ARYA44 ARYA45 ARYA46 ARYA47 ARYA48 ARYA49 ARYA50 ARYA51 ARYA52 ARYA53 ARYA54 ARYA55 ARYA56 ARYA57 ARYA58 ARYA59 ARYA60 ARYA61 ARYA62 ARYA63 ARYA64 ARYA65 ARYA66 ARYA67 ARYA68 ARYA69 ARYA70 ARYA71 ARYA72 ARYA73 ARYA74 ARYAC ARYACD02 ARYAFER ARYAFPS ARYAFVL ARYAFWC ARYAFWR ARYALL99 ARYALOG ARYAPOST ARYBABAL ARYBABCK ARYBABIP ARYBABOB ARYBABOI ARYBABSC ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBAICG ARYBAMRR ARYBAOEN ARYBARPA ARYBARPD ARYBBADM ARYBBASL ARYBBCFO ARYBBCK ARYBBCOS ARYBBCSL ARYBBERS ARYBBGLO ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBIEN ARYBBIPM ARYBBIPS ARYBBISL ARYBBJCL ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOSC ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPI ARYBBPLN ARYBBQTA ARYBBQTJ ARYBBRA ARYBBRMA ARYBBRPC ARYBBSYS ARYBBTDM ARYBBTPS ARYBBTRS ARYBBTSJ ARYBBTSL ARYBBTSS ARYBBTUJ ARYBBUCD ARYBBUCI ARYBBUCL ARYBBUCO ARYBBUCR ARYBBUDC ARYBBUES ARYBBUGC
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI71307
UP20/09/02 P F009
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]
Document Information
Modified date:
12 February 2021