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: 8 January 2018
DB2 High Performance Unload for z/OS Version 3.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PM34446
29_Apr
2011
UK67264


HPU UNLOAD STOPS COMPLETES WITH CC 8 AND ISSUES INZI174E AFTER INSTALLING DB2 APAR PM23243.
PM35510
29_Apr
2011
UK67264


HPU UNLOADS FROM LOCAL TABLE EVEN THOUGH FROM CLAUSE SPECIFIES THREE PART NAME
PM33987
11_Apr
2011
UK66637


UNLOAD SPECIFYING DDLDDN & IMAGE COPY DOESN'T UNLOAD ALL RECORDS
PM34425
11_Apr
2011
UK66637


HPU FOR Z/OS ABENDU1005 WITH R15=0X2C DURING UNLOAD OF PARTITIONED TABLESPACE WITH PARELLELISM
PM34875
11_Apr
2011
UK66637


ABEND 0C4 OCCURS WHILE UNLOADING THE DATA FROM THE IMAGE COPY OFA PARTITION-BY-GROWTH
PM23952
28_Feb
2011
UK65290


VARIOUS FAILURES AFTER THE APPLY OF DB2 PTFS UK56261 OR UK56262.
PM31895
28_Feb
2011
UK65290


UNLOAD RC8 SELECT DISTINCT * SYNTAX ERROR INZU016E OR INZU096E
PM29346
16_Feb
2011
UK64904


UNLOAD GENERATES ABEND878 RC10
PM31001
16_Feb
2011
UK64904


DB2 HPU FOR Z/OS FAILS WITH ABENDU1113 UNLOADING TABLE WITH VARCHAR COLUMN WITH FIELDPROC
PM30244
28_Jan
2011
UK64361


LOGICAL UNLOAD GENERATES MESSAGES INZU025E AND INZU063I
PM16848
28_Dec
2010
UK63535


INCORRECT OUTPUT USING FASTUNLOAD SYNTAX.
PM26761
28_Dec
2010
UK63535


LOGICAL UNLOAD GENERATES MESSAGES INZU025E AND INZU063I
PM27285
28_Dec
2010
UK63535


DB2 HPU FOR Z/OS FASTUNLOAD COMPATIBILITY PROBLEM
PM24566
18_Nov
2010
UK62315


INZU063I UNSUPPORTED SELECT USING A WITH COMMOM-TABLE-EXPRESSION
PM24699
18_Nov
2010
UK62315


VARIOUS DB2 HPU FOR Z/OS ABENDS LIKE 0C1 OR 0C7
PM23412
10_Nov
2010
UK62055


ABEND0C7 UNLOAD INZUTILK
PM23419
10_Nov
2010
UK62055


DB2 FOR Z/OS HPU ABENDU1021 WITH R15=0
PM21044
19_Oct
2010
UK61474


DB2 HPU ISSUES INZI187E ERRONEOUSLY IN DATA SHARING ENVIRONMENT
PM15452
1_Sep
2010
UK60174


DSNT404I SQLCODE = 098, WARNING: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON
PM17520
1_Sep
2010
UK60174


UNLOAD GENERATING MSG INZU035E
PM11310
23_Aug
2010
UK59919


INZU031E DUE TO DUPLICATE FORMAT STATEMENT
PM17930
23_Aug
2010
UK59919


INCORRECT OUTPUT WHEN UNLOADING UNLOAD INTEGER OR DECIMAL DATA.
PM14372
16_Jul
2010
UK58894


AN ABEND0C1, ABENDU1010, OR AN INCORRECT RESULT CAN OCCUR WHEN SEVERAL SELECT ARE PROCESSED BY DB2
PM15064
16_Jul
2010
UK58894


AN S0C4 ABEND MAY OCCUR WHILE UNLOADING FROM AN INLINE IMAGE COPY.
PM16782
16_Jul
2010
UK58894


ABENDU1134-0A WITH BAD REG2.
PM16670
16_Jul
2010
UK58894


ABENDU1022 OR INCORROUT ON UNLOAD FIC
PM11773
18_Jun
2010
UK58095


HPU FAILS WITH INZUT4-2 UNLOADING A PARTITIONED TABLE SPACE
PM12601
18_Jun
2010
UK58095


UNLOAD IMAGE COPY GENERATES MSG FIELD OVERLAP END OF RECORD OR S0C7 OR S0C4
PM12576
18_Jun
2010
UK58095


MESSAGE INZU238E AND INZU366I RC08 FOR SELECT STATEMENT
PM13753
18_Jun
2010
UK58095


S0C4 WITH LISTDEF AND INCORRECT LOAD STMT SPECIFYING DELIMTED FORMAT
PM13741
18_Jun
2010
UK58095


ABEND0C4 MAY OCCUR WHEN SPECIFYING PROCESS_OPTIONS OFF
PM11040
13_May
2010
UK56941


