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: 6 July 2023
DB2 Log Analysis Tool Version 2.2
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK63624
11_Apr
2008
UK35507


RECONCILIATION PROBLEM BETWEEN GENERAL REPORT AND LOAD IN DB2 LOG ANALYSIS TOOL HIGH SPEED MODE
PK63772
11_Apr
2008
UK35507


LOADFILE PROBLEMS WHEN ADVANCED DB2 LOG ANALYSIS TOOL OPTION BYPASS DEFAULTIF USED ON TABLE WITH NON NULL AND HAS DEFAULT
PK63838
11_Apr
2008
UK35507


POSSIBLE ALAA0440E OR ALAA0447E WHILE USING MISCELLANEOUS FILTERS AND TABLES WITH DCC TURNED LOG FORWARD MODE
PK63379
3_Apr
2008
UK35211


IF THE GMT OFFSET INCLUDES A PARTIAL HOUR AMOUNT, IT IS POSSIBLETO GET NO DATA BACK FROM DB2 LOG ANALYSIS TOOL
PK62811
28_Mar
2008
UK35067


UTILID MAY NOT BE UNIQUE, CAUSING DUPLICATE ERROR
PK62900
28_Mar
2008
UK35067


DB2 LOG ANALYSIS WAS NOT REPORTING ACTIVITY ON TABLES WITH AN OBID OF 1.
PK62978
28_Mar
2008
UK35067


ABENDS0C4 IN CSECT ALAURID WITH MASS DELETES AND DATA SHARING
PK61166
10_Mar
2008
UK34413


INVALID DATE OR DUPLICATE ENTRY ADDED TO ARCHIVE TABLE ARCHIVINGOUTPUT DB2 LOG ANALYSIS TOOL RUN IF NO ACTIVITY WAS REPORTED
PK61172
10_Mar
2008
UK34413


SQLCODE313 WHEN USING CURRENT ROW BY KEY AND THE TABLE HAS MULTIPLE UNIQUE INDEXES
PK60426
15_Feb
2008
UK33767


POSSIBLE ALAA447E, ALAA440E IF THERE ARE MANY ACTIONS FOR ONE ROW AND A MASS DELETE WAS FOUND ON A DIFFERENT OBJECT
PK60450
15_Feb
2008
UK33767


NULL VALUE MAY BE QUOTED IN SQL IF ALTER CONDITION FOUND
PK60715
15_Feb
2008
UK33767


INCORRECT TIME TRANSLATION IF LEAP SECONDS ARE PRESENT
PK59759
11_Feb
2008
UK33592


EXCLUDING OBJECTS IN DETAIL REPORT OR IN RESPONSE TO ALAA358E MSG RESULTED IN OBJECTS STILL BEING CONSIDERED
PK59840
11_Feb
2008
UK33592


WHEN MANY INSTANCES OF A MASS DELETE ARE FOUND WITHIN THE TIME FRAME BEING PROCESSED AN 0C4 IS LIKELY TO OCCUR
PK58733
18_Jan
2008
UK33089


WHEN CCSID CONVERSIONS FAIL DURING DB2 LOG ANALYSIS PROCESSING, INVALID SQL STATEMENTS CAN OCCUR
PK57856
14_Dec
2007
UK32286


ALAA051E-GET ERR FOR ROWDATA, RES CDE: 088 DUE TO RECORD ACCESSBIAS=SYSTEM WHICH CAUSES VSAM RET CODE=X'58' (DECIMAL 88)
PK56316
28_Nov
2007
UK31687


ALADTL3 RECEIVES AN 0C4 WHEN DB2 IDS CAN NOT BE FOUND IN A STORED FILE DURING LOG BACKWARD REPORTING.
PK55378
12_Nov
2007
UK31163


CHARACTER FOR BIT DATA WILL NOW BE GENERATED IN A HEXADECIMAL FORMAT IN THE SQLOUT FILE
PK53506
22_Oct
2007
UK30502


ADD SUPPORT FOR THE CLEAR KEY ENCRYPTION EDITPROC FROM THE IBM DATA ENCRYPTION FOR IMS AND DB2 DATABASES
PK53965
22_Oct
2007
UK30502


