why phantom pdq message in wee hours?

This involves running IDS 11.70.TC1IE on Windows 2008 Server os. I see this each morning at the same time in the ids log file: 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 10. It is reset to 0. 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 10. It is reset to 0. 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 10. It is reset to 0. ... [ for a total of 2256 lines] I do not have anything scheduled to run at that time and I have been careful not to use pdqpriority anyplace. Could this be some automatic update stats routine? Where is it and how do I turn it off?

On Aug 15, 1:45 pm, "Bill Hamilton" <garage_...@hotmail.com> wrote: > This involves running IDS 11.70.TC1IE on Windows 2008 Server os. > I see this each morning at the same time in the ids log file: > > 01:11:01  Warning: PDQ functionality is not supported in IDS Innovator-C > Edition.>          The value of PDQPRIORITY cannot be set to 10. It is reset to 0. > 01:11:01  Warning: PDQ functionality is not supported in IDS Innovator-C > Edition.>          The value of PDQPRIORITY cannot be set to 10. It is reset to 0. > 01:11:01  Warning: PDQ functionality is not supported in IDS Innovator-C > Edition.>          The value of PDQPRIORITY cannot be set to 10. It is reset to 0. > ... > [ for a total of 2256 lines] > > I do not have anything scheduled to run at that time and I have been careful > not to use pdqpriority anyplace. > Could this be some automatic update stats routine? > Where is it and how do I turn it off? Yes I think it is something to do with the automatic update stats. Do the following query in the sysadmin database: select * from ph_threshold where name = "AUS_PDQ"; On my system I get the following row returned and I think this is the default, so by default I think auto update stats trys to run at PDQ of 10: id 10 name AUS_PDQ task_name Auto Update Statistics Refresh value 10 value_type NUMERIC description Update statistics executes with this PDQ priority. So I believe you should be able to update the value column to 0, which I would think get rid of the messages in your ids log file. Jacques Renaut IBM Informix Advanced Support APD Team