PK23322: LOAD DATA SHRLEVEL CHANGE RESUME YES.. RESULTS IN ZEROS FOR TIMESTAMP COLUMN WHEN THERE IS A BEFORE TRIGGER ON THE TABLE.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • LOAD DATA SHRLEVEL CHANGE RESUME YES results in zeros for a
    TIMESTAMP  column on the very first row, when there is a BEFORE
    trigger on the table.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 UDB for OS/390 or z/OS utility users *
    ****************************************************************
    * PROBLEM DESCRIPTION: LOAD SHRLEVEL CHANGE generates invalid  *
    *                      timestamp values when a before trigger  *
    *                      statement using CURRENT TIMESTAMP is    *
    *                      executed.                               *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    User ran a LOAD SHRLEVEL CHANGE to populate a table, which
    is the target of a before trigger to alter one of its timestamp
    columns to the CURRENT TIMESTAMP value.  After LOAD completed,
    the timestamp column contains invalid value of zeroes and/or
    inaccurate timestamp values.
    

Problem conclusion

  • Code has been modified to correct the reported problem.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK23322

  • Reported component name

    5740 IBM DATABA

  • Reported component ID

    5740XYR00

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-04-12

  • Closed date

    2006-05-05

  • Last modified date

    2006-06-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK14242 UK14243

Modules/Macros

  • DSNURWBF
    

Fix information

  • Fixed component name

    5740 IBM DATABA

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R710 PSY UK14242

       UP06/05/23 P F605

  • R810 PSY UK14243

       UP06/05/23 P F605

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

7.0

Reference #:

PK23322

Modified date:

2006-06-03

Translate my page

Machine Translation

Content navigation