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: 21 November 2024
DB2 Automation Tool Version V4.3
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH63910
31_Oct
2024
UI98922


TS REORG CAN RESULT IN INCLUDE STATEMENTS APPEARING OUTSIDE OF ALISTDEF DUE TO A SYNTAX ISSUE WITH PARTITION RANGE FORMATTING
PH63029
28_Oct
2024
UI98897
UI98922


JOB BUILD FOR REORG IX CAN RESULT IN VARIOUS PROBLEMS RELATED TO SYSUT1 DD
PH63362
28_Oct
2024
UI98897
UI98922


REORG FOR COMPRESSED TS CAN RESULT IN INSUFFICIENT SECONDARY SPACE FOR SYSREC WHEN JOB STEP ALSO CONTAINS A
NON-COMPRESSED TS
PH62877
17_Oct
2024
UI98801


REORG AVOIDANCE: COMMUNICATION WITH QUERY MONITOR (CQM) CAN FAILWHEN A LARGE VOLUME OF DB2 OBJECTS IS PASSED TO CQM
PH62781
9_Oct
2024
UI98702


BUILD MESSAGE HAAB574W SHOULD NOT BE GENERATED WHEN TEMPLATE DSNIS SPECIFIED ON SETUP PANEL HAAPNL6 FOR REORG TS
PH63171
27_Sep
2024
UI98573


DB2 CATLG & DIR: DSNDB06.SYSTSOEV SHOULD BE INCLUDED IN SAME COPY/RECOVER STATEMENT AS DSNDB06.SYSTSUTL
PH63299
27_Sep
2024
UI98573


JOB BUILD FOR RECOVER OF DB2 CATLG & DIR CAN RESULT IN "ALL" KEYWORD IN LISTDEF FOR DSNDB01 AND DSNDB06 OBJECTS.
PH62472
18_Sep
2024
UI98473


BATCH BUILD SYSOUT: THE NBR OF ACCEPTED/REJECTED OBJECT COUNTS DISPLAYED CAN BE INCORRECT WHEN DEFINE NO INDEXES ARE INCLUDED
PH62618
19_Aug
2024
UI98083


APPARENT LOOP CAN OCCUR IN A JOB BUILD WHEN PROCESSING A LARGE VOLUME OF OBJECTS WHEN USING A HIGH NUMBER OF PARALLEL TASKS
PH61448
9_Aug
2024
UI97972


ELIMINATE A POTENTIAL SQLCODE -188 IN THE AUTONOMICS EXECUTE STORED PROCEDURE
PH61698
2_Aug
2024
UI97895


REORG: IF OBJ PROFILE CONTAINS ADVANCED SQL TO SELECT SPECIFIC PARTS FOR TS AND IX, THE INDEXES TO BE REORGED CAN BE
DUPLICATED
PH52765
24_Jul
2024
UI97780


AUTOMATICALLY TURN ON SYSPUNCH AND SYSDISC DDS WHEN REORG-ING A TS WITH A PENDING ALTER COLUMN SET COMMAND
PH60927
18_Jul
2024
UI97682
UI97780


JOB BUILD CAN RESULT IN DSNT408I SQLCODE = -924 DB2 CONNECTION INTERNAL ERROR
PH61605
11_Jun
2024
UI97273


WHEN A TS CONTAINS A NPSI, A POTENTIAL SYNTAX ERROR IN THE PARTLEVEL KEYWORD CAN OCCUR WHEN GROUPING > 50 PRTITIONS
PH60068
5_Jun
2024
UI97171


MESSAGE HAAB122E CAN BE GENERATED IN ERROR WHEN EXECUTING COPY TO COPY UTILITY WITH FROMLASTFLASHCOPY KEYWORD SPECIFIED.
PH61076
10_May
2024
UI96847


THIS PTF WILL PROVIDE ROUTINE INFRASTRUCTURE CHANGES FOR HAA V4.3
PH60339
23_Apr
2024
UI96627


PANEL HAA$UIPC: IX REORG UTILITY - OPTION LASTLOG DOES NOT DISPLAY FOR DB2 V13
PH60337
23_Apr
2024
UI96627


PANEL HAA$UOPC: TS REORG UTILITY - OPTION LASTLOG DOES NOT DISPLAY FOR DB2 V13
PH54985
10_Apr
2024
UI96449


ADD SUPPORT FOR DISJOINTED PARTITIONS WHEN OPTION "GROUP PARTITIONS WITH NPI" IS SELECTED FOR REORG TS.
PH59358
20_Feb
2024
UI95758


THE "ALL" KEYWORD CAN BE GENERATED PREMATURELY FOR A RUNSTATS UTILITY USING LISTDEFS FOR A PARTITIONED OBJECT
PH57772
14_Feb
2024
UI95686


RUNSTATS OPTIONS PANEL HAA$URST: STAT COLGROUP MEM SORT HAS AN ERRONEOUS LIMIT OF 4096 VALUE.
PH59463
30_Jan
2024
UI95493


THIS PTF ADDS SUPPORT FOR THE 'FROMLASTFLASHCOPY' KEYWORD ON THE COPYTOCOPY UTILITY.
PH54582
8_Jan
2024
UI95144


DB2 V13 FL100 SSID: HAA$UREO - ENTER "Y" ON STATISTICS OPTIONS INCLUDE & UPDATE RESULTS IN ISPF ERROR ON PANEL HAA$USTT
PH56111
15_Dec
2023
UI94950


