PH49375: GENERATE REDO SQL FOR RI ACTIONS.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Provide the ability to generate REDO SQL for RI actions, so
  customers can apply the SQL in the target system where
  referential integrity is not defined. A new parameter was added
  to the "Generate Details" panel to allow the generation of REDO
  SQL for referential integrity actions.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides the ability to       *
  *                      generate REDO SQL for RI actions, so    *
  *                      customers can apply the SQL in the      *
  *                      target system where referential         *
  *                      integrity is not defined. A new         *
  *                      parameter was added to the "Generate    *
  *                      Details" panel to allow the generation  *
  *                      of REDO SQL for referential integrity   *
  *                      actions.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  New parameter to allow generation of Redo SQL for RI actions
  

Problem conclusion

• Apply the PTF
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• ALA#ERRM ALA#STOR ALAA19   ALAA36   ALAAA16  ALAAA3   ALAAA3A
  ALAAFWR  ALAAPICD ALAARC1  ALAARC2  ALAARCH  ALAARCPN ALAARDCU
  ALAARDDO ALAARDRT ALAARDUW ALAAUDPN ALABSDR  ALABSQL  ALABSSQL
  ALACADMN ALACCORD ALACFGRP ALACLDEL ALACQT   ALACTAU  ALACUOW6
  ALACURR  ALADATA  ALADB2S  ALADB2SP ALADDM   ALADECP  ALADELER
  ALADIN   ALADLMPN ALADSNM  ALADTL1  ALADTL2  ALADTL3  ALADTL4
  ALADTL6  ALAERRIN ALAEXP   ALAFA    ALAFCFG  ALAFLADV 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  ALAGLOAD ALAGMT   ALAGNJCL
  ALAGVRFY ALAHDR   ALAHDRPN ALAHRC   ALAHSM   ALAJSDEF ALAJSON
  ALALAUD  ALALB2   ALALB3   ALALCOPN ALALDDSN ALALDPN  ALALEOPN
  ALALF1   ALALF1A  ALALF1B  ALALF2   ALALF3   ALALF3W  ALALFCPN
  ALALIN   ALALOG   ALALOPT  ALALPD   ALAMAINT ALAMDTL  ALAMFLTR
  ALAMFOPN ALAMGR   ALAMLOB  ALAMLSWR ALAMNTRP ALAMODEF ALAMODEM
  ALAMPNL  ALAMSGPN ALAOBD   ALAPEXP  ALAPOPUP ALAQGLPN ALAQGRPN
  ALAQGSPN ALAQSPN  ALAQTRP  ALARDR   ALAREC   ALAREC2  ALAREC3
  ALAREC3W ALARM    ALARM64  ALASBDB  ALASBDF  ALASFREX ALASQLER
  ALASRCTB ALASUBG  ALASUBGC ALATICS  ALATIME  ALATSC   ALATVRP
  ALAUES   ALAUTIL  ALAVLXPN ALAVRD   ALAXUTIL ALAZH020 ALAZH070
  ALAZH200 ALAZH500 ALAZT610 ALAZT830
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI82462

     UP22/09/27 P F209  

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.