ODBC logs for database connection and failed servers detection in Policy Server

Products

• SITEMINDER

Issue/Introduction

Running Policy Server, how to investigate the ODBC configuration to a Session Store, in light of Connection_Management, when and how Policy Server  creates and terminates database connection and detects failed servers on Linux?
  

Resolution

 

• Set the Policy Server odbc traces like these at the very end of the file system_odbc.ini:
  
  system_odbc.ini:
  
  [ODBC]
  Trace=1
  TraceFile=/{home_policy_server}/log/odbctrace.out
  TraceDll=/{home_policy_server}/odbc/lib/NStrc28.so
  InstallDir=/{home_policy_server}/odbc
  TraceOptions=3
  
  
• Stop and start the Policy Server;
• Reproduce the issue and look for the transactions in the files:
  
   /{home_policy_server}/log/:
  
  smtracedefault.log
  odbctrace01.out 
  odbctraceINFO.out