AVOID GENERATING MAXPRIME & PCTPRIME KEYWORDS IF PRI/SEC VALUES ARE GENERATED.
PH56114
15_Dec
2023
UI94950


CORRECT ERROR MSG HAA835E TEXT. CORRECT PANEL BEHAVIOR WHEN UTILITY HISTORY IS SELECTED FROM HAA$MAIN WHEN DB2 < V13
PH58603
15_Dec
2023
UI94950


MISSING KEYWORD "NOSYSUT1" ON PANEL HAA$UREX FOR DB2 V13 FL100
PH56096
6_Sep
2023
UI93460


CORRECT BUG IN IDENTIFICATION METHOD OF HISTORY TABLES. ALSO ALLOW DISCARD ON HISTORY TABLES.
PH55502
28_Jul
2023
UI92946


REORG TS JOB BUILD - REDUCE CPU / CALLS TO HAA#IX12. TS REORG/PARTITIONED TS-UTILITY KEYWORDS PASS COL 72
PH53954
19_Apr
2023
UI91496


MAY 2023 ROLL UP PTF
PH53666
19_Apr
2023
UI91496


WHEN MULTIPLE EXCEPTION PROFILES WITH DATE/TIME CRITERIA ARE SPECIFIED, OBJECTS CAN BE TRIGGERED OUTSIDE OF SPECIFIED TIME
PH53760
12_Apr
2023
UI91406

HIPER

HAA COMPATIBILITY FIX FOR DB2 PTF UI83154
PH50859
14_Feb
2023
UI90519


PGM=HAA#BTMP LOOP WHEN EXECUTING TS REORG WHERE LOAD BALANCING BY TIME IS SPECIFIED AND SYSPRINT FILE DOESN'T CONTAIN STATS
PH51449
14_Feb
2023
UI90519


BUILD OF REORG TS JOB REMOVE INCONSISTENCIES WITH DISCARD AND SYSPUNCH DDS
PH52039
14_Feb
2023
UI90519


JAN 2023 BUG FIXES FOR INTERNAL ISSUES
PH52281
2_Feb
2023
UI90372

HIPER

JUN 2022 ENH PTF
PH51427
30_Dec
2022
UI83894


REASSEMBLE FEC-DEPENDENT HAA MODULES TO CORRECT A POTENTIAL ASSEMBLY PROBLEM.
PH50569
8_Dec
2022
UI83632


PROVIDE SUPPORT FOR DB2 V13 FL502
PH49369
1_Dec
2022
UI83536
UI83537


EXCEPTION PROFILES: PROVIDE THE SAME OPTIONS IN VIEW MODE THAT ARE AVAILABLE IN UPDATE MODE.
PH50117
1_Dec
2022
UI83536


INTERNAL FIXES FOR NOV 2022 ROLL UP PTF
PH51207
1_Dec
2022
UI83537


INTERNAL FIXES FOR NOV 2022 ROLL UP PTF
PH48097
29_Sep
2022
UI82631


JOB BUILD RESULTS IN MISSING DISCARD AND SYSPUNCH DDS FOR REORG OF RPN OBJECT IN AREOR STATE DUE TO AN ALTER PARTITION
COMMAND.
PH49656
29_Sep
2022
UI82631


INTERNAL FIXES FOR OCT 2022 ROLL UP PTF
PH46991
22_Sep
2022
UI82492
PH52281

JUN 2022 ENH PTF
PH47013
30_Aug
2022
UI82174
UI82492
PH52281

IGNORE DIAGNOSE OUTPUT WHEN COLLECTING RUN TIMES.
PH46749
3_Aug
2022
UI81798
UI82492
PH52281

S0C4 ABEND POSSIBLE AT OFFSET X'F0' IN PGM=HAA$ERRS WHEN ATTEMPTING TO UPDATE HAA REPOSITORY OBJECTS WITH RUNSTATS
STAT.
PH48338
3_Aug
2022
UI81796


INTERNAL FIXES FOR AUG 2022 ROLL UP PTF
PH47584
29_Jul
2022
UI81716
UI82492
PH52281

REMOVE RESTRICTION FOR &PART AND ALLOW STACK YES FOR RPN OBJECTS
PH47631
19_Jul
2022
UI81534


INTERNAL FIXES FOR JUL 2022 ROLL UP PTF
PH47088
29_Jun
2022
UI81243


EXCEPTIONS REORG_IX.INS_UPD_DEL, REORG_TS.DELETES_PCT AND COPY.COPY_CHANGES_PCT INCORRECTLY TRIGGER 22/06/16 PTF
PECHANGE
PH45718
27_May
2022
UI80739
UI81243


INVALID SYNTAX GENERATED FOR RUNSTATS UTILITY, SYSSTATFEEDBACK EXCEPTION TRIGGERS TS WITH USE PROFILE AND INDEX PART
PH44563
27_May
2022
UI80739
UI81243


WHEN A REORG IS BUILT FOR DB2 OBJECTS WITH PENDING DEFINITION CHANGES, TAPE STACKING SHOULD BE TURNED OFF.
PH45361
27_May
2022
UI80739
UI81243


Panel HAA$UMOD: Adding field "Process Define No Objects" for MODIFY STATISTICS utility - for both TS and IX objects
PH43895
19_May
2022
UI80596
UI81243


Provide Phase II Support for Db2 V13
PH43205
2_May
2022
UI80372
UI81243


4.3 APR 2022 ROLL UP APAR
PH43568
2_May
2022
UI80372
UI81243


