A fix is available
APAR status
Closed as program error.
Error description
Various fixes for Log Analysis Tool V3.5 1. Possible loop during the processing of Fast Apply 2. Possible incorrect processing of the Materialized LOB functionality 3. Improved and reduced reads of control file 4. Possible incorrect translation of LRSN to timestamp 5. Possible U0026 Abend when using Impact report 6. Possible 0C4 in ALACLDEL 7. Added V13R1M503 to TCz
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: 1. Possible ABEND U0026 in the Impact * * report. * * 2. Possible infinite loop in ALA@FSP * * when CURRENT_TIMESTAMP is used * * in DELETE statement. * * 3. Refactored and reduced calls * * to open the control file. * * 4. Added V13R1M503 option into * * "Db2 APPLCOMPAT bind option" in TCZ. * * 5. Fixed comment after DATAIN DD * * in JSON job. * * 6. Incorrect Timestamp conversion * * in ALATSC that caused incorrect * * timestamp field * * in ALA_TABLE_VERSIONING fixed. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** Various fixes for Log Analysis Tool V3.5.0
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH54938
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
2023-06-05
Closed date
2023-06-12
Last modified date
2023-07-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI92191
Modules/Macros
ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA#WTO ALA$$PRM ALA@FSP ALAADSLP ALAADSNP ALAAFWR ALAAPICD ALAARC1 ALAARC2 ALAARCH ALAARCPN ALAARDCU ALAARDDO ALAARDRT ALAARDUW ALAAUDPN ALABSDM ALABSDR ALABSQL ALABSSQL ALACADMN ALACCFG ALACCORD ALACDC ALACFG ALACFGRP ALACFRR ALACLDEL ALACQT ALACSSQL ALACURR ALADATA ALADB2S ALADB2SP ALADDM ALADECP ALADELER ALADIN ALADLMPN ALADSA ALADSNM ALADTL1 ALADTL2 ALADTL3 ALADTL4 ALADTLF ALAEBS ALAERRIN ALAESQL ALAFCFG ALAFLADV ALAFLOBI ALAFLOBN ALAFMAIN ALAFR1CX ALAFRC8 ALAFRCA ALAFRCCM ALAFRCOL ALAFRCQS ALAFRCRV ALAFRDTL ALAFRETV ALAFRFLA ALAFRFLO ALAFRGNR ALAFRJSN ALAFRLAP ALAFRLCV ALAFRMFC ALAFRPGS ALAFRPIE ALAFRPMA ALAFRPMC ALAFRSL ALAFRSP ALAFRTCV ALAFRTP1 ALAFRTSC ALAFRTVB ALAFRTVI ALAFRTVS ALAFRUT ALAFTC ALAGEN1 ALAGEND ALAGENR ALAGFL2 ALAGLOAD ALAGMR ALAGNJCL ALAHDR ALAHDRPN ALAHRC ALAIR2 ALAJSON ALALAUD ALALCOPN ALALDCR ALALDDSN ALALDPN ALALDST ALALEOPN ALALF1 ALALF1A ALALF1B ALALF2 ALALF3 ALALF3W ALALFCPN ALALIN ALALOG ALALOPT ALALPD ALAMAINT ALAMDTL ALAMFLTR ALAMFOPN ALAMLOB ALAMLSWR ALAMNTRP ALAMODEF ALAMODEM ALAMPNL ALAMSGPN ALAOBD ALAPEXP ALAPOPUP ALAQGLPN ALAQGRPN ALAQGSPN ALAQSPN ALAQTRP ALARDPG2 ALARDR ALAREC ALAREC2 ALAREC3 ALAREC3W ALARM ALASBDB ALASBDF ALASETUP ALASETWN ALASFREX ALASQL1 ALASQL1C ALASQL2 ALASQL3 ALASRCTB ALASUBG ALASUBGC ALATICS ALATIME ALATSC ALATV ALATVRP ALAUTIL ALAVBIO ALAVLXPN ALAVRD ALAVSTR ALAXUTIL
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R350 PSY UI92191
UP23/06/14 P F306
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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"3.5.0"}]
Document Information
Modified date:
03 July 2023