IBM Support

PM61811: TEMPORAL SUPPORT TO SUPPRESS PRODUCTION OF HISTORY DATA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Temporal support to suppress production of history data
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who use both    *
    *                 temporal support and replication products.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: DM1541 for DB2 10 for z/OS: A new       *
    *                      DB2-supplied stored procedure has been  *
    *                      implemented to set the internal         *
    *                      option to disable recording of          *
    *                      temporal history for a system-period    *
    *                      temporal table and allow values to be   *
    *                      specified for the special temporal      *
    *                      column types previously mentioned.      *
    *                                                              *
    *                      When this procedure is invoked by a     *
    *                      connection, DB2 behavior (for static    *
    *                      and dynamic SQL) is affected as         *
    *                      follows:                                *
    *                      1, historical rows are not written      *
    *                      to a history table for update or delete *
    *                      operations.                             *
    *                      2, an application may specify values    *
    *                      (such as in an INSERT statement or      *
    *                      UPDATE statement) for a row-begin,      *
    *                      row-end, or transaction-start-ID        *
    *                      column even though the column is        *
    *                      defined as GENERATED ALWAYS, and        *
    *                      these values will be stored in the      *
    *                      affected rows.                          *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    DM1541 for DB2 for z/OS V10: A new DB2-supplied stored procedure
    has been implemented to set the internal option to disable
    recording of temporal history for a system-period temporal
    table and allow values to be specified for the special
    temporal column types previously mentioned. The DB2-supplied
    procedure is named,
    SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY.
    
    This stored procedure is not intended for general use.  It is
    intended to be used by products that enable DB2 replication.
    
    When this procedure is invoked by a connection, DB2 behavior
    (for static and dynamic SQL) is affected as follows:
    1, historical rows are not written to a history table for
    update or delete operations.
    2, an application may specify values (such as in an INSERT
    statement or UPDATE statement) for a row-begin, row-end, or
    transaction-start-ID column even though the column is defined
    as GENERATED ALWAYS, and these values will be stored in the
    affected rows.
    
    Additional Keywords:  SQLBITEMPORAL SQLSPTT
    

Problem conclusion

Temporary fix

Comments

  • DB2 code has been modified to implement the DCR.
    

APAR Information

  • APAR number

    PM61811

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-04-03

  • Closed date

    2013-02-06

  • Last modified date

    2013-03-04

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

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

    UK91454

Modules/Macros

  • DSN@RIN  DSN@XAZP DSNIDLER DSNILREP DSNINUKY
    DSNIRELK DSNISRTI DSNITDLE DSNLQCTL DSNLQINA DSNLTCM1 DSNLTDSR
    DSNLTRB1 DSNTACT  DSNTESR  DSNTIDXA DSNTIDXB DSNTIJRT DSNTINST
    DSNTINSV DSNTINS1 DSNTIPRL DSNTRIN  DSNTXAZP DSNXEBR  DSNXECW
    DSNXECWA DSNXECWU DSNXERT2 DSNXGRTM DSNXOCAS DSNXOFF  DSNXOST
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK91454

       UP13/02/22 P F302

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 March 2013