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 1.3
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PK15573
19_Jan
2006
UK10960


WHEN EXCESSIVE AMOUNTS OF DATA ARE TRACKED, POSSIBLE S0C4 IN GENERAL REPORT.
PK11149
27_Sep
2005
UK07636


USER ABEND = 61 FOR INCORRECT RELATIVE PAGE NUMBER DETERMINATION
PK08747
25_Jul
2005
UK05698


PROBLEMS DURING READING AMONGST MULTIPLE DATASET TABLESPACES
PK05503
24_Jun
2005
UK04874


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


USER ABEND 61 PROCESSING TABLESPACES WITH DSSIZE SPECIFICATION
PQ99392
20_Jan
2005
UQ96999


LRSN VALUES FROM DB2 LOG REFLECTING YEAR-END VALUES CAN BE INCORRECTLY TRANSLATED
PQ97726
10_Dec
2004
UQ96016


DB2 LOG ANALYSIS TOOL R130 DOES NOT SUPPORT ALL METHODS OF CHARACTER CONVERSION WITH UNICODE DATA
PQ97729
10_Dec
2004
UQ96016


LOAD CARDS INCORRECTLY GENERATED WHEN LONG ROW LENGTH IS ENCOUNTERED
PQ92597
20_Aug
2004
UQ92054


BAD SQL GENERATED WITH LONG VARCHAR COLUMN DATA OF LENGTH 500
PQ88385
17_Jun
2004
UQ89700


UPDATES CAN BE INCLUDED IN REPORTS WHEN ONLY DELETES/INSERTS WERE REQUESTED.
PQ88951
17_Jun
2004
UQ89700


Archive log access failure may not properly attempt active log access
PQ89074
17_Jun
2004
UQ89700


If decimal point = ',' generated SQL can be incorrect
PQ88155
7_May
2004
UQ88226


ALAA172W messages, bad SQL and detail report output possible handling certain update type log records
PQ86027
14_Apr
2004
UQ87358


POSSIBLE SQLCODE104 WHEN RUNNING DYNAMIC SQL AND DECIMAL POINT = COMMA
PQ85790
14_Apr
2004
UQ87358


PROGRAM ALALF1 CAN FORCE A ABENDS0C1 WHEN PARTITIONED TABLESPACEIS ACCESSED IN DROPPED-OBJECT MODE
PQ85800
14_Apr
2004
UQ87358


LONG RUNNING DETAIL REPORT JOB DURING MERGE PROCESSING DUE TO REPETITIVE INSERT/DELETE ACTIVITY AGAINST SINGLE TABLE.
PQ86262
29_Mar
2004
UQ86751


ABENDU0061 DURING DETAIL REPORT PROCESSING ACCESSING TABLESPACE GREATER THAN 2GB
PQ83128
11_Feb
2004
UQ85024


INCORRECT SQL GENERATION AS A RESULT OF VARIABLE LENGTH COLUMNS WITH LENGTH=0
PQ83357
11_Feb
2004
UQ85024


ALAA052E ERROR MSG FROM DETAIL REPORT WITH RETURN CODE = 20, RESOURCE CONTENTION
PQ82794
11_Feb
2004
UQ85024


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


INCORRECT HANDLING OF 3-CHARACTER SSID USING ALA#LOAD MAY CAUSE BAD CONFIGURATION OR RETURN CODE =4
PQ83304
11_Feb
2004
UQ85024


DB2 COMMIT ISSUED MORE FREQUENTLY THAN REQUESTED WHILE RUNNING 'DYNAMIC SQL IN BATCH'
PQ81190
12_Jan
2004
UQ83981


COLUMN NAMES WITH EMBEDDED SPACES NOT HANDLED PROPERLY IN REPORTS, SQL, AND LOAD PROCESSING
PQ81780
12_Jan
2004
UQ83981


ABEND SOC4 IN MODULE ALALF1 IN DETAIL STEP7 OR BAD DETAIL REPORTOUTPUT
PQ82024
12_Jan
2004
UQ83981


S0C4 RC=11 IN ALAMAIN
PQ78908
3_Dec
2003
UQ82778


ABENDs0978 ( S0978 ) - Error in FREEMAIN due to Storage overlay
PQ80002
3_Dec
2003
UQ82778


POSSIBLE S0C4 ABEND (W/O WILDCARDS) OR ERROR MSG ALAA036E (WITH WILDCARDS) WHEN REQUESTING MANY OBJECTS FROM LIST.
PQ78232
7_Nov
2003
UQ81978


LONG ALALF1 RUNTIME, MESSAGE ALAA156I: RE-READING BSDS ISSUED SEVERAL TIMES AND DB2 LOGS ARE READ OVER AND OVER AGAIN.
PQ78492
7_Nov
2003
UQ81978


INVALIDE CARRIAGE CONTROL CHARACTER IN COLUMN 1 OF REPORT
PQ77171
2_Sep
2003
UQ79852


ABEND0C4 OR ABEND0E0 IN MODULE ALALF1: OR ABEND0C4 IN ALABSQL: REDUCE MSGALAA156I WHEN DATA COMPRESSION IS PRESENT
PQ75757
28_Jul
2003
UQ78928


DYN ALLOC FAILURE (NO DEVICES AVAILABLE) ALLOWS NO RETRY: FALSE ALAA061W MSGS: ALALOAD PROBLEM: ABENDS0C4 IN ALAREC3
PQ75259
27_Jun
2003
UQ78081


ALAA073W GENERATED IN ERROR DUE TO ALA NOT PROPERLY RETRIEVING DICTIONARY PAGE FOR PGLOGRBA VALUE, ABENDS0C4 OR ABENDS0C1
PQ74083
3_Jun
2003
UQ77413


INCORRECT HANDLING OF MULTI-VOLUME CATALOGED ARCHIVE LOGS IN THEBSDS CAN RESULT IN INCORRECT LOG READING.
PQ73759
27_May
2003
UQ77214


INCORRECT OUTPUT CAN OCCUR IF NUMBER OF ACTIVE LOGS ARE LOW AND ARCHIVING OCCURS RAPIDLY WHEN 'ACTIVE LOG PRIORITY=Y'
PQ72901
9_May
2003
UQ76785

HIPER

INCORRECT HANDLING OF MULTI-VOLUME CATALOGED ARCHIVE LOGS IN THEBSDS CAN RESULT IN INCORRECT LOG READING.
PQ73402
29_Apr
2003
UQ76425


INCORRECT OUTPUT IN GENERATED UNDO/REDO SQL DURING DETAIL REPORTRUN
PQ72095
11_Apr
2003
UQ75946

HIPER

I/O PERFORMANCE, STORAGE REUSE AND AUO INTERFACE IMPROVEMENTS: ADDITION OF EXTENDED REPORT OPTION: HELP TEXT ADDITIONS
PQ70818
28_Feb
2003
UQ74590


ABENDS013 RC4C IN DETAIL RPT: INCORROUT IN DETAIL REPORT FOR UPDATES WHERE EVERY COLUMN INCORRECTLY FLAGGED AS CHANGED
PQ70372
11_Feb
2003
UQ74068


ABENDS0C4 IN ALAREC3/ALALF3 FIELDPROCS PRESENT: MSGCTC910E IN IN SETUP: LOOP IN ALALF1: ABENDS0C4 IN ALALF3
PQ69369
16_Jan
2003
UQ73300


DB2 OBJECT RESTORE INTERFACE JCL ERRORS: IMPROPER SUMMARY REPORTFORMATTING: LOAD UTILITY ERROR: ABENDS0C4 IN ALAREC3 OR
ALALF3

Top of page