A fix is available
APAR status
Closed as program error.
Error description
The DDDEF definition for target/destination library sections needs to be added in the SAMPLIB(ALADDDEF) member, and the product version needs to be corrected in the ISPF front end. Member SAMPLIB(ALADDDEF) lacks DDDEFs for AALA*, AFEC*, and SFEC* DDs in the target library section. Also, the distribution library section lacks AFEC* DDs. Quick Start Menu and TCz display the previous version number. ---------------------------------------------------------------- 1.Fixed possible incorrect 'Generate Details' field population from modefile. 2. Fixed possible incorrect detailed report if FIELDPROC is present in the dropped object. 3. Fixed possible CEE5207E during manipulation with a profile. 4. Fixed possible wrong detail report with "current row by key" = Y and object containing FIELDPROC - check. 5. Improved help tutorial. 6. Added new repository table ALA_ADOM_SYSTABLEPART 7. Possible U0031 Abend in case object needs dictionary and it has multiple incremental IC and then full. 8. Fixed incorrect JCL generation when JSON with ADOM option, the LOADCARD DD has incorrect allocation size. 9. Fixed possible S0C4 in ALASUBGC. 10. Added validation for COND field when only one column specified in Advanced filters. 11. Possible U1003 Abend when reporting partition by growth objects. ---------------------------------------------------------------- CCQPHLQ and CCQPWRK panels of TCz show version 3.5.0. This APAR updates the shown product version. ---------------------------------------------------------------- Fixed possible ISPP121E ISPF error when Model 2 (24x80) used. Fixed possible S0C4 in ALASUBGC.ALAALOG. Fixed possible skip of the full IC after processing incremental IC. Fixed output of the ALAA576E error message. Fixed possible incorrect FRMTFILE sorting in 1PH-64 mode with UOW commit scope. Fixed possible incorrect conversion of NULL value for BINARY/VARBINARY column. 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. Added filtering over dropped objects in Archive output processing (ALAARC2) when 'PROCESS ALL=N'. Added PARTITION processing for dropped objects. Fixed possible SQL -206 error code for SQLIND=360. Fixed possible SA03 ABEND in ALAARC2. Fixed possible error in SQL generation from TCz (SALADENU(ALAUD001) - schema SYSTOOLS is hardcoded). TCz jobs descriptions were improved Fixed possible incorrect data in Details Report when 'Current row by key=Y'. Fixed possible S0C4 on an attempt to report over LOAD LOG (YES) with filter by name on a specific partition.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Log Analysis Tool for z/Os * **************************************************************** * PROBLEM DESCRIPTION: 1. Member SAMPLIB(ALADDDEF) lacks * * DDDEFs for AALA* DDs in the target * * library section. * * Quick Start Menu and TCz display * * the previous version number. * * * * 2. Fixed possible incorrect 'Generate * * Details' field population from * * modefile. * * * * 3. Fixed possible incorrect detailed * * report if FIELDPROC is present in the * * dropped object. * * * * 4. Fixed possible CEE5207E during * * manipulation with a profile. * * * * 5. Fixed possible wrong detail report * * with "current row by key" = Y and * * object containing FIELDPROC - check. * * * * 6. Improved help tutorial. * * * * 7. Added new repository table * * ALA_ADOM_SYSTABLEPART * * * * 8. Possible U0031 Abend in case * * the object needs a dictionary and * * has multiple incremental IC and * * then full. * * * * 9. Fixed incorrect JCL generation * * when JSON with ADOM option, * * the LOADCARD DD has incorrect * * allocation size. * * * * 10. Fixed possible S0C4 in ALASUBGC. * * * * 11. Added validation for COND field * * when only one column is specified * * in Advanced filters. * * * * 12. Possible U1003 Abend when * * reporting partition by growth objects. * * * * 13. CCQPHLQ and CCQPWRK panels of TCz * * show version 3.5.0. This APAR updates * * the shown product version. * * * * 14. Fixed possible allocation LOADFILE * * DD with 65535 TRACKS in ALACLDEL. * * * * 15. Fixed possible S0C4 in ALADTL2. * * * * 16. Fixed possible ISPP121E ISPF error * * when Model 2 (24x80) used. * * * * 17. Fixed possible S0C4 in * * ALASUBC.ALAGLF2 on building index for * * filters. * * * * 18. Fixed possible S0C4 in * * ALASUBGC.ALAALOG. * * * * 19. Fixed possible skip of the full IC * * after processing incremental IC. * * * * 20. Fixed output of the ALAA576E error * * message. * * * * 21. Fixed possible incorrect FRMTFILE * * sorting in 1PH-64 mode with UOW commit * * scope. * * * * 22.Fixed possible incorrect conversion * * of NULL value for BINARY/VARBINARY * * column. * * * * 23. 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. * * * * 24. Added filtering over dropped * * objects in Archive output processing * * (ALAARC2) when 'PROCESS ALL=N'. * * * * 25. Added PARTITION processing for * * dropped objects. * * * * 26. Fixed possible SQL -206 error code * * for SQLIND=360. * * * * 27. Fixed possible SA03 ABEND in * * ALAARC2. * * * * 28. Fixed possible error in SQL * * generation from TCz (SALADENU(ALAUD001) * * - schema SYSTOOLS is hardcoded). * * * * 29. TCz jobs descriptions were * * improved. * * * * 30. Fixed possible incorrect data in * * Details Report when * * 'Current row by key=Y'. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** PE Fixer for UI98931(PH63687).
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH64624
Reported component name
DB2 LOG ANALYSI
Reported component ID
5655E6601
Reported release
360
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-12-20
Closed date
2024-12-23
Last modified date
2025-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI99519
Modules/Macros
ALA#ERRM ALA#LCLF ALA#LDSN ALA#LOAD ALA#STOR ALA#WTO ALA$$CCQ ALA$$DSC ALA$$PRM ALA$$SEQ ALA$ADM1 ALA0PCNF ALA0PNL ALA@FD28 ALA@FFN8 ALA@FSP ALAA00 ALAA01 ALAA03 ALAA04 ALAA05 ALAA06 ALAA07 ALAA10 ALAA11 ALAA13 ALAA14 ALAA16 ALAA17 ALAA18 ALAA19 ALAA20 ALAA21 ALAA22 ALAA23 ALAA2M ALAA31 ALAA32 ALAA33 ALAA34 ALAA35 ALAA36 ALAA40 ALAA42 ALAA43 ALAA44 ALAA46 ALAA47 ALAA48 ALAA49 ALAA50 ALAA51 ALAA53 ALAA54 ALAA55 ALAA58 ALAA59 ALAA60 ALAA62 ALAA64 ALAA65 ALAA67 ALAA68 ALAA69 ALAA70 ALAA71 ALAA72 ALAA73 ALAA76 ALAA90 ALAAA10 ALAAA11 ALAAA11A ALAAA11B ALAAA12 ALAAA12A ALAAA12B ALAAA13 ALAAA13A ALAAA13I ALAAA13J ALAAA13P ALAAA13Q ALAAA14A ALAAA14B ALAAA15 ALAAA16 ALAAA16A ALAAA16B ALAAA17 ALAAA18 ALAAA19 ALAAA2 ALAAA3A ALAAA3B ALAAA3C ALAAA5 ALAAA5C ALAAA5CA ALAAA5D ALAAA5DA ALAAA5E ALAAA5F ALAAA5G ALAAA6 ALAAA7 ALAAA7A ALAAA7AP ALAAA7B ALAAA7BP ALAAA8 ALAAA9 ALAAAD ALAAATV ALAAC ALAACCEP ALAACVLT ALAACVTL ALAADB2 ALAADBI ALAADBI2 ALAADBI3 ALAADSLP ALAADSNP ALAAFWC ALAAFWR ALAALLOC ALAALLOP ALAALOG ALAAP1 ALAAP2 ALAAP2C ALAAP2V ALAAP3 ALAAP4 ALAAP5 ALAAPICD ALAAPYN ALAARC1 ALAARC2 ALAARCH ALAARCPN ALAARD ALAARDCU ALAARDDO ALAARDLU ALAARDRT ALAARDTU ALAARDUW ALAASQCM ALAATSC ALAATVB ALAATVI ALAATVS ALAAUDPN ALABHDR ALABIND1 ALABINDA ALABINDC ALABINDR ALABINDU ALABSDR ALABSQL ALABSSQL ALACADMN ALACADOM ALACATF ALACCFG ALACCORD ALACDC ALACDICT ALACFGRP ALACFREP ALACFRR ALACLDEL ALACLOAT ALACLST1 ALACNTL ALACNTL1 ALACQT ALACRRF ALACTAU ALACTV ALACUOW6 ALACURR ALADATA ALADB2S ALADB2SP ALADDDEF ALADDDF2 ALADDM ALADECP ALADELER ALADIN ALADISC ALADLMPN ALADSNM ALADSPG ALADSUM ALADTL1 ALADTL2 ALADTL3 ALADTL4 ALADTL6 ALADTS ALAERR ALAERRIN ALAETV ALAEXP ALAEXPI ALAEXTFD ALAFA ALAFAS1 ALAFCFG ALAFCP ALAFLADV ALAFLOBI ALAFLOBN ALAFMAIN ALAFR1CX ALAFRC8 ALAFRCA ALAFRCCM ALAFRCOL ALAFRCQS ALAFRDOB ALAFRDOS ALAFRDTL ALAFRETV ALAFRFLA ALAFRFLO ALAFRGNR ALAFRGUT ALAFRJSN ALAFRLAP ALAFRLCV ALAFRMFC ALAFRMTR ALAFRON2 ALAFRONT ALAFRPGS ALAFRPIE ALAFRPMA ALAFRPMC ALAFRSL
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R360 PSY UI99519
UP24/12/25 P F412 ¢
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":"360","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 January 2025