IBM Support

PH14999: SUPPORT OF DDL STATEMENT KEYLABEL FOR DROPPED/ALTERED OBJECTS

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

  • New DDL statement KEYLABEL was introduced in Db2 V12 FL502.
With this enhancement, the product will be able to retrieve
and store values of KEYLABEL and generate the correct KEYLABEL
statement as a part of DDL for dropped/altered objects.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Recovery Expert for z/OS        *
****************************************************************
* PROBLEM DESCRIPTION: New DDL statement KEYLABEL was          *
*                      introduced in Db2 V12 FL502. With this  *
*                      enhancement, the product will be able   *
*                      to retrieve and store values of         *
*                      KEYLABEL and generate the correct       *
*                      KEYLABEL statement as a part of DDL for *
*                      dropped/altered objects.                *
****************************************************************
.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH14999
    • 

  • 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-07-26
    • 

  • Closed date
    2019-09-24
    • 

  • Last modified date
    2019-10-01
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • ARY#CCUP ARY#DCAC ARY#DCAF ARY#DHLI ARY#ENQ  ARY#ISPC ARY#ISPL
ARY#ISPS ARY#ISPV ARY#LBID ARY#LNDF ARY#LSQL ARY#MSGR ARY#PCF
ARY#QTCL ARY#RPSC ARY#SPRM ARY#SVCF ARY#SVCI ARY#SYSP ARY#UTIL
ARY#WRD8 ARY#WRDC ARY#WRDS ARY$$PRM ARY$$SEQ ARY$ESTA ARY4COMM
ARY4DLL  ARY4SAXB ARY4SAXC ARY4SCNV ARY4SERV ARY4SOCK ARY4SRRD
ARY4SRWR ARY4TYPS ARY8891  ARYA2STR ARYAATTR ARYABASE ARYACD02
ARYACONN ARYACSTL ARYADBGP ARYAEXPR ARYAFDCM ARYAFLST ARYAGNAL
ARYAGNAQ ARYAGNCL ARYAGNCT ARYAGNDB ARYAGNDT ARYAGNIX ARYAGNPK
ARYAGNPL ARYAGNRL ARYAGNRO ARYAGNRT ARYAGNSG ARYAGNSN ARYAGNSQ
ARYAGNTB ARYAGNTC ARYAGNTR ARYAGNTS ARYAGNVA ARYAGNVT ARYAGNXT
ARYALOG2 ARYALST2 ARYAMETL ARYANORM ARYAOBJT ARYAOBJZ ARYAPDBG
ARYARYST ARYASQLE ARYAUTIL ARYBABCK ARYBABHE ARYBABSC ARYBBASL
ARYBBCK  ARYBBCOS ARYBBCSL ARYBBDES ARYBBDSL ARYBBDTS ARYBBGOA
ARYBBGOC ARYBBIPS ARYBBISL ARYBBLSA ARYBBOBS ARYBBOPS ARYBBOSC
ARYBBPLS ARYBBPSL ARYBBRDS ARYBBROS ARYBBRSL ARYBBSAS ARYBBSLJ
ARYBBSSL ARYBBSYS ARYBBTPS ARYBBTRS ARYBBTSL ARYBBTSS ARYBBVDS
ARYBBVRP ARYBBVSL ARYBDT@  ARYBGRMT ARYBGRPL ARYBIND1 ARYBSDSR
ARYBSGR  ARYBSGRS ARYBSGSL ARYBSPR  ARYBSPRS ARYBTDT@ ARYBTENV
ARYBTSJA ARYBTTLR ARYBUSGA ARYCAL9C ARYCAL9D ARYCAL9L ARYCAL9S
ARYCALNC ARYCAQ1C ARYCAQ1D ARYCAQ1L ARYCAQ1S ARYCAQNC ARYCAT01
ARYCATNC ARYCAUTH ARYCCT9C ARYCCT9D ARYCCT9L ARYCCT9S ARYCCTNC
ARYCD001 ARYCD002 ARYCDB9C ARYCDB9D ARYCDB9L ARYCDB9S ARYCDPNC
ARYCDPND ARYCDPNL ARYCDPNS ARYCDT0C ARYCDT0D ARYCDT0L ARYCDT0S
ARYCDT1C ARYCDT1D ARYCDT1L ARYCDT1S ARYCDT9C ARYCDT9D ARYCDT9L
ARYCDT9S ARYCDTNC ARYCDTND ARYCDTNL ARYCDTNS ARYCFI   ARYCFICR
ARYCFIDC ARYCFIDF ARYCFIDT ARYCFIFT ARYCFIMX ARYCFIOR ARYCFIPC
ARYCFIPV ARYCFIRB ARYCFISF ARYCFIXX ARYCFN0C ARYCFN0D ARYCFN0L
ARYCFN0S ARYCFN9C ARYCFN9D ARYCFN9L ARYCFN9S ARYCFNNC ARYCFNND
ARYCFNNL ARYCFNNS ARYCIX0C ARYCIX0D ARYCIX0L ARYCIX0S ARYCIX1S
ARYCIX2C ARYCIX2D ARYCIX2L ARYCIX2S ARYCIX9C ARYCIX9D ARYCIX9L
ARYCIX9S ARYCIXNC ARYCIXND ARYCIXNL ARYCIXNS ARYCMT0C ARYCMT0D
ARYCMT0L ARYCMT0S ARYCMTNC ARYCPK0C ARYCPK0D ARYCPK0L ARYCPK0S
ARYCPK1C ARYCPK1D ARYCPK1L ARYCPK1S ARYCPK9C ARYCPK9D ARYCPK9L
ARYCPK9S ARYCPKNC ARYCPKND ARYCPKNL ARYCPKNS ARYCPL0C ARYCPL0D
ARYCPL0L ARYCPL0S ARYCPL1C ARYCPL1D ARYCPL1L ARYCPL1S ARYCPL9C

    



Fix information


    

  • Fixed component name
    DB2 REC EXPERT
    • 

  • Fixed component ID
    5697H7400
    • 



Applicable component levels


    

  • R320  PSY  UI65469
       UP19/10/01  P  F909
    • 



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 October 2019
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback