Timestamps in the ODBC trace file for Policy Server on Linux and Windows
Article ID: 54489
Updated On:
Products
CA Single Sign-On
SITEMINDER
Issue/Introduction
How to get the match information from SiteMinder Policy Server ODBC trace?
The ODBC trace doesn't show any timestamps, and it's very difficult to match the information up.
Resolution
To get timestamps in the ODBC trace file, the DataDirect Driver should be version 5.3.
The new attribute TraceOptions is available in 5.3 SP1 for the trace library (1)(2)(3).
The new attribute is TraceOptions and has the following values:
0 - Use standard ODBC tracing (the initial default);
1 - Print the current timestamp, parent process id, process id, and thread id for all ODBC functions to the output file.
To illustrate, the TraceOptions should be set to 1:
Linux:
[ODBC]
Trace=1
TraceOptions=1
TraceFile=/{home_policy_server}/logs/odbctrace.out
TraceDll=/{home_policy_server}/odbc/lib/odbctrac.so
InstallDir=/{home_policy_server}/odbc
Windows:
HKEY_CURRENT_USER/Software/ODBC/ODBC.INI/ODBC
TraceOptions 1
Sample of an output:
2008-10-24 11:25:25.933464 ppid=<ppid>:pid=<pid>:c ENTER SQLSetEnvAttr
2008-10-24 11:25:25.933464 ppid=<ppid>:pid=<pid>:c SQLHENV 0x0044fc98
2008-10-24 11:25:25.933464 ppid=<ppid>:pid=<pid>:c SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION->
2008-10-24 11:25:25.933464 ppid=<ppid>:pid=<pid>:c SQLPOINTER 3
2008-10-24 11:25:25.933464 ppid=<ppid>:pid=<pid>:c SQLINTEGER 0
Additional Information
Feedback
Yes
No
Powered by
