IBM Support

PH21727: PRIMARY KEY IS NOT GENERATED FOR MIGRATED TABLE

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

  • Tables migrated from previous versions of Db2 may have no
records for unique constraints in the SYSIBM.SYSTABCONST
catalog table. DDL for such constraints may not be generated
by the product, and the table may be recovered without
constraints.
With this fix, the DDL generation module is corrected to
generate DDL for such migrated constraints and recover a
table correctly.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: Users of Db2 Recovery Expert for z/OS        *
****************************************************************
* PROBLEM DESCRIPTION: Tables migrated from previous versions  *
*                       of Db2 may have no records for unique  *
*                       constraints in the SYSIBM.SYSTABCONST  *
*                       catalog table.                         *
*                      DDL for such constraints may not be     *
*                       generated by the product, and the      *
*                       table may be recovered without         *
*                       constraints.                           *
*                      With this fix, the DDL generation       *
*                       module is corrected to generate DDL    *
*                       for such migrated constraints and      *
*                       recover a table correctly.             *
****************************************************************
.

    



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH21727
    • 

  • 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
    2020-02-03
    • 

  • Closed date
    2020-03-04
    • 

  • Last modified date
    2020-04-02
    • 





    

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

    • 

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

    • 



Modules/Macros


    

  • ARY#MIO  ARY#ONDX ARY#PARM ARY#SVOL ARY#YCAL ARY$$PRM ARY$SSID
ARY4COMM ARY4DLL  ARY4SAXB ARY4SAXC ARY4SCNV ARY4SERV ARY4SOCK
ARY4SRRD ARY4SRWR ARY4TYPS ARY@BACK ARY@BAKE ARY@BAKV ARY@DB2R
ARY@DISP ARY@MSGS ARY@OFLD ARY@PARM ARY@SOFF ARYA2STR ARYAATTR
ARYABASE ARYACD02 ARYAGNAL ARYAGNAQ ARYAGNCL ARYAGNCT ARYAGNDB
ARYAGNDT ARYAGNIX ARYAGNPK ARYAGNPL ARYAGNRL ARYAGNRO ARYAGNRT
ARYAGNSG ARYAGNSN ARYAGNSQ ARYAGNTB ARYAGNTC ARYAGNTR ARYAGNTS
ARYAGNVA ARYAGNVT ARYAGNXT ARYALST2 ARYANORM ARYAOBJT ARYAOBJZ
ARYAPDBG ARYARYST 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 ARYBBCK  ARYBBCLS ARYBBCNS ARYBBCOM ARYBBCOS ARYBBCSL
ARYBBDBS ARYBBDDM ARYBBDES ARYBBDSG ARYBBDSL ARYBBDTM ARYBBDTS
ARYBBERS ARYBBGLO ARYBBGOC ARYBBGRJ ARYBBGRP ARYBBIDM ARYBBINS
ARYBBIPM ARYBBIPS ARYBBISL ARYBBIST ARYBBJOB ARYBBKSG ARYBBLRJ
ARYBBOBM ARYBBOBS ARYBBOCN ARYBBOCR ARYBBODM ARYBBOPS ARYBBOSC
ARYBBOSV ARYBBPAC ARYBBPAS ARYBBPCJ ARYBBPCO ARYBBPCV ARYBBPDM
ARYBBPI  ARYBBPLM ARYBBPLN ARYBBPLS ARYBBPRS ARYBBPSL ARYBBPSO
ARYBBQTA ARYBBQTJ ARYBBRA  ARYBBRDM ARYBBRDS ARYBBRLS ARYBBRMA
ARYBBROM ARYBBROS ARYBBRPC ARYBBRSL ARYBBRTS ARYBBSAM ARYBBSAS
ARYBBSCM ARYBBSDM ARYBBSES ARYBBSGD ARYBBSGS ARYBBSQS ARYBBSRC
ARYBBSSL ARYBBSST ARYBBSYM ARYBBSYS ARYBBTBS ARYBBTDM ARYBBTPM
ARYBBTPS ARYBBTRG ARYBBTRM ARYBBTRS ARYBBTSJ ARYBBTSL ARYBBTSM
ARYBBTSO ARYBBTSS ARYBBUCD ARYBBUCI ARYBBUCL ARYBBUCO ARYBBUCR
ARYBBUDC ARYBBUES ARYBBUGC ARYBBULA ARYBBULD ARYBBUNM ARYBBUPR
ARYBBUPV ARYBBUQU ARYBBURB ARYBBURC ARYBBURD ARYBBURL ARYBBURP
ARYBBURV ARYBBUSR ARYBBUSS ARYBBUTH ARYBBUTM ARYBBVAS ARYBBVDM
ARYBBVDS ARYBBVRP ARYBBVSL ARYBCDCS ARYBCOAS ARYBCRAS ARYBDAMA
ARYBDDCS ARYBDPLS ARYBDRAS ARYBDSF  ARYBDSUT ARYBDT@  ARYBDTCS

    



Fix information


    

  • Fixed component name
    DB2 REC EXPERT
    • 

  • Fixed component ID
    5697H7400
    • 



Applicable component levels


    

  • R320  PSY  UI68210
       UP20/04/02  P  F003
    • 



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:
            

            10 March 2020
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback