IBM Support

LI73211: SCHEDULED TASKS MAY BE EXECUTED MORE THAN EXPECTED AFTER THE SWITCH TO DAYLIGHT SAVING TIME IN SOME TIMEZONES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After the switch to daylight saving time, the "Next Execution"
    time of scheduled tasks will not change any more and the tasks
    are executed over and over again.
    
    This can be seen in the db2diag.log file (the tasks in question
    should be executed once every hour, the switch to DST was on
    March 3rd 02:00):
    
    2008-03-30-04.00.00.255849+120 E127980487E408      LEVEL: Event
    PID     : 13286                TID  : 1132489056   PROC : db2acd
    INSTANCE: xxxxxxx              NODE : 000
    APPID   : xxxxxxxxxx
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:300
    START   : Begin execution - Task ID: 29
              Task Name      : SAPTOOLS.DBH_DB_COLLECT
              Database       : XXXXX
    
    2008-03-30-04.00.02.967307+120 E127990099E408      LEVEL: Event
    PID     : 13286                TID  : 1132489056   PROC : db2acd
    INSTANCE: xxxxxx               NODE : 000
    APPID   : xxxxxxxxxxxx
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:300
    START   : Begin execution - Task ID: 29
              Task Name      : SAPTOOLS.DBH_DB_COLLECT
              Database       : xxxxxx
    
    2008-03-30-04.00.04.898337+120 E127998479E408      LEVEL: Event
    PID     : 13286                TID  : 1132489056   PROC : db2acd
    INSTANCE: xxxxxx               NODE : 000
    APPID   : xxxxxxxxxxxxxxx
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:300
    START   : Begin execution - Task ID: 29
              Task Name      : SAPTOOLS.DBH_DB_COLLECT
              Database       : xxxxxxxxxxx
    ...
    

Local fix

Problem summary

  • ****************************************************************
    *PROBLEM DESCRIPTION:
    *          After the switch to daylight saving time, the
    *          "Next Execution" time of scheduled tasks will not
    *          change any more and the tasks are executed over
    *          and over again.
    *
    *          This can be seen in the db2diag.log file.
    *
    ****************************************************************
    *RECOMMENDATION:
    *          Upgrade to DB2 Version 9.5 fix pack 2 or higher.
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.5 FixPack 2
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI73211

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-05-23

  • Closed date

    2008-08-27

  • Last modified date

    2010-01-11

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

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

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 January 2010