Tony, I am afraid I don't have any experience with QMF. But there are some pretty sharp folks on this list who probably do. One other thought is even though this is VM DB2, you might want to post to the VSE list as well. There are a couple of folks there who know DB2 and don't follow this list. Good luck!
Ed Zell Illinois Mutual Life (309) 636-0107 ________________________________ From: The IBM z/VM Operating System [mailto:[email protected]] On Behalf Of Anthony Pignataro Sent: Thursday, March 18, 2010 9:16 AM To: [email protected] Subject: Re: DB2 on VM question 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 Inactive hide details for Ed Zell ---03/18/2010 09:38:47 AM---Hi Tony, I think you are referring to the isolation level that Ed Zell ---03/18/2010 09:38:47 AM---Hi Tony, I think you are referring to the isolation level that the query runs From: Ed Zell <[email protected]> To: [email protected] Date: 03/18/2010 09:38 AM Subject: Re: DB2 on VM question Sent by: The IBM z/VM Operating System <[email protected]> ________________________________ 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:[email protected]] On Behalf Of Anthony Pignataro Sent: Thursday, March 18, 2010 8:31 AM To: [email protected] 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. . 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, notify the sender and delete this e-mail from your system.
