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: 2 August 2023
DB2 High Performance Unload for z/OS Version 4.3
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH51691
13_Feb
2023
UI90507


MISSING OR TRUNCATED DATA IN NATIVE MODE INVOLVING CCSID CONVERSION
PH33305
27_Apr
2021
UI75100
PH47485

After PH17958, ABENDS0CA or 227 * EXPRESSION EVALUATION ERROR or incorrout for an unload involving DECIMAL division
PH35541
26_Apr
2021
UI75100
PH47485

INCORRECT VALUE/SCALE FOR EXPRESSION INVOLVING OPERATION BETWEENBIGINT CONSTANT AND DECIMAL VALUE
PH35806
26_Apr
2021
UI75100
PH47485

AFTER PH27640, UNDUE INZU039E OR INZU090E IF UNLOAD WITH UNLOAD PLUS SYNTAX AND WHERE CLAUSE WITH SUBSELECT
PH36327
26_Apr
2021
UI75100
PH47485

AFTER APAR PH17958,OVERFLOW DURING SQL EVALUATION IN SQL MODE LEADS TO ABENDS0CA INSTEAD OF 227 * EXPRESSION EVALUATION
ERROR
PH30766
18_Nov
2020
UI72654
UI75100
PH38791

MORE TROUBLESHOOTING INFORMATION WHEN THE VALUE OF VUU030/ ULOPTNS IS INVALID
PH28718
18_Nov
2020
UI72654
UI75100
PH38791

WRONG SQLPART EVALUATION FOR AN UNLOAD RUN IN SQL MODE
PH24987
18_Nov
2020
UI72654
UI75100
PH38791

SQLCODE713 IF APPLCOMPAT REQUIRED THROUGH DB2 HPU LATER THAN DB2SUBSYSTEM APPLCOMPAT
PH30767
18_Nov
2020
UI72654
UI75100
PH38791

SOME SUBPARAMETERS COMBINATIONS FOR VUU030/ULOPTNS CANNOT BE SPECIFIED THROUGH TOOLS CUSTOMIZER
PH25262
22_Jun
2020
UI70170
UI72654
UI75100
PH38791

&UNIQ NOT IDENTICAL FOR ALL PARTITION USING SQLPART IN SQL MODE
PH26119
22_Jun
2020
UI70170
UI72654
UI75100
PH38791

ABENDU1009 OR INCORRECT ORDER FOR THE UNLOADED ROWS
PH23549
14_May
2020
UI69506
UI70170
UI72654
UI75100
PH38791

AFTER FIX FOR PH17958, LOGICAL UNLOAD FAILS WITH INZU238E 20/04/27 PTF
PECHANGE
PH22067
14_Apr
2020
UI69013
UI72654
UI75100
PH35806

INSUFFICIENT LRECL FOR OUTPUT DATASET IF VARBINARY EXPRESSION - 2 BYTES MISSING PER VARBINARY FIELD
PH21119
3_Mar
2020
UI68180
UI69013
UI72654
UI75100
PH38791

INZI164E INSTEAD OF INZI190E AND INZI165E INSTEAD OF INZI191E
PH21189
3_Mar
2020
UI68180
UI69013
UI72654
UI75100
PH38791

TOLERATE INDEXES ON DECFLOAT COLUMN
PH17958
23_Jan
2020
UI67514
UI68180
UI69013
UI72654
UI75100
PH35806

ABEND S0CA IF WHERE CLAUSE WITH PREDICATE ON DECIMAL DATA
PH17989
6_Jan
2020
UI67268
UI68180
UI69013
UI72654
UI75100
PH35806

ABENDU114 DURING AN UNLOAD INVOLVING THE INDEXSCAN FEATURE
PH16591
19_Dec
2019
UI67136


DIFFICULT TROUBLESHOOTING IF REQUIRED BIND NOT RUN AFTER UPGRADETO DB2 V12
PH16342
28_Oct
2019
UI66098


LOW PERFORMANCE FOR AN UNLOAD IN SQL MODE OF LOB DATA
PH14248
12_Aug
2019
UI64706


ABENDS0C4 WHEN UNLOADING FROM DB2 CATALOG TABLE IN NATIVE MODE
PH12190
25_Jun
2019
UI63853


LAST UNLOADED DATA SET WRITTEN ON TAPE REPORTED AS DELETED
PH11448
7_May
2019
UI62866


SQL ERROR WHEN SQLPART ON DB2 WITH DECIMAL POINT COMMA
PH09192
12_Apr
2019
UI62517
UI69013
UI72654
UI75100
PH35806

DATA UNLOADED AND RC 0 DESPITE INZI193E MENTIONNING ERROR WITH APPLCOMP/APPLCOMPAT
PH09284
12_Apr
2019
UI62517
UI69013
UI72654
UI75100
PH35806