INCORRECT SQL STATEMENTS ARE BEING GENERATED FOR GRAPHIC COLUMNSCONTAINING MORE THAN 20 CHARACTERS SQLCODE322
PK53994
22_Oct
2007
UK30502


LOG ANALYSIS MAY ENCOUNTER AN ALAA067E ERROR DURING CERTAIN RESTART CONDITIONS
PK52787
26_Sep
2007
UK29632


DB2 LOG ANALYSIS TOOL MAY END IN AN 0C4, IF PROCESSING INCLUDES NON-CATALOGED ARCHIVED LOG DATASETS
PK53299
26_Sep
2007
UK29632


POSSIBLE ALAA447E, ALAA440E MESSAGE WHEN MANY UPDATES TO SAME ROW
PK49046
3_Aug
2007
UK27860


POSSIBLE BAD OUTPUT OR S0C4 INVOLVING DECLARED GLOBAL TEMP TABLE
PK49540
3_Aug
2007
UK27860


ABENDB37 RC04 USING DB2 LOG ANALYSIS TOOL REPORT UTILITY
PK48454
16_Jul
2007
UK27133


SQLCODE104 WHEN PROCESSING ARCHIVED OUTPUT IF USING DB2 V8 COMPATIBILITY
PK46129
20_Jun
2007
UK26329


MESSAGE ALAA358E MAY INCORRECTLY BE RETURNED
PK44265
24_May
2007
UK25511


MESSAGE ALAA447E MAY OCCUR WHEN MASSIVE NUMBERS OF UPDATES OCCURTO SAME ROW
PK44841
24_May
2007
UK25511


ALAA058W MESSAGE CAUSES S001 RC04 IN LOG-FORWARD MODE
PK43590
10_May
2007
UK24956


DB2 DATA TYPES OF 'FLOAT' NOT ACCURATE ENOUGH DURING CONVERSION FROM INTERNAL TO DISPLAY FORMAT. MESSAGE ALAA325E MAY
RESULT.
PK42576
17_Apr
2007
UK24112


ALAA036E-THE REQUESTED FILTER OBJECT XXXXX .%%%%%%%% WAS NOT FOUND.
PK42715
17_Apr
2007
UK24112


CONTINUOUS MODE PROBLEM HANDLING 32K PAGESIZES ABENDS AND OTHER UNPREDICTABLE RESULTS
PK40580
21_Mar
2007
UK23254


ALAA041E MESSAGE WHILE DECOMPRESSING DATA.
PK38994
26_Feb
2007
UK22508


A S0C4 IS POSSIBLE WHEN USING CONTINUOUS MODE AND NO DATA IS READ . THE ABEND OCCURS IN PROGRAM ALASUBG
PK38220
13_Feb
2007
UK22109


SQL RETURN CODE = +100
PK37651
25_Jan
2007
UK21595


ABENDSB37 POSSIBLE AGAINST SYSPRINT DURING REPORT UTILITY PROCESSING
PK36802
16_Jan
2007
UK21291


INCORRECT HANDLING OF DB2 LOAD RECORDS FOUND IN THE LOG
PK36964
16_Jan
2007
UK21291


GENERATED SQL IS NOT CORRECT WHEN A DELIMETER IS EMBEDDED OR X'00' IS EMBEDDED
PK35835
3_Jan
2007
UK21020


ALAA415E MESSAGE ON A NEW DB2 SUBSYSTEM
PK36402
3_Jan
2007
UK21020


A00 ABEND DURING LOG-BACKWARD DETAIL REPORT
PK34334
21_Dec
2006
UK20856


GENERATED SQL IS NOT USABLE WHEN A X'0E' IS EMBEDDED WITHIN A CHARACTER STRING WITHOUT A TRAILING X'0F'
PK35325
21_Dec
2006
UK20856


MASS DELETE NOT FILTERED OUT IN DETAIL REPORT
PK35482
21_Dec
2006
UK20856


USE OF MISCELLANEOUS FILTERS ONLY CAUSING ALAA440E
PK34728
21_Dec
2006
UK20856


