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.2
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PI80358
29_Jun
2017
UI48427


NON-DELIMITED SQL KEYWORDS NOT SUPPORTED AS COLUMN NAME IN DDLDDN FILE.
PI75402
5_Apr
2017
UI46200


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


UNLOAD FAILS WITH ABENDU1022 R15=0 WHEN THE TABLE SPACE VSAM DATA SET CONTAINS RECORDS W/ VERSION 0
PI73002
10_Jan
2017
UI43798
PI74438

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

UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN SQL MODE
PI72828
21_Dec
2016
UI43510
PI74438

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

UNEXPECTED MSGS INZT028E, INZU469E, INZU283E, INZC003E COULD BE ISSUED WHEN TEMPLATE IS USED.
PI71885
23_Nov
2016
UI42866


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

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

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

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

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

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

UNEXPECTED MSGINZU020E AND RC08 WHEN UNLOADING FROM SYSTABLES.
PI60031
5_Oct
2016
UI41421


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


HPU WITH UNLOAD PLUS SYNTAX SPECIFYING INFILE DDNAME INCREMENTAL
PI62205
8_Aug
2016
UI39949
PI76892

UNEXPECTED INZI181E WHEN USING SQLPART OPTION.
PI64634
1_Jul
2016
UI39125


ABENDS0C4 OR INZU499E
PI61522
1_Jul
2016
UI39125


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


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


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


ABEND0C4
PI57122
18_May
2016
UI37984


UNEXPECTED INZU016E STATEMENT SYNTAX IS INVALID
PI57958
18_May
2016
UI37984


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


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


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


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


INZU283E ERROR IN TEMPLATE LIBRARY DDNAME
PI55738
29_Feb
2016
UI35745


A PHYSICAL UNLOAD (UNLDDN) IN INTERNAL FORMAT (INTERNAL_FORMAT) PRODUCES INCORRECT OUTPUT DATA THAT CANNOT BE LOADED BY DB2
LOAD
PI52402
7_Jan
2016
UI34287


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


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


ABENDS0C4 OR OTHER UNPREDICTABLE RESULT UNLOADING FROM FLASHCOPYOF TABLE SPACE OR PARTITION IN BRF (BASIC ROW FORMAT).
PI47438
23_Oct
2015
UI32342


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


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


UNLOAD WITH UNLOAD PLUS SYNTAX REQUESTING BIGINT DATA
PI46786
23_Oct
2015
UI32342


THE PARAMETER "USER WHO RUNS THE DISPLAY COMMAND (VUM028/DISPLUSR)" IS NOT TAKEN INTO ACCOUNT BY THE ISPF
PI46788
23_Oct
2015
UI32342


THE ISPF INTERFACE OF DB2 HPU ISSUES MESSAGE WITH AN UDB PREFIX INSTEAD OF THE INZ ONE.
PI47724
8_Oct
2015
UI31879


CONFUSING MSGINZU063I UNSUPPORTED SELECT UNLOADING TABLE WITH SYSIBM.SYSTABLES COLUMN TYPE NOT T, C, M OR V
PI45640
21_Sep
2015
UI31322


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


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


QUIESCE YES/NO NOT ACCEPTED IN SYSIN IN UNLOAD PLUS SYNTAX
PI38442
22_Jul
2015
UI29639


LIMIT OPTION FOR TEMPLATE IS IGNORED
PI42736
22_Jul
2015
UI29639


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


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


INCORRECT LOAD STATEMENT CREATED CONTAINING SAME NUMBER OF LOAD COMMANDS AS TABLES INVOLVED
PI45202
22_Jul
2015
UI29639


ABEND S0C4
PI41195
29_Jun
2015
UI28951


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


ABENDS0C4 OR AND ABENDU4093
PI42584
29_Jun
2015
UI28951


DISCOVER MORE PARAMETERS WHEN UPGRADING FROM AN HPU V4.2 VERSION
PI39147
5_May
2015
UI27358


HPU FAST UNLOAD OUTPUT LRECL BIGGER THAN ACTUAL RECORD LENGTH
PI39734
5_May
2015
UI27358


ABENDS0C1 OR ABENDU4083
PI39736
5_May
2015
UI27358


ABENDU1136 U1136
PI29858
23_Apr
2015
UI27012


ULCNVTRC DEFAULTS TO NO INSTEAD OF YES, WHICH RESULTED IN MSGINZR3001
PI38262
23_Apr
2015
UI27012


HPU BEHAVES AS IF ULUNIEXP WAS SET TO 100
PI38263
23_Apr
2015
UI27012


ABENDS0C1 OR ABENDS0C4 WITH SPANNED FORMAT AND PARALELISM
PI34282
9_Mar
2015
UI25728

HIPER

A DB2 HPU JOB DOES NOT UNLOAD ALL EXPECTED ROWS.
PI34825
9_Mar
2015
UI25729


INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X109A02A)
PI33340
20_Feb
2015
UI25353


DB2 HPU GENERATES A LOAD STATEMENT (LOADDDN) WITH AN IN INCORRECT OR EVEN INVALID NEGATIVE VALUE FOR SORTKEYS.
PI32840
20_Feb
2015
UI25353


MSGINZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B) WHEN DDL CONTAINS BOTH MAXPARTITIONS AND NUMPARTS.
PI32472
5_Feb
2015
UI24991


ABENDU1004 MSGIKJ56228I AND MISLEADING ERROR MESSAGE INZU015E
PI30581
21_Jan
2015
UI24555
PI41195

ABENDS0C4 REASON 11 AND ABENDU1017
PI30345
21_Jan
2015
UI24555
PI41195

AN UNLOAD FAILS WITH AN ABENDU1009 AND A MESSAGE CNK046E SORT CAPACITY EXCEEDED IS ISSUED.
PI32717
21_Jan
2015
UI24558


INZRE45 IMAGE COPY FROM DD COPYDD CONTAINS NO ROW WITH SPECIFIEDOBID(S), SCAN ABORTED AND DBCS VIEW
PI32227
21_Jan
2015
UI24555
PI41195

ABENDS0C4 IF A LOGICAL UNLOAD (SELECT .... OUTDDN) UNLOAD SPECIFIES AN ORDER CLAUSE
PI32089
21_Jan
2015
UI24558


LOOP, USES CPU-TIME WITHOUT COMPLETING 15/01/05 PTF
PECHANGE
PI32228
21_Jan
2015
UI24555
PI41195

ABENDX37 WHEN A LOGICAL UNLOAD (SELECT .... OUTDDN) WITH AN ORDER CLAUSE
PI32470
21_Jan
2015
UI24558


INZU080E OR INZU063I UNSUPPORTED SELECT WITH DBCS
PI30214
4_Dec
2014
UI23627


HPU V4.2 ABEND IN INZSTI00 - CODE=S0C4
PI29160
4_Dec
2014
UI23627


AN UNLOAD FAILS WITH ABENDU1005 WITH MESSAGE IKJ56246I DATA SET DATA.SET.OF.AN.INDEX.SPACE NOT ALLOCATED, FILE IN USE.
PI30571
4_Dec
2014
UI23627


UNLOAD USING UNNECESSARY STORAGE SPACE WITH DB2 SORT
PI28098
19_Nov
2014
UI23202


INZZ001S(0001): ABEND IN INZUTILK - CODE=S000 U1137 REASON=00000005 CNK052I END DB2 SORT FOR Z/OS
PI28544
19_Nov
2014
UI23202


UNEXPECTED INZU080E OR INZU063I RUNNING ON DB2 LOWER THAN V10 NFM
PI26202
19_Nov
2014
UI23202


TIOT SATURATION AND MESSAGES SUCH AS THE INZI330E DYNAMIC ALLOCATION FAILED
PI27191
19_Nov
2014
UI23202


INZI340E MISSING MODELDCB OR DATACLAS IN DEFINITON OF TEMPLATE=TEMPLATE
PI27721
19_Nov
2014
UI23202


INZI330E DYNAMIC ALLOCATION FAILED
PI29233
19_Nov
2014
UI23202


ABENDU1010 UNLOADING AN INLINE IMAGE COPY
PI13578
20_Oct
2014
UI22322


