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.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK46129
20_Jun
2007
UK26328


MESSAGE ALAA358E MAY INCORRECTLY BE RETURNED
PK44265
24_May
2007
UK25510


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


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


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


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


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


ALAA041E MESSAGE WHILE DECOMPRESSING DATA.
PK38220
13_Feb
2007
UK22108


SQL RETURN CODE = +100
PK37153
25_Jan
2007
UK21594


POSSIBLE S0C4 WHEN LGBFLGS2=LGBFLOG USING LOG-FORWARD MODE
PK36802
16_Jan
2007
UK21290


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


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


ALAA415E MESSAGE ON A NEW DB2 SUBSYSTEM
PK34334
21_Dec
2006
UK20855


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


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


USE OF MISCELLANEOUS FILTERS ONLY CAUSING ALAA440E
PK33845
13_Nov
2006
UK19633


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


S0C4 OR BAD OUTPUT FORMATTING GRAPHIC UNICODE DATA
PK31698
4_Oct
2006
UK18542


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


POSSIBLE S0C4 READING BSDS AFTER DSNJCNVB
PK31744
4_Oct
2006
UK18542


INCORRECT OUTPUT DURING DROPPED OBJECT MODE WHEN IDS ARE SWAPPED
PK29815
6_Sep
2006
UK17793


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


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


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


FLOAT FIELDS MAY CAUSE ALAA325E MESSAGE
PK30853
6_Sep
2006
UK17793


ALAA190E DURING DATA DECOMPRESSION
PK28324
3_Aug
2006
UK16892


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


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


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


GENERATED SQL MAY EXCEED COLUMN 72
PK24413
5_Jun
2006
UK15108


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


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


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


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


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


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


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


POSSIBLE ABEND S0C4 DURING LOG READS.
PK21871
29_Mar
2006
UK13114


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


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


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


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


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


NEGATIVE DECIMAL CONVERSION ERROR GENERATING LOADFILE
PK18019
2_Feb
2006
UK11403


SYSTABLESPACE COLUMN TYPE=K NOT TREATED AS LARGE TABLESPACE
PK15573
19_Jan
2006
UK10961


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


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


TIME RANGE REQUESTS YIELD INCORRECT RESULTS IN DISABLED DATA SHARING
PK15344
29_Dec
2005
UK10466


FULL ROW IMAGES NOT PROPERLY MATERIALIZED IF RE-CREATED OBJECT HAS NEW
PK14137
1_Dec
2005
UK09677


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


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


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


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


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


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


ERROR HANDLING IMPROPER IN SOME CASES AND MAY CAUSE PROGRAM TO CONTINUE
PK10584
2_Sep
2005
UK06896


S0C4 IN ALAGEN1 USING OBJECT RESTORE INTERFACE ONLY
PK10065
18_Aug
2005
UK06400


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


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


INVALID SQL CONCAT STATEMENT BUILT BY PRODUCT IN GENERATED SQL
PK05503
24_Jun
2005
UK04875


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


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


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


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


RETURN CODE 8 ON VSAM PUT DUE TO IDENTICAL LRSNS RC08
PK05055
18_May
2005
UK03609


POSSIBLE ALAA190E MSG (MISSING DICTIONARY) WHEN INCREMENTAL IMAGE COPIES ACCESSED
PK03795
3_May
2005
UK03092


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


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


POSSIBLE BUFFER OVERLAYS CAN CAUSE INCORRECT REPORT OUTPUT
PK03435
13_Apr
2005
UK02386


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


POSSIBLE BAD OUTPUT IN DETAIL REPORT AND SUBSEQUENT PROCESSES HANDLING ABORTED URS
PQ99735
17_Feb
2005
UK00681


PRODUCT MISINTERPRETS RETURN CODE OF SPACES FROM FIELD PROCEDUREAS ERROR
PQ99790
17_Feb
2005
UK00681


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


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


