Since upgrading to version 6.0.1 of the ISC and 5.5.0.0 of the TSM Admin Center, hourly queries are being issued from the machine where the ISC/Admin Center is running. For example:
06/11/2008 15:01:33 ANR0407I Session 23713 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4666)). (SESSION: 23713)
06/11/2008 15:01:33 ANR2017I Administrator XXXXX issued command: select pct_utilized from log (SESSION: 23713)
06/11/2008 15:01:33 ANR0405I Session 23713 ended for administrator XXXXX (WinNT). (SESSION: 23713)
06/11/2008 15:01:34 ANR0407I Session 23714 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4667)). (SESSION: 23714)
06/11/2008 15:01:34 ANR2017I Administrator XXXXX issued command: select stgpool_name,pct_migr,migr_running,pct_utilized from stgpools where devclass='DISK' (SESSION: 23714)
06/11/2008 15:01:34 ANR0405I Session 23714 ended for administrator XXXXX (WinNT). (SESSION: 23714)
06/11/2008 15:01:34 ANR0407I Session 23715 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4668)). (SESSION: 23715)
06/11/2008 15:01:34 ANR2017I Administrator XXXXX issued command: select count(*) from sessions where session_type='Node' (SESSION: 23715)
06/11/2008 15:01:34 ANR0405I Session 23715 ended for administrator XXXXX (WinNT). (SESSION: 23715)
06/11/2008 15:03:34 ANR2017I Administrator XXXXX issued command: select library_name,drive_name from drives where online<>'YES' (SESSION: 23703)
06/11/2008 15:03:34 ANR2939E The reference 'DRIVES' is an unknown SQL table name. (SESSION: 23703)
The last query is the problem – it results in error messages that kick off alarms in TSMManager. I have searched for a way to shut these queries off or modify them, but haven’t been able to find it. I’ve changed the Health Monitor to run its updates only once per day, but that has no effect – nor did disabling the user that runs the Health check. I can’t disable this user, because it is my main administrator ID.
I found a couple suggestions with searches, but nothing that applies to the ISC (I did see a couple of things for the Management console, but I am not running it on the machine where the ISC is running. Can anyone point me in the right direction? Thanks for your help.
------------------
Kevin Kinder
06/11/2008 15:01:33 ANR0407I Session 23713 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4666)). (SESSION: 23713)
06/11/2008 15:01:33 ANR2017I Administrator XXXXX issued command: select pct_utilized from log (SESSION: 23713)
06/11/2008 15:01:33 ANR0405I Session 23713 ended for administrator XXXXX (WinNT). (SESSION: 23713)
06/11/2008 15:01:34 ANR0407I Session 23714 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4667)). (SESSION: 23714)
06/11/2008 15:01:34 ANR2017I Administrator XXXXX issued command: select stgpool_name,pct_migr,migr_running,pct_utilized from stgpools where devclass='DISK' (SESSION: 23714)
06/11/2008 15:01:34 ANR0405I Session 23714 ended for administrator XXXXX (WinNT). (SESSION: 23714)
06/11/2008 15:01:34 ANR0407I Session 23715 started for administrator XXXXX (WinNT) (Tcp/Ip xxx.xxx.xxx.xxx(4668)). (SESSION: 23715)
06/11/2008 15:01:34 ANR2017I Administrator XXXXX issued command: select count(*) from sessions where session_type='Node' (SESSION: 23715)
06/11/2008 15:01:34 ANR0405I Session 23715 ended for administrator XXXXX (WinNT). (SESSION: 23715)
06/11/2008 15:03:34 ANR2017I Administrator XXXXX issued command: select library_name,drive_name from drives where online<>'YES' (SESSION: 23703)
06/11/2008 15:03:34 ANR2939E The reference 'DRIVES' is an unknown SQL table name. (SESSION: 23703)
The last query is the problem – it results in error messages that kick off alarms in TSMManager. I have searched for a way to shut these queries off or modify them, but haven’t been able to find it. I’ve changed the Health Monitor to run its updates only once per day, but that has no effect – nor did disabling the user that runs the Health check. I can’t disable this user, because it is my main administrator ID.
I found a couple suggestions with searches, but nothing that applies to the ISC (I did see a couple of things for the Management console, but I am not running it on the machine where the ISC is running. Can anyone point me in the right direction? Thanks for your help.
------------------
Kevin Kinder