A fix is available
APAR status
Closed as program error.
Error description
This APAR introduces a new approach to table versioning handling. Instead of relying on an external TVFILE, the tool now uses an internal Db2 table to store and manage table versioning entries. The "Track schema changes" job will store versioning entries to the table automatically as well as a regular batch process of updating from table space / image copy processing. New ISPF panels are introduced in this APAR. The "Utilities" panel now has option 3 as "Table Versioning Support", which invokes the corresponding panel. The new panel incorporates all actions regarding table versioning support: interface to delete and view particular versioning entries; running track schema changes job; importing and exporting versioning entries from the old TVFILE; interface for manual addition of entries. It is required to create a new internal Db2 table to manage table versioning entries after applying the PTF, refer to the HOLD actions for a detailed explanation of migration steps.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: This APAR introduces a new approach to * * table versioning handling. Instead of * * relying on an external TVFILE, the * * tool now uses an internal Db2 table to * * store and manage table versioning * * entries. The "Track schema changes" * * job will store versioning entries to * * the table automatically as well as a * * regular batch process of updating from * * table space / image copy processing. * * New ISPF panels are introduced in this * * APAR. The "Utilities" panel now has * * option 3 as "Table Versioning * * Support", which invokes the * * corresponding panel. * * The new panel incorporates all actions * * regarding table versioning support: * * interface to delete and view * * particular versioning entries; running * * track schema changes job; importing * * and exporting versioning entries from * * the old TVFILE; interface for manual * * addition of entries. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** Simplification of table versioning handling
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH53523
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-03-27
Closed date
2023-04-07
Last modified date
2023-05-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI91341
Modules/Macros
ALA#CMET ALA#ERRM ALA#LCLF ALA#LDSN ALA#STOR ALA#WTO ALA$$PRM ALA$$SEQ ALA@FSP ALAA05 ALAA06 ALAA08 ALAA10 ALAA13 ALAA16 ALAA30 ALAA33 ALAA44 ALAA50 ALAA52 ALAA61 ALAA62 ALAA66 ALAA71 ALAA72 ALAA74 ALAA75 ALAAA20 ALAAAD ALAAATV ALAAC ALAADSLP ALAADSNP ALAAFPS ALAAFVL ALAAFWC ALAAFWR ALAAP5 ALAAPICD ALAAPYN ALAARC1 ALAARC2 ALAARCH ALAARCPN ALAARDCU ALAARDDO ALAARDRT ALAARDUW ALAATVB ALAATVI ALAATVS ALAAUDPN ALABHDR ALABINDC ALABSQL ALABSSQL ALACADMN ALACCFG ALACCORD ALACDC ALACDICT ALACFREP ALACFRR ALACLDEL ALACQT ALACRRF ALACTV ALACURR ALADATA ALADB2SP ALADDM ALADECP ALADELER ALADIN ALADLMPN ALADSA ALADSNM ALADTL1 ALADTL2 ALADTL3 ALADTL4 ALADTLF ALADTS ALAEBS ALAEDIT ALAERRIN ALAESQL ALAEXP ALAEXPI ALAFA ALAFCFG ALAFCSTL ALAFLADV ALAFLOBI ALAFLOBN ALAFMAIN ALAFMETL 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 ALAFTC ALAFUTIL ALAGEN1 ALAGEND ALAGENR ALAGFL2 ALAGFLA ALAGFLT ALAGIC ALAGL2 ALAGL3 ALAGLOAD ALAGLOAT ALAGLSUM ALAGNJCL ALAGVRFY ALAHDR ALAHDRPN ALAHLP0 ALAHRC ALAIN4X ALAIN4XR ALAIN5X ALAIN9X ALAIN9XR ALAINBX ALAINBXR ALAIOEX ALAIR2 ALAISPMN ALAIXP ALAJSDEF ALAJSON ALAJSONW ALALB3 ALALCOPN ALALDCR ALALDDSN ALALDPN ALALDST ALALEOPN ALALF1 ALALF1A ALALF1B ALALF3 ALALF3W ALALFCPN ALALIN ALALOG ALALOPT ALALPD ALAMFLTR ALAMFOPN ALAMLOB ALAMLS ALAMLSWR ALAMNTRP ALAMODEF ALAMODEM ALAMPNL ALAMPRT ALAMSGPN ALAMSP ALAOBD ALAPEXP ALAPGR ALAPGR2 ALAPNL0 ALAPOPUP ALAQGLPN ALAQGRPN ALAQGSPN ALAQSPN ALAQT ALAQTL ALAQTP ALAQTRP ALARDPG2 ALARDR ALAREC ALAREC3 ALAREC3W ALARRFC ALARXML ALASETUP ALASETWN ALASFREX ALASI ALASKLR ALASLX ALASQ1CA ALASQ1CB ALASQL ALASQL0 ALASQL0A ALASQL0B ALASQL1 ALASQL1A ALASQL1B ALASQL1C ALASQL2 ALASQL2A ALASQL2B ALASQL3 ALASQL3A ALASQL3B ALASQLCR ALASQLER ALASRCTB ALASRPT ALASUBG ALASUBGC ALATICS ALATIME ALATSC ALATV ALATVF ALATVRP
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R350 PSY UI91341
UP23/04/14 P F304
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":"3.5.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 May 2023