728x90

인포믹스 스케줄러에 기본으로 등록된 TASK로 인해 online.log 파일에서 아래의 메시지가 발생하는 경우가 있습니다.

해당 메시지는 테이블의 압축률을 계산하는 프로시저 admin_fragment_command 의 실행 결과를 표시하는 것입니다.

압축기능 라이센스를 보유하지 않은 고객이라면 의미 없는 작업이므로 비활성화 하는 것이 좋습니다.


아래 작업 후에 인포믹스 프로세스를 재시작해야 합니다.


Question

Why do we see estimate compression message in the online.log as shown below, when we did run any compression command? 

Snippet from the online.log:
--------------------------------------
14:50:28 SCHAPI Estimate Compression for txc07_4q:"ssadmin".ubevent started 
14:50:30 admin_fragment_command('fragment estimate_compression ','69206165') succeeded 
14:50:30 SCHAPI Estimate Compression for txc07_4q:"ssadmin".ubflag started 
14:50:31 admin_fragment_command('fragment estimate_compression ','69206167') succeeded 
14:50:31 SCHAPI Estimate Compression for txc07_4q:"ssadmin".ubkeys started 
14:50:35 admin_fragment_command('fragment estimate_compression ','69206168') succeeded 
-------------------------------------- 

Answer

When you connect to the database via OAT and while browsing through the menu in OAT, you click on "Storage" under "Space Administration" section, it will deploy a task called "mon_compression_estimates" in the scheduler. Whenever the task executes, it generates the message, SCHAPI Estimate Compression, in the online.log.

You can run the following SQL statement to stop the task from being executed, hence stop the message from being displayed in the online.log.

UPDATE sysadmin:ph_task 
SET tk_enable = "F" 
WHERE tk_name = "mon_compression_estimates";

You will still need to bounce the informix instance after the update.


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

728x90
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

+ Recent posts