SHAASAMP(HAAPROFE) COMMENTS NEED CLARIFICATION RE: PROPER FORMATOF PROFNAME PARM - INCLUDES UPDATE TO USER'S GUIDE
PH44226
2_May
2022
UI80372
UI81243


REMOVE REQUIREMENT TO SPECIFY A VALUE FOR PCTPRIME. THE DEFAULT VALUE WILL BE A BLANK, WHICH WILL REPRESENT THE DB2 DEFAULT.
PH44145
26_Apr
2022
UI80306
UI81243
PH47088

4.3 MAR 2022 ENH PTF
PH44511
8_Apr
2022
UI79787
UI80596
UI81243


Correct performance issue related to job build of REORG PBR objects with PDC; add BEST PRACTICE PBR REORG sample profile
PH43401
8_Feb
2022
UI79214
UI80306
UI80596
UI81243
PH47088

POTENTIAL S378 ABEND WHEN MODULE HAA$SV26 IS INVOKED
PH43518
8_Feb
2022
UI79217
UI79787
UI80306
UI80596
UI81243
PH47088

REORG UTILITY FOR PBR OR RPN OBJECTS WITH PENDING CHANGES: CONVERT FROM PART TO ALL WHEN JOB BUILD OCCURS
PH43783
8_Feb
2022
UI79217
UI79787
UI80306
UI80596
UI81243
PH47088

REORG INDEX: FOR PBR or RPN SPACE, WHEN 1 OR MORE [INDEX] PARTS IS IN AREOR STATE, GENERATE INDEX REORG FOR ALL PARTS
PH43360
27_Jan
2022
UI79096
UI80306
UI80596
UI81243
PH47088

MISSING KEYWORDS ON LISTDEF ARE POSSIBLE WHEN A LISTDEF INCLUDES A PARTITIONED OBJECT FOLLOWED BY A NON-PART OR PART ALL
OBJECT.
PH39748
27_Jan
2022
UI79096
UI80306
UI80596
UI81243
PH47088

AUXILIARY SPACES CAN BE IGNORED IN CALCULATION TO LOAD BALANCE DASD
PH41536
3_Jan
2022
UI78783


ADD SUPPORT FOR THE PCTPRIME KEYWORD WHEN TEMPLATES ARE GENERATED.
PH42437
22_Dec
2021
UI78708


DEC 2021 ENH PTF
PH40788
19_Nov
2021
UI78176


INVALID QUERY FOR HISTORY/ARCHIVE EXCLUDES OBJECTS INCORRECTLY
PH41382
19_Nov
2021
UI78176


Provide means of setting severity of message HAAB605W when a deadlock/timeout occurs and allow multiple retry attempts
PH41976
19_Nov
2021
UI78176


NOV 2021 BUG FIX PTF
PH40193
19_Nov
2021
UI78176


TS REORG job build:S0C4 ABEND occurs if DSN specified on HAAPNL6(Template DSN Parms) becomes corrupted, renamed or deleted
PH39527
3_Nov
2021
UI77932
UI78708


JOB BUILD CAN RESULT IN RC=8 WHEN OBJECT PROFILE CONTAINS TEMP OR WRK OBJECTS. EXPECTED [EMPTY] IEFBR14 MEMBERS NOT CREATED
PH41501
3_Nov
2021
UI77932
UI78708


BUILDING A JOB THAT CONTAINS BOTH AN IDAA OBJECT AND AN IDAA DETAIL TEXT IS AS FOLLOWS:LCODE(S) +445, +462 OR -420.
PH40241
21_Oct
2021
UI77736
UI78708


JOB BUILD FOR IC UTILITY: WHEN SPECIFYING TEMPLATES, USRX_RETPD VALUE FROM EXCEPTION PROFILE USER EXIT IS NOT BEING
GENERATED.
PH40240
27_Sep
2021
UI77318
UI78708


MISCELLANEOUS FIXES TO SUPPORT Z/OS V2.5
PH38518
30_Aug
2021
UI76952


OPTIONS TEMPLATEDD SYSTEMPL CAN INCORRECTLY OVERRIDE PREVIOUS OPTIONS STATEMENTS
PH38843
30_Aug
2021
UI76952


DISCARD KEYWORD ERRONEOUSLY GENERATED FOR REORG UTILITY FOR CONTAINING XML COLUMNS
PH38890
30_Aug
2021
UI76952


4.3 UI00000 AUG 2021 ROLL UP APAR
PH39016
20_Aug
2021
UI76856


Description not available. Security/Integrity exposure
PH37485
4_Aug
2021
UI76591


REORG TABLESPACE: NOCHECKPEND KEYWORD MISSING FROM SUPPORT
PH38719
4_Aug
2021
UI76591


4.3 UI00000 JUL 2021 ROLL UP APAR
PH36351
13_Jul
2021
UI76292


CHECK DATA UTILITY ISSUES MSG DSNU729I FOR EXCLUDED DEFINE NO UNDERLYING VSAM DSNS) OBJECTS INVOLVED IN RI RELATIONSHIP
PH38043
13_Jul
2021
UI76292


HAAB007W NO OBJECTS WERE TRIGGERED BY EXCEPTION PROCESSING WAS BEING ISSUED FOR JOB PROFILES THAT CONTAIN NO EXCEPTION
PH37159
28_Jun
2021
UI76108


4.3 UI00000 JUN 2021 ENH PTF
PH34895
26_May
2021
UI75589


PROGRAM HAA@BULD - ENHANCE HAA ERROR MESSAGES TO INCLUDE DB2 REASON CODES WHEN JOB BUILD FAILURES OCCUR.
PH35276
26_May
2021
UI75589


