A fix is available
APAR status
Closed as program error.
Error description
Various Bug fixes that include: * * Unable to include 'TIME=NOLIMIT' to JOBCARD * ARYS118E - Error fetching object profile trying to generate IC for Object Profile. * Image Copy from SLB will end with a reason code 8 and with error message ADR380E. * Various changes to TCz skeletons and Migration JCL in Samplib. -ARY_DELETEDRBA in table ARYT_VARIABLES is not defined as CHAR(10) as all other ARY_DELETEDRBA columns are defined for v11. -Add Constraint IDENT Foreign Key to ARYT_VARIABLES and ARYT_VARIABLEAUTH tables. * Both Archive Logs Not Listed in PDSE Member xxxxCPYL. * Error message,DSN1966I OUTPUT DATA SET xxxx.I0001.A002 NOT FOUND,may occur when allocating Dataset when performing DSN1COPY dropped object recovery of multi-dataset non partitioned tablespace. * Image copy JCL generated by Recovery Expert might not generate/be missing EMC libraries. * When performing dropped object recovery on a tablespace for the scenario where the table was dropped first and then tablespace was dropped after table, Recovery Expert loops when trying to generate recovery plans. * When doing versioning recovery on objects that have RI, Recovery Expert recreates the indexes for all the related tables when it shouldn't be doing that. * When building a SNAP IC job the SCF$010 DD DUMMY statement is not generated properly.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 Recovery Expert z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Various Bug fixes that include: * * * Unable to include 'TIME=NOLIMIT' to * * JOBCARD * * * ARYS118E - Error fetching object * * profile trying to generate IC for * * Object Profile. * * * Image Copy from SLB will end with * * a reason code 8 and with error * * message ADR380E. * * * Various changes to TCz skeletons and * * Migration JCL in Samplib. * * -ARY_DELETEDRBA in table * * ARYT_VARIABLES is not defined as * * CHAR(10) as all other ARY_DELETEDRBA * * columns are defined for v11. * * -Add Constraint IDENT Foreign Key to * * ARYT_VARIABLES and ARYT_VARIABLEAUTH * * tables. * * * Both Archive Logs Not Listed in PDSE * * Member xxxxCPYL. * * * Error message,320 FOUND, DSN1COPY * * dropped object recovery of * * multi-dataset non partitioned * * tablespace. * * * Image copy JCL generated by Recovery * * Expert might not generate/be missing * * EMC libraries. * * * When performing dropped object * * recovery on a tablespace for the * * scenario where the table was dropped * * first and then tablespace was dropped * * after table, Recovery Expert loops * * when trying to generate recovery * * plans. * * * When doing versioning recovery on * * objects that have RI, Recovery Expert * * recreates the indexes for all the * * related tables when it shouldn't be * * doing that. * * * When building a SNAP IC job the * * SCF$010 DD DUMMY statement is * * not generated properly. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI53015
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
2015-11-23
Closed date
2016-09-13
Last modified date
2016-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI40790
Modules/Macros
ARY#YCAL ARY@SIMG ARYALCVD ARYBDJOB ARYBIND1 ARYCFOIC ARYCRL2L ARYCRL9L ARYGAICP ARYGAPGL ARYGBCOL ARYGBICJ ARYGBLDJ ARYGBSCJ ARYGBTRJ ARYGCCOL ARYGCDSN ARYGCLSR ARYGCOBL ARYGCOLS ARYGCOMM ARYGCPIT ARYGCSCR ARYGCTSR ARYGDCOL ARYGDEVT ARYGDGRP ARYGDLSR ARYGDUPG ARYGECOL ARYGEXAG ARYGEXPL ARYGFROP ARYGGDDL ARYGGRPS ARYGGVAR ARYGICOL ARYGICOP ARYGIOHR ARYGLMIF ARYGLOGN ARYGLSLR ARYGMAIN ARYGMIFN ARYGMSQT 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 ARYGSCNV ARYGSDSN ARYGSKL ARYGSPIP ARYGSPRF ARYGSSID ARYGSSPS ARYGSTOP ARYGSUBS ARYGTDSN ARYGTICO ARYGTOBF ARYGTRPF ARYGTRRD ARYGTSDS ARYGTYPS ARYGUMFR ARYGUOBJ ARYGUTP ARYGVDSN ARYGVRFY ARYGVTOP ARYGWARN ARYGWCAR ARYGWDLG ARYGWEXP ARYGWHIT ARYGWIRI ARYGWLRT ARYGXAPG ARYGXCOL ARYHCTSR ARYHTRPF ARYJRDT@ ARYJRGEN ARYJRGJU ARYLJECD ARYLJECI ARYLJECL ARYLJECP ARYLJECR ARYLJEGC ARYLJEPV ARYLJERB ARYLJERL ARYLJERP ARYLJERV ARYLJFDC ARYLJFIM ARYLJFSD ARYLJGAC ARYLJGCR ARYLJGOB ARYLJGPX ARYLJGXX ARYLJSXX ARYLJXAX ARYLJ8TB ARYLJ9CP ARYLJ9TB ARYLQTRS ARYLQXAX ARYLQXLA ARYMIGB2 ARYRTBL ARYTAGT ARYTDT@ ARYTMO@ ARYTMSGS ARYTQSTA ARYTSM@ ARYZAATR ARYZAGT ARYZAPGT ARYZARGT ARYZDT@ ARYZMO@ ARYZMSGS ARYZPLN ARYZQGSJ ARYZQJCL ARYZQPLN ARYZQVAL ARYZRES ARYZRPL ARYZRPLC ARYZRPLS ARYZSM@ ARYZTRNS ARY4CREF ARY4IOHR ARY4LOG ARY4LOGI ARY4MEM 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 UI40790
UP16/09/24 P F609
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:
03 October 2016