PI49711: ROLLUP APAR FOR VARIOUS FIXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ROLLUP APAR FOR VARIOUS FIXES
  - DSNX105I  !ssid BIND SQL WARNING for DBRMs ARYLBBU0, ARYLBBU1
  and ARYLBBU5 after migrating from DB2 V10 to V11 using
  ARYMIGB1-4 jobs.
  - Message "ARYZ018E - The following objects are unrecoverable:"
  when trying to recover a existing or dropped single table in a
  multi table table space or in a RI relationship.
  - Message "ARYG016E: DSNT408I SQLCODE = -601, ERROR:" may occur
  whentrying to recover a dropped child table in a RI
  relationship.
  - Web interface unable to run new QT report through Point In
  Time panel of using object patterns
  - Message "ARYR274E - The day in the expiration date must be in
  the range of 1 to 366" may appear when specifying an IC
  Expiration date of YYDDD in an object profile.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Recovery Expert for z/OS.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: ROLLUP APAR FOR VARIOUS FIXES           *
  *                      - DSNX105I  !ssid BIND SQL WARNING for  *
  *                      DBRMs ARYLBBU0, ARYLBBU1 and ARYLBBU5   *
  *                      after migrating from DB2 V10 to V11     *
  *                      using ARYMIGB1-4 jobs.                  *
  *                      - Message "ARYZ018E - The following     *
  *                      objects are unrecoverable:" when        *
  *                      trying to recover a existing or         *
  *                      dropped single table in a multi table   *
  *                      table space or in a RI relationship.    *
  *                      - Message "ARYG016E: DSNT408I SQLCODE   *
  *                      = -601, ERROR:" may occur when trying   *
  *                      to recover a dropped child table in a   *
  *                      RI relationship.                        *
  *                      - Web interface unable to run new QT    *
  *                      report through Point In Time panel of   *
  *                      using object patterns                   *
  *                      - Message "ARYR274E - The day in the    *
  *                      expiration date must be in the range    *
  *                      of 1 to 366" may appear when            *
  *                      specifying an IC Expiration date of     *
  *                      YYDDD in an object profile.             *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI32597

Modules/Macros

•    ARYFEXPR ARYFMETL ARYFUTIL ARYGAICP ARYGAPGL
  ARYGBCOL ARYGBICJ ARYGBLDJ 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 ARYGUIW  ARYGUMFR ARYGUOBJ ARYGUTP
  ARYGVDSN ARYGVRFY ARYGVTOP ARYGWARN ARYGWCAR ARYGWDLG ARYGWEXP
  ARYGWHIT ARYGWLRT ARYGXAPG ARYGXCOL ARYHWLRT ARYISPF  ARYJCMN
  ARYJDT@  ARYJICMU ARYJICSP ARYJIMGM ARYJIMGX ARYJMDT@ ARYJMIGU
  ARYJXDT@ ARYLHGRI ARYLHNCC ARYLJGOX ARYLJGRX ARYLJGTP ARYLJGUP
  ARYLJGUT ARYLJMAT ARYLJOXX ARYLJXAX ARYLJXXX ARYLJ0RL ARYLJ9RL
  ARYMIGB2 ARYMIGB3 ARYPANEL ARYPCONF ARYPROC  ARYRPT   ARYRPTNS
  ARYZAGT  ARYZASAG ARYZCSI  ARYZDT@  ARYZICTL ARYZICUO ARYZJBC
  ARYZPLN  ARYZPLRP ARYZPPLN ARYZQDRP ARYZQGCJ ARYZQGRP ARYZQGSJ
  ARYZQJCL ARYZQLRP ARYZQORJ ARYZQPLN ARYZQSAV ARYZQVAL ARYZRGOL
  ARYZRGPO ARYZRPL  ARYZRPLC ARYZRPLS ARYZRTON ARYZUOPB ARYZUOPD
  ARYZUOPR ARYZUOPT ARYZUORR ARY4CREF ARY4IOHR ARY4LOG  ARY4LOGI
  ARY4MEM  ARY4SAXB ARY4SAXC ARY4SERV ARY4SOCK ARY4SRRD ARY4SRWR
  ARY4THRD ARY4TIME ARY4XMLU ARY4XMLW ARY4XSWR ARY5ABUF ARY5ACUR
  ARY5AEXS ARY5AFLE ARY5AREC ARY5AREP ARY5ASYS ARY5BBIN ARY5BINT
  ARY5BLOG ARY5BPST ARY5BVCH ARY5CLSR ARY5CMAP ARY5CONT ARY5STMP
  ARY5TIME ARY5TIMP ARY5UTIL H30R320J
  

Fix information

• Fixed component name

  DB2 REC EXPERT

• Fixed component ID

  5697H7400

Applicable component levels

• R320 PSY UI32597

     UP15/11/11 P F511

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.