Informix/informix troubleshooting

PDQ functionality is not supported in IDS Growth Edition

@ipajama 2015. 6. 3. 17:45
728x90
online.log 파일에서 아래의 메시지가 나오는 경우가 있습니다.
Warning: PDQ functionality is not supported in IDS Growth Edition.
이 메시지는 Growth 또는 Workgroup Edition 에서 PDQ 기능을 설정하려 할 때 발생하는 메시지입니다.
Growth 또는 Workgroup 에서는 지원하지 않는 기능이므로 PDQ 기능이 활성화되지 않으며, 
인포믹스 프로세스에 영향은 주지 않지만 관리목적으로 비활성화 할 수 있습니다.

Problem(Abstract)

Customer is getting warning messages when AUS is executed even if PDQPRIORITY is 0 in onconfig

Symptom

online.log messages:

Warning: PDQ functionality is not supported in IDS Growth Edition.

The value of PDQPRIORITY cannot be set to 10. It is reset to 0.  

Cause

the default PDQ priority configured to run AUS is 10%

Environment

IDS 11.50.FC8GE Growth Edition. C is getting warning messages in the online.log after the following tasks are executed.

Auto Update Statistics Evaluation

Auto Update Statistics Refresh  

PDQPRIORITY is set to 0 in the onconfig


Diagnosing the problem

If the following select retunr integer bigger than zero ( 0 ):

select value from ph_threshold where name="AUS_PDQ";

Resolving the problem

Execute the following sentences in dbaccess

database sysadmin;                                  

update ph_threshold set value=0 where name="AUS_PDQ";



http://www-01.ibm.com/support/docview.wss?uid=swg21569243

728x90