Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 8 May 2018
DB2 Log Analysis Tool Version 3.5
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PI94178
2_Apr
2018
UI54922


SUPPRESSION OF LEADING ZEROS IN THE DELIMITED LOADFILE
PI94261
2_Apr
2018
UI54922


POSSIBLE LOOP IN MODULE ALADTL1 WHEN OUT OF MEMORY CONDITION OCCURS
PI94552
2_Apr
2018
UI54922


ISSUE WITH TRANSACTION REPORT IN DETAIL REPORT WHEN SKIP FORMATTING = Y
PI94741
2_Apr
2018
UI54922


LOB / XML ISSUES WHEN GENERATING LOADFILES
PI92839
5_Mar
2018
UI54241


EXCLUDED XML / LOB COLUMNS STILL REQUIRE TRACKING FOR LOADFILE /SQL GENERATION
PI92894
5_Mar
2018
UI54241


INCORRECT BEHAVIOR WHILE READING IMAGE COPY WITH MULTIPLE PARTITIONS IN A PBR2 TABLESPACE
PI92890
5_Mar
2018
UI54241


ADDING ABILITY TO CONTROL REPORT SELECTION VIA MODEPARM EVEN WHEN WRITING REPORTS TO DATASETS
PI93366
5_Mar
2018
UI54241


PERFORMANCE IMPROVEMENT FOR UOW LOOKUP
PI93558
5_Mar
2018
UI54241


VARIOUS LOB / XML ISSUES RESOLVED
PI91135
9_Feb
2018
UI53769


MESSAGE IEC0201 001-4 OR IEC036I 002-04 ON CATFILE
PI91450
9_Feb
2018
UI53769


CONTROL FILE REPORT MAY INCORRECTLY SHOW LOAD LIBRARIES AS NOT APF AUTHORIZED
PI91463
9_Feb
2018
UI53769


ADDING SUPPORT FOR TRANSPARENT DATASET ENCRYPTION WITHIN ACTIVE DB2 LOG FILES.
PI91865
9_Feb
2018
UI53769


ISSUES WITH DB2 SORT WHEN A FILE SIZE EXCEEDS 65,535 TRACKS
PI92233
9_Feb
2018
UI53769


THE LOADCARD CAN BE GENERATED INCORRECTLY WHEN REORDERING THE DATA COLUMNS
PI92234
9_Feb
2018
UI53769


INCORRECT LOADCARD CAN BE GENERATED WHEN SPLITTING LOADFILES
PI92496
9_Feb
2018
UI53769


BIND JOB RECEIVES SQLCODE -4743 WHEN APPLCOMPAT SET IN DB2 12 LESS THAN V12R1M100
PI91444
12_Jan
2018
UI53196


ALAA440E AFTER DB2 SORT FAILURE DURING ROW MOVEMENT PROCESSING
PI91462
12_Jan
2018
UI53196


THE SQL PROCESSOR IN LOG ANALYSIS TOOL NOT HANDLING USER DEFINEDDATATYPES FOR VARCHAR, VARGRAPHIC
PI91464
12_Jan
2018
UI53196


VARIOUS ISSUES WHEN MULTIPLE VERSIONS OF A TABLE EXIST
PI91514
12_Jan
2018
UI53196


LONG RUNNING PROCESS WHEN USING IMAGE COPIES FROM PARTITIONED TABLESPACES
PI90323
8_Jan
2018
UI53054


ADDING A CONTINUEIF PARAMETER TO THE GENERATED DB2 LOADFILE AND LOADCARD
PI90787
8_Jan
2018
UI53054


MESSAGE ALAA440E WITH SPANNED RECORDS FOR REPORTING DATA AND SPANNED RECORDS FOR DISTRIBUTED TRANSACTIONS.
PI91071
8_Jan
2018
UI53054


VARIOUS ISSUES WITH GENERATING A DELIMITED OR FIXED FORMAT LOADFILE WITH MULTIPLE TABLES IN A SEGMENTED TABLESPACE
PI89909
5_Dec
2017
UI52404


ALAA157E CAN OCCUR EVEN WHEN PROCESSING A SINGLE MEMBER OF A DATASHARING ENVIRONMENT
PI90257
5_Dec
2017
UI52404


ABEND S0C4 IN MODULE ALAGEN1 WHEN PROCESSING OVER 1,000 ARCHIVE LOGS
PI90486
5_Dec
2017
UI52404


WHEN "USE ONLY ARCHLOG2 = P' AND 'ACTIVE LOG PRIORITY = Y', ARCHLOG1 IS USED
PI89345
16_Nov
2017
UI51958


POSSIBLE S0C4 IN CSECT ALALB2 WHEN DATA RECORD IS NEAR END OF BUFFER
PI89773
16_Nov
2017
UI51958


