dbTalk Databases Forums  

why phantom pdq message in wee hours?

comp.databases.informix comp.databases.informix


Discuss why phantom pdq message in wee hours? in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bill Hamilton
 
Posts: n/a

Default why phantom pdq message in wee hours? - 08-15-2011 , 01:45 PM






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?

Reply With Quote
  #2  
Old   
jrenaut
 
Posts: n/a

Default Re: why phantom pdq message in wee hours? - 08-15-2011 , 02:30 PM






On Aug 15, 1:45*pm, "Bill Hamilton" <garage_... (AT) hotmail (DOT) com> wrote:
Quote:
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

Reply With Quote
  #3  
Old   
Art Kagel
 
Posts: n/a

Default Re: why phantom pdq message in wee hours? - 08-15-2011 , 02:47 PM



AUS - Auto Update Statistics runs at that time and it tries to set
PDQPRIORITY.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Mon, Aug 15, 2011 at 2:45 PM, Bill Hamilton <garage_dba (AT) hotmail (DOT) com>wrote:

Quote:
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?

_______________________________________________
Informix-list mailing list
Informix-list (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.