A fix is available
APAR status
Closed as new function.
Error description
NEW FUNCTION LOAD OVERRIDE for a ROW CHANGE TIMESTAMP column
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of the LOAD * * utility * **************************************************************** * PROBLEM DESCRIPTION: * * The LOAD utility will be enhanced to * * support a new operand ROWCHANGE for * * the keyword OVERRIDE, which will cause * * LOAD to honor data within a SYSREC for * * GENERATED ALWAYS AS ROW CHANGE * * TIMESTAMP columns specified via a * * field specification. * **************************************************************** * RECOMMENDATION: * **************************************************************** Presently, performing a LOAD directly into a table object that contains a column with attribute GENERATED ALWAYS ROW CHANGE TIMESTAMP while specifying that column in the field specification will generate an RC8 condition. It is possible to specify IGNOREFIELDS YES and replace the column name with DSN_RCTIMESTAMP in the field specification. This will allow users to bypass an RC8 condition and cause a row update with a new timestamp. However, there may be cases where loading different timestamp data into such columns from SYSRECs is desired instead of always getting a new timestamp.
Problem conclusion
Temporary fix
Comments
A new operand ROWCHANGE for keyword OVERRIDE will be added to the LOAD utility which will allow users to load into a GENERATED ALWAYS AS ROW CHANGE TIMESTAMP column using their input value. PH25572 introduces the following changes to externals: LOAD utility syntax diagram change for the override-spec: .-,------------. V | >>OVERRIDE--(---SYSTEMPERIOD-+-)--> +----IDENTITY------+ +-----TRANSID------+ +-NONDETERMINISTIC-+ +----ROWCHANGE-----+ ROWCHANGE Allows data to be loaded into a row change timestamp column that is defined as GENERATED ALWAYS. Specify OVERRIDE(ROWCHANGE) when you are loading a table with data that was previously unloaded and you want to preserve the timestamps in that data. Restrictions You cannot specify OVERRIDE(ROWCHANGE) with the following options: - NULLIF - DEFAULTIF - FORMAT INTERNAL The following messages may be issued: Various existing syntax checking messages will be issued during keyword compatibility checking. - DSNU070I csect-name - KEYWORD OR OPERAND FORMAT INTERNAL INVALID WITH OVERRIDE(ROWCHANGE) (return code = 8) - DSNU269I csect-name - FIELD field-name IS NOT ALLOWED (return code = 8) When specifying incompatible options on a row change generated always timestamp column, the following messages will be issued. - DSNU329I csect-name - FIELD field-name IS NOT DEFAULTABLE (return code = 8) - DSNU336I csect-name - INVALID nullif SPECIFICATION FOR INPUT FIELD field-name (return code = 8) IBM Knowledge Center is updated for this change: http://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0
APAR Information
APAR number
PH25572
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-05-19
Closed date
2020-07-09
Last modified date
2020-08-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70476
Modules/Macros
DSNURWBG DSNURURT DSNUGDDF DSNUGPPF DSNURNFL DSNUGUCA DSNURWUF
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI70476
UP20/07/21 P F007
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":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
05 August 2020