OBJECT PROFILES: ADVANCED SQL CAN RESULT IN HAAM556E WHEN 3RD IS NOT "PARTITION".
PH35398
26_May
2021
UI75589


INCORRECT UTILITY SYNTAX POSSIBLE WHEN GENERATING REORG TS JOB THAT SPECIFIES DISCARD KEYWORD
PH37193
26_May
2021
UI75589


EXCEPTION SYSSTATFEEDBACK.RUNSTS_RECOMMENDED CAN RESULT IN A THE BUILD PROCESS
PH35737
3_May
2021
UI75202


4.3 UI00000 APR 2021 ROLL UP APAR
PH33241
31_Mar
2021
UI74693


4.3 UI00000 MAR 2021 ENH PTF
PH33684
9_Mar
2021
UI74340


REORG UTILITY: MESSAGE HAAB707I "NO HISTORY OBJECTS EXIST..." SHOULD NOT BE GENERATED WHEN HISTORY KEYWORD IS SET TO N
PH33785
9_Mar
2021
UI74340


IMPROVE MAPPING TABLE NAME VALIDATION
PH34036
9_Mar
2021
UI74340


4.3 UI00000 FEB 2021 BUG FIX PTF
PH32481
9_Mar
2021
UI74340


OBJECT PROFILE PANELS HAA$TSQL & HAA$ISQL: PROVIDE A MAX OF 32,704 BYTES FOR LARGE SQL STATEMENTS
PH34724
9_Mar
2021
UI74340


JOB BUILD CAN RESULT IN A LOOP WHEN SQL ERROR(S) OCCUR IN AND/OR INDEX FETCH ROUTINES.
PH31836
2_Feb
2021
UI73747
UI74693


CHECK DATA UTILITY: EXCEPTION TABLE ISSUES
PH33256
2_Feb
2021
UI73747
UI74693


4.3 ROLL UP APAR FOR JAN 2021
PH32730
2_Feb
2021
UI73747
UI74693


BUILD JOB CAN RESULT IN B37 ABEND DUE TO INTERMITTENT SIZING ISSUE WITH DD SYSUT1
PH32446
24_Dec
2020
UI73304


ONLY GENERATE LISTPARTS FOR TABLE SPACES AT THE PART LEVEL, NOT ALL LEVEL
PH32732
24_Dec
2020
UI73304


JOB BUILD RESULTS IN DUPLICATE CONTOKEN ERROR
PH32472
24_Dec
2020
UI73304


DEC 2020 ENH PTF
PH29576
30_Nov
2020
UI72806


SHAADENU - DDL JOBS: REMOVE "BUFFERPOOL" FROM SYNTAX FOR CREATED ON SYSIBM (DB2 CATLG) OBJECTS.
PH29927
30_Nov
2020
UI72806


INVALIDATECACHE FIELD NOT ALLOWED FOR DB2 V12 FL100
PH30137
30_Nov
2020
UI72806


POSSIBLE LOOP IN TS AND IX RETRIEVAL ROUTINES WHEN SQL ERROR IS ENCOUNTERED
PH30987
30_Nov
2020
UI72806


LISTDEF - "HISTORY" KEYWORD MISSING ON BASE TABLESPACES FOR IMAGE COPY UTILITY.
PH28274
30_Nov
2020
UI72806


JOB BUILD FOR REORG UTILITY CAN RESULT IN DUPLICATE LISTDEF AND WRONG PARTLEVEL
PH29785
30_Nov
2020
UI72806


PANEL HAA$ADEH: SQLCODE -911 POSSIBLE DUE TO LOCK WAIT ON HAA REPOSITORY TABLESPACE DYXDB.DYXATRTS
PH30832
30_Nov
2020
UI72806


REORG IS TRIGGERED ON PARTITION LEVEL INSTEAD OF ALL PARTITIONS
PH31241
30_Nov
2020
UI72806


4.3 NOV 2020 ROLL UP PTF
PH29483
3_Nov
2020
UI72375


REORG INDEX UTILITY: INVALID VALUE POSSIBLE FOR UNCNT KEYWORD SYSUT1 TEMPLATE IS SPECIFIED.
PH29767
3_Nov
2020
UI72375


PROVIDE ADDITIONAL ISPF SKELETON FOR BUILDING UTILITY WORK NAMESET
PH28755
3_Nov
2020
UI72375


TCZ SHAADENU DDL JOBS: ALTER/ADD COLUMNS PROCESS_RI, PROCESS_UTIL TO OBJECTS_V13 TABLE IF FOUND TO BE MISSING.
PH30870
3_Nov
2020
UI72375


4.3 ROLL UP APAR FOR OCT 2020
PH30283
19_Oct
2020
UI72134


PANEL HAA$DSD & HAA$DS2: NEW FIELD TO PROVIDE RELIEF FOR PROBLEMS CAUSED BY REORG INDEX SYSUT1 DEFAULTING TO TEMPLATE.
PH25901
8_Oct
2020
UI72002


SEP 2020 ENH ROLL UP APAR
PH26699
28_Aug
2020
UI71311


WHEN OBJECT PROFILE SPECIFIES DB IN STOP STATUS AND EXCEPTION PROFILE SPECIFIES STATUS_STOP, ALL TS AND IX SHOULD BE
EXCLUDED
PH27285
28_Aug
2020
UI71311


TS REORG FAILS WITH RC=8 AND MESSAGE DSNU1371I WHEN SPECIFYING "U" IN PROFILE FIELD AND "Y" IN INDEX ALL FIELD ON PANEL
PH27657
28_Aug
2020
UI71311


