How to avoid logging DbChannel messages in the TIBCO Data Virtualization cs_server.log file(s)?
Article ID: KB0074785
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
TIBCO Data Virtualization cs_server.log file(s) show INFO entries on the OPEN / CLOSE Server Channel Connections. These messages cause the logs files to fill up and consume disk space. Below is an example from cs_server.log file:
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:26:41.788 -0600 ServerChannelConnection - 9575 OPEN from=[Server_name]:49644 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:26:41.788 -0600 ServerChannelConnection - 9575 CLOSE from=[Server_name]:49644 requests=0 count=0 ERROR
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:28:41.788 -0600 ServerChannelConnection - 9576 OPEN from=[Server_name]:49672 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:28:41.788 -0600 ServerChannelConnection - 9576 CLOSE from=[Server_name]49672 requests=0 count=0 ERROR
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:29:16.867 -0600 ServerChannelConnection - 9577 OPEN from=[Server_name]:51024 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:29:19.880 -0600 ServerChannelConnection - 9577 CLOSE from=[Server_name]:51024 requests=0 count=0 ERROR
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:29:51.931 -0600 ServerChannelConnection - 9578 OPEN from=[Server_name]:51034 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:29:54.971 -0600 ServerChannelConnection - 9578 CLOSE from=[Server_name]:51034 requests=0 count=0 ERROR
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:30:41.788 -0600 ServerChannelConnection - 9579 OPEN from=[Server_name]:49702 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:30:41.789 -0600 ServerChannelConnection - 9579 CLOSE from=[Server_name]:49702 requests=0 count=0 ERROR
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:31:59.656 -0600 ServerChannelConnection - 9580 OPEN from=[Server_name]:51056 count=1
INFO [DbChannel-RequestSelectThread] 2020-06-12 07:32:02.678 -0600 ServerChannelConnection - 9580 CLOSE from=[Server_name]:51056 requests=0 count=0 ERROR
Issue/Introduction
Environment
Resolution
Update the value for the configuration 'JDBC / ODBC trace level' to 0 (default) and select 'Apply' to save the changes. This will stop the TDV Server from logging connection events. This configuration can be found in TDV Studio > Administration > Configuration > Server > Configuration > Debugging > JDBC/ODBC Trace Level.
Here is a screenshot for reference:
Please note, this value is locally defined. In a clustered environment scenario, update the value for every TDV instance.
Feedback
