|
DB2 High Performance Unload for z/OS Version 4.3
|
|||||
| APAR | CLOSE DATE |
PTF(s) | Fixing APAR if PE |
HIPER? | Abstract |
|---|---|---|---|---|---|
2018 |
POTENTIAL ABEND WHILE UNLOADING THE DATA FROM IMMAGES COPIES FORMORE THAN 9 TABLESPACES | ||||
2018 |
ABENDS0C4 ON LOGICAL UNLOAD WITH ORDER CLAUSE FROM A PBR2 TABLE SPACE | ||||
2018 |
AN INTERMITTENT ABENDS0C4 CAN OCCURS WHEN UNLOADING LOB DATA FROM A PARTITIONNED TABLE SPACE | ||||
2018 |
ABENDS0C4 OR NEVER ENDING LOOP IF DDLDDN WITH NOT NULL WITH DEFAULT AS SECURITY LABEL | ||||
2018 |
ENHANCEMENT AND FIXES OF THE DDL GENERATION FEATURE (LOADDDL TABLE OPTION OR CNTLCARDS_DB2(DDL) IN VUU030/ULOPTNS). | ||||
2018 |
INZI503E IF DDLDDN SPECIFIES IMPLICITLY HIDDEN OR INLINE LENGTH OR GENERATED ... AS | ||||
2018 |
INCORRECT AUTOTAG FIELD AND WHEN CLAUSE WHEN ORIGINOBID OPTION IS SPECIFIED | ||||
2018 |
INCORRECT WHEN CLAUSE IF AUTOTAG OPTION SPECIFIED AND DATA WITH NON-EBCDIC ENCODING SCHEME | ||||
2018 |
ALLOW TO DISABLE BIF COMPATIBILITY RETRIEVAL FROM DB2 SETTINGS | ||||
2018 |
IRRELEVANT INZU460I IS ISSUED FOR A DB2 FORCE UNLOAD | ||||
2018 |
DDLDDN: INZU366I WITH REASON CODE 0X32A00B IF DDLDDN FILE CONTAINS A FOR UPDATE CLAUSE IN THE "FREE BLOCK" | ||||
2018 |
PERFORMANCE ENHANCEMENT OF NATIVE UNLOADS INVOLVING LOBS | ||||
2018 |
ABENDU1132 WHEN UNLOADING BIG LOB DATA IN NATIVE MODE | ||||
2018 |
WRONG DDLDDN FILE ANALYSIS IF APPEND / LOGGED / COMPRESS / DSSIZE / BUFFERPOOL / MEMBER | ||||
2018 |
INVALID LOAD CONTROL CARD IF SHRLEVEL REFERENCE IN LOADOPT | ||||
2018 |
A LOGICAL UNLOAD FAILS WITH DSNT408I SQLCODE = -4742, ERROR: ...(REASON 4) | ||||
2018 |
CLONE/MATERIALIZED/HISTORY TABLE NOT UNLOADED IF DEFINED THROUGHLISTDEF | ||||
2017 |
UNLOAD FROM IMAGE COPY FAILS AFTER IKJ56228I FILE HPU00000 NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED | ||||
2017 |
DB2 HPU REPEATEDLY ALLOCATES THE LOB AUXILIARY TABLE SPACES | ||||
2017 |
INZI010E INTERNAL CONVERSION ERROR BETWEEN CCSID XXXXX AND CCSIDYYYYY | ||||
2017 |
INZU016E EXPRESSION STATEMENT SYNTAX IS INVALID IF "NOT" CHARACTER USED IN THE SYSIN | ||||
2017 |
HPU TO BE ABLE TO PUT THE NULL INDICATOR GROUPED AT THE BEGINNING OF THE RECORD | ||||
2017 |
INVALID LOAD CONTROL CARDS LEAD TO DSNU088I DSNUGTIS - INVALID CHARACTER OPERAND - ''' IN DB2 LOAD. | ||||
2017 |
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B) WHEN DDLDDN CONTAINS INCORRECT SYNTAX | ||||
2017 |
MISLEADING MSGINZU095E SYNTAX ERROR - PROCMSG/SELMSG KEYWORD ONLY VALID WITH UNLOAD BLOCK | ||||
2017 |
LAST RECORD MISSING FROM PROCMSG IF DD IS EXPLICITLY ALLOCATED | ||||
2017 |
INZU015E GLOBAL STATEMENT : UNEXPECTED KEYWORD NOT CLEAR ENOUGH | ||||
2017 |
IRRELEVANT ENDING LETTER FOR INZU211W MESSAGE ASSOCIATED WITH RC 0 | ||||
2017 |
INZX133 SSSSSSSS NO VALID INPUT DDNAME DDDD FOUND | ||||
2017 |
S0C4 WHEN NATIVELY UNLOADING AN XML COLUMN | ||||
2017 |
SUPPORT OF THE COMPRESSED LOB | ||||
2017 |
ENCLOSEDBY SUB-OPTION OF CSV FORMAT ONLY TAKEN INTO ACCOUNT FOR THE FIRST SELECT OF A SAME UNLOAD STATEMENT. | ||||
2017 |
PROVIDE APPLCOMPAT OPTION AT THE JOB LEVEL VIA HPU PARM. | ||||
2017 |
INZU474I DATA TYPE FOR TARGET COLUMN COLUMN-NAME NOT SPECIFIED BY INTO CLAUSE BUT NO INTO WAS REQUESTED. | ||||
2017 |
PANEL CCQPLPR SHOWS SINZPLIB RATHER THAN SINZPANL | ||||
2017 |
INCOMPLETE DATASET NAME IN THE GENERATED LOAD CONTROL CARDS WHENTEMPLATE AND GDG ARE USED. | ||||
2017 |
UNLOAD FAILS WITH SQLCODE = -4742 REASON 2 | ||||
2017 |
UNLOAD PLUS COMPATIBILITY: TOLERATE NEW/RESTART IN PARM | ||||
2017 |
INCORRECT NUMBER OF ROWS AND/OR EMPTY ROWS AFTER FIX FOR PI72114 17/08/03 PTF PECHANGE |
||||
2017 |
NON-DELIMITED SQL KEYWORDS NOT SUPPORTED AS COLUMN NAME IN DDLDDN FILE. | ||||
2017 |
TRIM OPTION AND TRIM SCALAR FUNCTION: CHAR/VARCHAR FOR BIT DATA DATA NOT TRIMMED | ||||
2017 |
ABENDS0C2 WHEN UNLOADING IN SQL MODE WITH DB2 PARALLELISM | ||||
2017 |
INVALID DATE EXTERNAL(4) IN GENERATED LOAD STATEMENT IF REFORMAT/INTO CLAUSE INTO DATE DATA TYPE | ||||
2017 |
THE DATACLAS, MGMTCLAS OR STORCLAS OPTIONS OF A TEMPLATE STATEMENT ARE NOT TAKEN INTO ACCOUNT. | ||||
2017 |
MSGINZU366I UTILITY RC 8 (REASON CODE 0X130A00B) AGAINST A FLASHCOPY IMAGE COPY. | ||||
2017 |
THE UNLOAD PROCESS FAILS IN ABENDS12F WITH REASON CODE 28. | ||||
2017 |
UNLOAD FAILS - INZI503E WHEN MINVALUE OR MAXVALUE OPERAND OF AN AS-IDENTITY-CLAUSE GREATER THAN 2147483647. | ||||
2017 |
CHARACTER, GRAPHIC AND MIXED COLUMNS OF THE TARGET TABLE UNEXPECTEDLY ENCODED IN UNICODE INSTEAD O 17/02/20 PTF PECHANGE |
||||
2017 |
DUPLICATE TEMPLATE ANALYSIS MESSAGES IF TEMPLATE LIBRARY CONTAINS ERRORS | ||||
2017 |
ABENDS0C4 ON SQL MODE UNLOAD AGAINST A PARTITIONED TABLE SPECIFYING SQLPART | ||||
2017 |
INCONSISTENT RESULTS WHEN UNLOADING FROM BAD IMAGE COPY | ||||
2017 |
UNLOAD FAILS WITH ABENDU1022 R15=0 WHEN THE TABLE SPACE VSAM DATA SET CONTAINS RECORDS W/ VERSION 0 | ||||
2017 |
INZU042E & INZU516E UNLOADING FROM A UTS BY GROWTH COPY MADE BEFORE ADDED THE LAST PARTITION | ||||
2017 |
INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B) | ||||
2017 |
ABENDS0C4 OR INCORRECT DATA UNLOADING FROM IMAGE COPY | ||||
2017 |
SETTINGS FOR VUX038/CHECKINT IGNORED | ||||
2017 |
ABENDS0C4 UNLOADING FROM IMAGE COPY WITH DDLDDN IF DESCREPANCY BETWEEN THE TABLE SPACE AND INDEXPARTITION NUMBERS | ||||
2017 |
MISSING ROWS UNLOADING CONATENATESDINLINE IC OF VERY SMALL PARTITIONS OF PBR2 | ||||
2017 |
DB2 HPU MIGHT ABEND OR HAVE POOR PERFORMANCE IF THE LE OPTIONS ARE NOT SUITABLE TO DB2 HPU. | ||||
2017 |
INDEXSCAN FEATURE IS LESS USED THAN EXPECTED WITH AN ORDER CLAUSE | ||||
2017 |
REMOVE THE BRACKET RESTRICTION IN NATIVE HPU SYNTAX SPECIFYING PARTITIONS | ||||
2017 |
MESSAGE TO INFORM THAT A DEFAULT OUTPUT DATA TYPE IS ASSUMED IF OUTPUT-DATA-TYPE NOT SPECIFIED IN INTO CLAUSE | ||||
2017 |
INZQRY11 BIND FAILS WITH SQLCODE=-4700 STATEMENT=709 IN A DB2 V11 CM MODE WITH THE PTF UI43511 INSTALLED 17/01/25 PTF PECHANGE |
||||
2017 |
UNLOAD USING EXPRESSIONS WITH CHAR(DECIMAL_DATA) AND VARCHAR(DECIMAL_DATA) COULD BE INCORRECT. | ||||
2017 |
EXPECTED DDL NOT GENERATED IF FROM A VIEW (NOT TABLE) | ||||
2017 |
THE INDEX SCAN FEATURE ELIGIBLE FOR A LOGICAL UNLOAD WITH AN ORDER CLAUSE IS ENABLED BUT NOT USED. | ||||
2017 |
PACKAGE VERSIONING WILL BE REINSTATED, SQLCODE805 | ||||
2017 |
UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN SQL MODE | ||||
2017 |
ABENDS0C4 IN ISPF INTERFACE WITH DB2 12 | ||||
2017 |
SUPPORT ADDED TO ALLOW DECIMAL DATA TO BE CAST AS TIME OR DATE WHEN UNLOADING FROM AN IMAGE COPY | ||||
2016 |
SYNCHRONIZE INZU469W/E AND INZU283W/E MESSAGES WITH THE ASSOCIATED RETURN CODE 4/8. | ||||
2016 |
BETTER ADDRESS INZU395E HANDLING | ||||
2016 |
MSGINZU016E OUTDDN STATEMENT SYNTAX IS INVALID WITH UNSUPPORTED SELECT NOT TERMINATED WITH A SEMICOLON | ||||
2016 |
UNEXPECTED MSGS INZT028E, INZU469E, INZU283E, INZC003E COULD BE ISSUED WHEN TEMPLATE IS USED. | ||||
2016 |
UNLOAD FAILS WITH CC08 WITH MSGINZU016E LOADDDN IS INVALID OR MSGINZU016E DDLDDN STATEMENT SYNTAX IS INVALID. | ||||
2016 |
UNLOADING XML DATA AN EBCDIC TABLESPACE UNLOADED WITH ASIS NOT CONVERTED INTO EBCDIC 16/11/07 PTF PECHANGE |
||||
2016 |
INZU238E UNEXPECTED UNSUPPORTED SELECT UTILITY CANNOT SWITCH TO SQL PROCESSING | ||||
2016 |
ABENDS0C4 (INZZ001S(0001): ABEND IN INZUTILK - CODE=S0C4 U0000 REASON=00000011) WHEN LISTDEF IS INVALID. | ||||
2016 |
MISLEADING MESSAGE INZI345I WHEN QUESTION MARK (?) PATTERN-MATCHING CHARACTER IS USED IN LISTDEF | ||||
2016 |
UNLOAD FROM AN ALIAS FAILS WITH CC=8 AND MSGINZU066E NO TABLESPACE FOUND FOR TABLE TABLE_NAME | ||||
2016 |
THE ALTER DROP COLUMN STATEMENT FOLLOWED BY A REORG DOES NOT REMOVE THE VERSION 0 FROM THE CATALOG. | ||||
2016 |
AN UNLOAD ENDS WITH A NORMAL COMPLETION CODE WHILE AN I/O ERROR OCCURRED. | ||||
2016 |
UNEXPECTED MSGINZU020E AND RC08 WHEN UNLOADING FROM SYSTABLES. | ||||
2016 |
WITH HPU 4.3, IN UNDETERMINED SITUATIONS DB2 HPU MIGHT END WITH ABENDS0C4 AFTER HAVING ISSUED A MSG. CEE0374C CONDITION=CEE3204S |
||||
2016 |
UNICODE INSTEAD OF EBCDIC SPECIFIED IN THE LOAD STATEMENT GENERATED WITH LOADDDN OPTION RUN IN NATIVE MODE | ||||
2016 |
NO RESULTS AND SQLCODE104 RUNNING HPU ONLINE CLIST | ||||
2016 |
HPU NOW SUPPORTS THE UNLOAD PLUS CNTLCARDS DB2 INSTEAD OF MSGINZU027W | ||||
2016 |
ABENDS0C4 IN UNLOAD PLUS WITH "INFILE DDNAME INCREMENTAL" | ||||
2016 |
HPU WITH UNLOAD PLUS SYNTAX SPECIFYING INFILE DDNAME INCREMENTAL | ||||
2016 |
RETPD PARAMETER FROM THE TEMPLATE STATEMENT IS IGNORED | ||||
2016 |
UNEXPECTED INZI181E WHEN USING SQLPART OPTION. | ||||
2016 |
DB2 SUPPORT 1 | ||||
2016 |
PADDING_STRICT(NO) IS REMOVED | ||||
2016 |
DISABLE 'FOR READ ONLY' CLAUSE SUPPORT | ||||
2016 |
DBMDSSID VALUE 1215 INSTEAD OF 1010 | ||||
2016 |
ABENDS0C4 UNLOADING FROM IMAGE COPY | ||||
2016 |
MSGINZRE42 AND COMPLETION CODE 8 WHEN ATTEMPTING TO RUN HPU UNLOAD AGAINST THE TABLE SPACE (I.E. IN NATIVE MODE). | ||||
2016 |
UNEXPECTED INZI158E ERROR WHEN TRYING TO OBTAIN A SHARED LOCK ONTABLE : XXXX.YYYY | ||||
2016 |
HPU IGNORES FLASHCOPY DATA SET CREATED WITH THE OPTION CONSISTENT | ||||
2016 |
ABENDS0C4 OR INZU499E | ||||
2016 |
UNEXPECTED INZI330E DYNAMIC ALLOCATION FAILED | ||||
2016 |
ABEND0C4 | ||||
2016 |
UNEXPECTED INZU016E STATEMENT SYNTAX IS INVALID | ||||
2016 |
THE REFORMAT (TYPE TIMESTAMP INTO TIMESTAMP_X) OPTION HAS NO EFFECT AND OUTPUT FORMAT OF THE TIMESTAMP IS DEFAULT ONE. | ||||
2016 |
SOME UNDUE THUS MISLEADING MESSAGES ARE ISSUED RIGHT AFTER THE MESSAGE INZU283E/UDBU283E HAS BEEN ISSUED. | ||||
2016 |
THE INZI012E IN UNLOAD PLUS SYNTAX WITH TWO SELECT STATEMENT THAT BOTH REQUIRE THE FORMAT CSV TERMINATEDBY ',' | ||||
2016 |
LOGICAL UNLOAD WITH ORDER CLAUSE FAILS DURING THE SORT PHASE WITH ABENDU1017 OR ABENDU1009 | ||||
2016 |
INZU283E ERROR IN TEMPLATE LIBRARY DDNAME | ||||
2016 |
WAIT FOR MIGRATED DATA SETS BE RECALLED | ||||
2016 |
IKJ56221I DATA SET NOT ALLOCATED VOLUME NOT AVAILABLE+ ANOTHER JOB OR USER INZI330E DYNAMIC ALLOCATION FAILED REASON=0X220 | ||||
2016 |
IKJ56221I DATA SET NOT ALLOCATED, VOLUME NOT AVAILABLE IKJ56221I VOLUME ALLOCATED TO ANOTHER JOB OR USER | ||||
2016 |
ADD PARMLIB PARM TO FORCE THE QUIESCE YES OPTION WHEN UNLOAD OF A LOB COLUMN RATHER THAN ABENDU1133 | ||||
2016 |
DB2 12 PRECONDITION | ||||
2016 |
HPU SHOULD NOT SELECT A CONCURRENT IMAGE COPY WHEN THE COPYDDN LAST_IC OR COPYDDN INTEGER OPTION | ||||
2016 |
A PHYSICAL UNLOAD (UNLDDN) IN INTERNAL FORMAT (INTERNAL_FORMAT) PRODUCES INCORRECT OUTPUT DATA THAT CANNOT BE LOADED BY DB2 LOAD |
||||
2016 |
INVALID LOAD STATEMENT IN HPU V4.3 WHEN USING LOADOPT WITH PARTITION OR TABLE LEVEL OPTIONS. | ||||
2016 |
THE TRIM OPTION SPECIFIED IN THE GLOBAL OPTION BLOCK OR IN THE UNLOAD BLOCK IS NOT TAKEN INTO ACCOUNT. | ||||
2016 |
MISSING EXPECTED INZU380I INFORMATION : DEFAULT OUTPUT FORMAT MESSAGE | ||||
2016 |
A FAILURE IN QUIESCE UTILITY INITIATED BY DB2 HPU AND MSGDSNU024I DSNUTILB - PARM FIELD ERROR - 'SSID,UID.JOBNAME' | ||||
2016 |
THE MESSAGE INZU131W DISPLAYS UNREADABLE CHARACTERS. | ||||
2016 |
INZU366I UTILITY RETURN CODE 8, INZU310E CCSID 1140 IS NOT MIXEDINZU310E CCSID 1140 IS NOT DBCS | ||||
2016 |
ABENDS0C4 UNLOADING FROM A FLASHCOPY DATA SET OF A TABLE SPACE HAVING ONLY ONE PARTITION. | ||||
2016 |
ABENDS0C4 OR OTHER UNPREDICTABLE RESULT UNLOADING FROM FLASHCOPYOF TABLE SPACE OR PARTITION IN BRF (BASIC ROW FORMAT). | ||||
2015 |
ABENDU4093 REASON CODE=90 U1017 | ||||
2015 |
ALLOW TO UNLOAD NULL VALUES AS A STRING THAT INDICATES A NULL VALUE IN THE OUTPUT FILE WHEN THE DELIMITED FORMAT IS REQUESTED. |
||||
2015 |
PACKAGING PROBLEM LEADING TO MISSING FIX | ||||
2015 |
UNEXPECTED PADDING OF THE NULL VALUE | ||||
2015 |
SORT PERFORMED WITH FIXED LENGTH FIELDS (THE SORT PARAMETER TYPE=F IS SPECIFIED WHILE TYPE=V IS EXPECTED) | ||||
2015 |
UNLOADED RECORDS SORTED INCORRECTLY IN NATIVE MODE | ||||
2015 |
UNLOAD WITH UNLOAD PLUS SYNTAX REQUESTING BIGINT DATA | ||||
2015 |
CONFUSING MSGINZU063I UNSUPPORTED SELECT UNLOADING TABLE WITH SYSIBM.SYSTABLES COLUMN TYPE NOT T, C, M OR V | ||||
2015 |
A NEW PARAMETER (VUU076/ULICTYPE) TO BE SET VIA TOOLS CUSTOMIZER | ||||
2015 |
HPU REPORTS EMPTY TABLESPACE UNLOADING HISTORY TABLE IN SQL MODE | ||||
2015 |
SUPPORT UNLOADING TEMPORAL TABLE OF 'H' IN NATIVE MODE | ||||
2015 |
NEW PARAMETERS (VUU075/ULNULLP, ONE PER OUTPUT FORMAT) TO BE SETVIA TOOLS CUSTOMIZER WOULD BE ADDED. | ||||
2015 |
HELP TO NAVIGATE FROM INZB101I TO UPPER LEVEL PANELS | ||||
2015 |
IMPROVE 'FORMAT VARIABLE END' SUPPORT | ||||
2015 |
WRONG DB2 VERSION DISPLAYED IN HPU UNLOAD JOBLOG IN THE MSGINZI020I | ||||
2015 |
OPTIONS FOR CNTOLCARDS CONCATENATED WITHOUT ADDING EXPECTED BLANK CHARACTER | ||||
2015 |
QUIESCE YES/NO NOT ACCEPTED IN SYSIN IN UNLOAD PLUS SYNTAX | ||||
2015 |
ADD SUPPORT OF USELRECL IN SYSIN | ||||
2015 |
NEW ULOPTNS OPTION FMT_VAR_FB_IF_FIXED FOR FORMAT VARIABLE TO UNLOAD TO FB FILE IF NO VARCHAR COLUMN PRESENT | ||||
2015 |
LIMIT OPTION FOR TEMPLATE IS IGNORED | ||||
2015 |
ABENDU101 WITH DB2 FORCE UNLOADING PARTITIONED TABLE WITH TEMPLATE NAME ENDING WITH A NUMBER AND EXTERNAL SORT. | ||||
2015 |
INSURE HPU V4.3 CREATES NECESSARY DIAGNOSTICS | ||||
2015 |
INZU039E FATAL SYNTAX ERROR BEFORE LINE LLL COLUMN CC INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X107A002) | ||||
2015 |
ABENDU1003 WHEN UNLOAD FROM AN IMAGE COPY (COPYDDN) | ||||
2015 |
INCORRECT LOAD STATEMENT CREATED CONTAINING SAME NUMBER OF LOAD COMMANDS AS TABLES INVOLVED | ||||
2015 |
ABENDS0C1 MSGIEW2454W 9203 SYMBOL UNRESOLVED. NO AUTOCALL (NCAL) SPECIFIED ON NEW INSTALL | ||||
2015 |
ROWS FROM ONE PARTITION WRITTEN IN OUTFILE OF ANOTHER PARTITION,LEADS TO UNEXPECTED EXTRA NUMBER OF ROWS O 15/05/15 PTF PECHANGE |
||||
2015 |
ABENDS0C4 RUNNING AN UNLOAD FASTUNLOAD SYNTAX | ||||
2015 |
DECREASE THE AMOUNT OF TIME A PARTITION OF THE UNLOAD TABLE SPACE IS UNAVAILABLE TO OTHER PROGRAMS | ||||
2015 |
HPU SHOULD CREATE LOAD STATEMENT NAME CONSISTENTLY WITH UNLOAD PLUS SYNTAX | ||||
2015 |
THE LOCK YES OPTION IS IGNORED WHEN THE UNLOAD IS PROCESSED IN SQL MODE. | ||||
2015 |
UNEXPECTED TABLE NAME SPECIFIED IN HPU GENERATED LOAD STATEMENT USING UNLOAD PLUS SYNTAX | ||||
2015 |
MSGINZU097E SYNTAX ERROR - UNRECOGNIZED ELEMENT WITH FOR UNLOADBLOCK. | ||||
2015 |
MSGINZU097E SYNTAX ERROR - UNRECOGNIZED ELEMENT RTRIM FOR UNLOAD BLOCK | ||||
2015 |
APAR FOR ROLL UP PTF OF CODE FIXES AFTER CODE FREEZE | ||||