IKJ56228I INZU127W
PI26916
20_Oct
2014
UI22322


INZU080E ERROR : SELECT FROM VIEW IS NOT SUPPORTED BY THE UTILITY FOR COLUMN NAMES WITH DBCS
PI24280
9_Oct
2014
UI22107


UNLOAD FROM FULL IMAGE COPY IN INTERNAL FORMAT IS NOT VALID WHENTHE DATA IS IN RRF FORMAT. DB2 LOAD ABENDS S04E
REASON=00C90101.
PI24711
22_Sep
2014
UI21522


ABENDU1134 REASON 9 OR ABENDU1134 REASON 5
PI24463
22_Sep
2014
UI21522


UNLOAD FAILS WITH ABEND U1004 AND MESSAGE IKJ56228I DATA SET ...NOT IN CATALOG OR CATALOG ......
PI21191
4_Sep
2014
UI21116


ABENDU1136-RSN21 UNLOADING DATA FROM AN XML COLUMN, IN DB2 11 NFM
PI22291
4_Sep
2014
UI21116


CONVERSION ROUTINE ERROR MESSAGE (* 226 *) ISSUED IF TRIM YES OPTIONS REQUESTED AND LOGICAL UNLOAD IS PROCESSED IN SQL
MODE.
PI24564
4_Sep
2014
UI21116


LOB FILES UNLOADED FOR AN XML COLUMN FROM A TABLE STORED IN AN UNIVERSAL TABLE SPACE (UTS) ARE EMPTY.
PI19715
2_Jul
2014
UI19316


PROVIDE THE UNLOAD PLUS NULLSTRING COMPATIBILITY
PI18883
23_Jun
2014
UI19067


INZU020E DSNT408I SQLCODE = -551 USERID DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT
SYSIBM.SYSKEYS
PI19276
23_Jun
2014
UI19067


MSGINZZ001S (0001): ABEND S04E U0000 REASON=00E7000C R2=18 WHEN REFORMATTING THE CLOB, BLOB, AND XML DATA TO
VARCHAR(100)
PI18220
23_Jun
2014
UI19067


MESSAGES IEC130I ICNN DD STATEMENT MISSING ARE ISSUED WHEN ULOPTNS SPECIFIES ONDEMAND_RESOURCE_ALLOCATION(YES)
PI18157
13_Jun
2014
UI18808


SUPPORT 'SELECT COL1, COL1, COL1, COL1, * FROM .....'
PI18312
13_Jun
2014
UI18808


IGNORE THE ACTIVE OPTION IN UNLOAD PLUS SYNTAX
PI17454
16_May
2014
UI18060


ABEND 0C7 UNLOADING FROM IMAGE COPY (COPYDDN) OF COMPRESSED TABLESPACE
PI13474
5_May
2014
UI17675


ABENDS0C1 IN LOGICAL UNLOAD WITH COALESCE SCALAR FUNCTION AND USER FORMAT IS REQUESTED
PI13705
5_May
2014
UI17675


ALLOW USER TO SPECIFY ZERO FOR BLOCK SIZE ON INZB61 OR INZA40 PANEL
PI15047
5_May
2014
UI17675


ABEND IN INZSTI00 - CODE=S0C4 U0000 REASON=00000011 14/04/02 PTF
PECHANGE
PI15763
5_May
2014
UI17675


HPU ISPF INTERFACE DOES NOT ALLOW "BLOCK SIZE" BLANK WHEN RECFM FB OR VB SPECIFIED
PI13696
26_Mar
2014
UI16432


SQLCODE303 AFTER FALLBACK FROM DB2 10 CM TO V9 NFM
PI13047
26_Mar
2014
UI16432


S0C4-04
PI13700
26_Mar
2014
UI16432


USER ABEND OCCURS WHEN ATTEMPTING TO UNLOAD LOB DATA IN NATIVE MODE
PI12791
11_Mar
2014
UI15901


HPU WILL PROVIDE A WAY TO AVOID LEADING BLANK FOR POSITIVE NUMERICAL VALUES IN EXTERNAL FORMAT
PI11178
5_Mar
2014
UI15728


ABENDU1003 ABENDU1017 UNLOADING DATA FROM AN IMAGE COPY OF A PARTITION-BY-GROWTH ( PBG )
PI07921
5_Mar
2014
UI15724


UNLOAD LOB DATA IN SPANNED FORMAT
PI08596
5_Mar
2014
UI15726
PI32089

UNLOAD SUCCESSFUL EVEN THOUGH USER DOES NOT HAVE THE SELECT PRIVILEGE ON THE TABLE TO BE UNLOADED
PI12090
5_Mar
2014
UI15728


ABENDS0C4 UNLOADING DATA FROM IMAGE COPY OF A PARTITIONED-BY-GROWTH TABLESPACE
PI08648
5_Mar
2014
UI15726
PI32089

INZU080E SELECT FROM VIEW NOT SUPORTED BECAUSE OF UNDESIRABLE EXTRANEOUS INFORMATION IN THE TEXT OF A VIEW TO BE UNLOADED
PI11290
5_Mar
2014
UI15724


ABENDSX37 ON DATASET ALLOCATED VIA TEMPLATE STATEMENT
PI09250
7_Feb
2014
UI14932


MSGINZRE40 OR MSGINZRE42
PI09143
7_Feb
2014
UI14932


ABENDU1022 UNLOADING DATA FROM LDS OR IMAGE COPY WHICH RECORDS HAVE MORE THAN 7 DISTINCT VERSIONS
PI10847
7_Feb
2014
UI14932


ABENDU1003
PI07913
28_Jan
2014
UI14569
PI15047

ABENDS878 S878 878
PI07915
28_Jan
2014
UI14569
PI15047

THE NULLIF CLAUSE IN THE LOAD STATEMENT SPECIFIES AN INCORRECT VALUE WHERE THE EXPECTED X'00' IS REPLACED BY X'0'
PI07919
28_Jan
2014
UI14569
PI15047

ALLOW FOR ONE ROW PER ULOPTNS SUBPARAMETER
PI07914
28_Jan
2014
UI14569
PI15047

INZU168E INZU366I
PI07916
28_Jan
2014
UI14569
PI15047

UNLOADED RECORDS IN FORMAT VARIABLE TRUNCATED
PI09071
28_Jan
2014
UI14569
PI15047

HPU SUPPORTS UNLOAD PLUS FORMAT XML FEATURE CAPABILITIES
PI09874
28_Jan
2014
UI14569
PI15047

LOAD OF HPU UNLOADED TABLE IN INTERNAL FORMAT FAILS
PI07341
28_Jan
2014
UI14569
PI15047

ACCEPT INPUT PARM STRING FROM AN INPUT FILE
PI09462
28_Jan
2014
UI14569
PI15047

ABENDS0C4 AFTER APAR PM99251 14/01/15 PTF
PECHANGE
PI07692
28_Jan
2014
UI14569
PI15047

PERFORMANCE IMPROVEMENT OF THE NATIVE MODE PROCESSING OF DATA FROM TABLE SPACES IN DB2 RRF FORMAT.
PI07343
28_Jan
2014
UI14569
PI15047

SUPPORT TWO BYTE NULL SYSTEM DEFAULT
PI08644
28_Jan
2014
UI14569
PI15047

SINZCLST INZHPU ABENDS047 13/12/24 PTF
PECHANGE
PM99251
27_Nov
2013
UI13028
PI09462

INCONSISTENT OR UNEXPECTED DATE OR TIME EXTERNAL DATA ABENDS0C7
PM98396
30_Oct
2013
UI11933


&SSID TEMPLATE VARIABLE NOT SUBSTITUTED WITH EXPECTED GROUP ATTACH NAME
PM98746
30_Oct
2013
UI11933


THE UNLOAD FROM AN IMAGE COPY (COPYDDN OPTION) FAILS AFTER MSGINZRE41 HAS BEEN ISSUED 14/04/09 PTF
PECHANGE
PM97239
21_Oct
2013
UK98655


ALTHOUGH THE CORRECT IC IS USED, HPU IS ISSUING A MESSAGE INDICATING THE WRONG VERSION NUMBER
PM96960
21_Oct
2013
UK98655


