IBM Support

PM75735: PRE-CONDITIONING SUPPORT FOR DB2 V11

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Apar will provide:
    1) DB2 V11 QPP Support
    2) The fix for Invalid REBUILD INDEX statements. After
      a Disaster Recovery Profile is built, generated member
       ssidJCL3 may contain invalid REBUILD INDEX syntax for object
       object DSNDB06.SYSGROUP.  DSNDB06.SYSGROUP no longer exists
       in DB2 v10 resulting in a DSNU1530I message - OBSOLETE OR NFM
       DB2 CATALOG OR DIRECTORY OBJECT TABLESPACE  DSNDB06.SYSGROUP
       WILL NOT BE PROCESSED.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Recovery Expert for Z/OS.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: Apar will provide:                      *
    *                      1. DB2 V11 QPP Support                  *
    *                      2. The fix for Invalid REBUILD INDEX    *
    *                       statements. After a Disaster Recovery  *
    *                       Profile is built, generated member     *
    *                       ssidJCL3 may contain invalid REBUILD   *
    *                       INDEX syntax for object object         *
    *                       DSNDB06.SYSGROUP.  DSNDB06.SYSGROUP    *
    *                       no longer exists in DB2 v10 resulting  *
    *                       in a DSNU1530I message - OBSOLETE OR   *
    *                       NFM DB2 CATALOG OR DIRECTORY OBJECT    *
    *                       TABLESPACE  DSNDB06.SYSGROUP WILL NOT  *
    *                       BE PROCESSED.                          *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

Temporary fix

Comments

  • APPLY the PTF.
    ž**** PE13/07/22 FIX IN ERROR. SEE APAR PM93574  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PM75735

  • Reported component name

    DB2 REC EXPERT

  • Reported component ID

    5697H7400

  • Reported release

    310

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-23

  • Closed date

    2013-02-28

  • Last modified date

    2013-08-30

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

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

    UK92096

