PH25183: ERROR MESSAGES "ARYS880E - THE COLUMN WAS NOT FOUND" ARE INCORRECTLY GENERATED DURING THE IVP FOR V12R1M100

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• These messages are generated during the execution of the IVP
  procedure for Db2 subsystems with V12R1M100:
  ARYS880E - The column was not found: ARYTABLEPART DSSIZE
  ARYS879I - Checking v12 object: ARYTABLES, column KEYLABEL
  ARYS879I - Checking v12 object: ARYSTOGROUP, column KEYLABEL
  ARYS880E - The column was not found: ARYINDEXES PAGENUM
  ARYS880E - The column was not found: ARYINDEXES DSSIZE
  ARYS880E - The column was not found: ARYINDEXPART PAGENUM
  ARYS880E - The column was not found: ARYINDEXPART DSSIZE
  The listed columns should not be created and checked for Db2
  subsystems with V12R1M100, and these messages should be ignored.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Recovery Expert for z/OS        *
  ****************************************************************
  * PROBLEM DESCRIPTION: These messages are generated during the *
  *                       execution of the IVP procedure for Db2 *
  *                       subsystems with V12R1M100:             *
  *                      ARYS880E - The column was not found:    *
  *                       ARYTABLEPART DSSIZE                    *
  *                      ARYS879I - Checking v12 object:         *
  *                       ARYTABLES, column KEYLABEL             *
  *                      ARYS879I - Checking v12 object:         *
  *                       ARYSTOGROUP, column KEYLABEL           *
  *                      ARYS880E - The column was not found:    *
  *                       ARYINDEXES PAGENUM                     *
  *                      ARYS880E - The column was not found:    *
  *                       ARYINDEXES DSSIZE                      *
  *                      ARYS880E - The column was not found:    *
  *                       ARYINDEXPART PAGENUM                   *
  *                      ARYS880E - The column was not found:    *
  *                       ARYINDEXPART DSSIZE                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  .
  

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:

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.