Hello
I cannot connect to db2 with Uncommitted Reads. If on DB2 tables during update then
BO waits the locks a long time.
The Bosupport say
“Open the relevant parameters (.prm) file for your version of DB2 using a text editor such as Notepad.exe.Add end_sql=for SELECT only with UR” but I didn’t work it.
Best Regards,
If you connect via DB2Connect edit the DB2CLI.INI file in the SQLLIB directory and place TXNISOLATION=1 at the top of this file. This will force all DB2 Datasource to Uncommited read. No customisation is required to BO files.
Regards,
John.