CHANGE THE CONTENT OF INZIVP BY ADDING THE ASIS OPTION.
PM11338
13_May
2010
UK56941


ABEND0C4 WITH INZU063I
PM11330
13_May
2010
UK56941


ABENDU1208 WITH MESSAGE IKJ56228I
PM11505
13_May
2010
UK56941


INCORRECT OUTPUT CONVERTING A NUMERIC COLUMN INTO A CHAR(30)
PM02601
22_Apr
2010
UK56337


RUNNING A JOB WITH FASTUNLOAD SYNTAX GENERATES ERROR MESSAGE INZU238E
PM04338
22_Apr
2010
UK56337


INCORRECT RESULT WHEN USING BMC SYNTAX WITH FORMAT CSV
PM04546
22_Apr
2010
UK56337


ABENDU1132 REASON CODE = 00000008
PM06961
22_Apr
2010
UK56337


ADD NEW INZTVAR PARM VUM032/ACTGUSR
PM08077
22_Apr
2010
UK56337


HPU DOES NOT ACCEPT A WHERE CLAUSE THAT CONTAINS QUANTIFIED PREDICATES.
PM11110
22_Apr
2010
UK56337


UNLOAD WITH PIC GENERATES INCORRECT OUTPUT DATA
PK86027
3_Mar
2010
UK54861


ABENDU1210 AFTER SYNTAX ERROR
PK93732
3_Mar
2010
UK54861


INZU016E OUTDDN STATEMENT SYNTAX IS INVALID
PM02518
3_Mar
2010
UK54861


MESSAGE INZT035E WITH UNSUPPORTED SELECT STATEMENT.
PM04313
24_Feb
2010
UK54647


DSNT408I SQLCODE = -551, ERROR: USER IS LACKING PRIVILEGES FOR SELECT ON OBJECTS WITH SYSIBM.SYSKEYS
PM04752
24_Feb
2010
UK54647

HIPER

ABENDU1004 WHEN USING DEFINE NO. 10/02/11 PTF
PECHANGE
PK96998
5_Feb
2010
UK54185


UNLOAD PARALLELISM ABEND 878 RC10
PM02620
5_Feb
2010
UK54185


HPU IS RUNNING SLOWER THAN DSNUTILB
PK92649
16_Dec
2009
UK52951
PM04752

PANEL INZP00 EXECUTING INZT01 ERROR
PK93933
16_Dec
2009
UK52949


HPU FORMAT EXTERNAL GENERATES INCORRECT OUTPUT WITH A LEADING ZERO
PK98700
16_Dec
2009
UK52951
PM04752

SQLCODE -331 WITH CORRUPTED DATA.
PK95395
3_Dec
2009
UK52507


HPU UNLOAD TS INZI503E SYNTAX ERROR INZU366 RC08
PK99691
13_Nov
2009
UK51927


SYNTAX ERROR INZU016E IN R310. DOES NOT OCCUR IN R220.
PK95015
6_Nov
2009
UK51771


HPU UNLOAD GENERATES INCORRECT LOADDN WITH TYPE UNKNOWN
PK95675
6_Nov
2009
UK51771


UNLOAD IEC030I ABENDB37 RC04 ICE097I SORT RECOVERING FROM B37
PK95007
25_Sep
2009
UK50086


HPU UNLOAD PLUS FORMAT DSNTIAUL VARCHAR COLUMN GENERATES VB SYSREC DATASET
PK96416
25_Sep
2009
UK50086


ABENDU1132-0B OCCURS WHEN UNLOADING LOB DATA
PK86944
14_Sep
2009
UK50086


PERFORMANCE PROBLEM WHEN UNLOADING LARGE TABLE SPACES.
PK89729
14_Sep
2009
UK50086


INZIVP AND DDL FOR IVP
PK93336
14_Sep
2009
UK50086


LOW VALUES ON VARGRAPHIC COLUMNS
PK94019
14_Sep
2009
UK50086


ADDITIONAL HPU V310 ISSUES FOUND INTERNALLY AND ADDRESSED
PK87421
2_Sep
2009
UK49782


ABEND0C4 WHEN RUNNING HPU UNDER DB2 ADMIN TOOL, AND WHEN CALLED UNDER TSO.
PK92693
2_Sep
2009
UK49782


ADDITIONAL HPU V310 ISSUES FOUND INTERNALLY AND ADDRESSED
PK87789
14_Aug
2009
UK49278


INCORRECT RESULT WHEN USING BMC SYNTAX WITH FORMAT EXTERNAL ON COLUMNS DEFINED AS DEC(N,0).
PK88633
6_Jul
2009
UK48112


ABEND0C4 WHEN USING DB2 FORCE.
PK84369
5_Jun
2009
UK47222


