A fix is available
APAR status
Closed as program error.
Error description
Various issues can occur when attempting to unload the data from an image copy if the DDLDDN option is used and the provided DDL describes a table which definition includes an as-row-change-timestamp clause (i.e. FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP). The known issues are : - the unload ends with completion code 0 but the output data are incorrect and the generated LOAD statement is wrong (the columns having a sequence number less than or equal to the sequence number of the comlumn with the as-row-change-timestamp clause are missing) - the unload ends with completion code 8 and issues the irrelevant INZU024E COLUMN cccc IS NOT PART OF THE TABLE. For example: If the data set referred by the DDLDDN option contains the following table definition: CREATE TABLE DMVKAR1.TKAR05 ( COL01 INTEGER NOT NULL ,COL02 CHAR(08) ,COL03 CHAR(08) NOT NULL ,COL04 CHAR(08) NOT NULL WITH DEFAULT USER ,COL05 VARCHAR(48) ,COL06 DATE ,COL07 DATE NOT NULL ,COL08 DATE NOT NULL WITH DEFAULT ,COL09 VARCHAR(48) NOT NULL ,COL10 TIMESTAMP ,COL11 TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP ,COL12 TIMESTAMP NOT NULL WITH DEFAULT ,COL13 VARCHAR(72) NOT NULL WITH DEFAULT '*** COL13 - TKAR05 USES ROW ATTRIBUTES ***' ,COL14 VARCHAR(36) NOT NULL WITH DEFAULT ,PRIMARY KEY (COL01,COL03) the following unload UNLOAD TABLESPACE DMVKAR.SKAR05 COPYDDN FIC01,INLINE DDLDDN DDLDDN1 DB2 NO QUIESCE NO SELECT * FROM DMVKAR1.TKAR05 ORIGINOBID 0 OUTDDN (SYSREC) LOADDDN (SYSCNTL) FORMAT DSNTIAUL the output data are incorrect and the LOAD statement is as follows: LOAD DATA LOG NO REPLACE EBCDIC CCSID(0037) INTO TABLE DMVKAR1.TKAR05 ( COL12 POSITION ( 1 ) TIMESTAMP EXTERNAL ( 26 ) , COL13 POSITION ( 27 ) VARCHAR , COL14 POSITION ( 101 ) VARCHAR ) where the expected coloumns COL01 to COL11 are missing. With the follwing unload (and the same DDLDDN data set) UNLOAD TABLESPACE DMVKAR.SKAR05 COPYDDN FIC01,INLINE DDLDDN DDLDDN1 DB2 NO QUIESCE NO SELECT COL02 FROM DMVKAR1.TKAR05 ORIGINOBID 0 OUTDDN (SYSREC) LOADDDN (SYSCNTL) FORMAT DSNTIAUL the unload fails with RC 8 and issues INZU024E COLUMN COL02 IS NOT PART OF THE TABLE. PB11785
Local fix
Remove the as-row-change-timestamp clause (FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP) from the DDLDDN data set.
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: Various issues can occur when * * attempting to unload the data from an * * image copy if the DDLDDN option is * * used and the provided DDL describes a * * table which definition includes an * * as-row-change-timestamp clause (i.e. * * FOR EACH ROW ON UPDATE AS ROW CHANGE * * TIMESTAMP). * * The known issues are : * * - the unload ends with compeltion code * * 0 but the output data are incorrect * * and the generated LOAD statement is * * wrong (the columns having a sequence * * number less than or equal to the * * sequence number of the comlumn with * * the as-row-change-timestamp clause * * are missing) * * - the unload ends with completion code * * 8 and issues the irrelevant INZU024E * * COLUMN cccc IS NOT PART OF THE TABLE. * * For example: * * If the data set referred by the DDLDDN * * option contains the following table * * definition: * * CREATE TABLE DMVKAR1.TKAR05 * * COL01 INTEGER NOT NULL * * ,COL02 CHAR(08) * * ,COL03 CHAR(08) NOT NULL * * ,COL04 CHAR(08) NOT NULL * * WITH DEFAULT USER * * ,COL05 VARCHAR(48) * * ,COL06 DATE * * ,COL07 DATE NOT NULL * * ,COL08 DATE NOT NULL * * WITH DEFAULT * * ,COL09 VARCHAR(48) NOT NULL * * ,COL10 TIMESTAMP * * ,COL11 TIMESTAMP NOT NULL * * GENERATED BY DEFAULT * * FOR EACH ROW ON UPDATE * * AS ROW CHANGE TIMESTAMP * * ,COL12 TIMESTAMP NOT NULL * * WITH DEFAULT * * ,COL13 VARCHAR(72) NOT NULL * * WITH DEFAULT '*** COL13 - * * TKAR05 USES ROW ATTRIBUTES ***' * * ,COL14 VARCHAR(36) NOT NULL * * WITH DEFAULT * * ,PRIMARY KEY (COL01,COL03) * * the following unload * * UNLOAD TABLESPACE * * DMVKAR.SKAR05 * * COPYDDN FIC01,INLINE * * DDLDDN DDLDDN1 * * DB2 NO * * QUIESCE NO * * SELECT * * * FROM DMVKAR1.TKAR05 * * ORIGINOBID 0 * * OUTDDN (SYSREC) * * LOADDDN (SYSCNTL) * * FORMAT DSNTIAUL * * the output data are incorrect and the * * LOAD statement is as follows: * * LOAD DATA * * LOG NO REPLACE * * EBCDIC CCSID(0037) * * INTO TABLE DMVKAR1.TKAR05 * * ( * * COL12 * * POSITION ( 1 ) * * TIMESTAMP EXTERNAL ( 26 ) * * , * * COL13 * * POSITION ( 27 ) VARCHAR * * , * * COL14 * * POSITION ( 101 ) VARCHAR * * ) * * where the expected coloumns COL01 to * * COL11 are missing. * * With the follwing unload (and the same * * DDLDDN data set) * * UNLOAD TABLESPACE * * DMVKAR.SKAR05 * * COPYDDN FIC01,INLINE * * DDLDDN DDLDDN1 * * DB2 NO * * QUIESCE NO * * SELECT COL02 * * FROM DMVKAR1.TKAR05 * * ORIGINOBID 0 * * OUTDDN (SYSREC) * * LOADDDN (SYSCNTL) * * FORMAT DSNTIAUL * * the unload fails with RC 8 and issues * * INZU024E COLUMN COL02 IS NOT PART OF * * THE TABLE. * * pb11785 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The oddlx2y module was fixed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM79796
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-12-28
Closed date
2013-03-27
Last modified date
2013-04-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZCRXSM
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021