IBM Support

JR37799: Information that the database has been deactivated is not picked up instantly by ATS.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Information that the database has been deactivated is not picked
    up instantly by ATS, it is only in the next evaluation cycle
    that this information would be picked up and the tasklist be
    removed by ats.
    
    After deactivation of the database, the ATS tasklist continues
    to remain. The information that the database has been
    deactivated is not picked up instantly by ATS.
    It fills the db2diag.log with hundreds of following messages :
    
    ----------------------------------------------------------------
    -----------------------------
    
    2010-09-06-08.18.00.797972-240 E9119E448           LEVEL: Error
    PID     : 30504                TID  : 1115703616   PROC : db2acd
    INSTANCE: naveesin             NODE : 000
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:200
    MESSAGE : ADM15502W  The administrative task scheduler could not
    execute task<
              "FLUSH EVENT MONITOR EVERY HOUR" because the database
    is inactive.
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x82BA00FD
    
    2010-09-06-08.18.00.801959-240 E9568E397           LEVEL: Error
    PID     : 30504                TID  : 1115703616   PROC : db2acd
    INSTANCE: naveesin             NODE : 000
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:201
    MESSAGE : ZRC=0xFFFFFBDC=-1060
    DATA #1 : <preformatted>
    [IBM][CLI Driver] SQL1060N  User "DB2ATS" does not have the
    CONNECT privilege.  SQLSTATE=08004
    
    
    2010-09-06-08.18.00.802834-240 E9966E448           LEVEL: Error
    PID     : 30504                TID  : 1124096320   PROC : db2acd
    INSTANCE: naveesin             NODE : 000
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:200
    MESSAGE : ADM15502W  The administrative task scheduler could not
    execute task<
              "FLUSH EVENT MONITOR EVERY HOUR" because the database
    is inactive.
    DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x82BA00FD
    
    2010-09-06-08.18.00.803080-240 E10415E397          LEVEL: Error
    PID     : 30504                TID  : 1124096320   PROC : db2acd
    INSTANCE: naveesin             NODE : 000
    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run,
    probe:201
    MESSAGE : ZRC=0xFFFFFBDC=-1060
    DATA #1 : <preformatted>
    [IBM][CLI Driver] SQL1060N  User "DB2ATS" does not have the
    CONNECT privilege.  SQLSTATE=08004
    
    ----------------------------------------------------------------
    -------------------------------
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Customers using ATS(administrative task scheduler).          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * After deactivation of the database, the ATS tasklist         *
    * continues to remain. The information that the database has   *
    * been deactivated is not picked up instantly by ATS.          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Problem will be fixed in db2 v9.5 fp 7.                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    JR37799

  • Reported component name

    DB2 CEE WINDOWS

  • Reported component ID

    5765F3001

  • Reported release

    950

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-20

  • Closed date

    2010-11-09

  • Last modified date

    2010-11-09

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

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

    IC71555 IC71556

Fix information

Applicable component levels

  • R950 PSY

       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:
09 November 2010