INZU395E THE IMAGE COPY CANNOT BE USED FOR THE TABLE SPACE
PM96959
21_Oct
2013
UK98655


INCORRECT PADDING WHEN EVALUATING AN SQL EXPRESSION LIKE CHAR(VARCHAR_CONSTANT_EXPRESSION)
PM97735
21_Oct
2013
UK98655


ABENDU1003 UNLOADING DATA INTO OUTPUT DATA SETS ALLOCATED ON TAPE VIA A TEMPLATE REQUESTING VOLCNT GREATER THAN 127
PM98002
21_Oct
2013
UK98655


VARCHAR DATA CONSTANT CONVERTED INTO A CHAR DATA TYPE COLUMN LENGTH IS LESS THAN THE LENGTH ATTRIBUTE OF SOURCE DATA
PM98000
21_Oct
2013
UK98655


MSGINZU016E UNDULY ISSUED WHEN ONE OF THE TARGET TABLE COLUMN OF A LOGICAL UNLOAD IS NAMED GETVARIABLE
PM94708
3_Oct
2013
UK98178


INZPLIB0 DADSM OBTAIN MACRO FAILURE WHEN LIBRARIES ARE STORED ON AN EAV VOLUME WITH THE EXTENDED ATTRIBUTE
PM96542
3_Oct
2013
UK98178


INZU215E LOAD STATEMENT ERROR, BIGINT AND EXTERNAL FORMAT
PM91909
25_Sep
2013
UK97909
PI08644

DB2 V11 EXPLOITATION
PM91907
25_Sep
2013
UK97909
PI08644

SORTIN AND DB2 SORT: NATIVE I/O IS SUPPORTED TO ALLOW DB2 SORT TO READ SORTIN AND WRITE SORTOUT
PM95394
11_Sep
2013
UK97442


DOING AN UNLOAD USING SELECT WITH 'IN' CLAUSE RESULTS IN ZERO ROWS RETURNED
PM96330
11_Sep
2013
UK97442


A LOGICAL UNLOAD RUN IN NATIVE MODE IN WHICH THE SQL STATEMENT INVOLVES THE TIMESTAMP() SCALAR FUNCTION GIVES INCORRECT
RESULT
PM94583
5_Sep
2013
UK97322


HPU MAY HANG WHEN DB2SORT IS USED
PM94286
22_Aug
2013
UK96944


MSGINZI503E DDL ANALYSING: SYNTAX ERROR AT POS(X, Y)
PM87823
22_Aug
2013
UK96944


UNLOAD FROM AN IMAGE COPY WITH A DDL FILE INCLUDING A COLUMN WITH DEFAULT SESSION_USER CLAUSE CAN LEAD TO VARIOUS ERRORS
PM87914
22_Aug
2013
UK96944


MSGINZI503E RC08 UNLOAD FROM AN IMAGE COPY WITH DDLDDN ON A PARTITIONING INDEX
PM88425
12_Aug
2013
UK96617


ABENDS0C1 RSN CODE 1 DB2 SUBSYSTEM SETTING DATE=LOCAL AND/OR TIME=LOCAL
PM88474
12_Aug
2013
UK96617


INZU147E ERROR : DUPLICATE COLUMN XXX IN ORDER BY CLAUSE
PM89257
12_Aug
2013
UK96617


ABENDS0C4 RSN CDE 4 IF TRACE FILE (DDNAME STARTS WITH $)
PM92997
6_Aug
2013
UK96461


SELECT & OUTDDN INCORRECT OUTPUT IF SQLPART OR PART IS SPECIFIED
PM92665
6_Aug
2013
UK96461


SET RC=00 FOR MSGINZU103W
PM93270
6_Aug
2013
UK96461


ACCESS DSNHDECP FOR DB2 SETTINGS AS IN PRIOR RELEASES
PM86359
19_Jul
2013
UK96019


UNLOAD FROM IMAGE COPY ABENDU1210
PM86940
19_Jul
2013
UK96019


UNLOAD PLUS INFILE IMAGECOPY -N GENERATES INCORRECT FIC
PM87122
19_Jul
2013
UK96019