PANEL HAA$DSD MISSING DSNTYPE LARGE KEYWORD FOR TEMPLATES.
PH28536
28_Aug
2020
UI71311


HAA$TSQL (DB2 V11) & HAA$ISQL (DB2 V11 & V12): -302 OCCURS WHEN SPECIFYING 140 (OR MORE) LINES IN ADVANCED SQL STATEMENT
PH28721
28_Aug
2020
UI71311


RUNSTATS UTILITY: KEYWORD "STATCLGMEMSRT" BEING GENERATED FOR INDEXES
PH27999
28_Aug
2020
UI71311


4.3 ROLL UP APAR FOR AUG 2020
PH23713
28_Jul
2020
UI70780


ADD SUPPORT FOR UNCNT PARAMETER TO TEMPLATES FOR SYSUT1
PH23655
28_Jul
2020
UI70780


TS REORG IS GENERATED AND ABENDS WHEN TABLESPACE(S) ARE CONTAINING 0 TABLES
PH23938
28_Jul
2020
UI70780


PANEL HAA$TSQL: VALID SQL CAN FAIL WITH A -302 SQLCODE WHEN THE CONTAINS A LARGE NUMBER OF LINES
PH25191
28_Jul
2020
UI70780


CHECK UTILITY: JOB BUILD CAN FAIL WHEN LONG TABLE NAMES ARE ENCOUNTERED
PH25795
28_Jul
2020
UI70780


4.3 ROLL UP APAR FOR JUL 2020
PH26482
28_Jul
2020
UI70780


IMPLEMENT NEW KEYWORD STATCLGMEMSRT FOR RUNSTATS
PH26752
28_Jul
2020
UI70780


JOB BUILD USING BEST PRACTICE FULL INCR COPY SAMPLE PROFILE AND GENERATING CONTROL CARDS TO A DSN CAN RESULT IN A RC=12
PH25393
28_Jul
2020
UI70780


JOB BUILD FOR CHECK DATA UTILITY RESULTS IN INCORRECT # OF TABLES CREATED WHEN MULTIPLE LOB COLUMNS ARE ENCOUNTERED.
PH26368
7_Jul
2020
UI70431
UI72002


Description not available. Security/Integrity exposure
PH25439
30_Jun
2020
UI70342


JUN 2020 ENH ROLL UP APAR
PH23461
11_May
2020
UI69419


HAA$JOPT - DISALLOW PERIOD TO BE ENTERED IN 1ST AND 2ND QUALIFIER FIELDS.
PH24044
11_May
2020
UI69419


TS REORG - WHEN SPECIFYING TEMPLATES, SYSREC IS GENERATED AS A DD INSTEAD
PH24711
11_May
2020
UI69419


MAY 2020 PTF
PH23818
11_May
2020
UI69419


RECOVER UTILITY - HAA IS NOT AUTOMATICALLY INCLUDING ALL OBJECTS WHEN RECOVER VERIFYSET IS SPECIFIED.
PH24321
11_May
2020
UI69419


INVALIDATECACHE FIELD FOR RUNSTATS SHOULD BE ALLOWED FOR DB2 V12FL 100 OR HIGHER
PH24831
11_May
2020
UI69419


BEST PRACTICE FULL INCR COPY SAMPLE PROFILE TRIGGERS UNNECESSARYOBJECTS
PH24140
16_Apr
2020
UI69062
UI70342

HIPER

CORRECTION TO FULL JCLIN WHERE REFERENCES TO BOTH AHAALOAD AND AFECLOAD IN THE //SYSLIB DD AND REMOVE TYPE=UTIN
PH23500
4_Apr
2020
UI68795


4.3 APRIL 2020 ROLL-UP APAR
PH22602
3_Apr
2020
UI68795


ERROR MESSAGE HAAB607E OCCURS EVEN THOUGH THE TEMPLATE INCLUDES QUALIFIER IN THE COPY DATASET NAME.
PH22181
13_Mar
2020
UI68399


4.3 MAR 2020 ENH PTF
PH22398
25_Feb
2020
UI68072
UI68399


PE FIXER FOR UI67385
PH21812
12_Feb
2020
UI67852


FEB 2020 PTF
PH20599
12_Feb
2020
UI67852


JOB GROUP BREAKDOWN OPTIONS CAUSE ERRONEOUS OBJECTS TO BE INCLUDED IN LISTDEF.
PH21671
6_Feb
2020
UI67740
UI68399

HIPER

POSSIBLE CORRUPTION OF UTILITY PROFILES WHEN USING IMPORT FUNCTION
PH18740
29_Jan
2020
UI67632
UI68399


TABLESPACE MISSING FROM TRIGGER REPORT
PH21307
29_Jan
2020
UI67632
UI68399


JANUARY 2020 PTF
PH19447
14_Jan
2020
UI67385
PH22398

ADD THE ALL KEYWORD TO THE LISTDEF STATEMENT FOR LOBS, XMLS, ANDBASE TSS.
PH19411
14_Jan
2020
UI67385
PH22398

ADD REORG IX SYSUT1 TO USE DATASET DEFINITION INTERFACE
PH20307
14_Jan
2020
UI67385
PH22398

4.3 - DECEMBER 2019 ENH PTF
PH19205
5_Dec
2019
UI66815


ROLL UP APAR FOR NOV 2019 BUG FIXES
PH17160
5_Dec
2019
UI66815


