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 <[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.
