.EDU
Date:
03/18/2010 09:38 AM
Subject:
Re: DB2 on VM question
Sent by:
The IBM z/VM Operating System
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
Date: 03/18/2010 09:38 AM
Subject: Re: DB2 on V
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
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
fo