PH64115: VARIOUS FIXES FOR LOG ANALYSIS TOOL V3.5

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• 1. Fixed possible allocation LOADFILE DD with 65535 TRACKS in
  ALACLDEL.
  2. Fixed possible S0C4 in ALADTL2.
  3. Fixed possible ISPP121E ISPF error when Model 2 (24x80) used.
  4. Fixed possible S0C4 in ALASUBC.ALAGLF2 on building index for
     filters.
  5. Fixed possible S0C4 in ALASUBGC.ALAALOG.
  6. Fixed possible skip of the full IC after processing
     incremental IC.
  7. Fixed output of the ALAA576E error message.
  8. Fixed possible incorrect FRMTFILE sorting in 1PH-64 mode with
     UOW commit scope.
  9. Fixed possible incorrect conversion of NULL value for
     BINARY/VARBINARY column
  10 Fixed possible abend in ALAGEN1 (S0C4 in 2ph mode / S001
     in 1ph mode) on an attempt to report over LOAD REPLACE
     with filter by name on a specific partition.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the Db2 Log Analysis Tool for z/Os                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * 1. Fixed possible allocation LOADFILE DD                     *
  * with 65535 TRACKS in ALACLDEL.                               *
  * 2. Fixed possible S0C4 in ALADTL2.                           *
  * 3. Fixed possible ISPP121E ISPF error                        *
  * when Model 2 (24x80) used.                                   *
  * 4. Fixed possible S0C4 in                                    *
  * ALASUBC.ALAGLF2 on building index for                        *
  * filters.                                                     *
  * 5. Fixed possible S0C4 in                                    *
  * ALASUBGC.ALAALOG.                                            *
  * 6. Fixed possible skip of the full IC                        *
  * after processing incremental IC.                             *
  * 7. Fixed output of the ALAA576E error                        *
  * message.                                                     *
  * 8. Fixed possible incorrect FRMTFILE                         *
  * sorting in 1PH-64 mode with UOW commit                       *
  * scope.                                                       *
  * 9. Fixed possible incorrect conversion                       *
  * of NULL value for BINARY/VARBINARY                           *
  * column.                                                      *
  * 10. Fixed possible abend in ALAGEN1                          *
  * (S0C4 in 2ph mode / S001 in 1ph mode) on                     *
  * an attempt to report over LOAD REPLACE                       *
  * with filter by name on a specific                            *
  * partition.                                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF                                                *
  ****************************************************************
  Various fixes for Db2 Log Analysis Tool V 3.5
  

Problem conclusion

• Apply the PTF
  

Temporary fix

Comments

• ×**** PE24/12/02 FIX IN ERROR. SEE APAR PH64375  FOR DESCRIPTION
  

APAR Information

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

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

  UI99072

Modules/Macros

• ALA0PCNF ALA0PNL  ALA@FSP  ALAAA11  ALAAA18  ALAAA3C  ALAAA9
  ALAADSLP ALAADSNP ALAALOG  ALAARCH  ALAARCPN ALAARDCU ALAARDDO
  ALAARDRT ALAARDUW ALAASQCM ALAATVI  ALAAUDPN ALABSQL  ALACADMN
  ALACCFG  ALACCORD ALACLDEL ALACQT   ALACUOW6 ALADATA  ALADDM
  ALADIN   ALADLMPN ALAERR   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 ALAFRTVB
  ALAFRTVI ALAFRTVS ALAFRUT  ALAGEN1  ALAGFLT  ALAGIC   ALAGNJCL
  ALAHDR   ALAHDRPN ALAHLP1  ALAJSDEF ALAJSON  ALAJSONO ALAJSONW
  ALALCOPN ALALDCR  ALALDDSN ALALDPN  ALALDST  ALALEOPN ALALF1
  ALALFCPN ALALIN   ALALOG   ALALOPT  ALAMAIN  ALAMFLTR ALAMFOPN
  ALAMNTRP ALAMODEF ALAMPNL  ALAMSGPN ALAPOPUP ALAQGLPN ALAQGRPN
  ALAQGSPN ALAQMAIN ALAQSPN  ALAQTRP  ALASETWN ALASFREX ALASQLER
  ALASRCTB ALATICS  ALATIME  ALAVLXPN ALAXUTIL ALAZHSWN
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI99072

     UP24/11/21 P F411

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.