MESSAGE ALAA024E RETURN CODE 000 REASON CODE 000 RETURNED ON DISABLED DB2 DATA SHARING SUBSYSTEM
PQ99391
1_Feb
2005
UK00205


LRSN VALUES FROM DB2 LOG REFLECTING YEAR-END VALUES CAN BE INCORRECTLY TRANSLATED
PQ99459
1_Feb
2005
UK00205


MSG ALAA0411E DETECTED DURING LOG-BACKWARD PROCESSING OF DETAIL REPORT
PQ96536
17_Jan
2005
UQ96877


ALLOW USER TO HAVE GREATER CONTROL OVER FORMAT OF GENERATED LOADFILE.
PQ98182
17_Jan
2005
UQ96877


BAD LOADCARD GENERATED IF TARGET TABLE LEFT BLANK
PQ98442
17_Jan
2005
UQ96877


INCORRECT ERROR MESSAGE GENERATED WITH MISSING ALA ARCHIVE DATASET
PQ97807
21_Dec
2004
UQ96347


INVALID OUTPUT AFTER FIELDPROC CONVERSION
PQ98326
21_Dec
2004
UQ96347


PRODUCT ERRORS WHEN USING DISABLED DATA SHARING BSDS MESSAGE ALAA415E
PQ95591
11_Nov
2004
UQ94953


IMAGE COPY READS TAKE EXCESSIVE TIME WHEN ONLY DICTIONARY NEEDED
PQ95248
8_Oct
2004
UQ93813


ALAA190E POSSIBLE DUE TO MISSING DICTIONARIES ON PARTITIONED TABLESPACE
PQ95249
8_Oct
2004
UQ93813


POSSIBLE MISSING REPORTED DATA DUE TO MISHANDLING OF INTERNAL RE-USEABLE STORAGE AREAS FOR ROLLBACKS.
PQ94378
20_Sep
2004
UQ93030


DECOMPRESSION FAILURE DUE TO INCOMPLETE IMAGE COPY ACCESS POSSIBLE ABENDS S0C7/S0C4 AT D60 IN ALAEXP IN ALADTL2
PQ93280
16_Sep
2004
UQ92979


Possible incorrect product-generated audit header column names, Load Details Step 4 RC8, MSGDSNU089I
PQ93853
16_Sep
2004
UQ92979


MERGE PROCESS WITH DATA CAPTURE CHANGES CAN BE SLOW AND/OR GENERATE INCORRECT RESULTS.
PQ92960
1_Sep
2004
UQ92478


MESSAGE ALAA190E (MISSING DICTIONARY) IN LOG-FORWARD MODE DETAILREPORT.
PQ92978
1_Sep
2004
UQ92478


POSSIBLE PUT ERROR RC08 DUE TO VIEW/ALIAS ON TABLE INVOLVED IN LOAD REPLACE.
PQ92425
18_Aug
2004
UQ91972


POSSIBLE S0C4 IN A DATA SHARING ENVIRONMENT WHILE READING DB2 LOGS.
PQ92736
18_Aug
2004
UQ91972


S0C1 ABEND in module ALAMMIF, load module ALATDLI possible when reading active logs
PQ92868
18_Aug
2004
UQ91972


ERRONEOUS SQL GENERATED WITH LONG VARCHAR COLUMN DATA OF LENGTH 500
PQ91474
28_Jul
2004
UQ91122


Possible ALAA415E message incorrectly written during CMODE processing
PQ91580
28_Jul
2004
UQ91122


RACF FAILURE READING ACTIVE LOGS ONLY WHEN UACC(NONE) FOR CURRENT USER.
PQ89983
14_Jul
2004
UQ90656


S0c7 possible when user incorrectly edits filters
PQ90050
14_Jul
2004
UQ90656


UNNEEDED LOG RECORDS (USED FOR ROW MOVEMENT BY DB2) ERRONEOUSLY USED IN REPORTING: RESULTS IN INCORRECT OUTPUT
PQ90363
14_Jul
2004
UQ90656