GETTING MESSAGE INZI188E.
PK85236
5_Jun
2009
UK47222


INZI010E INTERNAL CONVERSION ERROR BETWEEN CCSID 1208 AND CCSID 1364
PK85718
29_May
2009
UK47021


PROBLEM WHEN A TEMPLATE IS USED TO CREATE A VB FILE.
PK82951
11_May
2009
UK46435


ABEND878-10 WHEN PROCESSING MANY TABLESPACES WITH LOADDDN.
PK84364
11_May
2009
UK46435


GETTING AN ABEND0C4 REASON CODE=00000004 IN INZUTILB SPECIFYING FASTUNLOAD.
PK80559
14_Apr
2009
UK45750


RC=8 WITHOUT MESSAGE WHEN PROCESSING A LIKE CLAUSE.
PK79701
23_Mar
2009
UK45123


ABENDU1210
PK82130
23_Mar
2009
UK45123


INZU238E UNEXPECTED UNSUPPORTED SELECT.
PK79126
16_Feb
2009
UK44085


S0C4 IN INZUTILK RUNNING ADMIN WITH WSL AND HPU
PK76516
29_Jan
2009
UK43572


EXPRESSION EVALUATION ERROR WHEN A DATE SCALAR FUNCTION APPLIED ON A TIMESTAMP CONSTANT.
PK76837
29_Jan
2009
UK43572


ABEND0C1, ABEND0C4 OR ABEND0C7 FOLLOWED BY ABENDU1017
PK76547
12_Jan
2009
UK43076


GETTING MESSAGE PLI218 EXECUTING MEMBER INZPARM.
PK75504
19_Dec
2008
UK42696


APAR TAKEN TO PROVIDE A NEW OPTIONAL SYSIN VALUE LOADOPT IDENTITYOVERRIDE.
PK75683
19_Dec
2008
UK42696


UNLOAD OF A MULTI-PARTITIONED TABLE ONLY UNLOADS THE FIRST PARTITION.
PK76612
19_Dec
2008
UK42696


ABENDU1132 REASON 0000000F
PK74184
8_Dec
2008
UK42261


ABEND08B RC = 00C1001D AS HPU UNLOADS A CLOB DEFINED AS A VSAM CLUSTER WITH EXTENDED AND EXTENDED ADDRESSABLE ATTRIBUTES
PK72602
30_Sep
2008
UK40336


HPU GETS INZU366I WHEN PROCESSING A UNIVERSAL TABLESPACE OR A PARTITION BY GROWTH TABLESPACE.
PK72110
23_Sep
2008
UK40110


INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X107A002) WHEN WITHUR IS CODED WITH UNION IN HPU UNLOAD AFTER UK39075.
PK68431
15_Sep
2008
UK39911


INZU015E AFTER MIGRATION TO HPU R310
PK69853
15_Sep
2008
UK39911


WRONG RESULTS WHEN LOBS ARE UNLOADED WITH LISTDEF
PK62968
27_Aug
2008
UK39330


THIS APAR TAKEN TO PROVIDE IMPROVED PERFORMANCE IN HPU UNLOAD WHEN USING THE WHERE CLAUSE.
PK64424
27_Aug
2008
UK39330


DATE AND/OR TIME FORMATS ARE GARBLED BY HPU UNLOAD WHEN THERE ISA LOCAL DEFINITION FOR THE FORMATS.
PK66467
19_Aug
2008
UK39075
PK72110

SQLCODE -805 EXECUTING INZHPU 08/07/28 PTF
PECHANGE
PK68560
19_Aug
2008
UK39075


ABENDU1013 "ERROR IN EDITPROC" WHEN HPU IS UNLOADING AN OBJECT WHOSE UNDERLYING VSAM FILE IS ENCRYPTED.
PK64556
16_Jun
2008
UK37363
PK66467

MESSAGE DSNU1141I DURING LOAD
PK65272
13_May
2008
UK36449


CC=04 IS SET FOR HPU UNLOAD JOB WHEN MSGS INZU063I UNSUPPORTED SELECT & INZU103W DB2 YES, EVEN IF VUU024/UNLZLRC IS SET TO
'5'.
PK62818
9_May
2008
UK36344


INZT038E WHEN USING GDG DATASETS TO UNLOAD.
PK61386
8_Apr
2008
UK35379


ABEND0C4 DUE TO MISSING AUTHORIZATION
PK60114
19_Feb
2008
UK33850


ABEND0C4 WHEN TABLE DOES NOT EXIST.
PK58786
18_Jan
2008
UK33078


ABEND0C4 11 IN HPU ROUTINE ODDLCMD DURING UNLOAD.
PK55413
7_Jan
2008
UK32784


MSGINZI010E IS ISSUED WHEN DOING A SELECT ON A TABLE FROM THE DB2 CATALOG, VIEW WITH A NAME LONGER THAN 18 CHAR EXIST ON TS.
PK58182
7_Jan
2008
UK32782