ABENDU1017 AND SORT CAPACITY EXCEEDED
PM83273
19_Jul
2013
UK96019


INZU395E INCORRECTLY ISSUED OR UNLOAD COMPLETES NO ERROR BUT DOES NOT UNLOAD DATA FROM RECENTLY ADDED PARTITION(S)
PM87309
19_Jul
2013
UK96019


REVISE LOWMEM RECOMMENDATION WHEN SYNCSORT IS USED
PM87401
19_Jul
2013
UK96019


UNLOAD INLINE IMAGECOPY FOR A PARTITIONED TS UNLOADS DATA FROM GLOBAL IMAGE COPY
PM88423
19_Jul
2013
UK96019


INCORRECT OUTPUT GENERATED INVOLVING TABLE WITH COLUMN DEFINED WITH FIELDPROC CLAUSE
PM89904
25_Jun
2013
UK95405
PM98746

ABENDU1022
PM85601
25_Jun
2013
UK95405
PM98746

ABENDU1021 WITH R15 = 2 OCCURS WHILE UNLOADING DATA FROM AN IMAGE COPY (COPYDDN OPTION)
PM86790
25_Jun
2013
UK95405
PM98746

SQLCODE199 UNLOAD FROM VIEW
PM80732
7_May
2013
UK94107


INZU168E UNLOADING TIMESTAMP WITH TIME ZONE COLUMN DEFINED WITH A WITH DEFAULT CLAUSE
PM81245
7_May
2013
UK94107


INZUTILB ENDS SQL CODE -607 TRYING TO OBTAIN A SHARED LOCK ON TABLE SYSIBM.SYSDATABASE
PM81808
7_May
2013
UK94107


MSGINZU215E LOAD STATEMENT ERROR : INVALID CONVERSION FOR COLUMNBIGINT_COLUMN_NAME
PM81854
7_May
2013
UK94107


SQL STATEMENT WHERE CLAUSE WITH ONE OF ITS PREDICATES USING AN EXPRESSION SUCH AS TIMESTAMP(CHAR_COLUMN) ISSUES INZU063I
PM80929
7_May
2013
UK94107


THE DFSIGDCB OPTION SPECIFIED IN THE GLOBAL BLOCK IS IGNORED
PM81851
7_May
2013
UK94107


HPU NATIVE MODE SQL EXPRESSION DATE(CHAR_DATA) WHERE CHAR_DATA IS A NON CONSTANT CHAR TYPE DATA IS INCORRECTLY EVALUATED
PM87316
7_May
2013
UK94107


INCORRECT TIMESTAMP(CHAR_COLUMN) FOR LOGICAL UNLOAD
PM87397
7_May
2013
UK94107


MSGINZU168E ERROR WHEN READING DEFAULT VALUE IN CATALOG FOR COLUMN
PM88029
7_May
2013
UK94107


U1003 WITH COPYDDN FORMAT INTERNAL PARTITIONED
PM78293
7_May
2013
UK94107


CLARIFY INSTRUCTIONS IN HLQ.SINZCLST(INZADBI) TO INTEGRATE DB2 HPU INTO DB2 TOOLS LAUNCHPAD
PM85014
26_Apr
2013
UK93841


UNLOAD FAILS WITH CC 8 AFTER ISSUING INZI187E WITH RETURN CODE 8 REASON CODE 00E60820 WITH SUBSEQUENT INZI180E ERROR MESSAGE
PM84164
10_Apr
2013
UK93299


A NON SUPPORTED STATEMENT OR A STATEMENT PASSED TO DB2 USING DB2FORCE IS REJECTED WITH EITHER SQLCODE = -311 OR SQLCODE =
-010
PM76846
10_Apr
2013
UK93295


IKJ56221I VOLUME IS ALLOCATED TO ANOTHER JOB OR USER, TRY LATERINZI330E DYNAMIC ALLOCATION FAILED
PM78393
27_Mar
2013
UK92935


HPU UNLOAD FAILS WITH MSG CNK046E SORT CAPACITY EXCEEDED
PM78394
27_Mar
2013
UK92935