ABEND S0C4 IN MODULE ALADTL1 WHEN PROCESSING LOBS FROM IMAGE COPIES
PI89818
16_Nov
2017
UI51958


VARIOUS ISSUES WHEN CREATING A FIXED EXTERNAL OR DELIMITED LOADFILE AFTER MODIFYING MODEPARM FILE
PI89774
16_Nov
2017
UI51958


FIXED FORMAT AND DELIMITED LOADFILES ARE NOT HONORING THE LOAD SPECIFICATION
PI89917
16_Nov
2017
UI51958


U=77 ABEND WHEN PROCESSING LOBS
PI88473
25_Oct
2017
UI51429


MESSAGE ALAA172E DURING SQL GENERATION
PI88469
25_Oct
2017
UI51429


NULLS QUOTED IN SQL
PI88472
25_Oct
2017
UI51429


U077 ABEND WITH MULTIPLE LOBS
PI86542
19_Oct
2017
UI51274


ALAA470E DURING LOAD ON 32K PAGESIZES
PI86230
27_Sep
2017
UI50663


POSSIBLE S0C7 ABEND DURING THE BSDS REPORT
PI86317
27_Sep
2017
UI50663


S0C4 CAN OCCUR WHILE READING ACTIVE LOGS THAT HAVE MORE THAN 4GBOF DATA
PI86570
27_Sep
2017
UI50663


IEC141I 013-20 ON DD SYSPRINT CAN OCCUR WHEN USING IEBGENER FOR FAST BACKUP
PI86889
27_Sep
2017
UI50663


A S0C7 ABEND CAN OCCUR WHEN USING COMBO MODE AND INCREMENTAL IMAGE COPIES
PI87027
27_Sep
2017
UI50663


MESSAGE ALAA073E WHEN TABLE VERSIONING, FULL ROW IMAGES, AND A CHANGE IN COMPRESSION DICTIONARY OCCURS
PI85020
30_Aug
2017
UI49956


MISCELLANEOUS FILTER UNIQUENESS VALUE DOES NOT WORK
PI85788
30_Aug
2017
UI49956


AN IEC020I 001-4 MESSAGE ON DD ALAERRI CAN OCCUR IF RUNNING IN LOG BACKWARD MODE AND WARNING ALAA573W IS TRYING TO BE
ISSUED.
PI85940
30_Aug
2017
UI49956


ENABLE CONTINUE AFTER ERRORS OPTION IN QUICK START USER SETTINGS
PI69208
21_Aug
2017
UI49718


MISSING TRANSACTION INFORMATION IN URIDF
PI81856
21_Aug
2017
UI49718


ROLL-UP APAR #1
PI81861
21_Aug
2017
UI49718


ROLL UP APAR #2
PI84243
21_Aug
2017
UI49718


U=78 ABEND IN MODULE ALADTL1 WHEN PROCESSING LOG RECORDS FOR DELETING POINTER ROWS
PI84525
21_Aug
2017
UI49718


S0C4 IN MODULE ALADTL1 WHEN ONLY REPORTING A REORG LOG YES
PI83082
23_Jun
2017
UI48262


ALAA068E ERROR WHEN THE DB2 DATASET FOR A PARTITION HAS BEEN DELETED
PI81853
5_Jun
2017
UI47794


POSSIBLE ALAA046E WHEN COMPRESSION DICTIONARY IS NOT IN THE FIRST DATASET OF A MULTI-DATASET NON-PARTITIONED TABLESPACE
PI80904
15_May
2017
UI47247


ABORTED UNITS OF WORK REPORTING INCORRECTLY WHEN SPANNED ACROSS ARCHIVE LOGS
PI79335
1_May
2017
UI46866


RUNLIB NOT PROPERLY ALLOCATED
PI77607
25_Apr
2017
UI46687


ABENDS0C4 IN ALADTL1 IS POSSIBLE WHEN A MIXTURE OF COMPRESSED AND UNCOMPRESSED LOG RECORDS EXIST FOR THE SAME OBJECT
PI76805
18_Apr
2017
UI46506


JOB READS TOO MANY IMAGE COPIES
PI76477
13_Mar
2017
UI45513


CREATE A 'CONTINUE PROCESSING ON ERRORS' OPTION FOR HIGH SPEED MODE
PI75347
23_Feb
2017
UI44962


PARAMETER "RESTART ASSIST ON CONTINUOUS MODE" NOT GETTING UPDATED IN THE GENERAL REPORT FROM THE MODEPARM FILE
PI75410
9_Feb
2017
UI44542


FASTER METHOD TO BACKUP EXTFILE
PI73497
1_Feb
2017
UI44380


