IBM Support

PH25572: LOAD WITH OVERRIDE FOR GENERATED ALWAYS ROW CHANGE TIMESTAMP

A fix is available

Subscribe

You can track all active APARs for this component.

 

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":"BU029","label":"Software"},"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