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 3.1.0
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM33907
9_May
2011
UK67558
PM43068

POSSIBLE S0C4 IN LOG ANALYSIS TOOL WHEN GENERATING SQL FOR A NULL FLOATING POINT COLUMN.
PM34122
9_May
2011
UK67558
PM43068

POSSIBLE PROBLEMS WITHIN LOG ANALYSIS TOOL WHEN ARCHLOG1 OR ARCHLOG2 IS WRITTEN TO MULTIPLE VOLUMES BUT THE OTHER IS NOT
PM35979
9_May
2011
UK67558
PM43068

PROBLEMS PROCESSING MULTIPLE OBJECTS WITH TABLE VERSIONING INFORMATION IN LOG ANALYSIS. ABEND0C7 IN ALADCNV + X'82A'
PM35669
9_May
2011
UK67558
PM43068

ABEND0C4 RC11. TVFILE NOT BEING ALLOCATED IN TWO PHASE JOB DURING CREATION OFLOADFILE WHEN NEEDED.
PM35893
9_May
2011
UK67558
PM43068

POSSIBLE S0C4 WHEN CREATING A LOADFILE DUE TO A TABLE WITH ROW REORDER FORMAT HAVING A COLUMN ADDED
PM28316
19_Apr
2011
UK66911


LOB/XML ISSUES WHEN LOADING BACK INTO DB2.
PM28335
19_Apr
2011
UK66911


U0073 ABEND DURING GENERAL REPORT
PM34355
19_Apr
2011
UK66911


ABENDU0013 WHEN USING DROPPED OBJECT MODE AND FIRST ITEM IN RECOVERY IS LOAD REPLACE LOG YES
PM32791
24_Feb
2011
UK65190


ALAA073W WARNING WHEN USING LARGE SEGMENTED TABLESPACES
PM30742
24_Feb
2011
UK65190


LOG ANALYSIS TOOL MAY NOT REPORT ON CERTAIN OBJECTS AFTER THE DB2 LOG RBA HAS BEEN RESET
PM31818
24_Feb
2011
UK65190


ABENDS0C4 DURING ERROR HANDLING OF ERROR IN LOG READING PHASE OF DTL REPORT
PM32136
24_Feb
2011
UK65190


PROBLEMS WITH ADVANCED FILTERS IN ONE PHASE WORK FILE MODE WHEN DEALING WITH LARGE VOLUMES OF DATA. ALAA172E U4038
PM28631
14_Feb
2011
UK64826


ABENDSC03 OCCURS WHEN AN ERROR IS ENCOUNTERED DURING FORMATTINGGWHEN USING 1 PHASE WORK FILE MODE.
PM29200
14_Feb
2011
UK64826


MSGALAA447E DUE TO SEGMENTED TABLESPACE AND ORDER OF UPDATES.
PM29563
14_Feb
2011
UK64826


DB2 LOG ANALYSIS TOOL ADDING SUPPORT FOR LARGE BLOCK INTERFACE (LBI) FOR INLINE IMAGE COPIES
PM29973
14_Feb
2011
UK64826


PROBLEMS PROCESSING MULTIPLE OBJECTS WITH NEW TABLE VERSIONING INFORMATION IN LOG ANALYSIS TOOL
PM28097
14_Feb
2011
UK64826


ABEND0C4 OR ERROR MSGALAA506E COULD RESULT WHEN THERE ARE MULTIPLE SPANNNED DB2 LOG RECORDS FOR THE SAME PAGE.
PM04469
12_Jan
2011
UK63904


DB2 LOG ANALYSIS TOOL FAST APPLY SQL UNABLE TO HANDLE SOME SQL STATEMENTS WITH ONE VERY LARGE COLUMN STRING
PM18284
12_Jan
2011
UK63904


DB2 LOG ANALYSIS TOOL FAST APPLY SQL MAY ISSUE A -330 SQL ERROR CODE WHEN HANDLING SQL FOR A UNICODE TABLE WITH XML COLUMNS
PM01856
12_Jan
2011
UK63904


WHEN USING ONE PHASE MODE, LOG ANALYSIS MAY ABEND WITH A SC03 IFTHE FILTER SYNTAX IN THE JCL IS NOT CORRECT
PM26353
12_Jan
2011
UK63904


MESSAGE ALAA447E WITH PARTITIONED TABLE IN LOG-FORWARD MODE
PM22795
10_Dec
2010
UK63007


INCOMPLETE ERROR MESSAGES ISSUED AND ABEND0C4
PM25628
10_Dec
2010
UK63007


ABEND0C4 INCORROUT SPANNED DB2 LOG RECORD FOR DB2 RESTART
PM26096
10_Dec
2010
UK63007


LOG ANALYSIS TOOL GETS ABENDS013 REASON=000000E1 WITH LBI IMAGE COPIES
PM26887
10_Dec
2010
UK63007


POSSIBLE S0C4 WHEN USING HI-SPEED MODE AND HAVE LARGE UNITS OF WORK OR A UOW THAT HAS A LARGE SPAN FROM START TO FINISH.
PM23983
29_Nov
2010
UK62631


S002 ABEND WHILE PROCESSING LOB DATA
PM25622
29_Nov
2010
UK62631


POSSIBLE LONG RUNNING JOB WHEN USING ADVANCED FILTERS AND CURRENT ROW
PM26352
29_Nov
2010
UK62631


LOADFILE NOT BEING GENERATED PROPERLY AFTER ADDING A COLUMN TO A TABLE. POSSIBLE ABEND0C4.
PM23126
29_Nov
2010
UK62631


HIGH CPU OCCURS IN GENERAL REPORT DUE TO ROLLBACK
PM23353
3_Nov
2010
UK61897


ABENDU0024 IN DB2 LOG ANALYSIS TOOL MODULE ALADTL1 WHEN DEALING WITH COMPRESSION DICTIONARIES FOR LARGE TABLESPACES
PM23866
3_Nov
2010
UK61897


DUPLICATE LRSN CAUSING SORTING SEQUENCES FOR GENERATED DB2 LOADFILE FROM LOG ANALYSIS TOOL
PM21667
3_Nov
2010
UK61897


MISC FILTERS AND LOAD LOG YES COMBINATION CAN OMIT LOG RECORDS THAT SHOULD NOT BE OMITTED, ABENDS0C7 CAN OCCUR.
PM21739
3_Nov
2010
UK61897


WHEN PROCESSING MANY COMPRESSION DICTIONARIES A S0C4 IS POSSIBLEDUE TO EXHAUSTED STORAGE
PM22626
3_Nov
2010
UK61897


TABLE VERSIONING ISSUES WHEN COLUMNS ADDED TO A TABLE IN DB2 9 OR LATER AND A COLUMN WAS PREVIOUSLY VERSIONED
PM15275
24_Aug
2010
UK59951


POSSIBLE PROBLEMS WITH ADVANCED FILTERS IN ONE PHASE WORK FILE MODE FOR PARTICULAR TIMEFRAMES
PM15819
24_Aug
2010
UK59951


DB2 LOG ANALYSIS MAY DISALLOW A VALID DSN WHEN SPECIFYING THE CONTINUOUS MODE FILE
PM13940
24_Aug
2010
UK59951


DB2 LOG ANALYSIS TOOL IS NOT HANDLING A DATE BEYOND THE MAXIMUM ALLOWED CORRECTLY, THIS COULD RESULT IN A S0C7
PM16588
24_Aug
2010
UK59951


POSSIBLE S0C4 OR ALAA479E WHEN LAT FIND NO DATA TO REPORT WHEN USING HISPEED AND SYNCSORT
PM20001
24_Aug
2010
UK59951


ABENDSC03 ISSUED IN ALADTL1 WHEN ALAA064E MESSAGE ISSUED IN 1 PHASE MODE
PM13326
3_Aug
2010
UK59393


VARGRAPHIC COLUMNS NOT BEING HANDLED PROPERLY IN A UNICODE TABLESPACE THAT IS USING ROW REORDER FORMAT.
PM13327
3_Aug
2010
UK59393


IF A FLOATING POINT FIELD IS UPDATED BUT THE DISPLAYABLE FORMAT DOESN'T CHANGE, A POTENTIAL ALAA325E ERROR CAN OCCUR
PM14597
3_Aug
2010
UK59393


ALAGEN1 S0C4 WHEN COMPENSATION LOG RECORDS REMOVE ALL ACTIVITY IN A UOW AND THAT UOW IS SPLIT ACROSS MULTIPLE LOGS
PM16576
3_Aug
2010
UK59393


MATERIALIZED UNICODE CHAR FIELDS MAY BE MISSING A TRAILING X '0F' CHARACTER
PM16602
3_Aug
2010
UK59393


ABENDS0C4 IN ALADTL1 TRACKING REBIND COMMAND
PM04859
3_Aug
2010
UK59393


PROBLEMS GENERATING XML DATA WHEN XML SPANS MULTIPLE LOG RECORDS
PM16187
3_Aug
2010
UK59393


DB2 LOG ANALYSIS TOOL IS SPECIFYING THE FILE SEQUENCE NUMBER WHEN REQUESTING A CATALOGED IMAGE COPY THAT IS ON TAPE
PM07415
17_May
2010
UK57019


ABEND0C7 ALAGLOAD+B56 DURING A "LOAD DATA INTO DB2" JOB WHEN THEMODE FILE HAS BEEN OVERLAID AFTER THE "GEN/DTL REPORT" RUN
PM09102
17_May
2010
UK57019


S0C4 WHEN MULTIPLE DB2 ACTIVE LOGS ARE OVERWRITTEN WHILE DB2 LOGANALYSIS TOOL PROCESSING LOGS IN PARALLEL IN DATASHARING
ENVIRON
PM10872
17_May
2010
UK57019


POSSIBLE SQLCODE -413 RUNNING DB2 LOG ANALYSIS TOOL WHEN COPYPAGESF COLUMN IN SYSCOPY IS OUT OF INTEGER RANGE.
PM11890
17_May
2010
UK57019


POSSIBLE ABEND0C4 WHEN PROCESSING MORE THAN 27,000 UTILITY RECORDS IN ONE RUN OF LOG ANALYSIS TOOL
PM13248
17_May
2010
UK57019


