IBM Support

PH21727: PRIMARY KEY IS NOT GENERATED FOR MIGRATED TABLE

A fix is available

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