IBM Support

PI91148: SYSIBM.SYSTABLES_PROFILES.PROFILE_UPDATE WAS SET TO YEAR 1971 INCORRECTLY

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SYSIBM.SYSTABLES_PROFILES.PROFILE_UPDATE was set to
    1971-10-11-06.01.10.659072 incorrectly.
    

Local fix

  • update SYSIBM.SYSTABLES_PROFILES.PROFILE_UPDATE manually.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users of statistics                      *
    * feedback data in the catalog table                           *
    * SYSIBM.SYSTABLES_PROFILES.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * User sees invalid PROFILE_UPDATE value                       *
    * in SYSIBM.SYSTABLES_PROFILES.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    User sees invalid PROFILE_UPDATE value
    in SYSIBM.SYSTABLES_PROFILES.  For example,
    a value such as 1971-10-11-06.01.10.659072
    may be seen, which is prior to the insertion
    of the associated row.  The problem is due
    to incorrect initialization of a timestamp
    value.
    

Problem conclusion

  • Db2 has been fixed to correctly set the PROFILE_UPDATE field.
    
    Additional Keywords:
    SQLSTATS
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI91148

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-12-06

  • Closed date

    2018-01-18

  • Last modified date

    2018-03-01

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

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

    UI53331

Modules/Macros

  • DSNUGPRD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI53331

       UP18/02/03 P F802

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.



Document information

More support for: DB2 for z/OS

Software version: C10

Reference #: PI91148

Modified date: 01 March 2018


Translate this page: