A fix is available
APAR status
Closed as program error.
Error description
Different problems may occur during the usage of the Db2 migration script (Tools Customizer option "Db2 Migration" / "Migrate schema-level repository"): 1) The migration job is cancelled with messages "IAT4410 DDNAME ARYTB1 IS DUPLICATED WITHIN STEP" in JES3 4410 DDNAME environments. 2) The migration job may fail with message DSNU037I RECFM=U FOR DDNAME SYSIN. 3) Some tables are not correctly updated during the migration to Db2 V12: ARYT_TABLESPACESTATS, ARYT_INDEXSPACESTATS. 4) Referential constraints may be not recreated for LBDR tables. 5) Recreated table ARYTABLES doesn't have the required STATUS column.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Different problems may occur during the * * usage of the Db2 migration script * * (Tools Customizer option * * "Db2 Migration" / "Migrate schema-level * * repository"): * * 1. The migration job is cancelled with * * messages "IAT4410 DDNAME ARYTB1 IS * * DUPLICATED WITHIN STEP" in JES3 * * environments. * * 2. The migration job may fail with * * message DSNU037I RECFM=U FOR DDNAME * * SYSIN. * * 3. Some tables are not correctly * * updated * * during the migration to Db2 V12: * * ARYT_TABLESPACESTATS, * * ARYT_INDEXSPACESTATS. * * 4. Referential constraints may be not * * recreated for LBDR tables. * * 5. Recreated table ARYTABLES doesn't * * have the required STATUS column. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** .
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH25541
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-05-18
Closed date
2020-05-28
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ARY#AAPI ARY#ALLC ARY#BKUP ARY#BUPD ARY#CBIN ARY#HSM ARY#IDIO ARY#MGRT ARY#PARM ARY#PDSN ARY#PIO ARY#RIO ARY#SMS ARY#STB2 ARY#STUB ARY#SVOL ARY#VOLS ARY#VPRO ARY$ADMN ARY$APMN ARY$ATGT ARY$BACD ARY$BBLD ARY$BJOB ARY$BLDJ ARY$BPRC ARY$BPRD ARY$BPRU ARY$BPRV ARY$BSAU ARY$BUTD ARY$CG00 ARY$CGAD ARY$CGGL ARY$CGSL ARY$CGUP ARY$CGXD ARY$CORD ARY$CRMD ARY$CRMU ARY$CRQT ARY$DGRP ARY$DOF1 ARY$DPRU ARY$ERBA ARY$FQRY ARY$ICSB ARY$IMGO ARY$MAIN ARY$MVOL ARY$OBJD ARY$OBJR ARY$OFF1 ARY$OPRC ARY$OPRD ARY$PARM ARY$POOL ARY$PRCL ARY$PRFD ARY$PRFN ARY$RBAD ARY$RESO ARY$RPTD ARY$RSET ARY$SBCV ARY$SSDV ARY$SSID ARY$SSRA ARY$SSVC ARY$SSVD ARY$SSVV ARY$STOG ARY$SYMN ARY$SYSL ARY$VAL ARY8858 ARY@BACK ARY@BAKE ARY@BAKO ARY@BAKS ARY@BAKV ARY@BCHK ARY@BCKP ARY@BDB2 ARY@BHPG ARY@BLDB ARY@BULD ARY@CGBK ARY@CGOF ARY@CGOO ARY@CGOR ARY@CGOT ARY@CGRS ARY@CGRV ARY@CRCR ARY@DB2R ARY@DISP ARY@DOOD ARY@HCHK ARY@IVP ARY@IVP2 ARY@MAIN ARY@MJCR ARY@MSGS ARY@NRPO ARY@OCKO ARY@OCPE ARY@OCPR ARY@OCPY ARY@ODSD ARY@OFLD ARY@OFLE ARY@OFLP ARY@ORCT ARY@OREN ARY@ORPT ARY@ORSE ARY@ORST ARY@OSMS ARY@PARM ARY@PEND ARY@RDB1 ARY@REST ARY@RSTE ARY@RSTO ARY@RSTV ARY@RVCP ARY@RVNS ARY@RVSE ARY@RVSM ARY@RVSR ARY@SCAT ARY@SCKP ARY@SCLP ARY@SCLR ARY@SCMD ARY@SCNG ARY@SCON ARY@SDDU ARY@SDFG ARY@SDV2 ARY@SECQ ARY@SEST ARY@SETC ARY@SFC1 ARY@SFLA ARY@SFLD ARY@SFQY ARY@SHDS ARY@SHRL ARY@SIDC ARY@SIMG ARY@SIMX ARY@SLBL ARY@SLOG ARY@SNPC ARY@SNPD ARY@SNPQ ARY@SNPV ARY@SOFF ARY@SOFR ARY@SOFX ARY@SOIC ARY@SPLT ARY@SPTH ARY@SQRY ARY@SQUE ARY@SREC ARY@SRED ARY@SRES ARY@SRPT ARY@SSIO ARY@STOP ARY@STSK ARY@STUB ARY@SUCB ARY@SVER ARY@SVFY ARY@SVRY ARY@SXCF ARY@YDRM ARYB ARYBABAL ARYBABAQ ARYBABCK ARYBABDB ARYBABDT ARYBABIP ARYBABOB ARYBABOI ARYBABOP ARYBABPK ARYBABPL ARYBABRL ARYBABRO ARYBABRT ARYBABSC ARYBABSG ARYBABSN ARYBABSQ ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBABVA ARYBACSA ARYBADMA ARYBAICG ARYBALA ARYBAMRR ARYBAOEN ARYBARPD ARYBASEI ARYBBADM ARYBBASL ARYBBBOS ARYBBCAI ARYBBCDM ARYBBCK ARYBBCOM ARYBBCOS ARYBBCSL ARYBBDDM ARYBBDSL ARYBBDTM ARYBBDTS ARYBBERS ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBIPM ARYBBIPS ARYBBISL ARYBBJOB ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC
Fix information
Fixed component name
DB2 REC EXPERT
Fixed component ID
5697H7400
Applicable component levels
R320 PSY UI69743
UP20/05/30 P F005
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021