Enabling Uncommitted Read in TSQDA - trillium_discovery - trillium_quality - Latest

You can enable uncommitted read in tsqda, ODBC, DB2, Oracle, and so on.

To enable uncommitted read in tsqda:

1. Open the configuration file.

   • For Data Adapter, open Data Adapter\etc\config.txt

   • For ODBC, open ODBC Adapter\etc\config.txt

   • For other loader connections, for example, DB2 or Oracle, open MBSW\17\etc\config.txt

2. Modify the uncommitted_read parameter of the key rdbms section:  

   key rdbms {
      value uncommitted_read "on"
      value records_read 100
      value records_read_odbc 1
   }

3. Save your changes.