IBM Support

JR34974: SNAPSHOT TIMESTAMP AND CURRENT TIMESTAMP MAY BE DIFFERENT ON SOME MACHINES.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Snapshot timestamp and current timestamp may be different on
    some machines.
    This time discrepancy may be seen in the timestamps in the DB2
    Performance Expert.
    The two timestamps are obtained from the different Windows APIs,
    QueryPerformanceCounter() and GetLocalTime().
    On some multi-core processor, if the Periodic SMI (System
    Management Interrupt) is requested, one core is halted, the
    timer is also halted. Then the timer between the cores leaps
    every interrupt.
    The timestamp from QueryPerformanceCounter() is synchronized
    with the system time once at startup and is calculated using CPU
    high-performance timer, while the timestamp from GetLocalTime()
    is obtained from system time at every call.
    Thus, the two timestamps may be different.
    

Local fix

  • Not available.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 Windows user                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Snapshot timestamp and current timestamp can be different on *
    * some windows machines.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to db2 Version 9.1 FixPak 10                         *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.1 FixPak 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34974

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-27

  • Closed date

    2011-06-10

  • Last modified date

    2011-06-10

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

    JR27624

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 October 2021