POSSIBLE ALAA440E OR ALAA447E WHEN PROCESSING LF AND LOG RECORD WAS READ BUT NOT USED IN GENERAL REPORT.
PM06173
17_May
2010
UK57019


MESSAGE ALAA521E DYN ALLOC ERR RETURN CODE 0002 REASON 1708 IMAGE COPY NEEDED FOR DICTIONARY NOT AVAILABLE IN HI SPEED
MODE
PM09136
17_May
2010
UK57019


ABEND0C4 RC4 ALASTOR+6C4 R1 BAD IN ERROR HANDLING ROUTINE AFTER GETMAIN FAILURE IN THE DETAILS REPORT PROCESSING
PM10557
5_May
2010
UK56716


LONG CPU TIMES WITH MUTLIPLE IMAGE COPIES PER TABLESPACE
PM11029
5_May
2010
UK56716


WHEN LONG RUNNING UOWS HAVE ACTIVITY FROM MULTIPLE OBJECTS IT ISPOSSIBLE TO SKIP THE UOW IN CONTINUOUS MODE
PM06166
4_May
2010
UK56716


ABEND0C7 DURING DATA COMPRESSION IF LOG BACKWARD PROCESSING IS FORCED ACROSS A REORG.
PM07074
4_May
2010
UK56716


ADVANCED FILTERS DO NOT WORK PROPERLY WHEN PROCESSING ARCHIVED OUTPUT AND USING MULTIPLE ARCHIVE OUTPUT DATASETS
PM09914
4_May
2010
UK56716


THE TVFILE DSNAME IN 2 PHASE PROCESSING MUST CONFORM TO INTERNALNAMING STANDARDS OR RESULTS IN RC=8 WITHOUT ANY ERROR MESSAGE
PM11431
4_May
2010
UK56716


U073 ABEND WHEN USING RESOLVE STARTED UOW AND JOB ENDS BEFORE CURRENT LOG.
PM11433
4_May
2010
UK56716


POSSIBLE U0031 IN ALADTL2 USING A COMPRESSED TABLESPACE OF TYPE G.
PM07877
1_Mar
2010
UK54795


ABEND=SC03 U0000 REASON=00000000 MAY OCCUR WHEN PROCESSING TABLESPACES WITH MORE THAN 999 PARTITIONS
PM03341
1_Feb
2010
UK54054


USE OF SYSLGRNX INVALID WITH ANY MEMID > 9
PM03487
1_Feb
2010
UK54054


S0C4 U0000 REASON=00000011 IN ALASBDF AT OFFSET=00002474
PM02634
1_Feb
2010
UK54054


DB2 LOG ANALYSIS TOOL TABLE VERSIONING LOGIC IS INCORRECTLY FLAGGING SOME DELETES AS NEEDING TABLE VERSION 0.
PM03784
1_Feb
2010
UK54054


DB2 LOG ANALYSIS TOOL U077 ABEND WITH LOB INSERTS
PK99374
10_Dec
2009
UK52770


POSSIBLE S0C4 DURING QUIET TIME PROCESSING WHEN A FILTERED OBJECT CONTAINS A ROLLBACK THAT SPANS MULTIPLE LOGS.
PK99841
10_Dec
2009
UK52770


PROCESSING CAN BE SLOW DURING PROGAM ALAGLOAD WITH A HIGH NUMBEROF UOWS
PM01019
10_Dec
2009
UK52770


MISSING DETAIL RECORDS USING HIGH SPEED IN NON-DATA SHARING
PM01377
10_Dec
2009
UK52770


POSSIBLE S0C4 WHEN USING DB2 LOG ANALYSIS TOOL ADVANCED FILTERS WITH MORE THAN 200K LOG RECORDS TO PROCESS
PM01468
10_Dec
2009
UK52770


POSSIBLE S0C4 WHEN USING HISPEED AND THERE ARE MANY UOWS THAT HAVE A LARGE RANGE FROM START UOW TO END UOW
PK97070
10_Dec
2009
UK52770


MESSAGE LIBRARY MODIFICATION TO ALAA073 / ALAA549
PM00392
10_Dec
2009
UK52770


DB2 LOG ANALYSIS TOOL PERFORMANCE ENHANCEMENT FOR LARGE UOWS IN HIGH SPEED MODE
PM00868
10_Dec
2009
UK52770


LOOP WHEN THE GETMAIL FAILURE NOT HANDLED PROPERLY SOME ERRORS IN SUBTASK NOT PROPERLY PROPAGATED BACK TO MAIN
TASK
PK98416
10_Dec
2009
UK52770


THE "LOAD DATA INTO DB2" PANEL MAY INCORRECTLY GIVE AN ALAA546E ERROR WHEN THE USER SETS THE "GENERAL REPORT DATA" TO 'N'
PM01988
10_Dec
2009
UK52770


DB2 LOG ANALYSIS TOOL CAN ENCOUNTER ALAA440E/U=55 ABEND DUE TO AINCOMPATIBLE PARAMETER IN A SORT EXIT.
PK94238
29_Oct
2009
UK51549


THE ' POPULATE PANELS FROM MODE FILE ' FUNCTION DOES NOT WORK ONTHE ' RESOLVE STARTED UOWS ' FIELD
PK95306
29_Oct
2009
UK51549


