Documentum - API Command for Tracing

If you want to set up tracing for longer than just the current session, you can configure tracing for all future sessions by issuing the “Apply” API command with the “SET_OPTIONS” parameter:

               

apply,c,NULL,SET_OPTIONS,OPTION,S,<Trace option>,VALUE,B,<enable/disable option>

<Trace option>

Trace Options (4th parameter of the apply with SET_OPTIONS command):

• debug – Configures tracing for session debug messages during shutdown, launches, forks, and change checks
• docbroker_trace – Configures docbroker tracing
• lock_trace – Configures tracing for Windows NT locking
• net_ip_addr – Configures tracing of IP addresses used by the client
  and server for authentication
• nettrace – Configures tracing for remote procedure calls (including calls to Netwise). Shows the connection ID, client host address and host name
• sqltrace – Configures tracing of RDBMS SQL commands (during future sessions)
• trace_authentication – Configures tracing of authentication

<enable/disable option>

·     T (On) enable tracing

·     F (Off) disable tracing

        

Example API command to turn on SQL tracing:

               

apply,c,NULL,SET_OPTIONS,OPTION,S,sqltrace,VALUE,B,T

Sample error logs

SELECT * FROM dmi_dd_type_info_rv UE_ , dmi_dd_type_info_sv TE_  WHERE

 (TE_.R_OBJECT_ID=:handle AND TE_.R_OBJECT_ID=UE_.R_OBJECT_ID) ORDER BY

 UE_.R_OBJECT_ID,UE_.I_POSITION

:handle = 690f481d80000d0d

 SELECT J_.I_TYPE FROM bf_demo.dmi_object_type J_ WHERE J_.R_OBJECT_ID=

:handle

:handle = 090f481d80002980

select user_name, message, priority, oneshot, sen/articles/il, event, is_audittrail,

 registered_id from dmi_registry_s where (event = 'dm_setfile' or event = 'all')

 and registered_id ='090f481d80002980'

select s.group_name from dm_group_s s where s.group_name = :p0

:p0 = docu