COMBINATION OF MISCELLANEOUS AND OBJECT FILTERS CAN CAUSE MSGALAA440E
PK33845
13_Nov
2006
UK19634


DISTINCT COLUMN TYPES CAUSE USER ABEND 50 IN ALAGLOAD EXTERNAL SYMPTOM CODE
PK32393
27_Oct
2006
UK19207


S0C4 OR BAD OUTPUT FORMATTING GRAPHIC UNICODE DATA
PK32596
17_Oct
2006
UK18890


FAST APPLY SQL PROCESSING MAY RETURN PARSER ERRORS WHEN PARSING SQL STATEMENTS THAT HAVE EMBEDDED QUOTES.
PK31698
4_Oct
2006
UK18543


ABEND OR INCORRECT OUTPUT WHEN LGBFLGS2=LGBFLOG
PK31743
4_Oct
2006
UK18543


POSSIBLE S0C4 READING BSDS AFTER DSNJCNVB
PK31744
4_Oct
2006
UK18543


INCORRECT OUTPUT DURING DROPPED OBJECT MODE WHEN IDS ARE SWAPPED
PK31047
25_Sep
2006
UK18287


EMBEDDED QUOTE AT END OF A LINE CAUSING GENERATED SQL TO FAIL
PK31339
25_Sep
2006
UK18287


FAST APPLY TREATING DOUBLE PRECISION FLOATING POINT VALUES AS SINGLE PRECISION
PK29815
6_Sep
2006
UK17794


ERROR MESSAGE ALAA157E DURING CONTINUOUS MODE PROCESSING
PK30036
6_Sep
2006
UK17794


LONG SQL STATEMENTS CAUSING SQL GENERATION FAILURE
PK30213
6_Sep
2006
UK17794


UNNEEDED LOG RECORDS ARE TRACKED, MAY CAUSE ABENDS
PK30613
6_Sep
2006
UK17794


FLOAT FIELDS MAY CAUSE ALAA325E MESSAGE
PK30853
6_Sep
2006
UK17794


ALAA190E DURING DATA DECOMPRESSION
PK28324
3_Aug
2006
UK16893


POSSIBLE S0C4 ON ALAGLOAD WITH MANY COLUMN NAMES
PK27912
24_Jul
2006
UK16532


POSSIBLE S0C4 IN ALASUBG PROCESSING DECLARED GLOBAL TEMPORARY TABLES
PK26247
22_Jun
2006
UK15652


ALAA440E DUE TO DB2 RECOVER UTILITY IN-PROCESS
PK25888
12_Jun
2006
UK15336


GENERATED SQL MAY EXCEED COLUMN 72
PK25890
12_Jun
2006
UK15336


MISCELLANEOUS FILTERS NOT WORKING IN DETAIL REPORT
PK24413
5_Jun
2006
UK15109


PREVIOUSLY USED JOB ID REQUIRED FOR #6 OF PRIMARY MENU
PK23754
8_May
2006
UK14277


ARCHIVING ISSUES WITH PANEL AND RUNTIME ERRORS
PK23763
8_May
2006
UK14277


S0C4 WHEN MANY TABLES USED AS INPUT DURING AUDIT MODE LOAD PROCESS
PK22924
25_Apr
2006
UK13884


CONTINUOUS MODE CAN HANG AFTER CLOCK CHANGE.
PK23035
25_Apr
2006
UK13884


ABENDS0C4 DURING ALAESQL EXECUTION USING AUDIT MODE
PK23316
25_Apr
2006
UK13884


POSSIBLE B37 ON ARCHIVE FILE GENERATED BY LOG ANALYSIS TOOL
PK22250
18_Apr
2006
UK13667


POSSIBLE ALAA190E OR S0C7 DURING DECOMPRESSION ROUTINE.
PK22638
18_Apr
2006
UK13667


POSSIBLE ABEND S0C4 DURING LOG READS.
PK22246
18_Apr
2006
UK13667


ABEND S0C4 DURING PROGRAM ALAGEN1 DUE TO EXCESSIVE LOG DATA TRACKED
PK21871
29_Mar
2006
UK13115