ENHANCED HELP TEXT FOR VUM036/APPLCOMP Z672
PH08630
8_Mar
2019
UI61744
UI69013
UI72654
UI75100
PH35806

INZI009E WHEN UNLOADING GRAPHIC DATA FROM A COLUMN Z669
PH07884
22_Feb
2019
UI61511
UI69013
UI72654
UI75100
PH35806

PADDING OF VARGRAPHIC, WHERE CLAUSE ON VARGRAPHIC AND DATA TRUNCATION OF GRAPHIC/VARGRAPHIC CAN BE INCORRECT
PH04750
7_Feb
2019
UI61213
UI69013
UI72654
UI75100
PH35806

IEW2556W MESSAGES DURING APAR/PTF APPLICATION
PH02519
4_Feb
2019
UI61213
UI69013
UI72654
UI75100
PH35806

INZI330E IF EXECUTE NO AND SEVERAL UNLOAD COMMANDS WITH THE INPUT IMAGE COPIES LOCATED ON THE SAME TAPE
PH03191
14_Nov
2018
UI59619
UI69013
UI72654
UI75100
PH35806

INCORRECT LOAD CONTROL CARDS FOR CLOB/BLOB/DBCLOB/XML DATA UNLOADED INSTREAM
PH03135
8_Nov
2018
UI59619
UI69013
UI72654
UI75100
PH35806

MISSING INZU376I AND INCORRECT NUMBER OF ROWS MENTIONED BY INZU376I
PH04693
8_Nov
2018
UI59619
UI69013
UI72654
UI75100
PH35806

PB53712 Z660
PH03148
11_Oct
2018
UI58959
UI69013
UI72654
UI75100
PH35806

IEC143I 213-30 IF TWO SELECT STATEMENTS SHARE THE SAME OUTPUT PDS... INCLUDED IN PTF UI58908
PH03149
8_Oct
2018
UI58959
UI69013
UI72654
UI75100
PH35806

ROLLED UP MAINTENANCE
PH01174
17_Sep
2018
UI58542
UI69013
UI72654
UI75100
PH35806

COMPLETION CODE LESS THAN 4 WITH INZU502W
PH00452
10_Aug
2018
UI57807
UI69013
UI72654
UI75100
PH35806

INCORRECT UNLOADED IMAGE COPY WHEN COPYDDN -N WITH N > 1 AND ULICTYPE = ANYTYPE/ANYTYPE_CONSISTENT
PH00823
10_Aug
2018
UI57807
UI69013
UI72654
UI75100
PH35806

UNDESIRED EXTRA BLANK IN THE FAKE TABLE NAME SPECIFIED IN THE GENERATED LOAD CONTROL CARDS
PH01209
10_Aug
2018
UI57807
UI69013
UI72654
UI75100
PH35806

ESTIMATION FOR SORT OVERESTIMATED UNLOADING FROM IC
PI97170
9_Jul
2018
UI57145
UI69013
UI72654
UI75100
PH35806

TRUNCATED LINE IN THE SELECT CLAUSE DISPLAYED IN SYSPRINT BINARYZERO IN EXPRESSION FROM THE SELECT CLAUSE
PI98842
9_Jul
2018
UI57145
UI69013
UI72654
UI75100
PH35806

ABENS013-A4 IF SYSIN ALLOCATED WITH SUBSYS PARAMETER
PI96914
20_Jun
2018
UI56722
UI69013
UI72654
UI75100
PH35806

WRONG CATALOG VERSION DETERMINED IF DATA SHARING PARTIAL MIGRATION TO V12
PI96267
24_May
2018
UI56084
UI69013
UI72654
UI75100
PH35806

ALLOCATION OF WHOLE GDG INSTEAD OF MOST RECENT DATA SET IF TEMPLATE WITH DSN GDG_NAME(0)
PI96657
24_May
2018
UI56084
UI69013
UI72654
UI75100
PH35806

DATA/DICTIONARY SEQUENCE NOT TRAPPED ALTHOUGH CHECK_INTEGRITY/CHECKINT SPECIFIES LEVEL1 WITH IC SUBOPTION
PI96676
24_May
2018
UI56084
UI69013
UI72654
UI75100
PH35806

ABENDS0C4/ABENDU1003 IF UNLOAD OF PARTITION TABLESPACE WITH SQLPART OPTION AND SINGLE OUTPUT DATA SET ALLOCATED VIA
TEMPLATE
PI98081
24_May
2018
UI56084
UI69013
UI72654
UI75100
PH35806

THE ALLOCATION OF AN IMAGE COPY LOCATED ON TAPE TO BE UNLOADED (COPYDDN OPTION) FAILS WITH IKJ56221I
PI95207
9_Apr
2018
UI55111
UI69013
UI72654
UI75100
PH35806