SQL GENERATION ERROR HANDLING NOT PROPERLY HANDLED WHEN USING WORK FILES
PK98085
29_Oct
2009
UK51549


LONG RUN TIME AFTER 'START ETV' PROCESSING IN DB2 LOG ANALYSIS TOOL
PK97204
29_Oct
2009
UK51549


DB2 LOG ANALYSIS TOOL CONTINUOUS MODE ERROR HANDLING NOT PROPERLY HANDLED WHEN USING WORK FILES
PK96617
9_Oct
2009
UK50927


LOG ANALYSIS SOMETIMES ENDS WITH A RC=8 WHEN NO DATA WAS FOUND WHEN IT SHOULD HAVE ENDED WITH A MAX RC=2 OR BYPASSED STEPS
PK96625
9_Oct
2009
UK50927


LOG ANALYSIS TOOL 1 PHASE WORK FILE MODE ERRORS WITH STRIPED EXTENDED-FORMAT DATASETS.
PK96843
9_Oct
2009
UK50927


USER ABEND 71 CAN OCCUR WITH MASS DELETE ON BASE TABLE W/LOB
PK96547
28_Sep
2009
UK50554


LOG ANALYSIS TOOL HI-SPEED MODE CAN ENCOUNTER VARIOUS PROBLEMS WHEN THE LAST LOG RECORD EXTRACTED IS IN A UNIT OF WORK BY
PK93191
24_Sep
2009
UK50451


ABENDSS0C4 DURING ERROR HANDLING FOR DYNAMIC ALLOCATION ERROR MESSAGES OCCURING DURING SUBTASKING
PK93195
24_Sep
2009
UK50451


S0C4 WHILE PROCESSING DB2 LOG FORMAT PAGE RECORDS THAT ARE SPANNED ACROSS LOGS
PK93232
24_Sep
2009
UK50451


ALAA064E WHEN MULTIPLE DB2 ACTIVE LOGS ARE OVERWRITTEN WHILE LATIS PROCESSING LOGS IN PARALLEL
PK94583
24_Sep
2009
UK50451


POSSIBLE S0C4 IN ALASUBG DURING CONTINUOUS MODE PROCESSING DUE TO CONTIGUOUS MEMORY CONTENTS
PK94694
24_Sep
2009
UK50451


ALAA041E CATFILE LOOKUP ERROR RUNNING DETAIL REPORT THAT INCLUDES AN OBJECT IN RECOVERY THAT SPANS MORE THAN 2 LOGS
PK94922
14_Sep
2009
UK50099


LONG RUNNING DB2 LOG ANALYSIS TOOL HIGH SPEED MODE JOB WITH LARGE VOLUME OF EXTFILE (EXTRACT FILES) AND UOW (UNITS OF
WORK)
PK88953
9_Sep
2009
UK49951


LOG ANALYSIS MAY REPORT A ALAA440E ERROR WHEN USING INCREMENTAL IMAGE COPIES.
PK89527
9_Sep
2009
UK49951


THIS ENHANCEMENT WILL INCREASE THE INTERNAL BSDS ARRAY FOR LOGS FROM 2788 ENTRIES TO 9659 ENTRIES
PK92173
9_Sep
2009
UK49951


S0C4 OCCURS IN ALASUBG PROCESSING TEMPORARY TABLES . ABENDS0C4
PK94149
9_Sep
2009
UK49951


ROWDATA VALIDATION ERROR IN DROPPED OBJECT MODE
PK85037
9_Sep
2009
UK49951


ALLOW RECOVERY OF A DROPPED SIMPLE TABLESPACE INTO A SEGMENTED TABLESPACE IN DB2 V9 FROM OBJECT RESTORE
PK88132
9_Sep
2009
UK49951


ABEND0C4 IN LOG ANALYSIS QUIET TIME REPORTING WHEN A UNIT OF WORK IS SPREAD ACROSS TWO LOGS
PK88136
29_Jul
2009
UK48798


SUPPORT FOR GENERATED ALWAYS TIMESTAMP
PK91362
29_Jul
2009
UK48798


POSSIBLE MISSING UOW(S) IF A SYSTEM RESTART WAS PERFORMED DURINGTHE MIDDLE OF A UOW. ABENDU083
PK91573
29_Jul
2009
UK48798


ABENDU031 ABEND WITH ACCESS TO INLINE IMAGE COPY
PK88262
29_Jul
2009
UK48798


XML PARSING ISSUES
PK89625
29_Jul
2009
UK48798


POSSIBLE ALAA440E WHILE USING RESOLVE STARTED UOWS AND CONTINUOUS MODE TOGETHER
PK91947
29_Jul
2009
UK48798


POSSIBLE IEC020I 001-4 C03 ALAA440E WHEN TABLE VERSIONING WAS DETECTED ON A PREVIOUS RUN, BUT NOT DETECTED ON THE CURRENT
RUN
PK88155
6_Jul
2009
UK48109


POSSIBLE ERROR ALAA440E IN LOG ANALYSIS TOOL CAUSED BY A DB2 UPDATE RECORD WITH NO DATA CHANGE
PK88378
6_Jul
2009
UK48109


