Timestamps in the ODBC trace file for Linux Policy Server

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 and the operating system should be on Linux.

A new attribute is available in 5.3 SP1 for the trace library on Linux.

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 [ODBC] section of the system_odbc.ini file might include:

[ODBC]
Trace=1
TraceOpts=1
TraceFile=/{home_policy_server}/logs/odbctrace.out
TraceDll=/{home_policy_server}/odbc/lib/odbctrac.so
InstallDir=/{home_policy_server}/odbc

 
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