Before submitting a ticket to IBM Support, I thought I would ask here first. Using our SQL monitoring software we’ve found that there is one query that is happening quite a bit on our system that is causing a lot of wait times around the network:
SELECT SiteType, SiteTag, S.SHA1Hash, Certificate FROM SITE_SUPPORTING_CERTIFICATES S INNER JOIN CERTIFICATES C ON S.SHA1Hash = C.SHA1Hash WHERE S.IsDeleted = 0
Each query processes about 700 rows, but in the first 11 hours today it executed almost 16000 times. This query is happening with the BESRootServer and GatherDB.
Is this normal behavior or is there a setting that we have turned on or off that is causing this query to happen so many times?