Enabling Uncommitted Read in TSQDA - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

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.