ALAA148E MESSAGE ISSUED WITHOUT A DATASET NAME.
PI74208
25_Jan
2017
UI44205


ERROR MESSAGE ALAA564E WITH LONGVAR TYPE COLUMN
PI72317
15_Dec
2016
UI43382


ENHANCEMENT TO ALLOW THE USER TO CONTROL WHICH DIAGNOSTIC REPORTS ARE WRITTEN DURING A LOG ANALYSIS RUN
PI72469
6_Dec
2016
UI43125


POSSIBLE MISSING RECORDS USING HISPEED, ROWDATA AS QSAM, AND CONTINUOUS MODE WHEN EXTFILE RESIDES ON MULTI-VOLUME DATASET
PI69816
23_Nov
2016
UI42863


POSSIBLE EXCESSIVE LOG USAGE
PI71672
8_Nov
2016
UI42365


MESSAGE ALAA440E OR ALAA447E WHEN USING MISC FILTERS 16/11/02 PTF
PECHANGE
PI69940
28_Oct
2016
UI42137


SUPPORT FOR FUTURE RELEASE OF DB2
PI68215
6_Oct
2016
UI41462


ABEND0C4 IN ALAGEN1 WITH MANY URIDS | ABEND3247 WHEN USING A V11 DB2 SUBSYSTEM IN NFM AND DSNDECP IN
CONVERSION
PI68464
26_Sep
2016
UI41111


ADDING A REPORTING OPTION FOR DB2 COMMANDS IN LOG ANALYSIS TOOL
PI66373
30_Aug
2016
UI40485


ALAA517E MESSAGE WHEN USING HIGH SPEED MODE WITH LOAD LOG YES
PI66376
30_Aug
2016
UI40485


ABEND S0C4 IN MODULE ALADTL2
PI65730
22_Aug
2016
UI40274
PI71672

MESSAGE ALAA440E OR ALAA447E WHEN USING MISC FILTERS
PI65749
22_Aug
2016
UI40274


ERROR MESSAGE ALAA628E - UNSUPPORTABLE DROP COLUMN ACTIVITY
PI65753
22_Aug
2016
UI40274


HANG IN MODULE ALAGEN1
PI66701
22_Aug
2016
UI40274


ABEND S0C7 IN MODULE ALADTL2 WHEN USING COMPRESSION
PI65010
11_Aug
2016
UI40045


ABEND S0C4 WITH XML AND DATA CAPTURE CHANGES
PI63159
12_Jul
2016
UI39331


A UNIT OF WORK COULD BE REPORTED A SECOND TIME WHEN USING THE 64 BIT MEMORY THRESHOLD PARAMETER.
PI63597
12_Jul
2016
UI39331


INCLUDE / EXCLUDE COLUMNS FOR LOADFILE / LOADCARD GENERATION ARENOT ALWAYS HONORED
PI63931
12_Jul
2016
UI39331


POSSIBLE LOOP DURING ERROR HANDLING IN MODULE ALADTL1
PI63848
12_Jul
2016
UI39331


MISSING RECORDS USING HIGH SPEED MODE AND PARALLELISM > 1
PI64295
12_Jul
2016
UI39331


LOB/XML PROBLEMS WITH DROPPED OBJECT MODE
PI61143
20_Jun
2016
UI38800


ALLOW THE PROCESSING OF LOAD LOG YES ACTIVITY IN HI-SPEED PROCESSING
PI61767
6_Jun
2016
UI38442


ABEND S0C4 WHEN USING FLDPROCS IN TABLES THAT HAVE MULTIPLE VARIABLE LENGTH COLUMNS
PI59353
27_May
2016
UI38243


REPORTING ON LOAD LOG YES ACTIVITY MAY OMIT SOME ACTIVITY
PI59899
27_May
2016
UI38243


ISPF ERROR ISPV006 ON THE PROFILE PANEL
PI60502
27_May
2016
UI38243


TABLES WITH FIELD AND EDIT PROCEDURES MAY HAVE COLUMN NAMES INCORRECTLY DISPLAYED IN REPORTS AND GENERATED SQL
PI60883
27_May
2016
UI38243


ABEND U0075 OR S0C4 ABENDS WHEN TRACKED DATA INCLUDES XML
PI56335
2_May
2016
UI37486


AN SVC DUMP MAY OCCUR DURING CLEANUP PHASE OF A JOB THAT USED ZIIP OFFLOAD
PI57227
2_May
2016
UI37486


MESSAGE ALAA064E WHEN MULTI-DATASET NON-PARTITIONED TABLESPACE FLASH COPY MISSING BUT COPYTOCOPY IC EXISTS FOR R340 R350
PI57168
2_May
2016
UI37486


