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
----------------------------------------------------------------
------------------------------- |
