IBM Support

PH20156: AUTOMATIC TABLE VERSIONING AND DROP COLUMN SUPPORT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This APAR introduced a new "Track Schema Changes" utility that
    enables automatic table versioning support.  The Track schema
    changes job processes activity of SYSIBM.SYSTABLES and
    SYSIBM.SYSCOLUMNS catalog tables for the period of reporting.
    After the successful completion of the job, TVFILE will be
    updated with new entries if any table versioning was detected.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: In some cases to proces an object that  *
    *                      was altered during reporting time,the   *
    *                      user must manually populate TVFILE with *
    *                      versioning information. The current     *
    *                      release provides an option to           *
    *                      automatically populate the TVFILE with  *
    *                      versioning information.                 *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    .
    

Problem conclusion

Temporary fix

Comments

  • Apply the PTF
    

APAR Information

  • APAR number

    PH20156

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-12-10

  • Closed date

    2020-01-11

  • Last modified date

    2020-02-04

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

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

    UI67360

Modules/Macros

  • ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA#WTO  ALA@FSP  ALAA02
    ALAA74   ALAAA1   ALAAA20  ALAAC    ALAAFER  ALAAFPS  ALAAFVL
    ALAAFWC  ALAAFWR  ALAALOG  ALAARC1  ALAARC2  ALAATSC  ALABHDR
    ALABSDM  ALABSDR  ALABSDS  ALABSQL  ALABSSQL ALACATF  ALACC
    ALACDF   ALACDICT ALACFG   ALACFGRP ALACFREP ALACFRR  ALACLDEL
    ALACMDR  ALACREP  ALACRRF  ALACSSQL ALACTAU  ALACUOW  ALACUOW6
    ALACURR  ALADB2S  ALADB2SP ALADCNV  ALADECP  ALADELER ALADSNM
    ALADSUM  ALADSUMR ALADTL1  ALADTL2  ALADTL3  ALADTL4  ALADTL6
    ALADTLF  ALADTS   ALADYN   ALAEBS   ALAEDIT  ALAERR   ALAERRIN
    ALAESQL  ALAETV   ALAEXP   ALAEXPI  ALAEXTF  ALAFA    ALAFCP
    ALAFCSTL ALAFFV   ALAFLD   ALAFLDR  ALAFMAIN ALAFMETL ALAFR1
    ALAFR12  ALAFR1A  ALAFR1AV ALAFR1C  ALAFR1CS ALAFR1CV ALAFR1D
    ALAFR1F  ALAFR1G  ALAFR1GV ALAFR1I  ALAFR1IV ALAFR1L  ALAFR1LS
    ALAFR1LT ALAFR1LV ALAFR1M  ALAFR1MA ALAFR1MP ALAFR1MV ALAFR1PV
    ALAFR1Q  ALAFR1QV ALAFR1V  ALAFR1X  ALAFR1XV ALAFR2   ALAFR2M
    ALAFR2V  ALAFR3   ALAFR6   ALAFR64  ALAFR6A  ALAFR6D  ALAFR6I
    ALAFR6PR ALAFR6SN ALAFR6T  ALAFR6TC ALAFR6TV ALAFR6X  ALAFR7UT
    ALAFR8A  ALAFR8B  ALAFR9   ALAFRA   ALAFRCL  ALAFRCT  ALAFRMTR
    ALAFRPAT ALAFRPER ALAFRPEX ALAFRPMD ALAFRPMN ALAFRPNW ALAFRPOP
    ALAFRQGL ALAFRQGR ALAFRQGS ALAFRQIV ALAFRQUS ALAFRTV  ALAFRTVV
    ALAFTC   ALAFUTIL ALAGEN1  ALAGEND  ALAGENR  ALAGFL2  ALAGFLA
    ALAGFLT  ALAGIC   ALAGLCS  ALAGLOAD ALAGLOAT ALAGLS   ALAGLSUM
    ALAGMR   ALAGMT   ALAIDCM  ALAIDRP  ALAIF    ALAIN4   ALAIN4R
    ALAIN4X  ALAIN4XR ALAIN5X  ALAIN9X  ALAIN9XR ALAINBX  ALAINBXR
    ALAIOEX  ALAIR2   ALAISPMN ALAIXP   ALALAUD  ALALB1   ALALB2
    ALALB3   ALALBC1  ALALF1   ALALF1A  ALALF1B  ALALF2   ALALF3
    ALALF3W  ALALF4   ALALFP   ALALLB   ALALPD   ALAM64PP ALAMAINT
    ALAMDTL  ALAMGR   ALAMLOB  ALAMLS   ALAMLSWR ALAMSP   ALAOBD
    ALAPEXP  ALAPGR   ALAPGR2  ALAPRED  ALAPREDQ ALAPRNEW ALAPRNWQ
    ALAQMAIN ALAQT    ALAQTL   ALAQTP   ALARDR   ALARE64  ALAREC
    ALAREC2  ALAREC3  ALAREC3W ALARM    ALARM64  ALARRFC  ALARTT
    ALARXML  ALASA    ALASBDB  ALASBDF  ALASETUP ALASI    ALASLX
    ALASQ1CA ALASQ1CB ALASQ9CA ALASQL0  ALASQL0A ALASQL0B ALASQL1
    ALASQL1A ALASQL1B ALASQL1C ALASQL2  ALASQL2A ALASQL2B ALASQL9
    ALASQL9A ALASQL9B ALASQL9C ALASQLPR ALASREP  ALASTOR  ALASUBG
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI67360

       UP20/01/15 P F001

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"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.5.0"}]

Document Information

Modified date:
17 March 2021