KB441649: How to get process id and timestamps logged in ODBC tracing

SYMPTOM:
 
In Strategy 10.x and 11.x, the ODBC trace file does not contain process id or parent process id and timestamps.  
 
Refer to Technical Document below on how to enable ODBC trace in Unix:
KB11979: How to turn on/turn off ODBC tracing in Strategy Intelligence Server Universal 9.x - 10.x
 
Refer to Technical Document below on how to enable ODBC trace on Windows:
KB8699: How to enable 32-bit Open Database Connectivity (ODBC) tracing in Strategy Intelligence Server 9.x?
 
 
CAUSE:
 
By default, ODBC trace does not log process id and timestamps.  
 
 
WORKAROUND: 
 
There are two ways to display process id and timestamps:
 

• Set TraceOptions=3 in the [ODBC] section of the odbc.ini configuration file.
  
  For example, the [ODBC] section of the odbc.ini file include below entries:
  Trace=1
  TraceFile=odbctrace.out
  TraceOptions=3
  TraceDll=ODBCHOME/lib/odbctrac.so [for ODBC verisons 6.0 and lower]

• TraceDll=ODBCHOME/lib/xxtrcyy.so

[for ODBC versions 6.1 and higher where xx represents either iv (32-bit version) or dd (64-bit version), and yy represents the driver level number, for example, ivtrc27.so.]
 
Further readings: 
Refer to Technical Document below on how to read ODBC trace file:
How to read ODBC trace in Strategy 10.x
 
 
Article Reference Number: KB441649