POTENTIAL ABEND WHILE UNLOADING THE DATA FROM IMMAGES COPIES FORMORE THAN 9 TABLESPACES
PI95133
29_Mar
2018
UI54846


ABENDS0C4 ON LOGICAL UNLOAD WITH ORDER CLAUSE FROM A PBR2 TABLE SPACE
PI95522
29_Mar
2018
UI54846


AN INTERMITTENT ABENDS0C4 CAN OCCURS WHEN UNLOADING LOB DATA FROM A PARTITIONNED TABLE SPACE
PI94331
7_Mar
2018
UI54315


ABENDS0C4 OR NEVER ENDING LOOP IF DDLDDN WITH NOT NULL WITH DEFAULT AS SECURITY LABEL
PI94164
26_Feb
2018
UI54072


ENHANCEMENT AND FIXES OF THE DDL GENERATION FEATURE (LOADDDL TABLE OPTION OR CNTLCARDS_DB2(DDL) IN VUU030/ULOPTNS).
PI92007
19_Feb
2018
UI53962


INCORRECT AUTOTAG FIELD AND WHEN CLAUSE WHEN ORIGINOBID OPTION IS SPECIFIED
PI92008
19_Feb
2018
UI53962


INCORRECT WHEN CLAUSE IF AUTOTAG OPTION SPECIFIED AND DATA WITH NON-EBCDIC ENCODING SCHEME
PI92055
19_Feb
2018
UI53962


ALLOW TO DISABLE BIF COMPATIBILITY RETRIEVAL FROM DB2 SETTINGS
PI93188
19_Feb
2018
UI53962


DDLDDN: INZU366I WITH REASON CODE 0X32A00B IF DDLDDN FILE CONTAINS A FOR UPDATE CLAUSE IN THE "FREE BLOCK"
PI91711
19_Feb
2018
UI53962


INZI503E IF DDLDDN SPECIFIES IMPLICITLY HIDDEN OR INLINE LENGTH OR GENERATED ... AS
PI91963
19_Feb
2018
UI53962


IRRELEVANT INZU460I IS ISSUED FOR A DB2 FORCE UNLOAD
PI93186
19_Feb
2018
UI53962


PERFORMANCE ENHANCEMENT OF NATIVE UNLOADS INVOLVING LOBS
PI93187
19_Feb
2018
UI53962


ABENDU1132 WHEN UNLOADING BIG LOB DATA IN NATIVE MODE
PI93189
19_Feb
2018
UI53962


WRONG DDLDDN FILE ANALYSIS IF APPEND / LOGGED / COMPRESS / DSSIZE / BUFFERPOOL / MEMBER
PI91438
30_Jan
2018
UI53550


INVALID LOAD CONTROL CARD IF SHRLEVEL REFERENCE IN LOADOPT
PI92553
30_Jan
2018
UI53550


A LOGICAL UNLOAD FAILS WITH DSNT408I SQLCODE = -4742, ERROR: ...(REASON 4)
PI89113
12_Jan
2018
UI53208


CLONE/MATERIALIZED/HISTORY TABLE NOT UNLOADED IF DEFINED THROUGHLISTDEF
PI89395
29_Dec
2017
UI52952


INZI010E INTERNAL CONVERSION ERROR BETWEEN CCSID XXXXX AND CCSIDYYYYY
PI89751
29_Dec
2017
UI52952


INZU016E EXPRESSION STATEMENT SYNTAX IS INVALID IF "NOT" CHARACTER USED IN THE SYSIN
PI90985
29_Dec
2017
UI52952


HPU TO BE ABLE TO PUT THE NULL INDICATOR GROUPED AT THE BEGINNING OF THE RECORD
PI88226
29_Dec
2017
UI52952


UNLOAD FROM IMAGE COPY FAILS AFTER IKJ56228I FILE HPU00000 NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED
PI88371
29_Dec
2017
UI52952


DB2 HPU REPEATEDLY ALLOCATES THE LOB AUXILIARY TABLE SPACES
PI85937
30_Nov
2017
UI52310


INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B) WHEN DDLDDN CONTAINS INCORRECT SYNTAX
PI86356
30_Nov
2017
UI52310


MISLEADING MSGINZU095E SYNTAX ERROR - PROCMSG/SELMSG KEYWORD ONLY VALID WITH UNLOAD BLOCK
PI89112
30_Nov
2017
UI52310


IRRELEVANT ENDING LETTER FOR INZU211W MESSAGE ASSOCIATED WITH RC 0
PI85634
30_Nov
2017
UI52310


