Re: DB2 on VM question
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:ib...@listserv.uark.edu] On Behalf Of Anthony Pignataro Sent: Thursday, March 18, 2010 9:16 AM To: IBMVM@LISTSERV.UARK.EDU 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 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 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. . 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.
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 From: Ed Zell 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 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.
Re: DB2 on VM question
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, notify the sender and delete this e-mail from your system.
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
Re: DB2 on VM
Thanks Roland. I am aware of the VMDSS issues with 5.3 and have those APARs applied. Thanks again. Aria.
Re: DB2 on VM
Hi Aris, that is OK, DB2/VM V7.10 runs well in z/VM 5.30. However, 1) if you are using TCP/IP, make sure that you re-gen the CEEPIPI as documented in Appendix E. IBM Language Environment for VM User Exit Customization for use with TCP/IP in the PD. 2) if you have VMDSS enabled, make sure you have intalled all VMDSS related APARs. a) DB2/VM: - PQ54781 DBSS - SHOW TARGETWS SHOWS WRONG VALUE OF CURRENT WORKING STORAGE WHEN Z/VM IS RUNNING IN 64-BIT MODE. - PQ58880 VMDSS - DURING ROLLBACK, AN 0C8 ABEND IN ARIYT17 COULD OCCUR IF A 2G DATASPACE IS BEING USED. b) z/VM - you have to call z/VM support Good luck. ...Roland - Original Message From: Aria Bamdad <[EMAIL PROTECTED]> To: IBMVM@LISTSERV.UARK.EDU Sent: Tuesday, August 26, 2008 11:43:18 AM Subject: DB2 on VM Hi List, Anyone using an older version of DB2 for VM on a later version (5) of VM? I am moving to zVM 5.3 and have a DB2 7.1 server that needs to move with it. I want to know if there are any 'problems' running an older 7.1 server on zVM version 5. I would rather not upgrade DB2 if I don't have to. Thanks in advance. Aria
DB2 on VM
Hi List, Anyone using an older version of DB2 for VM on a later version (5) of VM? I am moving to zVM 5.3 and have a DB2 7.1 server that needs to move with it. I want to know if there are any 'problems' running an older 7.1 server on zVM version 5. I would rather not upgrade DB2 if I don't have to. Thanks in advance. Aria