인포믹스 스케줄러에 기본으로 등록된 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.
'Informix > informix troubleshooting' 카테고리의 다른 글
| onbar restore중 out of virtual shared memory 오류 (0) | 2015.06.28 |
|---|---|
| Message Referencing return code 126 or 127 and alarmprogram.sh in your online.log File (0) | 2015.06.11 |
| PDQ functionality is not supported in IDS Growth Edition (0) | 2015.06.03 |
| KAIO: out of OS resources, errno = 11 _aiowrite() returning EAGAIN (0) | 2015.05.07 |
| KAIO: out of OS resources (AIX 6 이상) (0) | 2015.05.07 |