IBM Support

PH43957: GENERATED ALWAYS COLUMNS PROCESSING IMPROVEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This enhancement adjust the functionality to improve the
    processing of the Generated Always columns.
    The generation of UNDO/REDO SQL will be changed to allow
    specification of SET SYSIBMADM.REPLICATION_OVERRIDE global
    variable. Also, the generation of LOADCARDS will automatically
    include the override option to the card that contain generated
    always columns.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This enhancement adjust                 *
    *                      the functionality to improve            *
    *                      the processing of the Generated Always  *
    *                      columns.                                *
    *                      The generation of UNDO/REDO SQL will be *
    *                      changed to allow specification of       *
    *                      SET SYSIBMADM.REPLICATION_OVERRIDE      *
    *                      global variable. Also, the generation   *
    *                      of LOADCARDS will automatically include *
    *                      the override option to the card that    *
    *                      contain generated always columns.       *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Generated Always columns processing improvement
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH43957

  • Reported component name

    DB2 LOG ANALYSI

  • Reported component ID

    5655E6601

  • Reported release

    350

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2022-02-08

  • Closed date

    2022-07-06

  • Last modified date

    2022-08-02

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

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

    UI81330

Modules/Macros

  • ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA@FCCH ALA@FCOM ALA@FERR
    ALA@FFN8 ALA@FFNG ALA@FSFL ALA@FSP  ALA@FST2 ALA@PCOM ALA@PGLN
    ALA@POBJ ALA@PPRS ALA@PSPS ALA@PSTN ALAA65   ALAAA16  ALAAA3
    ALAAA3A  ALAAA5E  ALAAFPS  ALAAFVL  ALAAFWC  ALAAFWR  ALAAPICD
    ALAARC1  ALAARC2  ALAARCPN ALAARDCU ALAARDDO ALAARDRT ALAARDUW
    ALAAUDPN ALABSDR  ALABSQL  ALABSSQL ALACADMN ALACDC   ALACFGRP
    ALACLDEL ALACRRF  ALACTAU  ALACUOW6 ALACURR  ALADATA  ALADB2S
    ALADB2SP ALADECP  ALADELER ALADLMPN ALADSNM  ALADTL1  ALADTL2
    ALADTL3  ALADTL4  ALADTL6  ALAEDIT  ALAERRIN ALAEXP   ALAFA
    ALAFLADV ALAFLD   ALAFLDR  ALAFLOBI ALAFLOBN ALAFMAIN ALAFR1CX
    ALAFRC8  ALAFRCA  ALAFRCCM ALAFRCOL ALAFRCQS ALAFRCRV ALAFRDTL
    ALAFRETV ALAFRFLA ALAFRFLO ALAFRGNR ALAFRJSN ALAFRLAP ALAFRLCV
    ALAFRMFC ALAFRMTR ALAFRPGS ALAFRPIE ALAFRPMA ALAFRPMC ALAFRSL
    ALAFRSP  ALAFRTCV ALAFRTP1 ALAFRTSC ALAFRUT  ALAFTC   ALAGEN1
    ALAGEND  ALAGL2   ALAGL3   ALAGL4   ALAGLOAD ALAGLOAT ALAGLSUM
    ALAGMT   ALAGNJCL ALAHDRPN ALAHRC   ALAHSM   ALAIXP   ALAJSDEF
    ALAJSON  ALALAUD  ALALB2   ALALB3   ALALCOPN ALALDPN  ALALEOPN
    ALALF1   ALALF1A  ALALF1B  ALALF2   ALALF3   ALALF3W  ALALFCPN
    ALALIN   ALALLB   ALALOPT  ALALPD   ALAMAINT ALAMDTL  ALAMFLTR
    ALAMFOPN ALAMGR   ALAMLOB  ALAMLS   ALAMLSWR ALAMNTRP ALAMODEF
    ALAMODEM ALAMPNL  ALAMSGPN ALAOBD   ALAPEXP  ALAPOPUP ALAQGLPN
    ALAQGRPN ALAQGSPN ALAQSPN  ALAQTRP  ALARDR   ALAREC   ALAREC2
    ALAREC3  ALAREC3W ALARM    ALARM64  ALASETUP ALASFREX ALASQL0
    ALASQL1  ALASQL2  ALASQL3  ALASQL9  ALATSC   ALATV    ALATVRP
    ALAUES   ALAUTIL  ALAVLXPN ALAVRD   ALAZH020 ALAZH200 ALAZH500
    ALAZH960 ALAZT610
    

Fix information

  • Fixed component name

    DB2 LOG ANALYSI

  • Fixed component ID

    5655E6601

Applicable component levels

  • R350 PSY UI81330

       UP22/07/08 P F207

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

Document Information

Modified date:
02 August 2022