IBM Support

PH52997: DATABASE AND TABLESPACE IS NOT TRANSLATED FOR MQT

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

  • In redirected recovery, object translation of database and
tablespace is not applied for an MQT. This could cause SQL -904
error during plan execution.

Local fix

  • N/A

Problem summary

  • In redirected recovery object translation of database and
tablespace isn't applied for an MQT. This could cause SQL -904
error during plan execution.

Problem conclusion

  • Apply the PTF.

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH52997
    • 

  • 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
    2023-03-03
    • 

  • Closed date
    2023-04-26
    • 

  • Last modified date
    2023-05-03
    • 





    

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

    • 

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

    
UI91573
    

    • 



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#ENCR 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#LGAA ARY#LGAC
ARY#LGAF ARY#LGAI ARY#LGAP ARY#LOGR ARY#LRD6 ARY#MAIN ARY#MDRV
ARY#MLOG ARY#MMGR ARY#MREP ARY#MTIO ARY#NREC ARY#OBRP ARY#OS
ARY#PRNG ARY#QSAM ARY#RANG ARY#RESM ARY#RPRP ARY#RUNT ARY#STAT
ARY#SUBD ARY#SUBX ARY#SYSC ARY#TUTL ARY#UTLS ARY#VERS ARY#VSM
ARY#WRIT ARY#XMLD ARY#XMLI ARY#XMLJ ARY#XMLS ARY#XMLU ARY$ACCS
ARY3MEPI ARY3MEPL ARYAATTR ARYAGNIX ARYALL99 ARYAPOST ARYCAPST
ARYCSI00 ARYCUTL  ARYDB2CN ARYDB2PR ARYDB2SQ ARYDECIM ARYDLL
ARYDTST  ARYEATTR ARYEGNIX ARYEQUAL ARYFTRT  ARYGGCJ  ARYICAPS
ARYIDCMS ARYIDTPS ARYIENQS ARYLGA   ARYLGAPS ARYLGC   ARYLGPR
ARYLGRD  ARYMMGR  ARYMSGPC ARYOBJST ARYPARET ARYPGPR  ARYPRSR
ARYS1ICA ARYS2IDT ARYS3LGA ARYS4XSI ARYS5XDI ARYS6XDU ARYS99
ARYSA001 ARYSACIR ARYSACIW ARYSACON ARYSACRD ARYSACUP ARYSADIS
ARYSADSC ARYSAEXT ARYSAFMT ARYSAFRR ARYSALLO ARYSAUMX ARYSCLLS
ARYSDYNL ARYSMDRV ARYSMNIN ARYSMTIO ARYSOS   ARYSQSAM ARYSTUTL
ARYSUTLS ARYSVSAM ARYXAS31 ARYXAS64 ARYXASMS ARYXASPR ARYXCCMN
ARYXCDT@ ARYXCPKG ARYXDDM  ARYXDIPS ARYXDUPS ARYXEXPM ARYXMLST
ARYXPDS  ARYXSIPS ARYXUTLS

    



Fix information


    

  • Fixed component name
    DB2 REC EXPERT
    • 

  • Fixed component ID
    5697H7400
    • 



Applicable component levels


    

  • R320  PSY  UI91573
       UP23/04/28  P  F304
    • 



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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            03 May 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback