Hi Ed, Thanks for the response. I did mean Uncommitted Read. Sorry about that. I was just getting some security work I was doing mixed up with my question. The customers are running their queries from QMF. I am aware of the global DSQEC_ISOLATION parameter in QMF but I don't want to turn that on for everyone, just selected users. So I am not to sure what to do. I am going to do more digging, but if there are other ideas, I'd be glad to hear them.
Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 From: Ed Zell <ewz...@illinoismutual.com> To: IBMVM@LISTSERV.UARK.EDU Date: 03/18/2010 09:38 AM Subject: Re: DB2 on VM question Sent by: The IBM z/VM Operating System <IBMVM@LISTSERV.UARK.EDU> Hi Tony, I think you are referring to the isolation level that the query runs under. I always thought UR meant Uncommitted Read which give you the most concurrency, but means you may get different results with the same SELECT within a logical unit of work. How are the SELECT commands being entered? If it is with ISQL you could set up a profile for the user so that when they sign in to ISQL, it runs a SET ISOLATION UR which would accomplish what you want. If the SELECT’s are in a program, you will need to PREP it with ISOL(UR). You are welcome to give me a call if you want to discuss this. Ed Zell Illinois Mutual Life (309) 636-0107 From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Anthony Pignataro Sent: Thursday, March 18, 2010 8:31 AM To: IBMVM@LISTSERV.UARK.EDU Subject: DB2 on VM question Is there a way to make Unrestricted Access the norm for SELECT * commands on DB2 running on VM? Right now one of our customers adds 'WITH UR' to their SELECT queries because if they don't add 'WITH UR' the database can lock out other users/applications. Every time new users come on board they forget the 'WITH UR' and end up locking people/applications etc. etc. So they want to avoid this. Any thoughts or suggestions? Thanks! Tony Pignataro Information Technology Services America DB2/VM DBA Support Poughkeepsie, NY, (845) 433-7617 Confidentiality: This e-mail (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you receive this e-mail in error, please notify the sender and delete this e-mail from your system.