IBM Support

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

Fixes are available

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback