I’m using DB2 for the first time with horrenous performance problems.
Having read some tips on this bulletin board, I’m now trying to set the isolation level to Uncommitted Read. Business Objects runs on a server and the PRM file is located in a server directory.
Stupid question, but if I make the configuration change using the DB2 Client Configuration Assistant on my P.C., will it override the PRM setting, or do I actually have to edit the PRM file?
seems like you are mixing things up here. When you talk about Uncommitted Reads (I assume that is same as “dirty reads” as the DBAs say here which means – just read what you can and don’t wait for record locks), I believe that is set on the database and doesn’t have anything to do with settings in BO PRM file or DB2 CCA. CCA defines your connection to the database while the PRM translates SQL into DB2.
But then I may be wrong and we know I’m
(BOB member since 2002-09-13)
(BOB member since 2002-06-20)