DB2 High Performance Unload for z/OS Version 3.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 3.2
PM84164	10_Apr 2013	UK93297			A NON SUPPORTED STATEMENT OR A STATEMENT PASSED TO DB2 USING DB2FORCE IS REJECTED WITH EITHER SQLCODE = -311 OR SQLCODE = -010
PM70766	28_Aug 2012	UK81369			ABENDU1013 OR ABENDS0C4 OR INCORRECT UNLOAD UNLOADING A TABLE DEFINED WITH GRAPHIC OR VARGRAPHIC COLUMNS AND AN EDITPROC.
PM62207	22_Aug 2012	UK81248			HELP ON QUIESCE FROM PANEL INZA10 MAY GENERATE INZHF011 ERROR
PM66604	22_Aug 2012	UK81248			CORRECT REPORTED ELAPSED TIME ON MSGINZX090
PM69223	8_Aug 2012	UK80918			INCORRECT OUTPUT OR FAILURE UNLOADING LOB, XML OR ORDER BY WITH INDEXSCAN METHOD
PM63744	25_Jun 2012	UK79789			ABEND U1136 UNLOADING XML DATA IN NATIVE MODE, REASON CODE 1A ORRESON CODE 1E
PM58301	24_May 2012	UK79048			THE UNLOAD ENDS WITH COMPLETION CODE 0 EVEN THOUGH SOME OF THE TABLE SPACES FROM THE LISTDEF LIST DO NOT EXIST.
PM60124	6_Apr 2012	UK77749			A LOGICAL UNLOAD WITH A WHERE CLAUSE HAVING AN IN PREDICATE ON CHAR DATA RETURNS AN INCORRECT NUMBER OF ROWS.
PM60606	6_Apr 2012	UK77749			ABEND0C1 ABEND0C4 ABEND0C7 OR INCRRECT NUMBER OF ROWS IF MOD EXPRESSION PART OF PREDICATE IN WHERE CLAUSE
PM54509	16_Mar 2012	UK77136			THE DATA FROM THE TABLE SPACE IS NOT LOCKED ALTHOGH THE LOCK YESOPTION IS SPECIFIED ON PHYSICAL UNLOAD
PM53585	17_Feb 2012	UK76342			TEMPLATE ERROR: TEMPLATE OUTLOB REDEFINES DSNAME DSNAME PREVIOUSLY GENERATED FROM TEMPLATE TEMPLATE_NAME
PM54847	17_Feb 2012	UK76342			INZU221I AND INZX005 GENERATING UNEXPECTED PARALLELISM
PM52874	17_Feb 2012	UK76342			HPU ENDS WITH COMPLETION CODE 8 AND ISSUES MSG REPORTING SQLCODE-206
PM50198	28_Nov 2011	UK74261			HPU UNLOAD STOPS WITH COMPLETION CODE 8 WITH NO EXPLANATION MESSAGE
PM50449	28_Nov 2011	UK74261			INZI503E CONCERNING A DDL ELEMENT SUCH AS ENDING AT (DECIMAL_CONSTANT).
PM50559	28_Nov 2011	UK74261			0C1 AND UNPREDICTABLE RESULTS UNLOAD FROM IMAGE COPY (COPYDDN) AND EXTERNAL DDL (DDLDDN) WHEN TABLE HAS AS IDENTITY COLUMN.
PM50669	28_Nov 2011	UK74261			WRONG NUMBER OF ROWS IN LOGICAL UNLOAD IF SELECT INCLUDES WHERE CLAUSE WITH PREDICATE REQUESTING COMPARISON OF TWO VARCHAR
PM50670	28_Nov 2011	UK74261			UNLOAD STOPS ISSUING MESSAGE ABOUT DDLDDN CONTENT WHERE DDLDDN SPECIFIES PARTITION BY SIZE CLAUSE BEFORE THE IN DB.TS CLAUSE
PM34549	25_Oct 2011	UK73227			HPU GENERATES INVALID LOAD STATEMENT WHEN VARCHAR DATA IS TO BE UNLOADED AS FIXED LENGTH FIELD
PM39955	25_Oct 2011	UK73227			HPU FAILS WITH U1033 INSTEAD OF REJECTING THE UNLOAD OF LOB FROMAN IMAGE COPY
PM34381	25_Oct 2011	UK73227			IF THE QUIESCE CANNOT BE PERFORMED HPU FOR Z/OS UNLOAD FAILS CC 8 AND INZI164E MESSAGE REGARDLESS OF VUU028/ULQSCEBH
PM38754	25_Oct 2011	UK73227			ERRONEOUSLY ISSUED INZI516E DDL ANALYSING: INVALID DDL DEFINITION
PM38963	25_Oct 2011	UK73227			ENQUEUE ON INZUTIL, HPU JOBS RUNNING IN PARALLEL MAY WAIT USELESSLY WHILE THEY COULD RUN INDEPENDENTLY
PM40056	25_Oct 2011	UK73227		HIPER	NUMBER OF UNLOADED ROWS FOR A LOGICAL UNLOAD WITH A WHERE CLAUSEMAY BE WRONG WHICH RESULTS IN MISSING ROWS
PM43991	25_Oct 2011	UK73227			SMALLINT DATA UNLOADED IN FASTUNLOAD FORMAT EXTERNAL ARE 11 CHARACTER LONG INSTEAD OF 6.
PM40587	14_Sep 2011	UK71901			AN UNLOAD AGAINST A PARTITIONED TABLE SPACE FAILS WITH ABENDU1004 AFTER MSGIKJ56220I HAS BEEN ISSUED
PM43634	14_Sep 2011	UK71901			SYSREC UNLOADED AS CHAR DATA DESPITE SPECIFYING DSNTIAUL STRICT
PM39513	14_Sep 2011	UK71901			HPU ABENDU1022
PM41840	14_Sep 2011	UK71901			MSGINZU096E UNLOAD SPECIFIES SPACE IN THE SELECT STATEMENT
PM47226	14_Sep 2011	UK71901			UNEXPECTED UNLOADING TABLE SPACE DEFINED WITH DEFINE NO OPTION
PM39636	1_Aug 2011	UK70403			UNLOAD GENERATES MESSAGE INZZ001S AND ABEND U0027
PM38671	17_Jun 2011	UK68872			ABENDU1132 WITH REASON CODE B ISSUED DURING THE UNLOAD OF A LOB
PM37619	1_Jun 2011	UK68368			ABENDU1125 WITH R15=X'10'
PM39334	1_Jun 2011	UK68368			HPU UNLOAD ENDS CC 8 WITH NO EXPLANATORY ERROR MSG.
PM37530	1_Jun 2011	UK68368			INZU016E ISSUED INCORRECTLY
PM37581	1_Jun 2011	UK68368			HPU LOGICAL UNLOAD OF SQL WITH MORE THAN 5 GRAPHIC OR VARGRAPHICCOLUMNS CONCATONATED
PM39331	1_Jun 2011	UK68368			CONCATONATED GRAPHIC DATA WITH RESULTING GREATER THAN 127 CHARACTERS SHOULD BE PROCESSED AS VARGRAPHIC
PM34446	29_Apr 2011	UK67265			HPU UNLOAD STOPS COMPLETES WITH CC 8 AND ISSUES INZI174E AFTER INSTALLING DB2 APAR PM23243.
PM35510	29_Apr 2011	UK67265			HPU UNLOADS FROM LOCAL TABLE EVEN THOUGH FROM CLAUSE SPECIFIES THREE PART NAME
PM33987	11_Apr 2011	UK66638			UNLOAD SPECIFYING DDLDDN & IMAGE COPY DOESN'T UNLOAD ALL RECORDS
PM34425	11_Apr 2011	UK66638			HPU FOR Z/OS ABENDU1005 WITH R15=0X2C DURING UNLOAD OF PARTITIONED TABLESPACE WITH PARELLELISM
PM34875	11_Apr 2011	UK66638			ABEND 0C4 OCCURS WHILE UNLOADING THE DATA FROM THE IMAGE COPY OFA PARTITION-BY-GROWTH
PM23952	28_Feb 2011	UK65291			VARIOUS FAILURES AFTER THE APPLY OF DB2 PTFS UK56261 OR UK56262.
PM31895	28_Feb 2011	UK65291			UNLOAD RC8 SELECT DISTINCT * SYNTAX ERROR INZU016E OR INZU096E
PM31681	28_Feb 2011	UK65291			S0C4 , U1017 OR OTHER ABEND DURING LOGICAL UNLOAD IN NON NATIVE MODE UNLROWSET OR ULROWSET > 1 AND DB2 V8 OR HIGHER
PM29346	16_Feb 2011	UK64905			UNLOAD GENERATES ABEND878 RC10
PM31001	16_Feb 2011	UK64905			DB2 HPU FOR Z/OS FAILS WITH ABENDU1113 UNLOADING TABLE WITH VARCHAR COLUMN WITH FIELDPROC
PM30244	28_Jan 2011	UK64362			LOGICAL UNLOAD GENERATES MESSAGES INZU025E AND INZU063I
PM27476	28_Jan 2011	UK64362			UNLOAD GENERATES MSG INZU366I WHEN TS IS IN COPY PENDING
PM16848	28_Dec 2010	UK63536			INCORRECT OUTPUT USING FASTUNLOAD SYNTAX.
PM26761	28_Dec 2010	UK63536			LOGICAL UNLOAD GENERATES MESSAGES INZU025E AND INZU063I
PM27285	28_Dec 2010	UK63536			DB2 HPU FOR Z/OS FASTUNLOAD COMPATIBILITY PROBLEM
PM27221	28_Dec 2010	UK63536			UNLOAD RC04 WITH NULLIF, CASE EXP, FASTUNLOAD DEFAULT IF, OR UNLOAD PLUS IF
PM18108	28_Dec 2010	UK63536			INZI164E ERROR WHEN TRYING TO QUIESCE THE TABLESPACE
PM26741	28_Dec 2010	UK63536			DB2 FOR Z/OS ENDS WITH INZU238E PERFORMING LOGICAL UNLOAD WHERE SQL STATEMENT INVOLVES COMPARISON WITH CONSTANT
PM24699	18_Nov 2010	UK62316			VARIOUS DB2 HPU FOR Z/OS ABENDS LIKE 0C1 OR 0C7
PM24566	18_Nov 2010	UK62316			INZU063I UNSUPPORTED SELECT USING A WITH COMMOM-TABLE-EXPRESSION
PM23419	10_Nov 2010	UK62056			DB2 FOR Z/OS HPU ABENDU1021 WITH R15=0
PM23412	10_Nov 2010	UK62056			ABEND0C7 UNLOAD INZUTILK
PM21044	19_Oct 2010	UK61475			DB2 HPU ISSUES INZI187E ERRONEOUSLY IN DATA SHARING ENVIRONMENT
PM21332	19_Oct 2010	UK61475			ABEND80A-10 WHEN THE EXPRESSION INVOLVES THE CONCAT FUNCTION.
PM20970	19_Oct 2010	UK61475			ABEND0C4 IN MODULE INZUTILK
PM21750	19_Oct 2010	UK61475			PROBLEMS FOUND DURING INTERNAL TESTING
PM15452	1_Sep 2010	UK60175			DSNT404I SQLCODE = 098, WARNING: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON
PM17520	1_Sep 2010	UK60175			UNLOAD GENERATING MSG INZU035E
PM12353	1_Sep 2010	UK60175			PANEL INZB601I OUTDDN PCOMM ISPP121 ERROR
PM11310	23_Aug 2010	UK59920			INZU031E DUE TO DUPLICATE FORMAT STATEMENT
PM17930	23_Aug 2010	UK59920			INCORRECT OUTPUT WHEN UNLOADING UNLOAD INTEGER OR DECIMAL DATA.
PM16782	16_Jul 2010	UK58895			ABENDU1134-0A WITH BAD REG2.
PM15064	16_Jul 2010	UK58895			AN S0C4 ABEND MAY OCCUR WHILE UNLOADING FROM AN INLINE IMAGE COPY.
PM16670	16_Jul 2010	UK58895			ABENDU1022 OR INCORROUT ON UNLOAD FIC
PM15997	16_Jul 2010	UK58895			INZU238E INVOLVING A CASE EXPRESSION.
PM11773	18_Jun 2010	UK58096			HPU FAILS WITH INZUT4-2 UNLOADING A PARTITIONED TABLE SPACE
PM13753	18_Jun 2010	UK58096			S0C4 WITH LISTDEF AND INCORRECT LOAD STMT SPECIFYING DELIMTED FORMAT
PM12576	18_Jun 2010	UK58096			MESSAGE INZU238E AND INZU366I RC08 FOR SELECT STATEMENT
PM12601	18_Jun 2010	UK58096			UNLOAD IMAGE COPY GENERATES MSG FIELD OVERLAP END OF RECORD OR S0C7 OR S0C4
PM13741	18_Jun 2010	UK58096			ABEND0C4 MAY OCCUR WHEN SPECIFYING PROCESS_OPTIONS OFF
PM12701	18_Jun 2010	UK58096			UNLOAD GENERATES INCORRECT FORMAT WHEN DATE OR TIME FORMAT IS DEFINED AS LOCAL
PM13742	18_Jun 2010	UK58096			INCORRECT OUTPUT GENERATED FOR PARTITIONED TABLESPACE
PM10002	8_Jun 2010	UK57796			PROVIDE TOLERATION SUPPORT FOR DB2 V10
PM11040	13_May 2010	UK56942			CHANGE THE CONTENT OF INZIVP BY ADDING THE ASIS OPTION.
PM11338	13_May 2010	UK56942			ABEND0C4 WITH INZU063I
PM11330	13_May 2010	UK56942			ABENDU1208 WITH MESSAGE IKJ56228I
PM11505	13_May 2010	UK56942			INCORRECT OUTPUT CONVERTING A NUMERIC COLUMN INTO A CHAR(30)
PM04546	22_Apr 2010	UK56338			ABENDU1132 REASON CODE = 00000008
PM04338	22_Apr 2010	UK56338			INCORRECT RESULT WHEN USING BMC SYNTAX WITH FORMAT CSV
PM11110	22_Apr 2010	UK56338			UNLOAD WITH PIC GENERATES INCORRECT OUTPUT DATA
PM06961	22_Apr 2010	UK56338			ADD NEW INZTVAR PARM VUM032/ACTGUSR
PM08077	22_Apr 2010	UK56338			HPU DOES NOT ACCEPT A WHERE CLAUSE THAT CONTAINS QUANTIFIED PREDICATES.
PM07299	22_Apr 2010	UK56338			INZU373I CONTAINS INCORRECT SUBSYSTEM
PM04636	22_Apr 2010	UK56338			MSG INZI331E UNLOADING LOBS
PM11107	22_Apr 2010	UK56338			ABEND U1003 MAY OCCUR FOR PARMS MAXPART, ONDEMAND RESOURCE ALLOCUSING TEMPLATE AS OUTPUT FILE
PK93732	3_Mar 2010	UK54862			INZU016E OUTDDN STATEMENT SYNTAX IS INVALID
PM02518	3_Mar 2010	UK54862			MESSAGE INZT035E WITH UNSUPPORTED SELECT STATEMENT.
PM03602	3_Mar 2010	UK54862			ABEND0C4 WHEN THE UNLOAD COMMAND SPECIFIES A TABLE SPACE NAME.
PM04313	24_Feb 2010	UK54648			DSNT408I SQLCODE = -551, ERROR: USER IS LACKING PRIVILEGES FOR SELECT ON OBJECTS WITH SYSIBM.SYSKEYS
PM04752	24_Feb 2010	UK54648		HIPER	ABENDU1004 WHEN USING DEFINE NO. 10/02/11 PTF PECHANGE
PK96998	5_Feb 2010	UK54186			UNLOAD PARALLELISM ABEND 878 RC10
PM02620	5_Feb 2010	UK54186			HPU IS RUNNING SLOWER THAN DSNUTILB
PK92649	16_Dec 2009	UK52952	PM04752		PANEL INZP00 EXECUTING INZT01 ERROR
PK93933	16_Dec 2009	UK52950			HPU FORMAT EXTERNAL GENERATES INCORRECT OUTPUT WITH A LEADING ZERO
PK98700	16_Dec 2009	UK52952	PM04752		SQLCODE -331 WITH CORRUPTED DATA.
PK98118	28_Oct 2009	UK51516		HIPER	INTERNAL DEFECT FIXES

Top of page