POOR PERFORMANCE OR FAILURE UNLOADING PARTITIONED TABLESPACE WITH ORDER CLAUSE INTO SINGLE OUTPUT DATASET
PM79432
27_Mar
2013
UK92935


PROVIDE CAPABILITY TO SET THE CURRENT SQLID SPECIAL REGISTER FORUNLOAD STATEMENTS PROCESSED IN SQL MODE.
PM79796
27_Mar
2013
UK92935


INZU024E COLUMN CCCC IS NOT PART OF THE TABLE OR INCORRECT DATA UNLOADED AND WRONG SEQUENCE NUMBERS IN GENERATED LOAD CONTROL
PM79799
27_Mar
2013
UK92935


DB2 HPU GENERATES INVALID A LOAD CONTROL STATEMENT FOR TEMPORAL TABLE.
PM76523
27_Mar
2013
UK92935


UNLOADED XML COLUMN CAN NOT BE LOADED WITH HPU GENERATED LOAD STATEMENT
PM78633
27_Mar
2013
UK92935


SOME CHARACTERS ARE REPLACED BY THE REPLACEMENT CHARACTER IN UNLOAD
PM80007
27_Mar
2013
UK92935


UDBX036 INDEX-SPACE INDEX PARTITION N PAGESET IS INVALID AND THEREPORT MENTIONS INDEX SCAN FEATURE WAS DISABLED IXSC = 0%).
PM80008
27_Mar
2013
UK92935


RECORDS PADDED WITH X'00' INSTEAD OF BLANKS WHEN UNLOADING WITH FASTUNLOAD SYNTAX AND SPECIFYING THE LRECL-USER YES
PM80782
27_Mar
2013
UK92935


ABENDU1132 REASON CODE 10 WITH RACF ERROR OCCURS WHEN DB2 HPU ATTEMPTS TO READ AN AUXILIARY TABLE SPACE REFERING TO LOB
COLUMN
PM82839
27_Mar
2013
UK92935


INCORRECT MSGINZI020I ISSUED BY HPU OR OTHER ERRORS CAUSED BY WRONG DATASHARING DETERMINATION.
PM84455
27_Mar
2013
UK92935


INZI020I INCORRECTLY DISPLAYS THE DB2 VERSION WHEN HPU IS RUN AGAINST A DB2 V11 SUBSYSTEM
PM80248
27_Mar
2013
UK92935


ADD EXAMPLE SYNTAX FOR MORE COMPLEX TOOLS CUSTOMIZER HPU FIELDS
PM78638
20_Feb
2013
UK91849


ADD TCZ AND DB2 TOLERATION SUPPORT
PM77484
15_Jan
2013
UK90946


REJECT UNSUPPORTED UNLOADING OF XML DATA IN NATIVE MODE
PM73273
4_Jan
2013
UK90738


MSGINZI010E INTERNAL CONVERSION ERROR BETWEEN CCSID 37 AND CCSIDCCSID
PM73845
4_Jan
2013
UK90738


ICE046A SORT CAPACITY EXCEEDED DUE TO VERY SMALL ESTIMATED FILE SIZE 1000
PM77347
4_Jan
2013
UK90738


ABENDU1010 WHEN UNLOADING A SUBSET OF PARTITIONS FOR A TABLE WITH A CLONE TABLE
PM78055
4_Jan
2013
UK90738


THE UNLOAD FAILS ISSUING SQLCODE -104
PM69749
18_Dec
2012
UK90488


CCSID CONVERSIONS THAT REQUIRE LENGTH CHANGES ARE NOT SUPPORTED MAY CAUSE DATA TRUNCATION
PM72025
18_Dec
2012
UK90488


LOGICAL UNLOAD FAILS WITH INZU238E UNEXPECTED UNSUPPORTED SELECTUTILITY CANNOT SWITCH TO SQL PROCESSING INZU366I RETURN CODE
8
PM74166
18_Dec
2012
UK90488


UNLOAD FAILS WITH ABEND U1136 AND REASON CODE 2C WHEN A MULTI-LDS XML TABLE SPACE IS INVOLVED
PM78828
18_Dec
2012
UK90488