INVALID LOAD CONTROL CARDS LEAD TO DSNU088I DSNUGTIS - INVALID CHARACTER OPERAND - ''' IN DB2 LOAD.
PI86361
30_Nov
2017
UI52310


LAST RECORD MISSING FROM PROCMSG IF DD IS EXPLICITLY ALLOCATED
PI88517
30_Nov
2017
UI52310


INZU015E GLOBAL STATEMENT : UNEXPECTED KEYWORD NOT CLEAR ENOUGH
PI86599
16_Nov
2017
UI52010


INZX133 SSSSSSSS NO VALID INPUT DDNAME DDDD FOUND
PI90048
16_Nov
2017
UI52010


SUPPORT OF THE COMPRESSED LOB
PI90049
16_Nov
2017
UI52010


S0C4 WHEN NATIVELY UNLOADING AN XML COLUMN
PI87440
3_Nov
2017
UI51696


ENCLOSEDBY SUB-OPTION OF CSV FORMAT ONLY TAKEN INTO ACCOUNT FOR THE FIRST SELECT OF A SAME UNLOAD STATEMENT.
PI83370
17_Oct
2017
UI51195


PROVIDE APPLCOMPAT OPTION AT THE JOB LEVEL VIA HPU PARM.
PI84681
17_Oct
2017
UI51195


INZU474I DATA TYPE FOR TARGET COLUMN COLUMN-NAME NOT SPECIFIED BY INTO CLAUSE BUT NO INTO WAS REQUESTED.
PI81153
19_Sep
2017
UI50433


PANEL CCQPLPR SHOWS SINZPLIB RATHER THAN SINZPANL
PI85378
19_Sep
2017
UI50433


INCOMPLETE DATASET NAME IN THE GENERATED LOAD CONTROL CARDS WHENTEMPLATE AND GDG ARE USED.
PI84871
30_Aug
2017
UI49959


UNLOAD PLUS COMPATIBILITY: TOLERATE NEW/RESTART IN PARM
PI84324
30_Aug
2017
UI49959


UNLOAD FAILS WITH SQLCODE = -4742 REASON 2
PI85458
30_Aug
2017
UI49959


INCORRECT NUMBER OF ROWS AND/OR EMPTY ROWS AFTER FIX FOR PI72114 17/08/03 PTF
PECHANGE
PI80358
29_Jun
2017
UI48428


NON-DELIMITED SQL KEYWORDS NOT SUPPORTED AS COLUMN NAME IN DDLDDN FILE.
PI80530
29_Jun
2017
UI48428


TRIM OPTION AND TRIM SCALAR FUNCTION: CHAR/VARCHAR FOR BIT DATA DATA NOT TRIMMED
PI82889
29_Jun
2017
UI48428


ABENDS0C2 WHEN UNLOADING IN SQL MODE WITH DB2 PARALLELISM
PI77202
28_Apr
2017
UI46841


INVALID DATE EXTERNAL(4) IN GENERATED LOAD STATEMENT IF REFORMAT/INTO CLAUSE INTO DATE DATA TYPE
PI75402
5_Apr
2017
UI46201


THE DATACLAS, MGMTCLAS OR STORCLAS OPTIONS OF A TEMPLATE STATEMENT ARE NOT TAKEN INTO ACCOUNT.
PI75671
5_Apr
2017
UI46201


MSGINZU366I UTILITY RC 8 (REASON CODE 0X130A00B) AGAINST A FLASHCOPY IMAGE COPY.
PI76684
5_Apr
2017
UI46201


UNLOAD FAILS - INZI503E WHEN MINVALUE OR MAXVALUE OPERAND OF AN AS-IDENTITY-CLAUSE GREATER THAN 2147483647.
PI76521
5_Apr
2017
UI46201


THE UNLOAD PROCESS FAILS IN ABENDS12F WITH REASON CODE 28.
PI76892
5_Apr
2017
UI46201


CHARACTER, GRAPHIC AND MIXED COLUMNS OF THE TARGET TABLE UNEXPECTEDLY ENCODED IN UNICODE INSTEAD O 17/02/20 PTF
PECHANGE
PI77354
5_Apr
2017
UI46201


DUPLICATE TEMPLATE ANALYSIS MESSAGES IF TEMPLATE LIBRARY CONTAINS ERRORS
PI78423
5_Apr
2017
UI46201


ABENDS0C4 ON SQL MODE UNLOAD AGAINST A PARTITIONED TABLE SPECIFYING SQLPART
PI69203
6_Mar
2017
UI45327
PI85458

INCONSISTENT RESULTS WHEN UNLOADING FROM BAD IMAGE COPY
PI70774
6_Mar
2017
UI45327
PI85458

UNLOAD FAILS WITH ABENDU1022 R15=0 WHEN THE TABLE SPACE VSAM DATA SET CONTAINS RECORDS W/ VERSION 0
PI74106
6_Mar
2017
UI45327
PI85458

INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B)
PI77025
6_Mar
2017
UI45327
PI85458

ABENDS0C4 OR INCORRECT DATA UNLOADING FROM IMAGE COPY
PI77028
6_Mar
2017
UI45327
PI85458

SETTINGS FOR VUX038/CHECKINT IGNORED
PI72114
6_Mar
2017
UI45327
PI85458

INZU042E & INZU516E UNLOADING FROM A UTS BY GROWTH COPY MADE BEFORE ADDED THE LAST PARTITION
PI77027
6_Mar
2017
UI45327
PI85458

ABENDS0C4 UNLOADING FROM IMAGE COPY WITH DDLDDN IF DESCREPANCY BETWEEN THE TABLE SPACE AND INDEXPARTITION NUMBERS
PI77029
6_Mar
2017
UI45327
PI85458

MISSING ROWS UNLOADING CONATENATESDINLINE IC OF VERY SMALL PARTITIONS OF PBR2
PI74387
8_Feb
2017
UI44503


DB2 HPU MIGHT ABEND OR HAVE POOR PERFORMANCE IF THE LE OPTIONS ARE NOT SUITABLE TO DB2 HPU.
PI75681
8_Feb
2017
UI44503


INDEXSCAN FEATURE IS LESS USED THAN EXPECTED WITH AN ORDER CLAUSE
PI75993
8_Feb
2017
UI44503


REMOVE THE BRACKET RESTRICTION IN NATIVE HPU SYNTAX SPECIFYING PARTITIONS
PI65560
23_Jan
2017
UI44140


MESSAGE TO INFORM THAT A DEFAULT OUTPUT DATA TYPE IS ASSUMED IF OUTPUT-DATA-TYPE NOT SPECIFIED IN INTO CLAUSE
PI74438
23_Jan
2017
UI44140


INZQRY11 BIND FAILS WITH SQLCODE=-4700 STATEMENT=709 IN A DB2 V11 CM MODE WITH THE PTF UI43511 INSTALLED 17/01/25 PTF
PECHANGE
PI74439
23_Jan
2017
UI44140


UNLOAD USING EXPRESSIONS WITH CHAR(DECIMAL_DATA) AND VARCHAR(DECIMAL_DATA) COULD BE INCORRECT.
PI73002
10_Jan
2017
UI43799
PI74438

PACKAGE VERSIONING WILL BE REINSTATED, SQLCODE805
PI73468
10_Jan
2017
UI43799
PI74438

UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN SQL MODE
PI74158
10_Jan
2017
UI43799
PI74438

ABENDS0C4 IN ISPF INTERFACE WITH DB2 12
PI74203
10_Jan
2017
UI43799
PI74438

SUPPORT ADDED TO ALLOW DECIMAL DATA TO BE CAST AS TIME OR DATE WHEN UNLOADING FROM AN IMAGE COPY
PI70588
10_Jan
2017
UI43799
PI74438

EXPECTED DDL NOT GENERATED IF FROM A VIEW (NOT TABLE)
PI71977
10_Jan
2017
UI43799
PI74438

THE INDEX SCAN FEATURE ELIGIBLE FOR A LOGICAL UNLOAD WITH AN ORDER CLAUSE IS ENABLED BUT NOT USED.
PI72828
21_Dec
2016
UI43511
PI74438

UNLOAD FAILS WITH CC08 WITH MSGINZU016E LOADDDN IS INVALID OR MSGINZU016E DDLDDN STATEMENT SYNTAX IS INVALID.
PI72450
21_Dec
2016
UI43511
PI74438

UNEXPECTED MSGS INZT028E, INZU469E, INZU283E, INZC003E COULD BE ISSUED WHEN TEMPLATE IS USED.
PI64904
21_Dec
2016
UI43511
PI74438

SYNCHRONIZE INZU469W/E AND INZU283W/E MESSAGES WITH THE ASSOCIATED RETURN CODE 4/8.
PI68906
21_Dec
2016
UI43511
PI74438

BETTER ADDRESS INZU395E HANDLING
PI71973
21_Dec
2016
UI43511
PI74438

MSGINZU016E OUTDDN STATEMENT SYNTAX IS INVALID WITH UNSUPPORTED SELECT NOT TERMINATED WITH A SEMICOLON
PI71885
23_Nov
2016
UI42867


UNLOADING XML DATA AN EBCDIC TABLESPACE UNLOADED WITH ASIS NOT CONVERTED INTO EBCDIC 16/11/07 PTF
PECHANGE
PI65461
31_Oct
2016
UI42180
PI71885

ABENDS0C4 (INZZ001S(0001): ABEND IN INZUTILK - CODE=S0C4 U0000 REASON=00000011) WHEN LISTDEF IS INVALID.
PI70006
31_Oct
2016
UI42180
PI71885

UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN NATIVE MODE
PI65463
31_Oct
2016
UI42180
PI71885

MISLEADING MESSAGE INZI345I WHEN QUESTION MARK (?) PATTERN-MATCHING CHARACTER IS USED IN LISTDEF
PI67064
31_Oct
2016
UI42180
PI71885

UNLOAD FROM AN ALIAS FAILS WITH CC=8 AND MSGINZU066E NO TABLESPACE FOUND FOR TABLE TABLE_NAME
PI67459
31_Oct
2016
UI42180
PI71885

AN UNLOAD ENDS WITH A NORMAL COMPLETION CODE WHILE AN I/O ERROR OCCURRED.
PI68502
31_Oct
2016
UI42180
PI71885

UNEXPECTED MSGINZU020E AND RC08 WHEN UNLOADING FROM SYSTABLES.
PI69123
31_Oct
2016
UI42180


WITH HPU 4.3, IN UNDETERMINED SITUATIONS DB2 HPU MIGHT END WITH ABENDS0C4 AFTER HAVING ISSUED A MSG. CEE0374C
CONDITION=CEE3204S
PI64271
31_Oct
2016
UI42180


INZU238E UNEXPECTED UNSUPPORTED SELECT UTILITY CANNOT SWITCH TO SQL PROCESSING
PI67455
31_Oct
2016
UI42180


THE ALTER DROP COLUMN STATEMENT FOLLOWED BY A REORG DOES NOT REMOVE THE VERSION 0 FROM THE CATALOG U1130
PI71036
31_Oct
2016
UI42180


NO RESULTS AND SQLCODE104 RUNNING HPU ONLINE CLIST
PI60031
5_Oct
2016
UI41422


ABENDS0C4 IN UNLOAD PLUS WITH "INFILE DDNAME INCREMENTAL"
PI60117
5_Oct
2016
UI41422


HPU WITH UNLOAD PLUS SYNTAX SPECIFYING INFILE DDNAME INCREMENTAL
PI56401
5_Oct
2016
UI41422


HPU NOW SUPPORTS THE UNLOAD PLUS CNTLCARDS DB2 INSTEAD OF MSGINZU027W
PI65449
15_Sep
2016
UI40836


RETPD PARAMETER FROM THE TEMPLATE STATEMENT IS IGNORED
PI62205
8_Aug
2016
UI39950
PI76892

UNEXPECTED INZI181E WHEN USING SQLPART OPTION.
PI64902
8_Aug
2016
UI39950
PI76892

DB2 SUPPORT 1
PI65723
8_Aug
2016
UI39950
PI76892

PADDING_STRICT(NO) IS REMOVED
PI65342
8_Aug
2016
UI39950
PI76892

DISABLE 'FOR READ ONLY' CLAUSE SUPPORT
PI65721
8_Aug
2016
UI39950
PI76892

DBMDSSID VALUE 1215 INSTEAD OF 1010
PI65722
8_Aug
2016
UI39950
PI76892

ABENDS0C4 UNLOADING FROM IMAGE COPY
PI64634
1_Jul
2016
UI39126


ABENDS0C4 OR INZU499E
PI61522
1_Jul
2016
UI39126


MSGINZRE42 AND COMPLETION CODE 8 WHEN ATTEMPTING TO RUN HPU UNLOAD AGAINST THE TABLE SPACE (I.E. IN NATIVE MODE).
PI62936
1_Jul
2016
UI39126


UNEXPECTED INZI158E ERROR WHEN TRYING TO OBTAIN A SHARED LOCK ONTABLE : XXXX.YYYY
PI63160
1_Jul
2016
UI39126


HPU IGNORES FLASHCOPY DATA SET CREATED WITH THE OPTION CONSISTENT
PI63170
16_Jun
2016
UI38734


ABEND0C4
PI62921
16_Jun
2016
UI38734


UNEXPECTED INZI330E DYNAMIC ALLOCATION FAILED
PI57122
18_May
2016
UI37985


UNEXPECTED INZU016E STATEMENT SYNTAX IS INVALID
PI57958
18_May
2016
UI37985


THE REFORMAT (TYPE TIMESTAMP INTO TIMESTAMP_X) OPTION HAS NO EFFECT AND OUTPUT FORMAT OF THE TIMESTAMP IS DEFAULT ONE.
PI58263
18_May
2016
UI37985


SOME UNDUE THUS MISLEADING MESSAGES ARE ISSUED RIGHT AFTER THE MESSAGE INZU283E/UDBU283E HAS BEEN ISSUED.
PI58390
18_May
2016
UI37985


THE INZI012E IN UNLOAD PLUS SYNTAX WITH TWO SELECT STATEMENT THAT BOTH REQUIRE THE FORMAT CSV TERMINATEDBY ','
PI58803
18_May
2016
UI37985


LOGICAL UNLOAD WITH ORDER CLAUSE FAILS DURING THE SORT PHASE WITH ABENDU1017 OR ABENDU1009
PI61545
18_May
2016
UI37985


INZU283E ERROR IN TEMPLATE LIBRARY DDNAME
PI58501
28_Apr
2016
UI37414


WAIT FOR MIGRATED DATA SETS BE RECALLED
PI58503
28_Apr
2016
UI37414


IKJ56221I DATA SET NOT ALLOCATED VOLUME NOT AVAILABLE+ ANOTHER JOB OR USER INZI330E DYNAMIC ALLOCATION FAILED REASON=0X220
PI58502
28_Apr
2016
UI37414


IKJ56221I DATA SET NOT ALLOCATED, VOLUME NOT AVAILABLE IKJ56221I VOLUME ALLOCATED TO ANOTHER JOB OR USER
PI54678
18_Apr
2016
UI37094


ADD PARMLIB PARM TO FORCE THE QUIESCE YES OPTION WHEN UNLOAD OF A LOB COLUMN RATHER THAN ABENDU1133
PI58083
18_Apr
2016
UI37094


DB2 12 PRECONDITION
PI56404
18_Mar
2016
UI36347


HPU SHOULD NOT SELECT A CONCURRENT IMAGE COPY WHEN THE COPYDDN LAST_IC OR COPYDDN INTEGER OPTION
PI55738
29_Feb
2016
UI35746


A PHYSICAL UNLOAD (UNLDDN) IN INTERNAL FORMAT (INTERNAL_FORMAT) PRODUCES INCORRECT OUTPUT DATA THAT CANNOT BE LOADED BY DB2
LOAD
PI56162
29_Feb
2016
UI35746


INVALID LOAD STATEMENT IN HPU V4.3 WHEN USING LOADOPT WITH PARTITION OR TABLE LEVEL OPTIONS.
PI47096
25_Jan
2016
UI34732


THE TRIM OPTION SPECIFIED IN THE GLOBAL OPTION BLOCK OR IN THE UNLOAD BLOCK IS NOT TAKEN INTO ACCOUNT.
PI52402
7_Jan
2016
UI34288


INZU366I UTILITY RETURN CODE 8, INZU310E CCSID 1140 IS NOT MIXEDINZU310E CCSID 1140 IS NOT DBCS
PI53068
7_Jan
2016
UI34288


ABENDS0C4 UNLOADING FROM A FLASHCOPY DATA SET OF A TABLE SPACE HAVING ONLY ONE PARTITION.
PI53302
7_Jan
2016
UI34288


ABENDS0C4 OR OTHER UNPREDICTABLE RESULT UNLOADING FROM FLASHCOPYOF TABLE SPACE OR PARTITION IN BRF (BASIC ROW FORMAT).
PI50988
7_Jan
2016
UI34288


MISSING EXPECTED INZU380I INFORMATION : DEFAULT OUTPUT FORMAT MESSAGE
PI51058
7_Jan
2016
UI34288


A FAILURE IN QUIESCE UTILITY INITIATED BY DB2 HPU AND MSGDSNU024I DSNUTILB - PARM FIELD ERROR - 'SSID,UID.JOBNAME'
PI51997
7_Jan
2016
UI34288


THE MESSAGE INZU131W DISPLAYS UNREADABLE CHARACTERS.
PI50023
8_Dec
2015
UI33623


ABENDU4093 REASON CODE=90 U1017
PI49693
23_Nov
2015
UI32343


ALLOW TO UNLOAD NULL VALUES AS A STRING THAT INDICATES A NULL VALUE IN THE OUTPUT FILE WHEN THE DELIMITED FORMAT IS
REQUESTED.
PI51321
23_Nov
2015
UI32343


PACKAGING PROBLEM LEADING TO MISSING FIX
PI52079
23_Nov
2015
UI32343


UNEXPECTED PADDING OF THE NULL VALUE
PI47438
23_Oct
2015
UI32343


SORT PERFORMED WITH FIXED LENGTH FIELDS (THE SORT PARAMETER TYPE=F IS SPECIFIED WHILE TYPE=V IS EXPECTED)
PI47610
23_Oct
2015
UI32343


UNLOADED RECORDS SORTED INCORRECTLY IN NATIVE MODE
PI48131
23_Oct
2015
UI32343


UNLOAD WITH UNLOAD PLUS SYNTAX REQUESTING BIGINT DATA
PI47724
8_Oct
2015
UI31880


CONFUSING MSGINZU063I UNSUPPORTED SELECT UNLOADING TABLE WITH SYSIBM.SYSTABLES COLUMN TYPE NOT T, C, M OR V
PI47987
8_Oct
2015
UI31880


A NEW PARAMETER (VUU076/ULICTYPE) TO BE SET VIA TOOLS CUSTOMIZER
PI47988
8_Oct
2015
UI31880


NEW PARAMETERS (VUU075/ULNULLP, ONE PER OUTPUT FORMAT) TO BE SETVIA TOOLS CUSTOMIZER WOULD BE ADDED.
PI48086
8_Oct
2015
UI31880


HELP TO NAVIGATE FROM INZB101I TO UPPER LEVEL PANELS
PI47723
8_Oct
2015
UI31880


HPU REPORTS EMPTY TABLESPACE UNLOADING HISTORY TABLE IN SQL MODE
PI47725
8_Oct
2015
UI31880


SUPPORT UNLOADING TEMPORAL TABLE OF 'H' IN NATIVE MODE
PI49040
8_Oct
2015
UI31881


IMPROVE 'FORMAT VARIABLE END' SUPPORT
PI45640
21_Sep
2015
UI31323


WRONG DB2 VERSION DISPLAYED IN HPU UNLOAD JOBLOG IN THE MSGINZI020I
PI46003
8_Sep
2015
UI30922


OPTIONS FOR CNTOLCARDS CONCATENATED WITHOUT ADDING EXPECTED BLANK CHARACTER
PI46781
8_Sep
2015
UI30922


QUIESCE YES/NO NOT ACCEPTED IN SYSIN IN UNLOAD PLUS SYNTAX
PI46782
8_Sep
2015
UI30922


ADD SUPPORT OF USELRECL IN SYSIN
PI45632
11_Aug
2015
UI30118


NEW ULOPTNS OPTION FMT_VAR_FB_IF_FIXED FOR FORMAT VARIABLE TO UNLOAD TO FB FILE IF NO VARCHAR COLUMN PRESENT
PI38442
22_Jul
2015
UI29640


LIMIT OPTION FOR TEMPLATE IS IGNORED
PI42736
22_Jul
2015
UI29640


ABENDU101 WITH DB2 FORCE UNLOADING PARTITIONED TABLE WITH TEMPLATE NAME ENDING WITH A NUMBER AND EXTERNAL SORT.
PI43979
22_Jul
2015
UI29640


ABENDU1003 WHEN UNLOAD FROM AN IMAGE COPY (COPYDDN)
PI44221
22_Jul
2015
UI29640


INCORRECT LOAD STATEMENT CREATED CONTAINING SAME NUMBER OF LOAD COMMANDS AS TABLES INVOLVED
PI42739
22_Jul
2015
UI29640


INSURE HPU V4.3 CREATES NECESSARY DIAGNOSTICS
PI43497
22_Jul
2015
UI29640


INZU039E FATAL SYNTAX ERROR BEFORE LINE LLL COLUMN CC INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X107A002)
PI44241
17_Jul
2015
UI29516


ABENDS0C1 MSGIEW2454W 9203 SYMBOL UNRESOLVED. NO AUTOCALL (NCAL) SPECIFIED ON NEW INSTALL
PI41195
29_Jun
2015
UI28952


ROWS FROM ONE PARTITION WRITTEN IN OUTFILE OF ANOTHER PARTITION,LEADS TO UNEXPECTED EXTRA NUMBER OF ROWS O 15/05/15 PTF
PECHANGE
PI41365
29_Jun
2015
UI28952


ABENDS0C4 RUNNING AN UNLOAD FASTUNLOAD SYNTAX
PI42495
29_Jun
2015
UI28952


DECREASE THE AMOUNT OF TIME A PARTITION OF THE UNLOAD TABLE SPACE IS UNAVAILABLE TO OTHER PROGRAMS
PI42497
29_Jun
2015
UI28952


HPU SHOULD CREATE LOAD STATEMENT NAME CONSISTENTLY WITH UNLOAD PLUS SYNTAX
PI42498
29_Jun
2015
UI28952


THE LOCK YES OPTION IS IGNORED WHEN THE UNLOAD IS PROCESSED IN SQL MODE.
PI41559
29_May
2015
UI28086


UNEXPECTED TABLE NAME SPECIFIED IN HPU GENERATED LOAD STATEMENT USING UNLOAD PLUS SYNTAX
PI41560
29_May
2015
UI28086


MSGINZU097E SYNTAX ERROR - UNRECOGNIZED ELEMENT WITH FOR UNLOADBLOCK.
PI41562
29_May
2015
UI28086


MSGINZU097E SYNTAX ERROR - UNRECOGNIZED ELEMENT RTRIM FOR UNLOAD BLOCK
PI40661
21_May
2015
UI27861


APAR FOR ROLL UP PTF OF CODE FIXES AFTER CODE FREEZE

Top of page