POSSIBLE ALAA190E OR ALAA041E RUNNING IN DROPPED OBJECT MODE
PK19996
3_Mar
2006
UK12322


USE OF MISCELLANEOUS FILTERS ONLY CAUSES POSSIBLE ABEND0C4 IN ALASUBG
PK19568
21_Feb
2006
UK11996


DECOMPRESSION ISSUES REGARDING PAGE SIZES > 4K
PK19169
14_Feb
2006
UK11760


MISSING RECORDS DUE TO MEMBER CLUSTER OPTION
PK18759
6_Feb
2006
UK11516


NEED TO SUPPRESS REPORTING ON CERTAIN DB2 LOGGED ACTIVITY
PK18901
6_Feb
2006
UK11516


NEGATIVE DECIMAL CONVERSION ERROR GENERATING LOADFILE
PK18019
2_Feb
2006
UK11404


SYSTABLESPACE COLUMN TYPE=K NOT TREATED AS LARGE TABLESPACE
PK17664
2_Feb
2006
UK11404


ALAA040E ERROR MSG USING INCREMENTAL IMAGE COPIES AND MASS DELETES
PK15573
19_Jan
2006
UK10962


WHEN EXCESSIVE AMOUNTS OF DATA ARE TRACKED, POSSIBLE S0C4 IN GENERAL REPORT.
PK17450
19_Jan
2006
UK10962


GENERATED SQL MAY BE INCORRECT WHEN USING DBCS STRINGS
PK17451
19_Jan
2006
UK10962


TIME RANGE REQUESTS YIELD INCORRECT RESULTS IN DISABLED DATA SHARING
PK13040
9_Jan
2006
UK10631


PROBLEMS GENERATING JCL USING INTERFACE BETWEEN DB2 OBJECT RESTORE R210 AND DB2 LOG ANALYSIS R220
PK15344
29_Dec
2005
UK10467


FULL ROW IMAGES NOT PROPERLY MATERIALIZED IF RE-CREATED OBJECT HAS NEW
PK14770
29_Dec
2005
UK10467


POSSIBLE ALAA040E ERROR MESSAGE PROCESSING LOG-FORWARD DETAIL REPORT
PK14137
1_Dec
2005
UK09678


ENHANCE INFORMATIONAL MESSAGE WHEN "SUPPORT FOR UNICODE" INTERFACE
PK14146
1_Dec
2005
UK09678


S0C4 OCCURS DURING PROGRAM ALADTL1 DUE TO EXHAUSTED MEMORY
PK14351
1_Dec
2005
UK09678


MESSAGE ALAA156I INCORRECTLY GENERATED DURING UNICODE CONVERSIONSERVICES
PK12036
18_Oct
2005
UK08247


LONG RUNNING DETAIL REPORT DURING IMAGE COPY READ
PK12042
18_Oct
2005
UK08247


S0C7 DURING DATA DECOMPRESSION DUE TO FASTPATH OPTION
PK11077
19_Sep
2005
UK07377


INTERFACE WITH OBJECT RESTORE FAILS TO PROPERLY HANDLE DROP TABLE
PK10520
2_Sep
2005
UK06897


ERROR HANDLING IMPROPER IN SOME CASES AND MAY CAUSE PROGRAM TO CONTINUE
PK10065
18_Aug
2005
UK06401


DECLARED GLOBAL TEMPORARY TABLES CAUSES S0C4 IN GENERAL REPORT MODULE ALASUBG
PK08747
25_Jul
2005
UK05700


PROBLEMS DURING READING AMONGST MULTIPLE DATASET TABLESPACES
PK08463
25_Jul
2005
UK05700


INVALID SQL CONCAT STATEMENT BUILT BY PRODUCT IN GENERATED SQL
PK08213
25_Jul
2005
UK05700


MESSAGE HELP FACILITY CAN GO INTO LOOP WHEN USER CONTINUOUSLY ENTERS INVALID INPUT
PK05503
24_Jun
2005
UK04876


SUPPORT "STCK TO LRSN DELTA" IN THE DB2 BSDS
PK07030
24_Jun
2005
UK04876


USER ABEND 61 PROCESSING TABLESPACES WITH DSSIZE SPECIFICATION
PK06129
24_Jun
2005
UK04876


