IBM Support

PH12413: RECOVERY FAILS IN LOG APPLY STEP WITH SQL CODE -530

A fix is available

Obtain the fix for this APAR.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL error code -530, or other codes, may occur during recovery
for plans including "Redo SQL" and recovered objects include
both dropped and non-dropped objects.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Recovery Expert for z/OS        *
****************************************************************
* PROBLEM DESCRIPTION: SQL error code -530, or other codes,    *
*                      may occur during recovery for plans     *
*                      including "Redo SQL" and recovered      *
*                      objects include both dropped and        *
*                      non-dropped objects.                    *
****************************************************************
* RECOMMENDATION: Apply the PTF                                *
****************************************************************
.

    



Problem conclusion


    

  • Apply the PTF

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH12413
    • 

  • 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
    2019-05-22
    • 

  • Closed date
    2019-07-17
    • 

  • Last modified date
    2019-08-01
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • ARY#A001 ARY#ACIR ARY#ACIW ARY#ACON ARY#ACRD ARY#ACUP ARY#ADIS
ARY#ADSC ARY#AEXT ARY#AFMT ARY#AFRR ARY#ALLO ARY#AMIN ARY#ASYS
ARY#AUMX ARY#CARD ARY#CHKR ARY#CLLS ARY#CMTS ARY#CNTL ARY#CPNT
ARY#CPOL ARY#DSAF ARY#DSPL ARY#DYNL ARY#ENQS ARY#ENVF ARY#FCPY
ARY#ICAI ARY#ICAL ARY#ICCC ARY#ICCI ARY#IDCF ARY#IDSA ARY#IERR
ARY#IHSA ARY#IKPL ARY#IKPN ARY#ILGP ARY#ILRA ARY#ILRS ARY#ILSA
ARY#INIT ARY#IPIE ARY#IPPB ARY#IPPC ARY#IPPD ARY#IPPH ARY#IPPL
ARY#IPPN ARY#IPPS ARY#IRPL ARY#ISNA ARY#ISPS ARY#LGAA ARY#LGAC
ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#LRDR ARY#LSQL
ARY#MAIN ARY#MDRV ARY#MLOG ARY#MMGR ARY#MREP ARY#MSGR ARY#MTIO
ARY#OBRP ARY#OS   ARY#PRNG ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP
ARY#RPSC ARY#RUNT ARY#STAT ARY#SUBD ARY#SUBX ARY#SYSC ARY#SYSP
ARY#TUTL ARY#UTLS ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS
ARY#XMLU ARY$$PRM ARY$ACCS ARY$BUTD ARY3MEPI ARY3MEPL ARY4COMM
ARY4CREF ARY4IOHR ARY4LOG  ARY4LOGI ARY4MEM  ARY4MSG  ARY4MVSF
ARY4SAXB ARY4SAXC ARY4SCNV ARY4SERV ARY4SOCK ARY4SRRD ARY4SRWR
ARY4THRD ARY4TIME ARY4TYPS ARY4XMLU ARY4XMLW ARY4XSWR ARY@BULD
ARY@CFUP ARY@MSG  ARY@MSGS ARY@RDCL ARY@YCRD ARY@YDRM ARYAPOST
ARYBAADM ARYBABCK ARYBABHE ARYBABIP ARYBABOB ARYBABOI ARYBABOS
ARYBABSC ARYBABTB ARYBABTP ARYBABTS ARYBABUR ARYBABUT ARYBACDM
ARYBACSA ARYBADCS ARYBADDM ARYBADMA ARYBADTM ARYBAICG ARYBAIDM
ARYBAIPM ARYBALA  ARYBAMRR ARYBAOBM ARYBAODM ARYBAOEN ARYBAORD
ARYBAOVD ARYBAPBB ARYBAPBP ARYBAPDM ARYBAPLM ARYBAPPL ARYBARCS
ARYBARDM ARYBAROM ARYBARPA ARYBARPD ARYBARPS ARYBASAM ARYBASDM
ARYBASEI ARYBASGD ARYBASIM ARYBASRC ARYBASYM ARYBATAS ARYBATDM
ARYBATDS ARYBATPM ARYBATRM ARYBATSM ARYBAVDM ARYBAVIM ARYBAVOM
ARYBBADM ARYBBALS ARYBBASL ARYBBBOS ARYBBCAI ARYBBCDM ARYBBCFO
ARYBBCK  ARYBBCLS ARYBBCNS ARYBBCOM ARYBBCOS ARYBBCSL ARYBBDBS
ARYBBDDM ARYBBDEA ARYBBDES ARYBBDSG ARYBBDSL ARYBBDTM ARYBBDTS
ARYBBERS ARYBBGLO ARYBBGOA ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM
ARYBBINS ARYBBIPM ARYBBIPS ARYBBISL ARYBBIST ARYBBJOB ARYBBJRN
ARYBBKSG ARYBBLRJ ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM
ARYBBOPS ARYBBOSC ARYBBOSV ARYBBPAC ARYBBPAS ARYBBPCA ARYBBPCJ
ARYBBPCO ARYBBPCV ARYBBPDM ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPRS
ARYBBPSL ARYBBPSO ARYBBQTA ARYBBQTJ ARYBBRA  ARYBBRDM ARYBBRDS

    



Fix information


    

  • Fixed component name
    DB2 REC EXPERT
    • 

  • Fixed component ID
    5697H7400
    • 



Applicable component levels


    

  • R320  PSY  UI64251
       UP19/07/19  P  F907
    • 



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:
            

            01 August 2019
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback