A fix is available
APAR status
Closed as program error.
Error description
This APAR corrects the conversion of the date on the "CONVERT LRSN TO TIMESTAMP" panel
Local fix
To get the correct date, please manually add one day to the received result.
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS * * * **************************************************************** * PROBLEM DESCRIPTION: This APAR corrects the conversion of * * the date on the * * "CONVERT LRSN TO TIMESTAMP" panel. * * * * As a PE, it also contains fixes for * * the following issues: * * * * 1. A new "View Db2 System Log Status" * * option has been added to the Utilities * * panel. This utility displays a list of * * active and archive log data sets that * * are available for the selected * * subsystem. It is meant to automate the * * process of calling the DSNJU004 * * Utility, presenting the output data in * * a convenient form. * * * * 2.A new "Generate DSN1LOGP JCL" option * * has been added to the Utilities panel. * * This functionality allows you to * * generate a DSN1LOGP JCL directly from * * the tool. * * * * 3. Possible incorrect LOB image copy * * dataset processing that identifies * * the table space name. The issue was * * caused by the incorrect skipping of * * this image copy type. * * * * 4. The BSDS validation algorithm was * * upgraded in this APAR to more * * efficiently eliminate possible * * slowdowns. * * * * 5.The ALAA440E may occur when the tool * * processes an object that was converted * * for partitioning during the reported * * timeframe. * * * * 6.If the load step (ALAGLOAD,ALACLDEL) * * in the SOURCE/TARGET section contained * * a table that is absent in the General * * report (i.e., it hasn't changed during * * the timeframe), LAT used to throw * * ALAA041E and RC = 02/04, which * * confused customers. This APAR corrects * * the message to "ALAA182I-No rows * * qualified for LOAD processing; job * * stops." and RC = 02. * * * * 7. 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 * **************************************************************** PE of UO06216 (PH69253 + PH69254). Incorrect conversion of the date on the "CONVERT LRSN TO TIMESTAMP" panel.
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH70320
Reported component name
DB2 LOG ANALYSI
Reported component ID
5655E6601
Reported release
360
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2026-02-26
Closed date
2026-03-10
Last modified date
2026-03-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ALA#CMET ALA#DSA ALA#ERRM ALA#HSA ALA#LCLF ALA#LDSN ALA#LOAD ALA#MREP ALA#STOR ALA#TRS ALA#WTO ALA$$CCQ ALA$$DSC ALA$$PRM ALA$$SEQ ALA$ADM1 ALA0ISPF ALA0PCNF ALA0PNL ALA0PROC ALA0RPT ALA@CALL ALA@FD28 ALA@FFN8 ALA@FSP ALAA00 ALAA01 ALAA02 ALAA03 ALAA04 ALAA05 ALAA06 ALAA07 ALAA08 ALAA09 ALAA10 ALAA11 ALAA12 ALAA13 ALAA14 ALAA15 ALAA16 ALAA17 ALAA18 ALAA19 ALAA20 ALAA21 ALAA22 ALAA23 ALAA2M ALAA30 ALAA31 ALAA32 ALAA33 ALAA34 ALAA35 ALAA36 ALAA40 ALAA41 ALAA42 ALAA43 ALAA44 ALAA45 ALAA46 ALAA47 ALAA48 ALAA49 ALAA50 ALAA51 ALAA52 ALAA53 ALAA54 ALAA55 ALAA56 ALAA57 ALAA58 ALAA59 ALAA60 ALAA61 ALAA62 ALAA63 ALAA64 ALAA65 ALAA66 ALAA67 ALAA68 ALAA69 ALAA70 ALAA71 ALAA72 ALAA73 ALAA74 ALAA75 ALAA76 ALAA77 ALAA81 ALAA82 ALAA83 ALAA84 ALAA90 ALAAA1 ALAAA10 ALAAA11 ALAAA11A ALAAA11B ALAAA12 ALAAA12A ALAAA12B ALAAA13 ALAAA13A ALAAA13I ALAAA13J ALAAA13P ALAAA13Q ALAAA14A ALAAA14B ALAAA15 ALAAA16 ALAAA16A ALAAA16B ALAAA17 ALAAA18 ALAAA19 ALAAA2 ALAAA20 ALAAA21 ALAAA3 ALAAA3A ALAAA3B ALAAA3C ALAAA5 ALAAA5C ALAAA5CA ALAAA5D ALAAA5DA ALAAA5E ALAAA5F ALAAA5G ALAAA6 ALAAA7 ALAAA7A ALAAA7AP ALAAA7B ALAAA7BP ALAAA8 ALAAA9 ALAAAD ALAAAODP ALAAATV ALAAC ALAACCEP ALAACVLT ALAACVTL ALAAD1LP ALAADB2 ALAADBI ALAADBI2 ALAADBI3 ALAADOB ALAADOI ALAADOS ALAADSLP ALAADSNP ALAAFER ALAAFPS ALAAFVL ALAAFWC ALAAFWR ALAALA ALAALB ALAALLO3 ALAALLOC ALAALLOP ALAALOC2 ALAALOG ALAAP1 ALAAP2 ALAAP2C ALAAP2V ALAAP3 ALAAP4 ALAAP5 ALAAPICD ALAAPPLY ALAAPYN ALAARC1 ALAARC2 ALAARCH ALAARCPN ALAARD ALAARDCU ALAARDDO ALAARDLU ALAARDRT ALAARDTU ALAARDUW ALAASQCM ALAATSC ALAATVB ALAATVI ALAATVS ALAAUDPN ALAAVLI ALAAVLS ALAAVLS2 ALABDCT ALABHDR ALABIND ALABIND1 ALABINDA ALABINDC ALABINDP ALABINDR ALABINDU ALABLNKT ALABPC ALABSCV ALABSDM ALABSDR ALABSDS ALABSQL ALABSSQL ALABZPRM ALACADMN ALACADOM ALACATF ALACATR ALACC ALACCFG ALACCORD ALACDC ALACDF ALACDICT ALACFG ALACFGRP ALACFREP ALACFRR ALACLDEL ALACLOAT ALACLST1 ALACMDR ALACNTL ALACNTL1 ALACQT ALACRRF
Fix information
Fixed component name
DB2 LOG ANALYSI
Fixed component ID
5655E6601
Applicable component levels
R360 PSY UO07092
UP26/03/12 I 1000 {
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:
12 March 2026