INZX036 INDEX-NAME INDEX PARTITION PARTITION-NUMBER PAGESET IS INVALID
PM75786
18_Dec
2012
UK90488


IN DATASHARING ENVIRONMENT DB2 VERSION DISPLAYED BY INZI020I WILL NOW BE IN FORM 910 OR 1010 INSTEAD OF 910 NFM OR 1010
NFM
PM78115
18_Dec
2012
UK90488


AN UNLOAD REQUESTING XML DATA BE UNLOADED FAILS WITH ABENDU1134 REASON CODE B.
PM78124
18_Dec
2012
UK90488


MSGUDBU183E ERROR : UNABLE TO QUIESCE DB2 CATALOG
PM76761
19_Nov
2012
UK92935


DB2 HPU GENERATES INVALID A LOAD CONTROL STATEMENT FOR TEMPORAL TABLE. RFE 28675 CREATED FOR THIS ISSUE
PM76525
6_Nov
2012
UK83274


SUPPORT TO UNLOAD TABLESPACE AND IT'S LOB AND XML DEPENDENCIES FROM SET OF CONSISTENT FLASHCOPIES
PM72613
6_Nov
2012
UK83274


INZU063I INCORRECTLY ISSUED FOR DATA(VARCHAR_EXPRESSION)
PM69738
16_Oct
2012
UK82662


INZI330E DYNAMIC ALLOCATION FAILED.
PM70042
16_Oct
2012
UK82662


PARTITION LEVEL PARALLELISM NOT USED DESPITE THE PARALLELISM (N,....) OPTION IS SPECIFIED IN THE GLOBAL BLOCK
PM70048
16_Oct
2012
UK82662


ABENDU1132 REASON CODE 10 WITH RACF ERROR OCCURS WHEN DB2 HPU ATTEMPTS TO READ AN AUXILIARY TABLE SPACE REFERING TO XML
COLUMN
PM71451
16_Oct
2012
UK82662


INCORRECT NUMBER OF UNLOADED ROWS FOR UNLOADS REQUESTING THE DATA OF SAME PARTITIONS BE UNLOADED.
PM71454
16_Oct
2012
UK82662


ABENDS0C4 WHEN OUTPUT DATA SET WRITTEN ON TAPE.
PM74165
16_Oct
2012
UK82668


ADD $PAGE DIAGNOSTIC TRACE TO HPU
PM70529
16_Oct
2012
UK82662


ABENDU1136 REASON 2B OCCURS WHILE UNLOADING XML DATA IF A PAGE OF THE XML INDEX WITH A NUMBER GREATER THAN 1000 IS INVOLVED
PM71037
16_Oct
2012
UK82662


ABENDU1021 WITH R15=0 IN HPU
PM71450
16_Oct
2012
UK82662


AFTER PM67778 MSG IMAGE COPY DATASET NOT ALLOCATED AND IMZU281I INZ277I ISSUED TWICE
PM71455
16_Oct
2012
UK82662


HOUR MINUTE VALUES IN ERROR IN MSGS INZX089 INZX090
PM72012
6_Sep
2012
UK81569


HPU INCORRECT SECONDARY EXTENT ALLOCATIONS WHEN MAXPRIME SPECIFIED
PM72017
6_Sep
2012
UK81569


INCORRECT NUMBER OF ROWS RETURNED
PM72013
6_Sep
2012
UK81569


WRONG VOLUMES LISTED ON SUMMARY REPORT
PM72015
6_Sep
2012
UK81569


CODE=S000 U1208 REASON=0000000
PM72016
6_Sep
2012
UK81569


INCORRECT OUTPUT OR FAILURE UNLOADING LOB, XML OR ORDER BY WITH INDEXSCAN METHOD
PM72018
6_Sep
2012
UK81569


CORRECT REPORTED ELAPSED TIME ON MSGINZX090
PM72022
6_Sep
2012
UK81569


INZU238E UNEXPECTED UNSUPPORTED SELECT MESSAGE INCORRECTLY ISSUED
PM72153
6_Sep
2012
UK81569


DB2 HPU INCORRECTLY DETERMINES THE DB2 VERSION LEADING TO SQLCODE204 AND OTHER ERRORS

Top of page