IBM Support

SQL query running frequently

Technote (FAQ)


It seems like the monitoring continuously asks SQL servers for backup-sets.


It does that by issuing statements like the following:
select substring(convert(nvarchar(22),backup_finish_date,102),1,4),substring(convert(nvarchar(22),backup_finish_date,102),6,2), substring(convert(nvarchar(22),backup_finish_date,102),9,2) from msdb..backupset
where database_name = 'WSS_Content_Flender_StdDocuments' order by backup_set_id desc

This query is ran by the KOQDBD cursor ("Database Detail" attribute group), to obtain the "Dump Tran Date" attribute.


You need to increase the intervals for historical data collection and situations for the "Database Detail" attribute group (KOQDBD).

In addition, the KOQDBS calls KOQDBD as a pre_cursor (KOQDBS runs every 180 seconds as it is an interval-driven cursor). You can force the KOQDBS cursor to become a demand-driven cursor by going into the file C:\IBM\ITM\TMAITM6\koqcoll.ctl, search for this:
cursor KOQDBS;
interval 180;
, and modify it to:
cursor KOQDBS;
;interval 180;

Document information

More support for: Tivoli Composite Application Manager for Microsoft Applications
Microsoft SQL Server Agent - 5724B96MO

Software version: 6.2.1,, 6.2.2, 6.2.3

Operating system(s): Windows

Reference #: 1609710

Modified date: 05 March 2013