Log records resulting in physical row movement from one dataset to another causing ABENDU0061 in log-backward mode
PQ90502
14_Jul
2004
UQ90656


POSSIBLE BAD OUTPUT WHEN FILTERING ON SPECIFIC TYPES OF DML ACTIVITY ALAA172E
PQ88241
1_Jul
2004
UQ90329


GENERAL PERFORMANCE IMPROVEMENTS TO ALLEVIATE LONGER ELAPSED ANDCPU TIMES
PQ88887
1_Jul
2004
UQ90329


Possible missing detail report data due to DATA CAPTURE CHANGES with INSERT or DELETE.
PQ89300
1_Jul
2004
UQ90329


If decimal point = ',' generated SQL can be incorrect
PQ89932
1_Jul
2004
UQ90329


Abend S0C1 or S0C4, or other possible problems, in load module ALAGLOAD in any module due to storage overlay
PQ89082
1_Jul
2004
UQ90329


POSSIBLE ABEND OR ERROR DURING LOG-FORWARD MODE WHEN LOGGED UTILITIES AFFECT MANY PAGES
PQ89301
1_Jul
2004
UQ90329


S0c4 in ALAGEN1 when using wildcards on table filters
PQ88724
14_Jun
2004
UQ89559


Rollbacks improperly bypassed in standard LOAD mode (i.e, non-audit mode).
PQ88950
14_Jun
2004
UQ89559


Archive log access failure may not properly attempt active log access
PQ88404
18_May
2004
UQ88608


LOOPING CAN OCCUR IN PROGRAM ALADTL2 DURING CCSID CONVERSION
PQ88405
17_May
2004
UQ88608


UPDATES CAN BE INCLUDED IN REPORTS WHEN ONLY DELETES/INSERTS WERE REQUESTED.
PQ87355
30_Apr
2004
UQ87965


S0C4 RUNNING GENERAL REPORT WITH NO FILTERS IN CSECT ALASKLR.
PQ87658
30_Apr
2004
UQ87965


POSSIBLE BAD OUTPUT OR ABEND USING LOG-FORWARD IN DATA SHARING ENVIRONMENT
PQ87784
30_Apr
2004
UQ87965


POSSIBLE BAD CHANGE INDICATOR VALUES AFTER LOADING DATA INTO DB2TABLE.
PQ87837
30_Apr
2004
UQ87965


ALAA037E MESSAGE WHEN RUNNING GENERAL REPORT WITH NO OBJECT FILTERS (OR VERY MANY OBJECT FILTERS).
PQ86899
20_Apr
2004
UQ87546


USER ABEND 61 DURING DETAIL REPORT PROCESSING ACCESSING TABLESPACE GREATER THAN 2GB
PQ85082
20_Apr
2004
UQ87546


S0C4 in module ALAGEN1 (csect ALAQT) while processing quiet time report.
PQ86029
20_Apr
2004
UQ87546


POSSIBLE SQLCODE104 WHEN RUNNING DYNAMIC SQL AND DECIMAL POINT = COMMA
PQ86398
20_Apr
2004
UQ87546


TUTORIAL TEXT FOR V2.1 INCORRECTLY REFLECTS SOME PRE-V2.1 RELEASE INFORMATION.
PQ87237
20_Apr
2004
UQ87546


IEC024I HANDLING USER ERROR WHEN REQUESTING INVALID JOB IDENTIFIER FROM DETAIL REPORT PANEL.
PQ86198
9_Apr
2004
UQ87212


LOWER CASE SEARCH ON ALAAA11 CHANGES TO UPPER CASE ADVANCED FILTERS DO NOT ALLOW LOWERCASE VALUES FROM PANEL.
PQ86777
9_Apr
2004
UQ87212


INCORRECT OUTPUT GENERATED DURING "LOAD DETAILS INTO DB2" WITH CHANGE INDICATOR COLUMN.
PQ86881
9_Apr
2004
UQ87212


INCORRECT OUTPUT POSSIBLE IN DETAIL REPORT WHEN SUBMITTING JCL REPEATEDLY WITHOUT ISPF FRONT END.
PQ85802
9_Apr
2004
UQ87212


LONG RUNNING DETAIL REPORT JOB DURING MERGE PROCESSING DUE TO REPETITIVE INSERT/DELETE ACTIVITY AGAINST SINGLE TABLE.
PQ85870
9_Apr
2004
UQ87212


PROGRAM ALALF1 CAN FORCE A ABENDS0C1 WHEN PARTITIONED TABLESPACEIS ACCESSED IN DROPPED-OBJECT MODE
PQ86879
1_Apr
2004
UQ86903


INCORRECT DDL GENERATED WHEN TARGET TABLE OWNER AND NAME EXCEEDSONE LINE OF INPUT.
PQ86878
1_Apr
2004
UQ86903


SUMMARY REPORT CAN DISPLAY IMPROPERLY FORMATTED TABLE NAME WHEN USING DB2 V8 LONG TABLE NAME.
PQ84373
26_Mar
2004
UQ86651


DETAIL REPORT ERRORS DURING LOG BACKWARD ONLY IN DB2 V8
PQ83127
15_Mar
2004
UQ86180


INCORRECT SQL GENERATION AS A RESULT OF VARIABLE LENGTH COLUMNS WITH LENGTH=0
PQ83139
15_Mar
2004
UQ86180


'LOAD DETAILS INTO DB2' MAY CAUSE INCORRECT OUTPUT IN LOAD FILE & CARDS, CAUSING ERRORS IN LOAD PROCESS, AND/OR BAD
PERFORMANCE.
PQ83208
15_Mar
2004
UQ86180


SQLCODE519 IN DETAIL REPORT POSSIBLE WHEN MULTIPLE TABLESPACES IN GENERAL REPORT RESULT SET
PQ83299
15_Mar
2004
UQ86180


INCORRECT HANDLING OF 3-CHARACTER SSID USING ALA#LOAD MAY CAUSE BAD CONFIGURATION OR RETURN CODE =4
PQ83359
15_Mar
2004
UQ86180


ALAA052E ERROR MSG FROM DETAIL REPORT WITH RETURN CODE = 20, RESOURCE CONTENTION
PQ84213
15_Mar
2004
UQ86180


CONTINUOUS MODE FUNCTIONING IMPROPERLY WITH EXTRACT FILE
PQ84708
25_Feb
2004
UQ85535

HIPER

MSGIEC161I DB2 LOG ANALYSIS TOOL V2.1 ACCESS OF DB2 ACTIVE LOG CAUSES CORRUPTED VSI CHAIN DURING ENQ PROCESSING.
PQ82805
2_Feb
2004
UQ84732


IF DB2 DECIMAL POINT DEFINED AS COMMA, SQL ERRORS OCCUR DURING LOAD PROCESS (DDL CREATE) AND STATIC SQL PROGRAM EXECUTION
PQ82809
2_Feb
2004
UQ84732


ABEND SOC4 IN MODULE ALADTL1 WHILE RUNNING DETAIL REPORT OR BAD DETAIL REPORT OUTPUT
PQ82812
2_Feb
2004
UQ84732


S0C4 ABEND CAN OCCUR DURING GENERAL OR DETAIL REPORTS IF ARCHIVELOGS ARE REQUESTED THAT ARE NOT CONTAINED IN BSDS
PQ82808
2_Feb
2004
UQ84732


S0C4 RC=11 IN ALAGEN1
PQ82811
2_Feb
2004
UQ84732


USING CONTINUOUS MODE DETAIL REPORT CAN REFLECT INCORRECT VALUES
PQ81331
17_Dec
2003
UQ83289


ABEND A78-18 MAY OCCUR IN DATA SHARING ENVIRONMENT

Top of page