IMAGE COPY PROCESSING ISSUES DEALING WITH READS FOR DICTIONARY
PK87546
6_Jul
2009
UK48109


ABENDS0C4 WHEN A URID INVOLVING A FILTERED OBJECT IS ROLLED BACK BUT THE ABORT UR RECORD IS ON A SUBSEQUENT LOG
PK87548
6_Jul
2009
UK48109


A ABEND0C4 WILL OCCUR IF AN INVALID TARGET SSID VALUE IS USED IN THE "LOAD DATA INTO DB2" PANEL DURING A GENERAL REPORT
RUN.
PK88325
6_Jul
2009
UK48109


USING WORK FILES IN ONE PHASE MODE WITH " LOAD OPTIONS " SELECTED MAY LEAD TO EMPTY ROWS OF DATA IN THE LOAD TABLES
PK89180
6_Jul
2009
UK48109


USING WORK FILES IN ONE PHASE MODE WITH " LOAD OPTIONS " SELECTED MAY LEAD TO ABENDS0C4
PK86760
9_Jun
2009
UK47296


A MASS DELETE COULD BE REPORTED FOR TABLES WITH DCC ON UNDER CERTAIN CIRCUMSTANCES BY DB2 LOG ANALYSIS TOOL
PK86450
9_Jun
2009
UK47296


LOB HANDLING MAY FAIL WITHIN LOAD OPTION WITH NULLS OR EMPTY STRINGS
PK86531
9_Jun
2009
UK47296


ABEND0C4 IN ALASTOR DUE TO HIGH NON-ZERO ORDER WORD IN REGISTER 14
PK86790
9_Jun
2009
UK47296


FAST APPLY SQL CAN NOT HANDLE AN EMPTY STRING ON A LOB COLUMN
PK85668
21_May
2009
UK46808


ABEND U077 USING LOBS IN PARTITIONED TABLESPACE DB2 LOG ANALYSISTOOL PROCESSING
PK85871
21_May
2009
UK46808


POSSIBLE MISSING ACTIVITY WHEN PERTINENT START UR RECORD FOLLOWSAN ORPHAN END UR RECORD IN LOG
PK85975
21_May
2009
UK46808


A ROLLBACK WITHOUT A CORRESPONDING ABORT CAN CAUSE A S0C4 DURINGA QUIET TIME REPORT IN DB2 LOG ANALYSIS TOOL
PK86072
21_May
2009
UK46808


FAST APPLY SQL DOES NOT PROPERLY HANDLE LOBS FOR UNICODE TABLES.
PK83915
11_May
2009
UK46453


ABEND0C4 WHILE TRYING TO HANDLE CALL ATTACH FACILITY ERRORS.
PK84571
11_May
2009
UK46453


ALAA440E WHEN USING ONLY MISC FILTERS ON NON DCC TABLES WHEN IN LOG FORWARD MODE
PK85260
11_May
2009
UK46453


LOB AS EMPTY STRING CAN CAUSE U077
PK85101
11_May
2009
UK46453


ABENDU078 ABEND WITH DCC AND LONG DB2 LOG RECORDS ON UPDATES
PK83535
27_Apr
2009
UK46080


POSSIBLE 0C4 IN LOG ANALYSIS DURING MERGE WHILE USING 64 BIT ONEPHASE MODE.
PK83804
27_Apr
2009
UK46080


REDUCE CHANCE OF ALAA486E MESSAGE
PK83255
27_Apr
2009
UK46080


ABENDS001 RC05 WHEN USING THE COMBINATION OF CONTINUOUS MODE , WORK FILE , AND HI SPEED MODE
PK83572
27_Apr
2009
UK46080


POSSIBLE ALAA447E IN LOG ANALYSIS WHEN RECOVERYSITE IMAGE COPY IS TAKEN SEPARATELY FROM THE LOCALSITE IMAGE COPY
PK84847
27_Apr
2009
UK46080


EDITPROC FAILURE IN DB2 V9 IF RRF PRESENT
PK81671
27_Mar
2009
UK45312


UPDATED SUPPORT FOR THE CLEAR KEY ENCRYPTION EDITPROC FROM THE IBM DATA ENCRYPTION FOR IMS AND DB2 DATABASES.
PK82260
27_Mar
2009
UK45312


POSSIBLE USER 78 ABEND OR ALAA447E IN DETAILS REPORT, DUE TO SKIPPING CERTAIN LOG RECORDS IN THE GENERAL REPORT
PK82065
27_Mar
2009
UK45312


POSSIBLE ALAA411E IN DETAILS REPORT WHEN A MASS DELETE WAS DONE ON ANY TABLE WITHIN A TABLESPACE THAT IS BEING REPORTED.
PK80300
25_Feb
2009
UK44356


QUIET TIME REPORTING MAY MISS ACTIVITY IF IN-FLIGHT
PK80391
25_Feb
2009
UK44356


FAST APPLY SQL SQLCODE20186 FOR SUBSEQUENT MULTI-ROW INSERTS THAT CONTAIN MORE ROWS THAN THE VERY FIRST ONE.
PK79935
25_Feb
2009
UK44356


