A fix is available
APAR status
Closed as program error.
Error description
This roll up APAR resolves the following issues: . 1. Permit single quotes, double quotes and '^' in object and backup profiles. 2. Add message ARY918. 3. Correct ABEND=SC03 that can occur when doing a drop recovery of a cloned object. 4. Updated the skeleton to have the option MRIOFF so an image copy from a system level backup with process the correct range. 5. Allow the user to selectively copy RUNSTATS values from source to target. 6. Retain the ADMIN_USERID in the ISPF dialog. 7. Correct DDL for random index during drop recovery. 8. Correct DDL for generation for ALTER ROTATE PARTITION. 9. Correct control file command, UPDATE ARY DSN PREFIX = NULL. 10. Correct ARYR071E error that occurs when saving the profile after the generation count has been reduced. 11. Correct the priority for implicitly selected objects. 12. Support DDL for compressed LOBs. 13. Update the ARYZ088E message to include altered objects. 14. Correct the display of the RBA/LRSN for V11 CM on panel ARYGGRPS. 15. Log the SQL warnings. 16. Allow shared access for file used during the generation of JCL for object profiles. 17. Correct error handling for the creation of new application group profiles. 18. Allow lowercase SQLID for ISPF logon. 19. Correct -803 for Mass Application profile recovery. 20. Correct an ARYR867E when adding multiple application profiles to an application group. 21. Generate a drop for implicit databases and tablespaces. 22. When different recovery strategies are used for different partitions this fix will generate the correct JCL and prevent the U0050 during job execution. 23. Remove the 'exclude' feature and the # of arch logs to copy feature implemented in PI82377. 24. ARYX066E - An XML schema violation was detected; element "syscopy-scan" value. 25. SLB Deferred object collection and multi-job offload causes child JCL error. 26. Miscellanous issues with versioned routines. 27. Restart recreated sequences and identity columns. 28. Allow mask pairs 'any mask' -> 'constant' for Redirected Recovery. 29. Infrastructure changes in DDL generator. 30. Target DDL for views is generated incorrectly during the Redirected Recovery in several cases. 31. Message ARYJ131W does not get display when multiple messages are issued. 32. Underscore character in the 'Single character wildcards' field is invisible.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This roll up APAR resolves the * * following issues: * * 1. Permit single quotes, double quotes * * and ' ' in object and backup profiles. * * 2. Add message ARY918. * * 3. Correct ABEND=SC03 that can occur * * when doing a drop recovery of a * * cloned object. * * 4. Updated the skeleton to have the * * option MRIOFF so an image copy from a * * system level backup with process the * * correct range * * 5. Allow the user to selectively copy * * RUNSTATS values from source to target. * * 6. Retain the ADMIN_USERID in the * * ISPF dialog. * * 7. Correct DDL for random index during * * drop recovery. * * 8. Correct DDL for generation for * * ALTER ROTATE PARTITION. * * 9. Correct control file command, * * UPDATE ARY DSN PREFIX = NULL. * * 10. Correct ARYR071E error that occurs * * when saving the profile after the * * generation count has been reduced. * * 11. Correct the priority for implicitly * * selected objects. * * 12. Support DDL for compressed LOBs. * * 13. Update the ARYZ088E message to * * include altered objects. * * 14. Correct the display of the * * RBA/LRSN for V11 CM on panel ARYGGRPS. * * 15. Log the SQL warnings. * * 16. Allow shared access for file used * * during the generation of JCL for * * object profiles. * * 17. Correct error handling for the * * creation of new application * * group profiles. * * 18. Allow lowercase SQLID for ISPF * * logon. * * 19. Correct -803 for Mass Application * * profile recovery. * * 20. Correct an ARYR867E when adding * * multiple application profiles to an * * application group. * * 21. Generate a drop for implicit * * databases and tablespaces. * * 22. When different recovery strategies * * are used for different partitions this * * fix will generate the correct JCL and * * prevent the U0050 during job * * execution. * * 23. Remove the 'exclude' feature and * * the # of arch logs to copy feature * * implemented in PI82377. * * 24. ARYX066E - An XML schema violation * * was detected; element "syscopy-scan" * * value. * * 25. SLB Deferred object collection and * * multi-job offload causes child JCL * * error. * * 26. Miscellanous issues with versioned * * routines. * * 27. Restart recreated sequences and * * identity columns. * * 28. Allow mask pairs 'any mask' -> * * 'constant' for Redirected Recovery. * * 29. Infrastructure changes in DDL * * generator. * * 30. Target DDL for views is generated * * incorrectly during the Redirected * * Recovery in several cases. * * 31. Message ARYJ131W does not get * * display when multiple messages * * are issued. * * 32. Underscore character in the * * 'Single character wildcards' * * field is invisible. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI86756
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-09-01
Closed date
2017-11-06
Last modified date
2017-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI51710
Modules/Macros
ARY$APMN ARY$CRMD ARY$CRQT ARY$ICSB ARY$MAIN ARY$MREP ARY#CMET ARY#DSA ARY#HSA ARY#TRS ARY#YCTL ARY@FSP ARY@MJCR ARY@MNT ARY@SNPV ARYAC ARYACONN ARYAFER ARYAFPS ARYAFVL ARYAFWC ARYAFWR ARYALOG ARYALOG2 ARYAMETL ARYARYST ARYASQLE ARYAUTIL ARYBDCT ARYBHDR ARYBLNKT ARYBPC ARYBSDM ARYBSDR ARYBSDS ARYBSQL ARYCAF ARYCAL9D ARYCAL9L ARYCAL9S ARYCAQ1D ARYCAQ1L ARYCAQ1S ARYCATF ARYCATR ARYCAUTH ARYCCT9D ARYCCT9L ARYCCT9S ARYCDB9D ARYCDB9L ARYCDB9S ARYCDC ARYCDICT ARYCDPND ARYCDPNL ARYCDPNS ARYCDTND ARYCDTNL ARYCDTNS ARYCDT0D ARYCDT0L ARYCDT0S ARYCDT1D ARYCDT1L ARYCDT1S ARYCDT9D ARYCDT9L ARYCDT9S ARYCD001 ARYCD002 ARYCFG ARYCFGRP ARYCFI ARYCFICR ARYCFIDC ARYCFIDF ARYCFIDT ARYCFIFT ARYCFIMX ARYCFIOR ARYCFIPC ARYCFIPV ARYCFIQT ARYCFIRB ARYCFISF ARYCFIXX ARYCFNND ARYCFNNL ARYCFNNS ARYCFN0D ARYCFN0L ARYCFN0S ARYCFN9D ARYCFN9L ARYCFN9S ARYCFOIC ARYCFREP ARYCFRR ARYCIXND ARYCIXNL ARYCIXNS ARYCIX0D ARYCIX0L ARYCIX0S ARYCIX1S ARYCIX2D ARYCIX2L ARYCIX2S ARYCIX9D ARYCIX9L ARYCIX9S ARYCMDR ARYCOMAT ARYCPKND ARYCPKNL ARYCPKNS ARYCPK0D ARYCPK0L ARYCPK0S ARYCPK1D ARYCPK1L ARYCPK1S ARYCPK9D ARYCPK9L ARYCPK9S ARYCPLND ARYCPLNL ARYCPLNS ARYCPL0D ARYCPL0L ARYCPL0S ARYCPL1D ARYCPL1L ARYCPL1S ARYCPL9D ARYCPL9L ARYCPL9S ARYCREP ARYCRL2D ARYCRL2L ARYCRL2S ARYCRL9D ARYCRL9L ARYCRL9S ARYCRO9D ARYCRO9L ARYCRO9S ARYCRRF ARYCRTND ARYCRTNL ARYCRTNS ARYCSG9D ARYCSG9L ARYCSG9S ARYCSI ARYCSN9D ARYCSN9L ARYCSN9S ARYCSPND ARYCSPNL ARYCSPNS ARYCSP9D ARYCSP9L ARYCSP9S ARYCSQL ARYCSQND ARYCSQNL ARYCSQNS ARYCSQ1D ARYCSQ1L ARYCSQ1S ARYCSQ9D ARYCSQ9L ARYCSQ9S ARYCTAU ARYCTBND ARYCTBNL ARYCTBNS ARYCTB0D ARYCTB0L ARYCTB0S ARYCTB2D ARYCTB2L ARYCTB2S ARYCTB9D ARYCTB9L ARYCTB9S ARYCTRND ARYCTRNL ARYCTR0D ARYCTR0L ARYCTR0S ARYCTR9D ARYCTR9L ARYCTR9S ARYCTSND ARYCTSNL ARYCTSNS ARYCTS0D ARYCTS0L ARYCTS0S ARYCTS2D ARYCTS2L ARYCTS2S ARYCTS9D ARYCTS9L ARYCTS9S ARYCUOW ARYCUOW6 ARYCURR ARYCVA1D ARYCVA1L ARYCVA1S ARYCVTND ARYCVTNL ARYCVTNS ARYCVT0D ARYCVT0L ARYCVT0S ARYCVT9D ARYCVT9L ARYCVT9S ARYCXAND ARYCXANL ARYCXANS ARYCXT9D ARYCXT9L ARYCXT9S ARYDB2S ARYDCNV ARYDCTP ARYDDLAL ARYDDLAQ ARYDDLCL ARYDDLCT ARYDDLDB ARYDDLDT ARYDDLIX ARYDDLPK ARYDDLPL ARYDDLRL ARYDDLRO ARYDDLRT ARYDDLSG ARYDDLSN ARYDDLSQ ARYDDLTB ARYDDLTR ARYDDLTS ARYDDLVA ARYDDLVT ARYDDLXT ARYDECP ARYDELER ARYDFLT ARYDSNM ARYDSPG ARYDSUM ARYDSUMR ARYDTLF ARYDTL1 ARYDTL2 ARYDTL3 ARYDTL4 ARYDTL6 ARYDTR ARYDTS ARYDYN ARYECONN ARYEDIT ARYELOG2 ARYEMETL ARYERR ARYERRIN ARYESQLE ARYETV ARYEUTIL ARYEXP ARYEXPI ARYEXTF ARYEXTFD ARYFA ARYFATTR ARYFBASE ARYFCHEX ARYFCONN ARYFCP ARYFCSTL ARYFDBGP ARYFDEPS ARYFEXPL ARYFEXPR ARYFFDCM ARYFFLST ARYFFTCH ARYFFV ARYFILTR ARYFLD ARYFLDR ARYFLOG2 ARYFLST2 ARYFMETL ARYFOBJT ARYFOBJZ ARYFPDBG ARYFRMTR ARYFRTSI ARYFRTSM ARYFRTST ARYFR1F ARYFR1V ARYFR12 ARYFR2M ARYFR2V ARYFR6 ARYFR6A ARYFR6D ARYFR6I ARYFR6PR ARYFR6T ARYFR6TV ARYFR6X ARYFR64 ARYFSLA1 ARYFSLB1 ARYFSLRM ARYFSLRX ARYFSL01 ARYFSL91 ARYFSQLE ARYFTC ARYFUTIL ARYF2STR ARYGAICP ARYGAL ARYGAPGL ARYGBCOL ARYGBICJ ARYGBLDJ ARYGBSCJ ARYGBTRJ ARYGCCOL ARYGCDSN ARYGCLSR ARYGCOBL ARYGCOLS ARYGCOMM ARYGCPIT ARYGCSCR ARYGCTSR ARYGCWDN ARYGDCOL ARYGDEVT ARYGDGRP ARYGDLSR ARYGDUPG ARYGECOL ARYGEND ARYGENR ARYGEN1 ARYGEXAG ARYGEXPL ARYGFLT ARYGFL2 ARYGFROP ARYGGDDL ARYGGRPS ARYGGVAR ARYGIC ARYGICOL ARYGICOP ARYGIOHR ARYGLMIF ARYGLOGN ARYGLSLR ARYGMAIN ARYGMIFN ARYGMR ARYGMSQT ARYGMT ARYGOBCL ARYGOBCS ARYGOBJP ARYGOBJS ARYGOBJV ARYGOBTF ARYGOBTS ARYGODLS ARYGORDS ARYGPAGE ARYGPRDM ARYGPRFX ARYGQTLA ARYGQTRT ARYGQTTS ARYGRAOP ARYGRCOL ARYGRESP ARYGRHES ARYGRMBO ARYGROBS ARYGROPT ARYGRPDS ARYGRPED ARYGRPJS ARYGRPLP ARYGRPSL ARYGRPTS ARYGRPVE ARYGRRDF ARYGRWRT ARYGSCNV ARYGSDSN ARYGSIXN ARYGSIX2 ARYGSKL ARYGSLSN ARYGSPIP ARYGSPRF ARYGSSGN ARYGSSID ARYGSSPS ARYGSTBN ARYGSTOP ARYGSTSN ARYGSTS1 ARYGSTS2 ARYGSUBS ARYGTDSN ARYGTICO ARYGTOBF ARYGTRPF ARYGTRRD ARYGTSDS ARYGTYPS ARYGUMFR ARYGUOBJ ARYGUTP ARYGVDSN ARYGVRFY ARYGVTOP ARYGWARN ARYGWCAR ARYGWDLG ARYGWEXP ARYGWHIT ARYGWIRI ARYGWLRT ARYGXAPG ARYGXCOL ARYHLI2 ARYHSM ARYIDCM ARYIDRP ARYIF ARYIOEX ARYIR2 ARYIXP ARYJDT@ ARYJICFW ARYJICMU ARYJICSP ARYJICTP ARYJMDT@ ARYJMIGU ARYJMNM ARYJMNX ARYJMO@ ARYJODT@ ARYJOMN ARYJOPU ARYJRDT@ ARYJRGJU ARYJRMN ARYJSM@ ARYJXDT@ ARYLBBUK ARYLBBUL ARYLBC1 ARYLBC2 ARYLBC3 ARYLB0UQ ARYLB1 ARYLB2 ARYLB2UQ ARYLB3 ARYLB9UL ARYLCC ARYLFP ARYLF1 ARYLF1A ARYLF1B ARYLF2 ARYLF3 ARYLF3W ARYLF4 ARYLJBAQ ARYLJBRD ARYLJBVA ARYLJBVW ARYLJEBN ARYLJECS ARYLJEGC ARYLJERB ARYLJESE ARYLJESO ARYLJEXX ARYLJFDC ARYLJFIM ARYLJGKS ARYLJGOB ARYLJGOT ARYLJGTA ARYLJGUP ARYLJMAT ARYLJSXX ARYLJXAO ARYLJXAX ARYLJXLA ARYLJ0RL ARYLJ0TR ARYLJ7AL ARYLJ7CL ARYLJ7CP ARYLJ7DB ARYLJ7DT ARYLJ7GS ARYLJ7IP ARYLJ7IX ARYLJ7OP ARYLJ7PK ARYLJ7PL ARYLJ7RL ARYLJ7RT ARYLJ7SG ARYLJ7SN ARYLJ7SQ ARYLJ7TB ARYLJ7TP ARYLJ7TR ARYLJ7TS ARYLJ7VW ARYLJ8AL ARYLJ8CL ARYLJ8CP ARYLJ8DB ARYLJ8DT ARYLJ8GS ARYLJ8IP ARYLJ8IX ARYLJ8OP ARYLJ8PK ARYLJ8PL ARYLJ8RL ARYLJ8RT ARYLJ8SG ARYLJ8SN ARYLJ8SQ ARYLJ8TB ARYLJ8TP ARYLJ8TR ARYLJ8TS ARYLJ8VW ARYLJ9AL ARYLJ9CL ARYLJ9CP ARYLJ9DB ARYLJ9DT ARYLJ9GS ARYLJ9IP ARYLJ9IX ARYLJ9OP ARYLJ9PK ARYLJ9PL ARYLJ9RL ARYLJ9RO ARYLJ9RT ARYLJ9SG ARYLJ9SN ARYLJ9SQ ARYLJ9TB ARYLJ9TP ARYLJ9TR ARYLJ9TS ARYLJ9VW ARYLLB ARYLOGP ARYLOGR ARYLOX00 ARYLPC ARYLPD ARYLQXLA ARYLVALT ARYLXP ARYMAINT ARYMDTL ARYMGR ARYMLS ARYMLSWR ARYMMIF ARYMPRT ARYMPR2 ARYMSP ARYM64PP ARYNBLKT ARYNNUMT ARYNORMT ARYOBD ARYPEXP ARYPGR ARYPGR2 ARYPH ARYPRI ARYPSB ARYPSIXN ARYPSIX2 ARYPSLSN ARYPSSGN ARYPSTBN ARYPSTSN ARYPSTS1 ARYPSTS2 ARYQT ARYQTL ARYQTP ARYRDR ARYREC ARYREC2 ARYREC3 ARYREC3W ARYRE64 ARYRM ARYRMW ARYRM64 ARYRPTNS ARYRRFC ARYRTT ARYRXML ARYSA ARYSBDB ARYSBDF ARYSI ARYSKLR ARYSKL2 ARYSLOG ARYSLX ARYSPLL ARYSQL ARYSQL0 ARYSQL0A ARYSQL0B ARYSQL1 ARYSQL1A ARYSQL1B ARYSQL1C ARYSQL2 ARYSQL2A ARYSQL2B ARYSQL9 ARYSQL9A ARYSQL9B ARYSQL9C ARYSQ1CA ARYSQ1CB ARYSQ9CA ARYSREP ARYSRPT ARYSTOR ARYSTYPE ARYSUBC ARYSUBG ARYTC ARYTV ARYTVF ARYTVRP ARYTV2 ARYTZC ARYUDDF ARYUES ARYUEX ARYUNCRE ARYUNI ARYUNRE ARYURC ARYURID ARYURRE ARYUTIM ARYUTIMR ARYVRD ARYWARN ARYWITF ARYWITF2 ARYWL1 ARYXDRP ARYXREP ARYXSLX ARYZAAPS ARYZAASO ARYZAJST ARYZARRO ARYZASAG ARYZASOS ARYZCIO ARYZCSI ARYZDT@ ARYZICTL ARYZICUO ARYZICVS ARYZJBC ARYZLQT ARYZMHQT ARYZMO@ ARYZOAL ARYZOAQ ARYZOBJ ARYZOCL ARYZODB ARYZODT ARYZOFI ARYZOFO ARYZOIX ARYZOOP ARYZOPK ARYZOPL ARYZORL ARYZORO ARYZORT ARYZOSB ARYZOSC ARYZOSG ARYZOSN ARYZOSQ ARYZOSS ARYZOTB ARYZOTR ARYZOTS ARYZOVL ARYZOVR ARYZOVW ARYZPCHL ARYZPGQT ARYZPGRH ARYZPGRP ARYZPLN ARYZPLRP ARYZPLVL ARYZPPLN ARYZQCHL ARYZQDRP ARYZQGCJ ARYZQGQT ARYZQGRH ARYZQGRP ARYZQGSJ ARYZQJCL ARYZQLRP ARYZQLVL ARYZQOBP ARYZQORJ ARYZQPLN ARYZQQTJ ARYZQSAV ARYZQSJR ARYZQSLJ ARYZQT ARYZQTS ARYZQVAL ARYZQVQT ARYZRDOL ARYZRGOL ARYZRGPO ARYZRPL ARYZRPLC ARYZRPLS ARYZRTOL ARYZRTON ARYZSCHD ARYZSDOL ARYZSGPO ARYZSM@ ARYZSPA ARYZSRB1 ARYZSRB2 ARYZSTOL ARYZSTON ARYZUOPB ARYZUOPD ARYZUOPR ARYZUOPT ARYZUORR ARY4CREF ARY4IOHR ARY4LOG ARY4LOGI ARY4MEM ARY4MSG ARY4MVSF ARY4SAXB ARY4SAXC ARY4SERV ARY4SOCK ARY4SRRD ARY4SRWR ARY4THRD ARY4TIME ARY4XMLU ARY4XMLW ARY4XSWR H30R320J
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI51710
UP17/11/15 P F711
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 December 2017