GROUPING IS NOT WORKING CORRECTLY WITH MULTIPLE DISCARD OBJECTS IN THE SAME STEP
PH18514
12_Nov
2019
UI66389
UI67385
PH22398

4.3 - OCTOBER 2019 BUG FIXES
PH15651
12_Nov
2019
UI66389
UI67385
PH22398

HAA$OPRU: OBJECT PROFILE ENTRY DISAPPEARS WHEN UPDATING AN ENTRYWITH PARTITION LEVEL "PART"
PH16185
12_Nov
2019
UI66389
UI67385
PH22398

TEMPLATE DSN NAME IS APPENDED WITH A PERIOD IN GENERATED REORG UTILITY
PH18408
4_Nov
2019
UI66233
UI68399


SUPPORT FOR DSM Q3 2019 MAINTENANCE
PH17433
25_Oct
2019
UI66085
UI66389
UI67385
PH22398

WHEN BUILDING A REORG INDEX UTILITY AND THE RESULT CONTAINS MULTIPLE JOB STEPS, DUPLICATE SYSUT1 DDS ARE POSSIBLE
PH16375
16_Oct
2019
UI65918


4.3 - SEPTEMBER 2019 PTF
PH12142
17_Sep
2019
UI65347


HAA$TSQL: PF3 ON UPDATE MODE WITHOUT MAKING ANY CHANGES SHOULD NOT SAVE THE OBJECT PROFILE
PH15784
17_Sep
2019
UI65347


AUG 2019 ROLL-UP APAR
PH11804
17_Sep
2019
UI65347


HAAJSTAT JOB TRACKING TASK FAILED WITH ABEND S0C7-X'0'
PH14133
17_Sep
2019
UI65347


HAAB072I MESSAGE SHOULD NOT BE ISSUED FOR DB2 OBJECTS EXCLUDED FROM THE UTILITY GENERATION.
PH14292
17_Sep
2019
UI65347


HAA#BTMP CREATES DUP ROWS IN SYSOUT DD AND DLC.UTILITY_STATS_V11TABLE AFTER EXECUTING A JOB PROFILE BUILD FOR A PART TS
PH11869
7_Aug
2019
UI64649


FIX TO DETECT THE NO INDEX SITUATION AND GENERATE THE UNLDDN SREC CONTROL CARD IN REORG UTILITY
PH12674
7_Aug
2019
UI64649


ERROR MESSAGE IS GENERATED FOR A VALID TEMPLATE NAME DURING ONLINE VALIDATION
PH13999
7_Aug
2019
UI64649


JULY 2019 ROLL-UP APAR
PH11575
7_Aug
2019
UI64649


HAAB016E ERROR WHEN TRYING TO RETRIEVE INDEX OR TABLESPACE STATISTICS.
PH12727
7_Aug
2019
UI64649


ERROR MESSAGE HAAM397E IS SHOWN INCORRECTLY
PH10512
15_Jul
2019
UI64210


ENABLE OPTION TO SUPPRESS HAAB134I MESSAGES
PH10626
15_Jul
2019
UI64210


JUNE 2019 ENH ROLLUP APAR
PH10309
20_May
2019
UI63119
UI65918


HAAM044W OCCURS WHEN VIEW/UPDATE OF EXCEPTION PROFILE FROM JOB PROFILE DUE TO LIKE_BLANK_INSIGNIFICANT PARM IN DB2 SSID.
PH10400
20_May
2019
UI63119
UI65918


HAAB003E ERROR MESSAGE RECEIVED ON JOB PROFILE BUILD
PH11424
20_May
2019
UI63119
UI65918


4.3 - MAY 2019 ROLLUP APAR
PH10671
25_Apr
2019
UI62700


4.3 - UI00000 (PH00000) - APRIL 2019
PI97594
5_Apr
2019
UI62358


ENHANCEMENT TO GROUP REORGS OF PARTITIONED TABLESPACES WITH NPISINTO A SINGLE STEP
PH04436
5_Apr
2019
UI62358


'HAA065E - THIS FIELD CANNOT BE LEFT BLANK' DISPLAYED ONLY WHEN A DSN INCLUDED FOR COPY OPTIONS, SYSDISC, SYSREC, OR SYSPUNCH
PH09073
5_Apr
2019
UI62358


4.3 - MARCH 2019 ENHANCEMENT PTF
PH06914
25_Feb
2019
UI61490


LOB COLUMN=LOBTEXT - DEFINITION IS NOT COMPLETE
PH06959
25_Feb
2019
UI61490


RUNSTATS - PBG GENERATING INDEX(ALL) FOR TS AND THEN GENERATING ADDITIONAL RUNSTATS ON THE PBG INDEX
PH08304
25_Feb
2019
UI61490


4.3 - UI00000 (PH00000) - FEBRUARY 2019
PH03493
30_Jan
2019
UI61033
UI62358


INDEX OBJECTS DO NOT RESULT FROM EXPLODE BUTTON - EVEN THOUGH THE WILD-CARDED OBJECT PROFILE SPECIFIES "PROCESS INDEX"
OPTION
PH03790
30_Jan
2019
UI61031


PANEL HAAHJG12 AND UG - DOC THE "BUILD PROCESS DOES NOT WAIT ON HRECALL TO COMPLETE"
PH04871
30_Jan
2019
UI61033
UI62358


MISSING JOB PROFILE BUILD OUTPUT WHEN RUNNING A BUILD FROM DATA SERVER MANAGER
PH06479
30_Jan
2019
UI61031