MESSAGE ALAA011E OCCURS DURING DETAIL REPORT PROCESSING
PK80389
25_Feb
2009
UK44356


CHOOSING TO SPECIFY THE ARCHIVE OUTPUT IN ONE PHASE MODE RESULTSIN THE DATA NOT BEING ARCHIVED
PK75680
13_Feb
2009
UK44047


SELECTING 'Y' ON THE "CURRENT ROW BY KEY" MAY LEAD TO S0C4, -311 OR -804 SQLCODES
PK78177
13_Feb
2009
UK44047


ABENDSOC4 IN DB2 LOG ANALYSIS GENERAL REPORT WHEN TOO MANY LOAD REPLACE UTILITIES ARE WITHIN THE TIMEFRAME OF THE
FILTERS
PK79109
13_Feb
2009
UK44047


ABENDS0C4 OR SQLCODE310 IF USE THE CURRENT ROW BY KEY OPTION AND HAVE A LARGE PRECISION DECIMAL COLUMN IN THE KEY OF TABLE
PK79692
13_Feb
2009
UK44047


POSSIBLE VSAM RET CODE=20 ON ROWDATA WHEN THE ROWDATA FILE IS MANUALLY BUILT
PK78090
13_Feb
2009
UK44047


LOB/XML, AND THEIR SUPPORT DATA TYPES, HAVE HANDLING ERRORS
PK78152
13_Feb
2009
UK44047


CHANGING JOB IDENTIFIER IN LOAD STEP TO DIFFERENT FROM GENERAL REPORT FOR COMBINED JOB, JCLERRORS OR ABEND IN ISPF PANELS
CAN
PK78173
13_Feb
2009
UK44047


THE GENERAL REPORT ISPF PANEL INCORRECTLY ALLOWS THE USER TO SPECIFY RESOLVE STARTED UOWS WHEN RUNNING A QUIET TIME REPORT
PK74857
27_Jan
2009
UK43500


A REORG OCCURRED AFTER REPORTING PERIOD WAS CAUSING TABLE VERSIONING LOGIC TABLE VERSIONING PROCESSING MORE COMPLICATED
PK74900
27_Jan
2009
UK43500


FAST APPLY SQL INCORRECTLY REPORTS A WARNING OR AN ERROR FOR MULTIPLE ROWS BEING AFFECTED WHEN AN SQL STATEMENT PREPARED
PK74976
27_Jan
2009
UK43500


BYPASSING REPORTS DURING GENERAL REPORT: DB2 LOGS INS/DEL ON UPDATE, DB2 LAT NOT COMBINING RECORDS INTO A SINGLE UPDATE.
PK75520
27_Jan
2009
UK43500


POSSIBLE ALAA447E WHEN MULTIPLE TABLES ARE BEING REPORTED AND ATLEAST ONE HAS IS FLAGGED AS BEING VERSIONED
PK75079
27_Jan
2009
UK43500


CHARACTER AND GRAPHIC STRINGS MAY BE IMPROPERLY TRANSLATED IN FAST APPLY SQL
PK76610
27_Jan
2009
UK43500


POSSIBLE ALAA107E ON PARTITION TABLESPACES THAT HAVE BOTH COMPRESSION AND DATA CAPTURE CHANGES TURNED ON.
PK75640
22_Jan
2009
UK43405

HIPER

ROLL UP
PK75437
12_Dec
2008
UK42447


ALAA031E MSG GENERATING PIT RECOVERY JCL WITH DB2 OBJECT RESTORE
PK72744
6_Nov
2008
UK41402


POSSIBLE 0C4 DURING SQL CREATION FOR VERY WIDE ROWS THAT CONTAINSEVERAL DBCS COLUMNS AND WHERE CLAUSE BY KEY IS 'Y'.
PK73149
6_Nov
2008
UK41402


DISTRIBUTED TYPE FILTERS (END USER, WORKSTATION, ETC) MAY PROVIDE INCORRECT RESULTS WHEN USED IN COMBINATION WITH
OTHER
PK73712
6_Nov
2008
UK41402


FAST APPLY SQL PARSES THE CHARACTERS X'0E' AND X'0F' AS SHIFT-OUT AND SHIFT-IN. THE DATA CORRECTLY
PK74095
6_Nov
2008
UK41402


POSSIBLE ALAA068E ON ROWDATA IF ATTEMPTING TO LOAD INTO DB2 WHENONLY A GENERAL REPORT RUN WAS SELECTED.
PK72739
6_Nov
2008
UK41402


POSSIBLE ALAA070W WHEN UNIT OF RECOVERY IS SPLIT ACROSS LOGS, WITH ACTIVITY IN FIRST LOG AND ONLY COMMIT/ABORT IN SECOND
LOG.
PK71989
24_Oct
2008
UK41053


POSSIBLE ALAA440E WHEN DB2 UPDATE LOG RECORDS ENCOUNTERED HAVE ZERO LENGTH UPDATES
PK72748
24_Oct
2008
UK41053


MISSING LOG RECORDS WHICH EXIST ONLY IN ACTIVE LOGS
PK73440
24_Oct
2008
UK41053


S0C7 DURING DECOMPRESSION WITH MULTI-PARTITION IMAGE COPIES
PK71801
24_Oct
2008
UK41053