S0C4 IN ALADTL1 PROCESSING CATALOG TABLE SYSINDEXES
PK06586
24_Jun
2005
UK04876


MISSING QUIET TIME REPORT ON A DATA SHARING SYSTEM
PK06816
24_Jun
2005
UK04876


RETURN CODE 8 ON VSAM PUT DUE TO IDENTICAL LRSNS RC08
PK04810
8_Jun
2005
UK04294


MESSAGE ALAA073W INCORRECTLY GENERATED USING EXPERT OPTIONS.
PK03795
3_May
2005
UK03093


ICH408I INSUFFICIENT ACCESS AUTHORITY READING MULTI-VOLUME TAPE ARCHIVE LOG
PK04277
3_May
2005
UK03093


S0C4 IN CSECT ALASKLR WHEN MANY ICTYPE='P' RECORDS IN SYSCOPY
PK04720
3_May
2005
UK03093


POSSIBLE BUFFER OVERLAYS CAN CAUSE INCORRECT REPORT OUTPUT
PK04579
3_May
2005
UK03093


FAST APPLY - U4083 ABEND ON V8 WITH LONG TABLE NAME
PQ99216
20_Apr
2005
UK02618


S0C4 USING FAST APPLY WITH RESTART=I WITH NO RESTART NAME
PK03435
13_Apr
2005
UK02387


FAILURE CALLING FIELD PROCEDURE WHEN PARAMETER LIST IS NOT NULL
PK01726
7_Mar
2005
UK01252


POSSIBLE BAD OUTPUT IN DETAIL REPORT AND SUBSEQUENT PROCESSES HANDLING ABORTED URS
PK00613
1_Mar
2005
UK01023


MESSAGE ALAA460E INCORRECTLY GENERATED IN PLACE OF MORE SPECIFICMESSAGE
PQ99790
17_Feb
2005
UK00682


POSSIBLE S0C7 DURING DATA DECOMPRESSION IN CSECT ALAEXP
PK00096
17_Feb
2005
UK00682


POSSIBLE MISSING DATA IN GENERAL REPORT OUTPUT USING DB2 SUBSYSTEM WITH NO ARCHIVING
PK00148
17_Feb
2005
UK00682


MESSAGE ALAA024E RETURN CODE 000 REASON CODE 000 RETURNED ON DISABLED DB2 DATA SHARING SUBSYSTEM
PK00313
17_Feb
2005
UK00682


PRODUCT MISINTERPRETS RETURN CODE OF SPACES FROM FIELD PROCEDUREAS ERROR
PQ99394
2_Feb
2005
UK00217


LRSN VALUES FROM DB2 LOG REFLECTING YEAR-END VALUES CAN BE INCORRECTLY TRANSLATED
PQ99485
2_Feb
2005
UK00217


MSG ALAA0411E DETECTED DURING LOG-BACKWARD PROCESSING OF DETAIL REPORT
PQ98658
27_Jan
2005
UK00075


INCORRECT DATA RETURNED WITH USE OF SINGLE % WILDCARD FOR AUTHID FILTERS
PQ99219
27_Jan
2005
UK00075


CLARIFICATION OF DISTRIBUTED TYPE FILTER USAGE IN HELP
PQ99222
27_Jan
2005
UK00075


PRODUCT ERRORS WHEN USING DISABLED DATA SHARING BSDS
PQ99351
27_Jan
2005
UK00075


LOADCARD CAN BE IMPROPERLY GENERATED IF TARGET TABLE OWNER/NAME = 26 CHARACTERS
PQ98068
28_Dec
2004
UQ96462


POSSIBLE S0C4 IN FECLINKL IN ALADTL1 USING LOG-FORWARD MODE
PQ98448
28_Dec
2004
UQ96462


INCORRECT ERROR MESSAGE GENERATED WITH MISSING ALA ARCHIVE DATASET
PQ97915
28_Dec
2004
UQ96462


INVALID OUTPUT AFTER FIELDPROC CONVERSION
PQ97013
9_Dec
2004
UQ95920


ALA 2.2 ROLLUP APAR

Top of page