DB2 High Performance Unload for z/OS Version 2.1

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

APAR	CLOSE DATE	PTF(s)	Fixing APAR if PE	HIPER?	Abstract
DB2 High Performance Unload for z/OS Version 2.1
PK35385	5_Jan 2007	UK21045	PK38419		PLUS SIGN REPLACED BY X'00' IN FORMAT DELIMITED FOR FLOAT WHEN USING FASTUNLOAD SYNTAX. PB 8619 06/12/21 PTF PECHANGE
PK34295	22_Dec 2006	UK20881			HPU UNLOAD FAILS WITH RC=8, BUT NO EXPLANATORY MESSAGE WHEN THE UNLOAD PROCESSES CCSIDS THAT ARE NOT LISTED IN THE UNICODE TABLE
PK35191	5_Dec 2006	UK20290			INZU090E UNRECOVERABLE SYNTAX ERROR
PK34723	27_Nov 2006	UK20039		HIPER	KEYWORD NO INCORRECTLY CONSIDERED A RESERVE WORD
PK34874	27_Nov 2006	UK20039		HIPER	DSNT408I SQLCODE=-331,ERROR: A STRING CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE IT CANNOT BE TRANSLATED. REASON 12
PK32710	16_Nov 2006	UK19774			MSGINZI174E ERROR WHEN TRYING TO DETERMINE ENFM MODE IS ISSUED WHEN CALL ATTACH FACILITY ( CAF ) RETURNS RC = 4. PB 8484.
PK34051	10_Nov 2006	UK19607		HIPER	WHEN HPU UNLOAD PASSES COMPLEX SQL TO DB2 PER DB2 YES & DB2 FORCE ROWS MAY BE MISSING OR APPEAR AS BINARY ZEROES IN OUTPUT.
PK32955	30_Oct 2006	UK19252			A SQLCODE -311 MAY OCCUR ON THE OPEN CURSOR CORRESPONDING TO A NON SUPPORTED SELECT. PB 8500.
PK31240	17_Oct 2006	UK18907			MSGINZU021E "UNSUPPORTED CONVERSION GRAPHIC TO CHAR" WHEN USING UNLOADPLUS SYNTAX FORMAT CSV.
PK31494	17_Oct 2006	UK18907			LOAD STATEMENTS GENERATED BY HPU UNLOAD ARE INCORRECT WHEN USINGOEM FASTUNLOAD SYNTAX.
PK31781	17_Oct 2006	UK18907			HPU UNLOAD ENDS WITH RC=4 THOUGH DSNT408I SQLCODE = -904, ERROR:UNSUCCESSFUL EXECUTION CAUSED BY UNAVAILABLE RESOURCE.
PK30591	8_Sep 2006	UK17837	PK35385		AFTER APPLYING UK12543 ( R210 ) OR UK12544 ( R220 ) HPU UNLOADED DATA WITH NULL VALUES OUTPUT CHANGED FROM X'40' TO X'00'.
PK26372	31_Jul 2006	UK16737			MSGINZU213W ISSUED WHEN A LIKE TABLENAME + A LOADDDN USED IN A FORMAT CLAUSE IN A SELECT FOR CONSTANTS OR EXPRESSIONS.
PK25680	30_Jun 2006	UK15976		HIPER	COLUMNS THAT ALLOW NULL VALUES ARE WRONGLY SET
PK24485	7_Jun 2006	UK15208			MSGIEC036I 02-18 IGC0005E WHEN UNLOADING A TABLE WHOSE LRECL EXCEEDS THE MAXIMUM AS DEFINED BY THE ACCESS METHOD. PB 8012
PK23790	18_May 2006	UK14616			HPU UNLOAD ABEND0C4 WHEN A PARTIAL SELECT ( NOT 'SELECT *' ) AND THE TABLE IS IN A TS WITH PAGES LARGER THAN 4K. PB 8024
PK21394	28_Apr 2006	UK14076			PROVIDE A NEW INZTVAR VARIABLE TO GIVE THE OPTION FOR AN UNLOAD TO COMPLETE, EVEN WHEN MSGINZU200E IS ISSUED.
PK20426	31_Mar 2006	UK13178			HPU UNLOAD OUTPUT MAY BE MISSING SOME ROWS AFTER A SELECT CODED TO MATCH ON MULTIPLE KEYS MISSING ROWS HAVE KEYS END IN X'40'
PK18123	10_Mar 2006	UK12543	PK30591		INCORRECT OUTPUT UNLOADING A UNICODE TABLE.
PK17548	2_Feb 2006	UK11412			ERROR RUNNING INZT02: THE MEMBER INZDB21X CANNOT BE WRITTEN INTOTHE LIBRARY AAA.BBB.SINZSAMP. INZTVAR VUU027 LONGER THAN 37 CHAR
PK16207	9_Jan 2006	UK10619			RECEIVE SQLCODE -805 ON INZQRYV8 WHEN RUNNING HPU R210 OR R220 WITH DB2 V8 IN COMPATABILITY MODE.
PK15319	14_Dec 2005	UK10092			MSGINZI152E WHEN RUNNING HPU UNLOAD POINTING TO A DB2 SSID THAT IS NOT STARTED. 05/12/07 PTF PECHANGE
PK14743	28_Nov 2005	UK09505			RUNNING HPU R220 WITH DB2 V8 CM RECEIVE SQLCODE ERROR -4700 4700SQLSTATE 56038 WHEN UNLOAD DONE WITH LOCK YES.
PK14322	21_Nov 2005	UK09338			USING UNLOAD PLUS UNLOAD SYNTAX RECEIVE ERROR MESSAGE INZU039E FATAL SYNTAX ERROR BEFORE LINE 12 COLUMN 73 FROM ADMIN.
PK13580	16_Nov 2005	UK09166	PK15319		THIS APAR WILL PROVIDE NEW FUNCTION SUPPORT FOR HPU IN NATIVE MODE TO PROCESS VARCHAR( ). PB 7518
PK12260	4_Nov 2005	UK08762			OVERRIDE OF THE DCB FOR THE LOADDDN FILE DOESN'T WORK. PB 7586
PK11943	19_Oct 2005	UK08288		HIPER	HPU NOT RECOGNIZING UNLOADPLUS RECORD FIELD SYNTAX AS PART OF THE UNLOADPLUS SELECT BLOCK.
PK11776	21_Sep 2005	UK07455			HPU BATCH UNLOAD STEP FAILS WITH COND CODE 0008 AND NO OTHER MSGIF THE CREATOR ID OF TABLESPACE AND CLUSTERING INDEX DIFFER.
PK11272	16_Sep 2005	UK07312			THE CONVERSION OF A FLOAT TO A CHAR GENERATES AN INVALID FLOATING POINT CONSTANT.
PK10379	1_Sep 2005	UK06880			INZI151E EXECUTING HPU
PK09531	11_Aug 2005	UK06201			WRONG SYSREC RECORD ORDER USING BMC COMPATIBILITY STATEMENT ORDER YES
PK07945	1_Aug 2005	UK05904			1. PADDING WITH BINARY ZEROES INSTEAD OF BLANKS 2. SIGN BYTE IN DEC EXTERNAL IS BLANK INSTEAD OF '+'
PK08278	14_Jul 2005	UK05407			ERROR IN GENERATED LOAD SYSIN IN CASE OF FORMAT VARIABLE ALL AND DECIMAL ZONED.
PK05817	20_Jun 2005	UK04677			DURING HPU UNLOAD INVOLVING CCSID CONVERSIONS RECEIVE MSGINZU191MSGINZU191I.
PK06385	3_Jun 2005	UK03679			AE PK05203
PK05203	20_May 2005	UK03679			MSGINZU180I UTPRINT DD CARD IN JCL IS NOT USED WHEN VUX020/SORTCLAS AND DB2 V8 IN COMPATABILITY MODE CM.
PK05010	9_May 2005	UK03257			INZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID NN AND CCSID MMM WHERE THIS CONVERSION IS SHOWN IN DB2 SYSSTRINGS.
PK03504	3_May 2005	UK03079			WHEN USING BMC UNLOAD PLUS UNLOAD SYNTAX, HPU PADS FIXED VARCHARCOLUMNS WITH BINARY ZEROS X'00', NOT BLANKS X'40'.
PK02935	14_Apr 2005	UK02422			ABEND S7E8 WITH SINGLE OUTPUT FILE ON TAPE AND PARALLELISM ACTIVATED. PB 6932.
PK01894	23_Mar 2005	UK01743	PK05010		HPU DIMINISHED PERFORMANCE WHEN UNLOADING USING ORDER CLUSTER AND THE SOURCE TABLE IS NOT EFFICIENTLY CLUSTERED.
PK00657	11_Mar 2005	UK01416			UNLOADING MULTIPLE PARTITIONS IN HPU R210 REGION REQUIRED IS MUCH LARGER THAN THE SAME UNLOAD UNDER HPU R120. ABEND878
PQ99262	1_Mar 2005	UK01041			LOADDDN INCORRECT AFTER UNLOAD WITH DSNTIAUL STRICT.
PQ98706	7_Feb 2005	UK00346			HPU ABEND U1017 IS PRECEEDED BY A DFSORT ABEND U0027 IN ICEMAN.
PQ98349	24_Jan 2005	UQ97085			ABEND138 S138 INDICATING DOUBLE ENQ ON THE SAME RESOURCE WITHOUTAN INTERVENING DEQ, IS RECEIVED IN HPU UNLOAD.
PQ97627	20_Dec 2004	UQ96285			HPU UNLOAD OUTPUT OF A TIMESTAMP WITH MICROSECONDS MAY SHOW ZEROES INSTEAD OF THE CORRECT MICROSECOND VALUE.
PQ98128	20_Dec 2004	UQ96285			MISSING ROWS ON HPU UNLOAD OF A DB2 TABLESPACE DEFINED AS MEMBER CLUSTER.
PQ98146	20_Dec 2004	UQ96285			RUNNING HPU UNLOAD USING FASTUNLOAD SYNTAX WITH QUOTE NONE SET STILL GET QUOTE MARKS AROUND THE DATE AND TIME FIELDS.
PQ96450	10_Dec 2004	UQ95982			HPU UNLOAD OUTPUT MAY CONTAIN DUPLICATE ROWS FROM A REORGED IMAGE COPY.
PQ94788	8_Nov 2004	UQ94859			ABEND0C7 DURING HPU UNLOAD WHEN UNLOAD STATEMENT INCLUDES PROCESSING A DATE COLUMN.
PQ93985	1_Nov 2004	UQ94612			WITH CCSID CONVERSION OF SBCS KATAKANA CHARACTERS CCSID 05026 THREE SPECIFIC CHARACTERS ARE NOT RETURNED ON THE HPU UNLOAD.
PQ93558	1_Oct 2004	UQ93531			ABEND0C4 DURING HPU UNLOAD WHEN UNSUPPORTED DATE / TIME FORMAT IS USED WITH BMC FASTUNLOAD SYNTAX. 04/09/23 PTF PECHANGE
PQ91548	16_Aug 2004	UQ91850	PQ93558		OUTPUT OF HPU UNLOAD CAN CONTAIN CORRUPTED ROWS IF ALTER TABLE ADD COLUMN WAS DONE AFTER THE ROWS WERE INSERTED. AFTER UQ90156.
PQ92538	16_Aug 2004	UQ91850	PQ93558		AE PQ91548
PQ84688	28_Jun 2004	UQ90156	PQ91548		DB2 V8 SUPPORT
PQ86473	28_Jun 2004	UQ90156	PQ91548		LTRIM & RTRIM SCALAR FUNCTIONS GENERATE INCORRECT OUTPUT
PQ86964	28_Jun 2004	UQ90156	PQ91548		PERFORMANCE ENHANCEMENTS
PQ87828	28_Jun 2004	UQ90156	PQ91548		HPU 2.1 LOOPING IF UNLOAD IS RUN AGAINST AN EMPTY TABLE AND FORMAT CSV TERMINATEDBY.
PQ86626	28_Jun 2004	UQ90156	PQ91548		SQLCODE104 OR ABEND0C4 WHEN ORDER CLAUSE EXCEEDS MORE THAN 454 LINES
PQ87546	28_Jun 2004	UQ90156	PQ91548		USE OF JOBCAT / STEPCAT CAUSED INABILITY TO ESTIMATE CORRECT SORTWRK SIZES
PQ87901	28_Jun 2004	UQ90156	PQ91548		RUNNING DB2 HPU UNLOAD USING ORDER CLUSTER CLAUSE THE OUTPUT DS IS NOT PROPERLY SORTED PER THIS CLAUSE.
PQ87907	28_Jun 2004	UQ90156	PQ91548		NO OUTPUT RECORDS WRITTEN WHEN USING LIKE PREDICATE WITH GRAPHICS - MSGINZX090
PQ89415	28_Jun 2004	UQ90156	PQ91548		1) INZU109E MESSAGE RECEIVED WITH VERY LONG WHERE CLAUSE, 2) SQLCODE904 TABLESPACE IN UT AND SHARE LOCK REQUESTED
PQ83895	1_Apr 2004	UQ86898			(1) IRRELEVANT MSGINZU065E, (2) INCORRECT DATA UNLOADED FOR CHAR(DECIMAL_COLUMN), (3) INCONSISTENT LOCKING, (4) DATA ORDER
PQ85902	1_Apr 2004	UQ86898			1) MISLEADING MSGINZGE0001, 2) TIMESTAMP FUNCTION RETURNS ZEROS,3) ABENDU1208 AND MSGLSCX130
PQ86562	1_Apr 2004	UQ86898			FLOAT FUNCTION RESULT IS TRUNCATED
PQ83064	10_Mar 2004	UQ86007			LARGE DEC FIELDS NOT HANDLED CORRECTLY
PQ82855	2_Feb 2004	UQ84713			VARIOUS HPU 2.1 FIXES
PQ82920	2_Feb 2004	UQ84713			VARIOUS HPU FIXES
PQ79530	24_Dec 2003	UQ83610			FIELDPROC ERROR
PQ80139	24_Dec 2003	UQ83610			CONCURRENT EXECUTION OF HPU WITH SHRLEVEL REFERENCE IMAGECOPY FAILS WITH INZU156E THE TABLESPACE XXX.MMM IS NOT AVAILABLE..
PQ81032	24_Dec 2003	UQ83610			PERFORMANCE ENHANCEMENT FOR HPU UNLOAD FROM IMAGE COPY
PQ81245	24_Dec 2003	UQ83610			LSCX130 ATTEMPT TO FREE AN ADDRESS NOT ALLOCATED BY MALLOC
PQ82373	24_Dec 2003	UQ83610			ABEND0C7 WHEN UNLOADING DB2 CATALOG TABLE WITH WHERE CLAUSE CONTAINING ONE OR SEVERAL CATALOG COLUMNS
PQ79147	30_Oct 2003	UQ81703			NEW DEFAULT TO PROVIDE COMPATIBILITY WITH FAST UNLOAD
PQ79793	30_Oct 2003	UQ81703			ABENDU0046 IN SORT WHEN UNLOADING FROM INLINE FULL IMAGE COPY
PQ78854	30_Oct 2003	UQ81703			INCORRECT OUTPUT WITH FORMAT DELIMITED SEP ',' DELIM '"' WHEN THERE IS A SEQUENCE OF TWO OR MORE LITERALS IN THE SELECT
PQ79810	30_Oct 2003	UQ81703			UNLOAD FAILS FOR NONEXISTENT PARTITION WHEN QUIESCE YES WITH DSNU524I #DSN7-DSNUQUIA INVALID DATA SET OR PARTITION NUMBER NN
PQ76876	6_Oct 2003	UQ80881			INCORRECT RECORD COUNT IN * TABLESPACE TOTAL .............* WHEN THE NUMBER OF UNLOADED ROWS ARE GREATER THAN 2**31.
PQ77656	6_Oct 2003	UQ80881			CURRENT_DATE IS NOT RECOGNIZED BY HPU 2.1
PQ78216	6_Oct 2003	UQ80881			INCORRECT NUMBER OF ROWS EXTRACTED FROM INLINE COPY
PQ78006	25_Sep 2003	UQ80555			INCORRECT MSGINZU204W AND RC04 WITH DB2 FORCE
PQ77308	24_Sep 2003	UQ80555			INCOR OUTPUT WITH DB2 NO WHEN CASE WAS USED WITHIN SELECT
PQ77842	8_Sep 2003	UQ80001			INCORRECT OUTPUT GENERATED WHEN USING UNLOAD PLUS CONTROL CARDS.DB2 LOAD ENDS WITH ABEND04E U0000 AND REASON 00E40323
PQ77850	8_Sep 2003	UQ80002			MSGINZU214E COLUMN ....: INVALID CONVERSION FOR LOAD STATEMENT
PQ77905	8_Sep 2003	UQ80002			ABEND0C4 IN EXTENDED NAME: _INZBABDESTROYDSCA
PQ77193	8_Sep 2003	UQ80001			ABEND1121 OR ABEND0C4 EXITING INTERACTIVE ISPF HPU
PQ76564	8_Aug 2003	UQ79307			INVALID LOAD GENERATED WITH FAST UNLOAD SYNTAX WHEN DEFAULTIF WAS REQUESTED WITHIN INTO CLAUSE
PQ77050	8_Aug 2003	UQ79307			SELECT WITH FORMAT VARIABLE + LIKE TABLE AND LOADDDN MAY GENERATE AN INCORRECT LOAD STATEMENT
PQ75765	17_Jul 2003	UQ78661			HPU CREATES INVALID OUTPUT WHEN UNLDDN, OUTDDN AND LOADDDN POINTTO THE SAME DD
PQ75771	17_Jul 2003	UQ78661			INVALID FIELDS GENERATED BY HPU FOR THE SORT COMMAND WHEN ORDER BY CONTAIN BOTH ASC AND DESC COLUMNS
PQ76033	17_Jul 2003	UQ78661			SYSOUT CONTENT IS SHIFTED (1 POSITION) WHEN EITHER QUIESCE QUIESCECAT IS REQUESTED.
PQ74020	19_May 2003	UQ77011			ABEND0C4 IN EXTENDED NAME: OCHAINEREMOVEITEM
PQ73714	5_May 2003	UQ76624			ABEND0C4 IN FUNCTION OLISTAPPEND CALLED BY INZDYYPARSE
PQ73516	30_Apr 2003	UQ76624			INVALID RESULT WHEN SCALAR FUNCTION DAYS IS USED WITH DB2 FORCE
PQ73048	23_Apr 2003	UQ76271			ABEND0C4 OCCURS IN FUNCTION _INZRUNCHECKSORTSUPPORT WHEN UNLDDN AND OUTDDN REFER TO THE SAME DDNAME FOR A PARTITIONED TABLESPACE
PQ71829	31_Mar 2003	UQ76271			NO ERROR MESSAGE AND RC08 WHEN UNLOADING FROM DSN1COPY DATA SET WITH UNLDDN OTHER THAN SYSREC
PQ71451	25_Mar 2003	UQ75403			UNLOAD PLUS COMPATIBILITY : CSV FORMAT OPTIONS ARE IGNORED
PQ71982	25_Mar 2003	UQ75403			MSGINZU020E ERROR WHILE RETRIEVING TABLESPACE INFO FROM THE CATALOG
PQ70902	24_Feb 2003	UQ74412			EXCESSIVE CPU CONSUMPTION WHEN INDEX SCAN IS USED TO READ DATA WITH ORDER BY CLAUSE
PQ71237	24_Feb 2003	UQ74412			INVALID MSGINZU210E DUPLICATE LOADDDN WITHOUT OPTION AUTOTAG WHEN MORE THAN ONE SELECT IS USED WITH THE SAME LOADDDN OPERAND
PQ70253	27_Jan 2003	UQ73575			INCORRECT OUTPUT OF CHAR(CURRENT DATE) WHEN PROCESSED BY DB2.
PQ69406	15_Jan 2003	UQ73270			ABEND0C6 WHEN USE FAST UNLOAD SYNTAX DEFAULTIF(XXXXX IS NULL) INITIAL(NULL)
PQ69121	20_Dec 2002	UQ72859			MSGIEC161I AND MSGINZSE066 AND MSGINZCE0518 WHEN DB2 CATALOG TABLESPACES ARE DEFINED AS EXTENDED VSAM DATA SETS
PQ68788	11_Dec 2002	UQ72859			SQLCODE098, WARNING: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICON
PQ68392	6_Dec 2002	UQ72423			TO FORCE SQL ACCESS FOR DB2 CATALOG READING.
PQ68020	15_Nov 2002	UQ71803			VARIOUS UNLOAD PLUS COMPATIBILITY FIXES.
PQ68310	15_Nov 2002	UQ71803			ABEND0C4 WHEN DB2 CATALOG, SYSIBM.SYSCOLUMNS, HAS INVALID VALUESIN COLUMNS LENGTH2, DATATYPEID AND SOURCETYPEID.
PQ67765	31_Oct 2002	UQ71374			RESERVED WORDS IN UNLOAD PLUS SYNTAX.
PQ67488	25_Oct 2002	UQ71374			MISCELLANEOUS FIXED TO PROVIDE COMPATIBILITY WITH THE UNLOAD PLUS.
PQ66877	22_Oct 2002	UQ71073		HIPER	MULTIPLE FIXES FOR HPU 2.1
PQ67252	22_Oct 2002	UQ71073			ABEND0C4 IN INFUTILB, EXTENDED NAME: OCHAINEREMOVEITEM, RUNNING HPU JOB.
PQ65724	5_Sep 2002	UQ69612			THE SYSIN IS AN IN-STREAM FILE (DD * OR DD DATA,DLM=XX) - QUIESCE YES AND QUIESCECAT NO IS REQUESTED. ABEND001.
PQ63627	30_Jul 2002	UQ68552		HIPER	MISCELLANEOUS PRE GA FIXES.
PQ63175	18_Jul 2002	UQ68206			ROLLUP OF MAINTENANCE WITH MISCELLANEOUS POST GA FIXES.

Top of page