ABENDS0C4 WHILE PROCESSING GENERAL REPORT LOGS ON 32K PAGESIZES
PK72998
24_Oct
2008
UK41053


MISSING EXTFILE DD IN DB2 LOG ANALYSIS TOOL LOAD-GENERATED JCL CAN ALSO APPEAR AS S0C4
PK73507
24_Oct
2008
UK41053


POSSIBLE DC2 ABEND DURING PROGRAM TERMINATION DUE TO AN ATTEMPT TO FREE AN INVALID ADDRESS
PK70875
8_Oct
2008
UK40542

HIPER

FAST APPLY SQL MAY SHUT DOWN WITH A USER ABEND: MESSAGE "IN HPCB CONTROL BLOCK, THE EYE CATCHER IS DAMAGED"
PK70642
8_Oct
2008
UK40542


ADDS CAPABILITY TO REPORT ON COMPLETE UNITS OF WORK THAT START WITHIN AN ANALYSIS TIME FRAME BUT END OUTSIDE OF THE TIME
FRAME.
PK70452
11_Sep
2008
UK39801


POSSIBLE S0C4 DURING DATA DECOMPRESSION DUE TO SYSOBD PAGES
PK69727
20_Aug
2008
UK39104


FAST APPLY SQL DOES NOT PROPERLY PARSE REAL OR FLOAT COLUMNS WHEN A COMMA IS THE DEFAULT DECIMAL POINT FOR THE DB2
SUBSYSTEM
PK70271
20_Aug
2008
UK39104


ABENDS0C4 WHEN USING LOG ANALYSIS WITH A TABLE THAT CONTAINS MORE THAN 580 COLUMNS
PK70278
20_Aug
2008
UK39104


DB2 LOG ANALYSIS NOT HANDLING GRAPHIC COLUMNS CORRECTLY DURING CURRENT ROW BY KEY PROCESSING WHICH COULD LEAD TO
UNPREDICTABLE
PK70354
20_Aug
2008
UK39104


ALAA440E WHILE PROCESSING VARIATION TYPE 3 LOG RECORD
PK70408
20_Aug
2008
UK39104


POSSIBLE VSAM RET CODE=20 ON ROWDATA
PK66142
5_Aug
2008
UK38705


ADD AN INFORMATIONAL MESSAGE TO JOB LOG WHEN A RECOVERY POINT ISENCOUNTERED
PK67913
5_Aug
2008
UK38705


ISSUES FOUND WHILE PROCESSING MASS DELETES AND / OR LOAD UTILITIES PARTICULARLY WHEN MULTIPLE INSTANCES WERE FOUND IN
ONE
PK69104
5_Aug
2008
UK38705


POSSIBLE USER 0078 ABEND DUE TO MISSED REORG / LOAD REPLACE DURING INTERNAL PROCESSING TO DETERMINE THE LOG READING MODE
PK69300
5_Aug
2008
UK38705


DATA HANDLED INCORRECTLY BY FAS IF TWO SIMILAR SQL STATEMENTS RUN USING DIFFERENT CODE SETS FOR ONE COLUMN IN UNICODE TABLE
PK69302
5_Aug
2008
UK38705


A -811 SQL ERROR WILL OCCUR IN FAST APPLY SQL WHILE PROCESSING ANY TABLE BELONGING TO A TABLESPACE THAT IS NOT UNIQUELY
NAMED
PK69353
5_Aug
2008
UK38705


IN SOME CASES, A CHARACTER CAN BE WRITTEN INTO THE 73RD COLUMN OF THE SQLOUT PREVENTING THAT CHARACTER FROM BEING PROCESSED
PK68847
30_Jul
2008
UK38541


THIS APAR WILL CHANGE THE WAY LAT HANDLES STRING LENGTHS GREATERTHAN 40 BYTES IN A WHERE CLAUSE.
PK69003
30_Jul
2008
UK38541


POSSIBLE SQLCODE OF -302 WHEN EXECUTING A SQL STATEMENT WITH A SUBSTR FUNCTION ON A UNICODE COLUMN.
PK67363
3_Jul
2008
UK37851


FAS RECEIVES AN SQLCODE518 WHEN PROCESSING A DIVERSE SET OF SQL COMMANDS RUN IN NFM
PK67374
3_Jul
2008
UK37851


FAILURE HANDLING ALTER ADD COLUMN WITH DB2 V9 VARIABLE LENGTH TABLE
PK67481
3_Jul
2008
UK37851


ERROR MSG ALAA460E WITH NO OTHER ERROR INDICATION
PK67600
3_Jul
2008
UK37851


WHEN SPECIFYING LOGS THAT HAVE DSNS OF 44 CHARACTERS, LOG ANALYSIS MAY TERMINATE BEFORE PROCESSING ALL THE SPECIFIED
LOGS.
PK67625
3_Jul
2008
UK37851


UTF-16 HEXADECIMAL STRINGS WILL NOW BE CREATED WITH THE UX'....'STRINGS INSTEAD OF X'....' STRINGS
PK67433
3_Jul
2008
UK37851


SC03 ABEND AND IEC999I ERROR MESSAGE.
PK66068
16_Jun
2008
UK37366


