DB2 High Performance Unload for z/OS Version 2.2

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.2
PK84364	11_May 2009	UK46434			GETTING AN ABEND0C4 REASON CODE=00000004 IN INZUTILB SPECIFYING FASTUNLOAD.
PK80559	14_Apr 2009	UK45749			RC=8 WITHOUT MESSAGE WHEN PROCESSING A LIKE CLAUSE.
PK76516	29_Jan 2009	UK43571			EXPRESSION EVALUATION ERROR WHEN A DATE SCALAR FUNCTION APPLIED ON A TIMESTAMP CONSTANT.
PK74184	8_Dec 2008	UK42260			ABEND08B RC = 00C1001D AS HPU UNLOADS A CLOB DEFINED AS A VSAM CLUSTER WITH EXTENDED AND EXTENDED ADDRESSABLE ATTRIBUTES
PK68431	15_Sep 2008	UK39910			INZU015E AFTER MIGRATION TO HPU R310
PK62968	27_Aug 2008	UK39329			THIS APAR TAKEN TO PROVIDE IMPROVED PERFORMANCE IN HPU UNLOAD WHEN USING THE WHERE CLAUSE.
PK66467	19_Aug 2008	UK39074	PK72110		SQLCODE -805 EXECUTING INZHPU 08/07/28 PTF PECHANGE
PK64556	16_Jun 2008	UK37362	PK66467		MESSAGE DSNU1141I DURING LOAD
PK65272	13_May 2008	UK36448			CC=04 IS SET FOR HPU UNLOAD JOB WHEN MSGS INZU063I UNSUPPORTED SELECT & INZU103W DB2 YES, EVEN IF VUU024/UNLZLRC IS SET TO '5'.
PK61386	8_Apr 2008	UK35378			ABEND0C4 DUE TO MISSING AUTHORIZATION
PK55413	7_Jan 2008	UK32783			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.
PK54119	30_Nov 2007	UK31801			MSGINZT034E TEMPLATE ERROR: WITH REASON CODE 0X12DA003 WHEN THE TEMPLATE IS CODED WITH :SELNUM.
PK53363	23_Oct 2007	UK30552			PARTITIONS REMAIN IN STOPPED STATUS.
PK51131	14_Sep 2007	UK29225			MSGIEC147I 613-44,IFG0196Q DURING UNLOAD WHEN PARALLELISM IS ACTIVE. PB 8971
PK49997	31_Aug 2007	UK28790			DURING HPU UNLOAD INVOLVING CCSID CONVERSIONS RECEIVE MSGINZU191MSGINZU191I. PB 8900
PK48968	28_Aug 2007	UK28657			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	UK27209			FAST UNLOAD ORDER-BY NOT BEING RECOGNIZED
PK45756	9_Jul 2007	UK26957			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	UK26605			MESSAGES INZI181E AND INZU366I AND UTILITY RSN CODE 0X109A003 WHEN TABLESSPACE OR PARTITIONS OF IT ARE IN RW,UTRW STATUS.
PK45094	24_Jun 2007	UK26448			ABEND0C4 DURING HPU UNLOAD
PK44862	12_Jun 2007	UK26029			INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X106A001)
PK38957	29_May 2007	UK25580			RECEIVE MSGINZU059W WITH RC=04 WHEN USING FASTUNLOAD SYNTAX AND CTLDDN=SYSCTL AND WHEN THE SYSCTLNN DD IS ALLOCATED AS DUMMY.
PK44869	29_May 2007	UK25584			INZI152E ERROR WHEN FINDING SQLID, ERROR CODE: 16 REASON CODE: 00000000
PK38404	22_Mar 2007	UK23280			THE DATE IS INCORRECTLY WRITTEN IN THE OUTPUT FILE.
PK39892	5_Mar 2007	UK22727			HPU UNLOAD OUTPUT IN R220 DOES NOT CONTAIN GRAPHIC SO/SI FOR DBCS CHARACTER SETS.
PK38419	20_Feb 2007	UK22359			AFTER APPLYING THE FIXING PTF FOR APAR PK35385 PADDING OF NULL CHARACTERS CHANGES FROM X'00' TO X'40'. UK21046 PE
PK37190	29_Jan 2007	UK21669			"IN" OPERATOR NOT RETURNING ROWS
PK36600	16_Jan 2007	UK21293			ABEND S0C4 IN IGG019AK WHEN PARTIAL INDEXSCAN IS USED. PB 8590.
PK35385	5_Jan 2007	UK21046	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	UK20882			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	UK20291			INZU090E UNRECOVERABLE SYNTAX ERROR
PK34723	27_Nov 2006	UK20040		HIPER	KEYWORD NO INCORRECTLY CONSIDERED A RESERVE WORD
PK34874	27_Nov 2006	UK20040		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	UK19775			MSGINZI174E ERROR WHEN TRYING TO DETERMINE ENFM MODE IS ISSUED WHEN CALL ATTACH FACILITY ( CAF ) RETURNS RC = 4. PB 8484.
PK34051	10_Nov 2006	UK19608		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	UK19253			A SQLCODE -311 MAY OCCUR ON THE OPEN CURSOR CORRESPONDING TO A NON SUPPORTED SELECT. PB 8500.
PK31240	17_Oct 2006	UK18908			MSGINZU021E "UNSUPPORTED CONVERSION GRAPHIC TO CHAR" WHEN USING UNLOADPLUS SYNTAX FORMAT CSV.
PK31494	17_Oct 2006	UK18908			LOAD STATEMENTS GENERATED BY HPU UNLOAD ARE INCORRECT WHEN USINGOEM FASTUNLOAD SYNTAX.
PK31781	17_Oct 2006	UK18908			HPU UNLOAD ENDS WITH RC=4 THOUGH DSNT408I SQLCODE = -904, ERROR:UNSUCCESSFUL EXECUTION CAUSED BY UNAVAILABLE RESOURCE.
PK30591	8_Sep 2006	UK17838	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	UK16738			MSGINZU213W ISSUED WHEN A LIKE TABLENAME + A LOADDDN USED IN A FORMAT CLAUSE IN A SELECT FOR CONSTANTS OR EXPRESSIONS.
PK25680	30_Jun 2006	UK15977		HIPER	COLUMNS THAT ALLOW NULL VALUES ARE WRONGLY SET
PK24485	7_Jun 2006	UK15209			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	UK14617			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	UK14077			PROVIDE A NEW INZTVAR VARIABLE TO GIVE THE OPTION FOR AN UNLOAD TO COMPLETE, EVEN WHEN MSGINZU200E IS ISSUED.
PK20426	31_Mar 2006	UK13179			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	UK12544	PK30591		INCORRECT OUTPUT UNLOADING A UNICODE TABLE.
PK17548	2_Feb 2006	UK11413			ERROR RUNNING INZT02: THE MEMBER INZDB21X CANNOT BE WRITTEN INTOTHE LIBRARY AAA.BBB.SINZSAMP. INZTVAR VUU027 LONGER THAN 37 CHAR
PK16207	9_Jan 2006	UK10620			RECEIVE SQLCODE -805 ON INZQRYV8 WHEN RUNNING HPU R210 OR R220 WITH DB2 V8 IN COMPATABILITY MODE.
PK15319	14_Dec 2005	UK10093			MSGINZI152E WHEN RUNNING HPU UNLOAD POINTING TO A DB2 SSID THAT IS NOT STARTED. 05/12/07 PTF PECHANGE
PK14743	28_Nov 2005	UK09506			RUNNING HPU R220 WITH DB2 V8 CM RECEIVE SQLCODE ERROR -4700 4700SQLSTATE 56038 WHEN UNLOAD DONE WITH LOCK YES.
PK14322	21_Nov 2005	UK09339			USING UNLOAD PLUS UNLOAD SYNTAX RECEIVE ERROR MESSAGE INZU039E FATAL SYNTAX ERROR BEFORE LINE 12 COLUMN 73 FROM ADMIN.
PK13580	16_Nov 2005	UK09167	PK15319		THIS APAR WILL PROVIDE NEW FUNCTION SUPPORT FOR HPU IN NATIVE MODE TO PROCESS VARCHAR( ). PB 7518
PK12260	4_Nov 2005	UK08763			OVERRIDE OF THE DCB FOR THE LOADDDN FILE DOESN'T WORK. PB 7586
PK11943	19_Oct 2005	UK08289		HIPER	HPU NOT RECOGNIZING UNLOADPLUS RECORD FIELD SYNTAX AS PART OF THE UNLOADPLUS SELECT BLOCK.
PK11776	21_Sep 2005	UK07456			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	UK07313			THE CONVERSION OF A FLOAT TO A CHAR GENERATES AN INVALID FLOATING POINT CONSTANT.
PK10379	1_Sep 2005	UK06881			INZI151E EXECUTING HPU
PK09531	11_Aug 2005	UK06202			WRONG SYSREC RECORD ORDER USING BMC COMPATIBILITY STATEMENT ORDER YES
PK07945	1_Aug 2005	UK05905			1. PADDING WITH BINARY ZEROES INSTEAD OF BLANKS 2. SIGN BYTE IN DEC EXTERNAL IS BLANK INSTEAD OF '+'
PK08278	14_Jul 2005	UK05408			ERROR IN GENERATED LOAD SYSIN IN CASE OF FORMAT VARIABLE ALL AND DECIMAL ZONED.
PK05817	20_Jun 2005	UK04678			DURING HPU UNLOAD INVOLVING CCSID CONVERSIONS RECEIVE MSGINZU191MSGINZU191I.
PK06385	3_Jun 2005	UK03680			AE PK05203
PK05203	20_May 2005	UK03680			MSGINZU180I UTPRINT DD CARD IN JCL IS NOT USED WHEN VUX020/SORTCLAS AND DB2 V8 IN COMPATABILITY MODE CM.
PK05010	9_May 2005	UK03258			INZI006E NO CONVERSION WAS AVAILABLE BETWEEN CCSID NN AND CCSID MMM WHERE THIS CONVERSION IS SHOWN IN DB2 SYSSTRINGS.
PK03504	3_May 2005	UK03080			WHEN USING BMC UNLOAD PLUS UNLOAD SYNTAX, HPU PADS FIXED VARCHARCOLUMNS WITH BINARY ZEROS X'00', NOT BLANKS X'40'.
PK02935	14_Apr 2005	UK02423			ABEND S7E8 WITH SINGLE OUTPUT FILE ON TAPE AND PARALLELISM ACTIVATED. PB 6932.
PK01894	23_Mar 2005	UK01744	PK05010		HPU DIMINISHED PERFORMANCE WHEN UNLOADING USING ORDER CLUSTER AND THE SOURCE TABLE IS NOT EFFICIENTLY CLUSTERED.
PK00657	11_Mar 2005	UK01417			UNLOADING MULTIPLE PARTITIONS IN HPU R210 REGION REQUIRED IS MUCH LARGER THAN THE SAME UNLOAD UNDER HPU R120. ABEND878
PQ99262	1_Mar 2005	UK01042			LOADDDN INCORRECT AFTER UNLOAD WITH DSNTIAUL STRICT.
PQ98706	7_Feb 2005	UK00347			HPU ABEND U1017 IS PRECEEDED BY A DFSORT ABEND U0027 IN ICEMAN.
PQ98349	24_Jan 2005	UQ97086			ABEND138 S138 INDICATING DOUBLE ENQ ON THE SAME RESOURCE WITHOUTAN INTERVENING DEQ, IS RECEIVED IN HPU UNLOAD.
PQ97627	20_Dec 2004	UQ96286			HPU UNLOAD OUTPUT OF A TIMESTAMP WITH MICROSECONDS MAY SHOW ZEROES INSTEAD OF THE CORRECT MICROSECOND VALUE.
PQ98128	20_Dec 2004	UQ96286			MISSING ROWS ON HPU UNLOAD OF A DB2 TABLESPACE DEFINED AS MEMBER CLUSTER.
PQ98146	20_Dec 2004	UQ96286			RUNNING HPU UNLOAD USING FASTUNLOAD SYNTAX WITH QUOTE NONE SET STILL GET QUOTE MARKS AROUND THE DATE AND TIME FIELDS.
PQ96450	10_Dec 2004	UQ95983			HPU UNLOAD OUTPUT MAY CONTAIN DUPLICATE ROWS FROM A REORGED IMAGE COPY.
PQ94788	8_Nov 2004	UQ94860			ABEND0C7 DURING HPU UNLOAD WHEN UNLOAD STATEMENT INCLUDES PROCESSING A DATE COLUMN.
PQ93985	1_Nov 2004	UQ94613			WITH CCSID CONVERSION OF SBCS KATAKANA CHARACTERS CCSID 05026 THREE SPECIFIC CHARACTERS ARE NOT RETURNED ON THE HPU UNLOAD.
PQ94763	15_Oct 2004	UQ94059			HPU R220 PROCESSING OF IN PREDICATE MAY RESULT IN FEWER ROWS OR NO ROWS AT ALL RETURNED.

Top of page