|
No. 20516
OFSA의 DEBUG 하는 방법
=================
PURPOSE
-------
PA,RM 등의 OFSA작업시 실제로 일어나는 Sql의 transaction을 Debug하는 방법에 대한 소개
Explanation
-----------
/<OFSA Install>/etc 아래에 있는 해당 모듈의 INI를 찾아본다.
PA의 경우에는 OFSPA.ini입니다.
해당파일에 [DEBUG] 항목이 있으며 초기에는 모두 Comment Out되어 있습니다.
[debug]
;FileName=ofspa
;CALC_LOG=3
;ACCESS_LOG=3
;ERROR_LOG=3
이를 풀어주면 Debug 정보가 ofs.ini 의 WorkingDirectory" 에
생성됩니다.
/<OFSA Install>/log.
아래 정보들은 각 Parameter에 대한 설명입니다.
CALC_LOG:
=========
CALC_LOG=1
--> Generates only OFSA SQL statements used in calculation process (does
not
include SQL statements against internal OFSA tables like ofsa_users,
ofsa_db_info, etc.)
CALC_LOG=2
CALC_LOG=3
--> Same information as "1" and list units of work used for
multiprocessing
CALC_LOG=0
--> Turns off logging but will still generate a file
ACCESS_LOG:
===========
ACCESS_LOG=1
--> Lists ODBC server, database and username information and module data
being accessed. An example:
Module Logging OFS Access module data: /* 151:
*io_id_data_filter::GetID*/
ACCESS_LOG=2
ACCESS_LOG=3
--> Lists info from "1" and ALL SQL statements generated by OFSA
including SQL on internal OFSA tables.
ACCESS_LOG=0
--> Turns off logging but will still generate a file
ERROR_LOG:
==========
ERROR_LOG=1
--> Outputs any Oracle errors to log file in addition to SQL statement
that
generated error.
ERROR_LOG=3
--> Outputs same info as "1" and includes the errno of failed
system calls to help in diagnosing kernel parameter issues involving
semaphores
and shared memory.
ERROR_LOG=0
--> Turns off logging but will still generate a file
Reference Documents
-------------------
197903.1
출처:http://211.106.111.2:8880/bulletin/list.jsp?seq=20516&pg=5&sort_by=last_updated&keyfield=subject&keyword=
|
