PH69989: VARIOUS FIXES FOR LOG ANALYSIS TOOL V3.6

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR fixes the following items:
  
  1.	ALAZT780 help panel was updated
  2.	Fixed possible incorrect ALAA112E error message when
  reporting tables with table versioning
  3.	Fixed possible incorrect ALAA470E error, when requesting the
  LOADFILE generation with General report data
  4.	Fixed 0C4 Abend in ALAGLOAD when requesting LOADFILE with
  General report data
  5.	Corrected population of the SSID for General report data
  LOADFILE
  6.	Possible 0C4 Abend in ALAGEN1 when requesting the One phase
  64 bit mode with option Spill
  7.	Corrected possible ALAA364E with Generate Redo SQL = Y when
  bypassing SQL generation
  8.	Removed excessive ALAA156I messages
  
  9.	Possible 0C4 Abend when requesting Delimited LOADFILE
  10.	Possible 0C4 Abend in ALATSC when receiving warnings
  11.	Possible S001 Abend when processing archive output
  12.	IDMAP report generation correction for LOB objects
  13.	Improved error handling for object filters by name
  14.	Improved validation of the Miscellaneous Filters panel
  15.	Possible incorrect -803 SQL error when requesting Track
  Schema changes
  16.	Corrected conversion of old-format archive output data
  17.	Fixed storage deallocation when reporting large amount of
  data
  18.	Possible JCL error when requesting LOADFILE with general
  report data
  19.	Possible 0C4 Abend when converting mode file
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR fixes the following minor     *
  *                      problems:                               *
  *                                                              *
  *                      1) ALAZT780 help panel was updated      *
  *                      2) Possible incorrect ALAA112E error    *
  *                      message when reporting tables with      *
  *                      table versioning                        *
  *                      3) Possible incorrect ALAA470E error    *
  *                      when requesting the LOADFILE generation *
  *                      with General report data                *
  *                      4) S0C4 Abend in ALAGLOAD when          *
  *                      requesting LOADFILE with General report *
  *                      data                                    *
  *                      5) Corrected population of the SSID for *
  *                      General report data LOADFILE            *
  *                      6) Possible 0C4 Abend in ALAGEN1 when   *
  *                      requesting the One phase 64 bit mode    *
  *                      with option Spill                       *
  *                      7) Corrected possible ALAA364E with     *
  *                      Generate Redo SQL = Y when bypassing    *
  *                      SQL generation                          *
  *                      8) Removed excessive ALAA156I messages  *
  *                      9) Possible 0C4 Abend when requesting   *
  *                      Delimited LOADFILE                      *
  *                      10) Possible 0C4 Abend in ALATSC when   *
  *                      receiving warnings                      *
  *                      11) Possible S001 Abend when processing *
  *                      archive output                          *
  *                      12) IDMAP report generation correction  *
  *                      for LOB objects                         *
  *                      13) Improved error handling for object  *
  *                      filters by name                         *
  *                      14) Improved validation of the          *
  *                      Miscellaneous Filters panel             *
  *                      15) Possible incorrect -803 SQL error   *
  *                      when requesting Track Schema changes    *
  *                      16) Corrected conversion of old-format  *
  *                      archive output data                     *
  *                      17) Storage deallocation when reporting *
  *                      large amount of data                    *
  *                      18) Possible JCL error when requesting  *
  *                      LOADFILE with general report data       *
  *                      19) Possible 0C4 Abend when converting  *
  *                      mode file                               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Various fixes for Log Analysis Tool V3.6
  

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#LCLF ALA#LDSN ALA#STOR ALAA13   ALAA2M   ALAA66
  ALAA77   ALAA84   ALAAC    ALAADSLP ALAADSNP ALAAFWC  ALAAFWR
  ALAAPICD ALAARC1  ALAARC2  ALAARCH  ALAARCPN ALAARDCU ALAARDDO
  ALAARDRT ALAARDUW ALAASQCM ALAAUDPN ALABSCV  ALABSQL  ALABSSQL
  ALACADMN ALACATF  ALACCORD ALACDC   ALACDF   ALACDICT ALACFREP
  ALACFRR  ALACLDEL ALACLOAT ALACQT   ALACRRF  ALACTAU  ALACUOW
  ALACUOW6 ALACURR  ALAD1LP  ALADATA  ALADB2AC ALADB2SP ALADDM
  ALADELER ALADIN   ALADLMPN ALADSNM  ALADSPG  ALADSUM  ALADTL3
  ALADTS   ALAERRIN ALAETV   ALAEXP   ALAEXPI  ALAFCFG  ALAFCP
  ALAFFV   ALAFLADV ALAFLOBI ALAFLOBN ALAFMAIN ALAFR1CX ALAFRC8
  ALAFRCA  ALAFRCCM ALAFRCOL ALAFRCQS ALAFRDLP ALAFRDOB ALAFRDOS
  ALAFRDTL ALAFRETV ALAFRFLA ALAFRFLO ALAFRGNR ALAFRGUT ALAFRJSN
  ALAFRLAP ALAFRLCV ALAFRMFC ALAFRMTR ALAFRPGS ALAFRPIE ALAFRPMA
  ALAFRPMC ALAFRSL  ALAFRSP  ALAFRTCV ALAFRTP1 ALAFRTSC ALAFRTVB
  ALAFRTVI ALAFRTVS ALAFRUT  ALAFRVLI ALAFRVLS ALAFTC   ALAGEN1
  ALAGENR  ALAGFLA  ALAGFLT  ALAGLOAD ALAGLSUM ALAGNJCL ALAGRWRT
  ALAHDR   ALAHDRPN ALAHRC   ALAIDRP  ALAIN5GX ALAIOEX  ALAIXP
  ALAJSDEF ALAJSON  ALAJSONO ALAJUUT  ALALAUD  ALALB3   ALALCOPN
  ALALDCOM ALALDCR  ALALDDSN ALALDPN  ALALDST  ALALEOPN ALALF1
  ALALF1A  ALALF1B  ALALF2   ALALF3   ALALF3W  ALALFCPN ALALFP
  ALALIN   ALALLB   ALALOPT  ALALPD   ALALXP   ALAMDTL  ALAMFLTR
  ALAMFOPN ALAMLOB  ALAMLREP ALAMLS   ALAMNTRP ALAMODEF ALAMPNL
  ALAMPR2  ALAMPRT  ALAMSGPN ALAMSP   ALAOBD   ALAODPC  ALAODPPN
  ALAPEXP  ALAPGR   ALAPGR2  ALAPOPUP ALAPRI2  ALAPSB   ALAQGLPN
  ALAQGRPN ALAQGSPN ALAQSPN  ALAQSRT  ALAQTRP  ALARDR   ALAREC
  ALAREC2  ALAREC3  ALAREC3W ALARFRMT ALARRE   ALARRFC  ALARROWD
  ALARXML  ALASBDB  ALASBDF  ALASETUP ALASETWN ALASFREX ALASI
  ALASLX   ALASPLL  ALASQLER ALASRCTB ALASUBC  ALASUBGC ALATICS
  ALATSC   ALATV    ALATVF   ALATVRP  ALAUTIL  ALAUTL64 ALAVBSDS
  ALAVLDEX ALAVLXPN ALAVRD   ALAXDRP  ALAZT780
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R360 PSY UO06990

     UP26/04/02 P F603

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.