WHEN A PARTITIONED TS IS UNLOADED TO A UNIQUE OUTPUT FILE PER EACH PART, THEN DATA MAY BE REWRITTEN IN THE OUTPUT.
PK57697
19_Dec
2007
UK32471


INZI187E RC=8 RSN=00E60820 INZI174E
PK57213
12_Dec
2007
UK32170


MSGINZU505E SORT SIZE CANNOT BE ESTIMATED WHEN TABLE TO BE UNLOADED HAS NO INDEX AND IS IN A MULTI-TABLE TS. PB 9092
PK54119
30_Nov
2007
UK31802


MSGINZT034E TEMPLATE ERROR: WITH REASON CODE 0X12DA003 WHEN THE TEMPLATE IS CODED WITH :SELNUM.
PK53363
23_Oct
2007
UK30553


PARTITIONS REMAIN IN STOPPED STATUS.
PK53410
23_Oct
2007
UK30553


MSGICE046A SORT CAPACITY EXCEEDED & ABENDU0046 WHEN HPU UNLOADS TS SEGMENTED & COMPRESSED, MULTI-TABLE, & TABLE HAS UNIQUE
INDEX
PK53749
23_Oct
2007
UK30553


ABEND0C4 DURING UNLOAD OF A TS CREATED BEFORE DB2 V5 FOR WHICH DB2 CATALOG HAS CCSID 0 AND VUU023/UNLSCHEM OR SYSIN = ASIS.
PK51131
14_Sep
2007
UK29226


MSGIEC147I 613-44,IFG0196Q DURING UNLOAD WHEN PARALLELISM IS ACTIVE. PB 8971
PK49997
31_Aug
2007
UK28791


DURING HPU UNLOAD INVOLVING CCSID CONVERSIONS RECEIVE MSGINZU191 MSGINZU191I. PB 8900
PK48968
28_Aug
2007
UK28658


ABEND U1009 WHEN SORT IS INVOKED BECAUSE THE SORT FAILS WITH SORT CAPACITY EXCEEDED OR ABEND SB37 ON TNNNIN OR TNNNMG FILES
PK47506
18_Jul
2007
UK27210


FAST UNLOAD ORDER-BY NOT BEING RECOGNIZED
PK45756
9_Jul
2007
UK26958


ERROR MESSAGE INZU066E NO TABLESPACE FOUND FOR TABLE TABLE-NAME ISSUED WHEN UNLOADING FROM AN ALIAS AFTER MIGRATION DB2 V7 -
V8.
PK46586
27_Jun
2007
UK26606


MESSAGES INZI181E AND INZU366I AND UTILITY RSN CODE 0X109A003 WHEN TABLESSPACE OR PARTITIONS OF IT ARE IN RW,UTRW STATUS.
PK45094
24_Jun
2007
UK26449


ABEND0C4 DURING HPU UNLOAD
PK44862
12_Jun
2007
UK26030


INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X106A001)
PK38957
29_May
2007
UK25581


RECEIVE MSGINZU059W WITH RC=04 WHEN USING FASTUNLOAD SYNTAX AND CTLDDN=SYSCTL AND WHEN THE SYSCTLNN DD IS ALLOCATED AS DUMMY.
PK40400
29_May
2007
UK25581


THIS APAR IS CREATED TO PROVIDE NEW FUNCTION TO DB2 HPU R310, INCLUDING UNLOAD OF XML COLUMNS.
PK43294
29_May
2007
UK25581


HPU UNLOAD OF A NULLABLE FIELD DOES NOT PRODUCE EXPECTED OUTPUT WITH NULL DELIMITED. PB 8796
PK43631
29_May
2007
UK25581


HPU UNLOADS ABENDS WITH U1022 ABEND1022 REFERENCING AN IMAGE COPY, BUT THE OBJECT BEING DOWNLOADED IS NOT AN IMAGE COPY.
PK44219
29_May
2007
UK25581


NO RECORDS UNLOADED USING THE ORIGINOBID KEYWORD IN CONJUNCTION WITH THE COPYDDN STATEMENT.
PK43380
27_Apr
2007
UK24537


ABEND0C4 DURING HPU UNLOAD IN LINE 3299 OF @@227961(OCHAR)
PK41443
28_Mar
2007
UK23458


MSGINZU096E REQUIRED KEYWORD, KEYWORD, NOT SPECIFIED, PROCESSING TERMINATED WHEN UNLOAD SELECT INCLUDES A COLUMN NAMED "
ORDER ".
PK38092
16_Mar
2007
UK23114


"IN" OPERATOR NOT RETURNING ROWS
PK35746
19_Dec
2006
UK20773


PARTIAL SUPPORT OF LOB UNLOAD

Top of page