Modules/Macros

  •    ARY$ACES ARY$ADMN ARY$ADM1 ARY$ADM2 ARY$ADM3
    ARY$ADM4 ARY$ADM5 ARY$ALLC ARY$APFT ARY$ASTK ARY$AXIS ARY$BACD
    ARY$BBLD ARY$BDSN ARY$BINC ARY$BJOB ARY$BLDI ARY$BLDJ ARY$BOOT
    ARY$BPND ARY$BPRC ARY$BPRD ARY$BPRS ARY$BPRT ARY$BPRU ARY$BREP
    ARY$BSAU ARY$BTCH ARY$BULJ ARY$BUTD ARY$CAF  ARY$CAFA ARY$CARD
    ARY$CMDS ARY$CORD ARY$CRBA ARY$CRMC ARY$CRMD ARY$CRMT ARY$CRMU
    ARY$CRPD ARY$CRPR ARY$CRQT ARY$CRST ARY$DOF1 ARY$DPRU ARY$EQRY
    ARY$ERBA ARY$ESTA ARY$FQRY ARY$IBLD ARY$ICSB ARY$IC1  ARY$IC2
    ARY$IC3  ARY$IC4  ARY$IC5  ARY$IDCM ARY$IMGO ARY$IMG2 ARY$IMG3
    ARY$INFO ARY$MAIN ARY$MVOL ARY$OBJD ARY$OBJR ARY$OBLD ARY$OFF1
    ARY$OFF2 ARY$OFF3 ARY$OFF4 ARY$OPRC ARY$OPRD ARY$OPRE ARY$OPRI
    ARY$OPRT ARY$OPRU ARY$POOL ARY$PRCL ARY$PRFD ARY$PRFR ARY$QSNP
    ARY$QTIM ARY$RBAD ARY$RECO ARY$RESO ARY$RIOP ARY$RPTD ARY$SBCV
    ARY$SCSI ARY$SPRM ARY$SQLC ARY$SQLD ARY$SQL2 ARY$SSAA ARY$SSAL
    ARY$SSBB ARY$SSBM ARY$SSBU ARY$SSDV ARY$SSID ARY$SSRA ARY$SSUC
    ARY$SSVC ARY$SSVD ARY$STOG ARY$SYSL ARY$TBLD ARY$TSOC ARY$URBO
    ARY$VAL  ARY$ZPAR ARY#AAPI ARY#ACES ARY#ALCT ARY#ALEX ARY#ALLC
    ARY#ALRN ARY#ALSL ARY#ALUP ARY#AUTL ARY#BIND ARY#BKUP ARY#BSDS
    ARY#BSDU ARY#CDB2 ARY#CDR  ARY#CID2 ARY#CIO  ARY#CMET ARY#CNVT
    ARY#CSI  ARY#CSIA ARY#CSID ARY#CSI1 ARY#CVAF ARY#DCAC ARY#DCAF
    ARY#DSA  ARY#DSNM ARY#HCHK ARY#HSA  ARY#HSM  ARY#IDIO ARY#ISPS
    ARY#ISPV ARY#JUST ARY#LIKE ARY#LSQL ARY#MFL  ARY#MGRT ARY#MIO
    ARY#MOD  ARY#MREP ARY#OBEX ARY#OBIO ARY#OIO  ARY#OMIG ARY#ONDX
    ARY#OUT2 ARY#PARS ARY#PCF  ARY#PDSN ARY#PEND ARY#PIO  ARY#PTVL
    ARY#PTV7 ARY#PTV8 ARY#RBA  ARY#RBAC ARY#RIO  ARY#RM24 ARY#RPBK
    ARY#RPSC ARY#RSVW ARY#SDB2 ARY#SGRP ARY#SMS  ARY#SPRM ARY#SQLC
    ARY#SQL2 ARY#STCK ARY#STMT ARY#SUBS ARY#SUPD ARY#SVOL ARY#TBSP
    ARY#TRS  ARY#UTIL ARY#UTLB ARY#UTLC ARY#VOLS ARY#VTC2 ARY#VTOC
    ARY#VTOP ARY#YARC ARY#YCAL ARY#YCTL ARY#YDEL ARY#YMCA ARY@BACK
    ARY@BAKE ARY@BAKO ARY@BAKS ARY@BAKV ARY@BCHK ARY@BCKP ARY@BDB2
    ARY@BHPG ARY@BLDB ARY@BSQL ARY@BULD ARY@CAF  ARY@CAFA ARY@CNUM
    ARY@COLS ARY@CSCR ARY@DBC  ARY@DB2Q ARY@DB2R ARY@DISC ARY@DOOD
    ARY@DSCC ARY@DSN  ARY@DSNX ARY@EXP1 ARY@FIX1 ARY@FORM ARY@FSP
    ARY@HCHK ARY@IGGC ARY@IMCD ARY@IMCE ARY@IMCP ARY@IMCQ ARY@IMCR
    ARY@IVP  ARY@IVP2 ARY@MAIN ARY@MNT  ARY@MNT2 ARY@MSG  ARY@MSGS
    ARY@NRPO ARY@OCKO ARY@OCK8 ARY@OCK9 ARY@OCPE ARY@OCPR ARY@OCPY
    ARY@ODSD ARY@OFLD ARY@OFLE ARY@ORD1 ARY@ORPT ARY@ORSE ARY@ORST
    ARY@PARM ARY@PCRD ARY@PEND ARY@RDB1 ARY@REM1 ARY@REST ARY@RES1
    ARY@RRTS ARY@RSTE ARY@RSTV ARY@RVCP ARY@RVNS ARY@RVSE ARY@RVSM
    ARY@RVSR ARY@SCAT ARY@SCCM ARY@SCGT ARY@SCIT ARY@SCMD ARY@SCON
    ARY@SCPB ARY@SCPT ARY@SCPY ARY@SCRL ARY@SCR1 ARY@SDFG ARY@SFC1
    ARY@SFLD ARY@SFND ARY@SIMG ARY@SIMX ARY@SIZ1 ARY@SOFF ARY@SOFR
    ARY@SOFX ARY@SOIC ARY@SQUE ARY@SRPT ARY@SRT1 ARY@SSET ARY@SSIO
    ARY@SSRT ARY@STSK ARY@SVRY ARY@SXCF ARY@USRT ARY@YCPL ARY@YCRD
    ARY@YDRM ARY@ZFD1 ARY@ZHEX ARY@ZTGT ARY@ZVV2 ARYAC    ARYAFER
    ARYAFPS  ARYAFVL  ARYAFWC  ARYAFWR  ARYALOG  ARYARCHK ARYARGSZ
    ARYBDCT  ARYBHDR  ARYBLNKT ARYBPC   ARYBSDR  ARYBSDS  ARYBSQL
    ARYCAF   ARYCATF  ARYCATR  ARYCDC   ARYCDICT ARYCFG   ARYCFI
    ARYCFIDC ARYCFIDT ARYCFIFT ARYCFIOR ARYCFIPC ARYCFIQT ARYCFIRB
    ARYCFOIC ARYCFREP ARYCFRR  ARYCREP  ARYCRRF  ARYCSQL  ARYCUOW
    ARYCUOW6 ARYCURR  ARYDAREA ARYDB2CA ARYDB2S  ARYDB2SL ARYDB2ST
    ARYDCTP  ARYDDLR  ARYDDLRP ARYDES   ARYDETST ARYDEXRI ARYDEXRL
    ARYDEXTR ARYDE7AN ARYDE7CA ARYDE7DA ARYDE7DB ARYDE7DT ARYDE7IC
    ARYDE7IP ARYDE7IX ARYDE7KA ARYDE7K0 ARYDE7K1 ARYDE7K2 ARYDE7K3
    ARYDE7OT ARYDE7OX ARYDE7PA ARYDE7PT ARYDE7P0 ARYDE7P1 ARYDE7P2
    ARYDE7P3 ARYDE7QA ARYDE7RA ARYDE7SA ARYDE7SG ARYDE7SR ARYDE7SV
    ARYDE7SY ARYDE7TA ARYDE7TB ARYDE7TC ARYDE7TP ARYDE7TR ARYDE7TS
    ARYDE7TV ARYDE7XA ARYDE8AN ARYDE8CA ARYDE8DA ARYDE8DB ARYDE8DT
    ARYDE8IC ARYDE8IP ARYDE8IX ARYDE8KA ARYDE8K0 ARYDE8K1 ARYDE8K2
    ARYDE8K3 ARYDE8OT ARYDE8OX ARYDE8PA ARYDE8PT ARYDE8P0 ARYDE8P1
    ARYDE8P2 ARYDE8P3 ARYDE8QA ARYDE8RA ARYDE8SA ARYDE8SG ARYDE8SR
    ARYDE8SS ARYDE8SV ARYDE8SY ARYDE8TA ARYDE8TB ARYDE8TC ARYDE8TP
    ARYDE8TR ARYDE8TS ARYDE8TV ARYDE8XA ARYDFLT  ARYDSNM  ARYDSPG
    ARYDSUM  ARYDSUMR ARYDTLF  ARYDTL1  ARYDTL2  ARYDTL3  ARYDTL4
    ARYDTL6  ARYDTR   ARYDTS   ARYDYN   ARYDYNAL ARYEDIT  ARYERR
    ARYETV   ARYEXP   ARYEXPI  ARYEXTF  ARYEXTFD ARYFA    ARYFCP
    ARYFFV   ARYFILTR ARYFLD   ARYFLDR  ARYFRMTR ARYFR1F  ARYFR1V
    ARYFR12  ARYFR2M  ARYFR2V  ARYFR6   ARYFR6A  ARYFR6I  ARYFR6PR
    ARYFR6T  ARYFR6TV ARYFR6X  ARYFR64  ARYFTC   ARYGAL   ARYGBICJ
    ARYGBLDJ ARYGCCOL ARYGCDSN ARYGCLSR ARYGCOBL ARYGCOLS ARYGCOMM
    ARYGCPIT ARYGCSCR ARYGDCOL ARYGDLSR ARYGECOL ARYGEND  ARYGENR
    ARYGEN1  ARYGEXPL ARYGFLT  ARYGFL2  ARYGFROP ARYGGDDL ARYGGRPS
    ARYGGVAR ARYGIC   ARYGICOL ARYGICOP ARYGIOHR ARYGLSLR ARYGMAIN
    ARYGMT   ARYGOBCL ARYGOBCS ARYGOBJP ARYGOBJS ARYGOBJV ARYGOBTF
    ARYGOBTS ARYGODLS ARYGPRDM ARYGPRFX ARYGQTLA ARYGQTRT ARYGQTTS
    ARYGRCOL ARYGRESP ARYGRHES ARYGROBS ARYGROPT ARYGRPDS ARYGRPED
    ARYGRPJS ARYGRPLP ARYGRPSL ARYGRPTS ARYGRPVE ARYGRWRT ARYGSCNV
    ARYGSDSN ARYGSKL  ARYGSSID ARYGSSPS ARYGSUBS ARYGTDSN ARYGTICO
    ARYGTYPS ARYGUTP  ARYGVDSN ARYGVRFY ARYGWARN ARYGWCAR ARYGWDLG
    ARYGWEXP ARYGWHIT ARYGWLBD ARYGXCOL ARYHLI   ARYHLI2  ARYHSM
    ARYIDCM  ARYIDRP  ARYIF    ARYIOEX  ARYIR2   ARYISPF  ARYIXP
    ARYJBDTM ARYJBDTX ARYJDATE ARYJICSP ARYJICTP ARYJMNM  ARYJMNX
    ARYLBB00 ARYLBCUA ARYLBCUB ARYLBCUC ARYLBCUD ARYLBCUE ARYLBCUF
    ARYLBCUG ARYLBCUH ARYLBCUI ARYLBCUJ ARYLBCUK ARYLBCUL ARYLBCUM
    ARYLBCUN ARYLBCUO ARYLBCUP ARYLBCUQ ARYLBCUX ARYLBCU0 ARYLBCU1
    ARYLBCU2 ARYLBCU3 ARYLBCU4 ARYLBCU5 ARYLBCU6 ARYLBCU7 ARYLBCU8
    ARYLBCU9 ARYLBNDA ARYLBNDB ARYLBNDC ARYLBND0 ARYLBND1 ARYLBND2
    ARYLBND3 ARYLBND4 ARYLBND5 ARYLBND6 ARYLBND7 ARYLBND8 ARYLBND9
    ARYLBNUA ARYLBNUB ARYLBNUC ARYLBNUD ARYLBNUE ARYLBNUF ARYLBNUG
    ARYLBNUH ARYLBNUI ARYLBNUJ ARYLBNUK ARYLBNUL ARYLBNUM ARYLBNUN
    ARYLBNUO ARYLBNUP ARYLBNUQ ARYLBNUR ARYLBNUS ARYLBNUX ARYLBNU0
    ARYLBNU1 ARYLBNU2 ARYLBNU3 ARYLBNU4 ARYLBNU5 ARYLBNU6 ARYLBNU7
    ARYLBNU8 ARYLBNU9 ARYLBXK1 ARYLBXK3 ARYLBX01 ARYLBX02 ARYLBX04
    ARYLBX05 ARYLBX06 ARYLB0UO ARYLB0UP ARYLB0UQ ARYLB0UZ ARYLB0U5
    ARYLB0U6 ARYLB1   ARYLB2   ARYLB3   ARYLB9DA ARYLB9DB ARYLB9DC
    ARYLB9DD ARYLB9D0 ARYLB9D1 ARYLB9D2 ARYLB9D3 ARYLB9D4 ARYLB9D5
    ARYLB9D6 ARYLB9D7 ARYLB9D8 ARYLB9D9 ARYLB9UA ARYLB9UB ARYLB9UC
    ARYLB9UD ARYLB9UE ARYLB9UF ARYLB9UG ARYLB9UH ARYLB9UI ARYLB9UJ
    ARYLB9UK ARYLB9UL ARYLB9UM ARYLB9UN ARYLB9UO ARYLB9UP ARYLB9UQ
    ARYLB9UR ARYLB9US ARYLB9UT ARYLB9UU ARYLB9UV ARYLB9UW ARYLB9UX
    ARYLB9UY ARYLB9U0 ARYLB9U1 ARYLB9U2 ARYLB9U3 ARYLB9U4 ARYLB9U5
    ARYLB9U6 ARYLB9U7 ARYLB9U8 ARYLB9U9 ARYLCC   ARYLCNVT ARYLDFLT
    ARYLDSN1 ARYLDS1X ARYLFP   ARYLF1   ARYLF1A  ARYLF1B  ARYLF2
    ARYLF3   ARYLF3W  ARYLF4   ARYLGC01 ARYLGN01 ARYLGX00 ARYLGX04
    ARYLGX05 ARYLHEAN ARYLHEBK ARYLHEBP ARYLHECA ARYLHEDA ARYLHEDB
    ARYLHEDT ARYLHEHI ARYLHEIX ARYLHEKA ARYLHEPA ARYLHEQA ARYLHERA
    ARYLHESA ARYLHESG ARYLHESQ ARYLHESR ARYLHESY ARYLHETA ARYLHETB
    ARYLHETR ARYLHETS ARYLHETV ARYLHEUA ARYLHEXA ARYLHGAN ARYLHGAX
    ARYLHGBK ARYLHGBP ARYLHGCA ARYLHGCT ARYLHGDA ARYLHGDB ARYLHGDT
    ARYLHGFQ ARYLHGFS ARYLHGFT ARYLHGFU ARYLHGGC ARYLHGIX ARYLHGKA
    ARYLHGMT ARYLHGPA ARYLHGPE ARYLHGPQ ARYLHGQA ARYLHGRA ARYLHGRD
    ARYLHGRI ARYLHGRO ARYLHGSA ARYLHGSG ARYLHGSQ ARYLHGSY ARYLHGTA
    ARYLHGTB ARYLHGTR ARYLHGTS ARYLHGTV ARYLHGUA ARYLHGXA ARYLHGXX
    ARYLHNCC ARYLHNCL ARYLHNFK ARYLHNPK ARYLHNTX ARYLHNUQ ARYLH0HK
    ARYLH0PK ARYLH0UQ ARYLH9TR H30R310J
    

Fix information

  • Fixed component name

    DB2 REC EXPERT

  • Fixed component ID

    5697H7400

Applicable component levels

  • R310 PSY UK92096

       UP13/03/09 P F303

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.1.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
30 August 2013