DB2 AUTOMATION TOOL GENERATES DUPLICATE LISTDEF TABLESPACE COMMANDS IN THE REORG UTILITY
PH06960
30_Jan
2019
UI61031


4.3 UI00000 (PH_____) JANUARY 2019 PTF
PH07095
30_Jan
2019
UI61031


ADD BUILD MESSAGES TO INDICATE PRE-GENERATION/POST-GENERATION EXITS ARE SPECIFIED
PH03501
30_Jan
2019
UI61031


BUILD JOB TERMINATES WITH SQLCODE -911 DUE TO LOCK WAIT ON DSNDB06.SYSTSTSS
PH06143
30_Jan
2019
UI61033
UI62358


4.3 UI00000 (PH00000): DEC 2018 - Q4 DSM MAINTENANCE
PH00694
19_Dec
2018
UI60363


BUILD JOB IN BATCH FAILING WITH SQLCODE-804 IF THE JOB PROFILE INCLUDED AN EVENT NOTIFICATION PROFILE THAT DOESN'T EXIST
PH02911
19_Dec
2018
UI60363


TYPOS AND TEXT FORMATTING ISSUES ON HAAHJG27 HELP SCREEN
PH02980
19_Dec
2018
UI60363


PROBLEMS WITH LOB AND NOT LOGGED ATTRIBUTES GENERATING THE IMAGECOPY UTILITY
PH05076
19_Dec
2018
UI60363


4.3 CD5
PH03320
7_Nov
2018
UI59566
UI62358


4.3 CD4 - UI00000 (PH03320)
PH04715
7_Nov
2018
UI59565


PE FIXER FOR UI59242 18/11/01 PTF
PECHANGE
PI97108
18_Oct
2018
UI59242
PH04715

SYSREC DSN OPTION 'UNIT TYPE = CART, DISK, ETC' IS NOT GENERATEDINTO THE REORG JOB.
PH00520
18_Oct
2018
UI59242
PH04715

HAA$SYMR: RENAMING SYMPTOM REGISTRY ENTRY 'DB2_DISPLAY_STATUS.STATUS_RBDP*' TO 'DB2_DISPLAY_STATUS.STATUS_RBDP*'
PH01615
18_Oct
2018
UI59242
PH04715

REMOVE DEFAULT PROFILE FIELD FROM PANEL HAA$NTFA
PH01996
18_Oct
2018
UI59242
PH04715

HAA$ADMU DISPLAYING UNEXPECTED VALUE IN THE 'SCHEDULED' COLUMN
PH02087
18_Oct
2018
UI59242
PH04715

CHANGING AN ACTION TYPE ON HAA$ALRT PANEL SHOWS INCORRECT TYPE.
PH02088
18_Oct
2018
UI59242
PH04715

NO WAY TO RETRIEVE PANEL HAA$PRV AFTER "Y" IS SELECTED
PH02214
18_Oct
2018
UI59242
PH04715

MAPPING TABLE NAME VALIDATION NEEDED
PH02259
18_Oct
2018
UI59242
PH04715

4.3 CD3 - PH02259
PH01977
27_Aug
2018
UI58115


ABSTRACT: ROLL UP APAR - IFREQ FOR DYX-312 BUNDLE
PI99194
17_Aug
2018
UI57943


IMPLEMENT NEW EXCEPTIONS, INCLUDING DSNACCOX-LIKE EXCEPTION
PI91206
19_Jul
2018
UI57378


ROLL UP APAR
PI96054
19_Jul
2018
UI57378


BUILD JOB MAY RECEIVE S0C7 ABEND PROCESSING NON-PARTITIONED RI OBJECTS IN THE OBJECT PROFILE
PI90596
19_Jul
2018
UI57378


JOB PROFILE USING PARTITIONING METHOD 'PART' WITH WILD-CARDED OBJECT PROFILE OBJECTS MAY RESULT WRONG OBJECTS BEING
SELECTED
PI91660
19_Jul
2018
UI57378


ARYS012E - UNMATCHED QUOTES FOUND IN INPUT
PI95559
19_Jul
2018
UI57378


DB2 AUTOMATION TOOL GENERATES DUPLICATED LISTDEF TABLESPACE COMMANDS IN REORG.
PI95613
19_Jul
2018
UI57378


S0C4 ABEND CAN OCCUR WHEN HAA V4.2 OBJECT PROFILE CONTAINING ADVANCED SQL IS IMPORTED INTO HAA V4.3
PI95686
19_Jul
2018
UI57378


MODIFY TCZ TO ALLOW HPU VERSION-SPECIFIC LIBRARY TO BE SPECIFIEDPER DB2 SSID
PI98936
6_Jul
2018
UI57077


DB2 AUTOMATION TOOL GENERATES DUPLICATE REORG JOBS INTO THE SAMEPDS MEMBER
PI96374
25_Jun
2018
UI56816


JOB EXCEEDS 255 STEPS WHICH RESULTS IN RC=8 AND MESSAGE IEFC602I'EXCESSIVE NUMBER OF EXECUTE STATEMENTS'.
PI89565
14_Jun
2018
UI56561


ROLL UP APAR #4
PI96819
6_Jun
2018
UI56315


SUPPORT Q1 2018 DSM MAINTENANCE THAT ALLOWS BUILD OF JOB PROFILES
PI92498
1_May
2018
UI55599


QUERY MONITOR REORG RECOMMENDATION EXCEPTION
PI96026
1_May
2018
UI55600