MATERIALIZED GRAPHIC FIELDS MAY HAVE AN INCORRECT TRAILING X'0F'CHARACTER.
PK66764
16_Jun
2008
UK37366


FAST APPLY SQL DOES NOT PROPERLY HANDLE HEXADECIMAL STRINGS WHENWORKING WITH UNICODE TABLES
PK67091
16_Jun
2008
UK37366


INVALID SQL CAN BE GENERATED WHEN THE LENGTH OF THE COLUMN NAME EXCEEDS 18 BYTES AND THE LENGTH OF THE DATA IS LESS THAN 40
BYTE
PK65552
9_Jun
2008
UK37187


ALAA440 MSG WHEN LOAD LOG YES PRESENT
PK65955
9_Jun
2008
UK37187


MISSING RECORDS MAY OCCUR IN HI SPEED MODE IF URLRTIME VALUES NOT IN TIME ORDER
PK64019
9_Jun
2008
UK37187


0C4, MULTIPLE LOAD STATEMENTS PER TABLE, AND MULTIPLE CREATE TABLE STATEMENTS PER TABLE USING DB2 LOG ANALYSIS OPTION TO
LOAD
PK57346
9_May
2008
UK36358


ALLOW PIT RECOVERY OF DROPPED TABLESPACE AFTER LOAD LOG YES UTILITY HAS BEEN RUN
PK63624
11_Apr
2008
UK35509


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


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


POSSIBLE ALAA0440E OR ALAA0447E WHILE USING MISCELLANEOUS FILTERS AND TABLES WITH DCC TURNED LOG FORWARD MODE
PK63109
11_Apr
2008
UK35509


SQLCODE311 USING DB2 LOG ANALYSIS IN DB2 V8 CM, SPECIFICALLY IN ALAESQL, ALAARC1, AND QUIET TIME PROCESSING IN ALAGEN1.
PK63848
11_Apr
2008
UK35509


THE GENERAL REPORT ISPF PANEL INCORRECTLY ALLOWS THE USER TO SPECIFY A QUIET TIME REPORT ALONG WITH A LOAD, ABENDS0C7
PK63379
3_Apr
2008
UK35213


IF THE GMT OFFSET INCLUDES A PARTIAL HOUR AMOUNT, IT IS POSSIBLETO GET NO DATA BACK FROM DB2 LOG ANALYSIS TOOL
PK63166
3_Apr
2008
UK35213


S0C4 IN ISPF PANELS WHEN USING FILTER FILES
PK62811
28_Mar
2008
UK35069


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


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


ABENDS0C4 IN CSECT ALAURID WITH MASS DELETES AND DATA SHARING
PK61998
28_Mar
2008
UK35069


DYNAMIC SQL PROCESSING USING FAST APPLY USES TOO MUCH MEMORY WHEN A JOB IS RE-RUN WITH THE RESTART OPTION
PK62341
28_Mar
2008
UK35069


REGISTER 0 AND REGISTER 8 HAVE A NON-ZERO HIGH WORD DURING 64 BITPROCESSING
PK63107
28_Mar
2008
UK35069


POSSIBLE MISSING RECORDS WHEN UR SPANS LOGS
PK61166
10_Mar
2008
UK34415


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


SQLCODE313 WHEN USING CURRENT ROW BY KEY AND THE TABLE HAS MULTIPLE UNIQUE INDEXES
PK61170
10_Mar
2008
UK34415


RC16 WITHOUT AN ERROR MESSAGE IN ALADTL4 IS POSSIBLE, IF "WHERE CLAUSE BY KEY" IS CHOSEN AND A TABLE IS PRESENT THAT HAS
PK60968
10_Mar
2008
UK34415


ABENDS0C4 RC=10 IN ALASUBG AT OFFSET=1CD4
PK61333
10_Mar
2008
UK34415


DB2 LOG ANALAYSIS CAN POTENTIALLY RECEIVE AN 0C4 IN MODULE ALASUBG DUE TO NOT HANDLING A STORAGE REQUEST FAILURE.
PK60426
15_Feb
2008
UK33769


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
UK33769


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


INCORRECT TIME TRANSLATION IF LEAP SECONDS ARE PRESENT
PK60440
15_Feb
2008
UK33769


ALAA440E OR ALAA479E WHEN THE END DATE AND END TIME HAS BEEN MANUALLY CHANGED IN THE JCL TO EQUAL THE BEGN DATE AND BEGIN
PK60597
15_Feb
2008
UK33769


POSSIBLE ABENDS0C4 DURING LOG SELECTION PROCESSING WHEN USING CONTINUOUS MODE IN A DATA SHARING ENVIRONMENT
PK59759
11_Feb
2008
UK33594


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


WHEN MANY INSTANCES OF A MASS DELETE ARE FOUND WITHIN THE TIME FRAME BEING PROCESSED AN 0C4 IS LIKELY TO OCCUR
PK59821
11_Feb
2008
UK33594


ERROR MSG OR INCORRECT OUTPUT USING HIGH SPEED MODE WITH DROPPEDOBJECTS
PK55380
23_Jan
2008
UK33176


ROLLUP APAR FOR LOG ANALYSIS V3.1

Top of page