Enable data compression in ODBC driver and DCS server

Introduction

Sending big bunch of data which is sparse to server side quickly over TCPIP network.

N/A

Windows driver:

we can enable compression in "Trafodion ODBC Data Source 'xxx' Configuration" tab of your DSN. see pic:

Linux driver:

if you use Trafodion ODBC Driver Manager, Adding "Compression = <compression level>" to the your DSN section of TRAFDSN file

if you use 3rd party Driver Manager, for ex: unixODBC, Adding "Compression = <compression level>" to your DSN section of odbc.ini file

Supported <compression level>:

SYSTEM_DEFAULT

best compression

best speed

balance

one number: 0-9

Internally, we use zlib to compress data.

N/A

N/A

N/A