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 2.1
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
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 USING OEM 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 INTO THE 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 4700 SQLSTATE 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 MSG IF 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 MSGINZU191 MSGINZU191I.
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 VARCHAR COLUMNS 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 WITHOUT AN 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 POINT TO 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 VALUES IN 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