uncommitted read

[system]

Hi,

I am upgarding BO 5.1.7 to BO 5.1.9. Is there a way to include uncommitted read during installation? Also, how uncommitted read helps in log in time…

Please help me

–Chan

---

chan2005 (BOB member since 2005-05-29)

[system]

@chan2005

Please help me

Time for a brief nag… I know folks are tired of seeing this, but searching for the two words “uncommitted read” found a variety of good topics, including this one:

120×120 10.4 KB

We are experiencing a problem where DB2 threads are not being canceled when quering large amounts of data. Eventually, these threads start bottlenecking our processors and affects system performance on that subsystem. One question in a meeting was, can an isolation level be set to Uncommented Read (UR). An example would be to append WITH UR to a SQL statement. Is this possible?? SELECT ADWJCIP.CUST_REGISTRY.ENT_ID, ADWJCIP.CUST_REGISTRY.CMP_ENT_ID, ADWJCIP.CUST_REGISTRY.LAST_NM, ADW…

In many cases it only takes a few minutes extra to try searching on a few key words from your question. I’m not picking on you (Chan) in particular, it just seems like a reminder is useful every now and then.

Please check out the other topic I linked and see if it helps you out. If not, try a search using those two terms and see some of the other topics.

---

Dave Rathbun (BOB member since 2002-06-06)

[system]

It’s also one of the FAQ

---

Chris Pohl (BOB member since 2002-06-18)