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,
Listserv Archives (BOB member since 2002-06-25)
Hi,
Try the following : end_sql=FOR FETCH ONLY
This is working with our DB2 (DB2/390 V5).
Ludo Geerts
Listserv Archives (BOB member since 2002-06-25)
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.
Listserv Archives (BOB member since 2002-06-25)