LISTAPARS COMMAND MAY FAIL WITH A S0F4 ABEND IF THE SHAALOAD LIBRARY HAS BEEN CONVERTED FROM PDS TO PDS/E
PI95600
1_May
2018
UI55600


QUERY MONITOR REORG RECOMMENDATION EXCEPTION
PI95840
1_May
2018
UI55599


LISTAPARS COMMAND MAY FAIL WITH A S0F4 ABEND IF THE SHAALOAD LIBRARY HAS BEEN CONVERTED FROM PDS TO PDS/E
PI94336
16_Apr
2018
UI55261
UI69419


RUNSTATS UTILITY GENERATED ON DB2 V12 BNFA MODE FAILING WITH ERROR "INVALID OPERAND 'TABLE' FOR KEYWORD 'INVALIDATECACHE'"
PI90791
15_Feb
2018
UI53926


ROLL UP APAR IN SUPPORT DSM Q4 2017 MAINTENANCE
PI89776
5_Jan
2018
UI53035


ROLL UP APAR
PI90125
2_Jan
2018
UI52977


DB2 AUTOMATION TOOL INCORRECTLY GENERATES DUPLICATE LISTDEF TABLESPACE COMMANDS WITH A BRACKET IN THE REORG TABLESPACE
PI89148
13_Dec
2017
UI52668


SAME DATASET NAME GENERATED IN TWO JOBS
PI89580
13_Dec
2017
UI52668


EXC SHOWS IN INC/EXC COLUMN WHEN AN INCLUDE OBJECT FILTER IS EXPLODED
PI88866
5_Dec
2017
UI52440


ALLOW MAPPING TABLES TO BE CREATED AS PBG
PI87298
27_Nov
2017
UI52156
UI76952


MESSAGE DSNU049I ON REORG DUE TO MISPLACED OPTIONS TEMPLATEDD STATEMENT
PI88688
17_Nov
2017
UI52001


MISSING EDIT FOR TABLESAMPLE ON RUNSTATS UTILITY
PI88109
17_Nov
2017
UI51996
PH01977

ROLL UP APAR - IFREQ FOR DYX-312 BUNDLE
PI87728
1_Nov
2017
UI51603


TABLESPACES WITH MQTS OR HISTORY TABLES NOT TRIGGERING CORRECTLY
PI83632
10_Oct
2017
UI50991


ADD SUPPORT FOR HPU V5.1 (AND REMOVE SUPPORT FOR HPU V4.2)
PI87395
5_Oct
2017
UI50915


VARIOUS FIXES
PI85789
13_Sep
2017
UI50287


ROLL UP APAR #6
PI83558
14_Aug
2017
UI49525


ALTER STATEMENTS GENERATED INCORRECTLY FOR PBG TABLESPACE
PI82594
8_Aug
2017
UI49393


VARIOUS FIXES
PI84114
2_Aug
2017
UI49279


TAPE STACKING IS NOT TURNED OFF WHEN MAXPARTITIONS > 1
PI82455
18_Jul
2017
UI48898


INCORRECTLY RETRIEVING DB2 CATALOG STATS WITH NO DB2 CATALOG EXCEPTIONS
PI81061
10_Jul
2017
UI48662


ADD SUPPORT FOR SORTDEVT AND SORTNUM TO RUNSTATS UTILITY
PI81317
10_Jul
2017
UI48670


POPULATE THE UTILITY_ID COLUMN IN THE ACTION TABLE FROM THE AUTOMATION TOOL ENACTOR
PI83508
7_Jul
2017
UI48633


BLANK SSID RECORD INSERTED INTO CONTROL FILE
PI82170
21_Jun
2017
UI48191


SYSUT1 ALLOCATION SIZE TOO SMALL
PI81490
15_Jun
2017
UI48080


ROLL UP APAR #5
PI80149
2_Jun
2017
UI47773


BATCH IMPORT/EXPORT
PI79728
15_May
2017
UI47255


MESSAGE HAAB574W AND TAPE STACKING OFF FOR PBG TABLESPACE
PI79164
28_Apr
2017
UI46857


ABEND S0C7 IN MODULE HAA#BTMP
PI77776
6_Apr
2017
UI46257


ROLL UP APAR #4
PI76470
16_Mar
2017
UI45612


ROLL UP APAR #3
PI72145
22_Feb
2017
UI44905


RECOVER OPTIONS ADDED IN UI41488
PI72314
22_Feb
2017
UI44905


DELETEDS SUPPORT FOR MODIFY RECOVERY
PI76019
17_Feb
2017
UI44783


SYMPTOM REGISTRY EDITOR DOESN'T DISPLAY SEVMULTIPLIER VALUES
PI73272
24_Jan
2017
UI44162


ROLL-UP APAR #2
PI71590
14_Dec
2016
UI43359


PROVIDE EXPLOITATION SUPPORT FOR DB2 V12 (3 OF 5)
PI71592
14_Dec
2016
UI43360


PROVIDE EXPLOITATION SUPPORT FOR DB2 V12 (4 OF 5)
PI71589
14_Dec
2016
UI43358


PROVIDE EXPLOITATION SUPPORT FOR DB2 V12 (2 OF 5)
PI71598
14_Dec
2016
UI43362


PROVIDE EXPLOITATION SUPPORT FOR DB2 V12 (5 OF 5)
PI70228
13_Dec
2016
UI43357


PROVIDE EXPLOITATION SUPPORT FOR DB2 V12 (1 OF 5)
PI70310
20_Oct
2016
UI41876


ROLLUP APAR #1 V43 AUTOMATION TOOL

Top of page