USER COMPLETION CODE=0050 WHEN REPORTING USER PRIVILEGES
PI58007
2_May
2016
UI37486


IEC020I 001-4 ON MESSAGE LIBRARY IF USER NOT AUTHORIZED TO VIEW SOME OBJECTS BEING REPORTED
PI56165
25_Apr
2016
UI37291


PROVIDE TOLERATION SUPPORT FOR FUTURE DB2 ENHANCEMENTS
PI56414
11_Mar
2016
UI36150


NEW THRESHOLD PARAMETER TO STOP PROCESSING ARCHIVE LOGS IN GENERAL REPORT
PI54676
10_Feb
2016
UI35269


ABEND S0C4 IN MODULE ALADTL3 WHEN PRODUCING A TRANSACTION REPORT
PI48145
3_Feb
2016
UI35031


ABEND0C4 IN CSECT ALACFRR
PI53621
29_Jan
2016
UI34882


ABEND U22 AND/OR U47 WHILE PROCESSING LOBS
PI54677
26_Jan
2016
UI34748


MESSAGE ALAA440E WHEN REPORTING AN UPDATE WHEN IMAGE COPY IS BEING TAKEN.
PI53487
19_Jan
2016
UI34577


POSSIBLE ERRONEOUS ALAA516E WHEN PROCESSING A PAGE FORMAT RECORDTHAT SPANS MULTIPLE ARCHIVE LOGS
PI49356
5_Jan
2016
UI34238


SETUP PANEL LOADLIB ENTRIES IGNORED
PI51317
7_Dec
2015
UI33591


MESSAGE ALAA440E WHEN USING SHRLEVEL CHANGE IMAGE COPIES
PI52612
7_Dec
2015
UI33591


POSSIBLE ALAA447E WHEN PROCESSING AN IMAGE COPY THAT CONTAINS MULTIPLE PARTITIONS THAT ARE NOT CONTIGUOUS
PI50738
24_Nov
2015
UI33126


ABENDS0C4 IN MODULE ALADTL1 WHEN PROCESSING LOAD LOG YES WITH A COMPRESSED TS
PI51174
24_Nov
2015
UI33126


S0C6 ABEND IN MODULE ALADTL2 WHEN USING PARTITIONED OBJECTS AND COMPRESSION
PI49260
19_Nov
2015
UI33126


ABENDS0C7 IN MODULE ALADTL2
PI48990
16_Nov
2015
UI32987


ALAA338E POSSIBLE WHEN USING RELATIVE END DATE AND CONTINUOUS MODE PROCESSING TOGETHER
PI48023
3_Nov
2015
UI32621


IMPROPER PARTITION NUMBER DERIVED
PI47585
20_Oct
2015
UI32200


PROFILE RENAME ISSUES WHEN FIRST PART OF RENAME IS AN ISPF COMMAND
PI49328
19_Oct
2015
UI32161


POSSIBLE LOOP/HANG AFTER MEMORY EXHAUSTION
PI49098
12_Oct
2015
UI31950


ALAA440E WHEN PROCESSING A SPANNED LOG RECORD AND MISC ONLY FILTERS
PI47219
7_Oct
2015
UI31849


ABENDS0C4 IN MODULE ALADTL2 OR ALAA052E ERROR MESSAGE
PI48085
30_Sep
2015
UI31654


INCREASING THE AMOUNT OF TABLES THAT CAN BE PROCESSED WHEN GENERATING A LOADFILE
PI45591
22_Sep
2015
UI31354


AN INCORRECT VALUE MAY BE GENERATED FOR FLOATING POINT NUMBERS DUE TO ERROR DURING ROUNDING.
PI44804
3_Sep
2015
UI30837


INVALID JCL MAY BE GENERATED FOLLOWING TCZ DISCOVER
PI41594
18_Aug
2015
UI30292

HIPER

VARIOUS ISSUES AFTER MIGRATING TO DB2 11 CM INCLUDING SQLCODE -302 AND ALAA628E MESSAGE
PI43061
6_Aug
2015
UI30024


MESSAGE ALAA157E GENERATED INCORRECTLY
PI40478
24_Jul
2015
UI29734


ABEND S0C4 IN MODULE ALADTL1 WHEN TOTAL SUM OF PARTITIONS WITH DATA BEING REPORTED EXCEEDS 2700
PI39943
29_Jun
2015
UI28926


ALAA064E WHEN ATTEMPTING TO USE FLASHCOPY IMAGE COPY FROM A MULTI-DATASET NON PARTITIONED TABLESPACE
PI40168
29_Jun
2015
UI28928


ABENDS0C4 ABEND IN MODULE ALADTL2
PI40961
22_Jun
2015
UI28697


ROLLUP APAR

Top of page