Re: DB2 running in a Linux enviornment
FYI.. DB2 under VM still has periodic (every 18 months or so) new releases and is actively supported. Tony Pignataro From: clifford jackson cliffordjackson...@msn.com To: IBMVM@LISTSERV.UARK.EDU Date: 04/21/2011 11:38 AM Subject:Re: DB2 running in a Linux enviornment Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Dave, what about storage capacity for large data bases and performance. Date: Thu, 21 Apr 2011 10:17:46 -0500 From: d...@vsoft-software.com Subject: Re: DB2 running in a Linux enviornment To: IBMVM@LISTSERV.UARK.EDU Hi, Cliff. One of the pros for running DB2 on zLinux is that the version of DB2 for zLinux is under active development by the IBM DB2 group and supports more features and capabilities than does the DB2 for z/VM. I think the DB2 for z/VM is basically in maintenance mode only these days. DJ On 04/21/2011 10:12 AM, clifford jackson wrote: what are the PROS and CONS of running DB2 under Linux with the Linux running under z/VM as to running DB2 under z/VM without Linux.. Cliff Jackson Senior Systems Programmer 703-607-1393 -- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
Re: DB2 Connect and DB2 V7.5
Those modules get created by prepping DB2 connect into the DB2 databases on the VM side. How you get DB2 Connect to work without those modules is more perplexing to me to tell you the truth, but maybe that was possible in older releases of DB2 Connect. Anyway, there is a bind process that our DB2 Connect users follow to create those missing modules. I don't know what that process is since I am just a VM Db2 guy, but we typically have to give the DB2 Connect folks temporary DBA authority in order to do the preps, then your VM DBA needs to grant run on those new objects to public by connecting as NULLID. Tony Pignataro From: E. Roller ewald.rol...@rolf-benz.com To: IBMVM@LISTSERV.UARK.EDU Date: 03/25/2011 10:55 AM Subject:DB2 Connect and DB2 V7.5 Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Hi, struggling on with implementing DB2 V7.5, on VM I got some DRDA Problems with DB2 Connect. Environment: Database P1 is on Level 7.3 Database T1 is on Level 7.5 DB2 Connect V7.2 connects to P1 and T1 with no problems DB2 Connect V8.1 connects to P1 with no problems DB2 Connect V8.1 connecting to T1 ends up with errors: Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.ph p on line 292 Warning: SQL error: [IBM][CLI Driver][SQLDS/VM] SQL0805N Package .NULLID.SYSSN200 was not found. SQLSTATE=51002 , SQL state 51002 in SQLExecDirect in /web/intern/htdocs/archivts/TA0010.ph p on line 325 The difference of the databases P1 and T1 are in SYSTEM.SYSACCESS table: the old V7.3 fatabase contains the following entries (and some more), I don't know, where they come from: TNAME CREATOR -- --- SYSLN100NULLID SYSLN101NULLID SYSLN102NULLID SYSLN200NULLID SYSLN201NULLID SYSLN202NULLID SYSLN300NULLID SYSLN301NULLID SYSLN302NULLID SYSLN400NULLID SYSLN401NULLID SYSLN402NULLID SYSSN100NULLID SYSSN101NULLID SYSSN102NULLID SYSSN200NULLID SYSSN201NULLID SYSSN202NULLID SYSSN300NULLID SYSSN301NULLID In the V7.5 database these entries are missing. Reading the Database Administration Guide, I found out, that I have to se t up a Stored Procedure Server for DB2 UDB V8.x connections. This is new with DB2 V7.3, the old database on this level works well without a Stored Proc Server. What do I miss ?? TIA Ewald Roller
Re: Restore DB2 Archive from old release to a newer release database
If you still have the 7.3 code disks lieing around, I would try logging on the 7.5 database, drop the 7.5 code disks, link and access the 7.3 code disks and then try the restore. It'll fail immediately if it won't work. My guess is it would work though if you have the 7.3 code disks accessed as Q V Tony Pignataro From: Ewald Roller e.rol...@rolf-benz.de To: IBMVM@LISTSERV.UARK.EDU Date: 03/17/2011 01:50 PM Subject: Restore DB2 Archive from old release to a newer release database Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU Hi, this might be a silly question: is there a way to restore a DB2 ARCHIVE (taken with V7.3) to restore on a newly created DB2 V7.5 Database ? Thanks Ewald Roller
Re: DOC3820
Do you have the tool Out or Anyout? You should be able to print it off using that assuming it is a LIST3820 file. Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 From: Jim Bohnsack jab...@cornell.edu To: IBMVM@LISTSERV.UARK.EDU Date: 07/27/2010 03:05 PM Subject: DOC3820 Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU I just downloaded the latest RSU and COR for VM 5.4 and can't help but wonder what I'm supposed to do with the DOC3820 file that comes with the COR. Is there anything on a PC or on a typical VM system that will handle it other than having hung on to an IBM 3820 for 20 years or so? This is certainly not the first time I've seen a DOC3820 file with maintenance, but this time I just had to ask. In the past, I've just ignored it. What am I missing? Jim -- James Bohnsack (972) 596-6377 home/office (972) 342-5823 cell
Re: DOC3820
Hmmm. That's possible I suppose. I have been looking for documentation for the tools and can't find any. Years ago I worked with people who supported them locally and they were IBM's strategic tools for printing on VM in the late 1990's but I can't come across any information on whether they were more then tools or not and whether they were supported by the VM guys in Endicott at a higher level. They still exist internally on the Y disk on the VM systems I work on in IBM though. Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 From: Jim Bohnsack jab...@cornell.edu To: IBMVM@LISTSERV.UARK.EDU Date: 07/27/2010 04:14 PM Subject: Re: DOC3820 Sent by: The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU No, but I found LP3820 on the IBM download page. Maybe it'll to the job. Are OUT or ANYOUT IBM IUO programs by any chance? That could very well explain why I don't have them. Jim On 7/27/2010 3:21 PM, Anthony Pignataro wrote: This is a multipart message in MIME format. --=_alternative 006A56B18525776D_= Content-Type: text/plain; charset=US-ASCII Do you have the tool Out or Anyout? You should be able to print it off using that assuming it is a LIST3820 file. Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 From: Jim Bohnsackjab...@cornell.edu To: IBMVM@LISTSERV.UARK.EDU Date: 07/27/2010 03:05 PM Subject: DOC3820 Sent by: The IBM z/VM Operating SystemIBMVM@LISTSERV.UARK.EDU I just downloaded the latest RSU and COR for VM 5.4 and can't help but wonder what I'm supposed to do with the DOC3820 file that comes with the COR. Is there anything on a PC or on a typical VM system that will handle it other than having hung on to an IBM 3820 for 20 years or so? This is certainly not the first time I've seen a DOC3820 file with maintenance, but this time I just had to ask. In the past, I've just ignored it. What am I missing? Jim -- James Bohnsack (972) 596-6377 home/office (972) 342-5823 cell
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 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 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.
Accessing a Federated DB in AIX from VM
Hello.. I have a customer who is looking to access a Federated Database residing in AIX from VM. No database in the VM environment. So VM would strictly be a 'launching pad' or the requestor environment and the Federated database in AIX would be the server. Can this be done? If so, is it documented anywhere or does anyone have an idea how to do it. DRDA? TCP/IP? Any help or suggestions would be appreciated. Tony Pignataro IBM - Information Technology Services America DB2/VM Support Poughkeepsie, NY
Re: Accessing a Federated DB in AIX from VM
My customer had this backwards.. My apologies.. They want to go from a Federated environment in AIX to a DB2 server on VM. Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 From: Rich Smrcina rsmrc...@wi.rr.com To: IBMVM@LISTSERV.UARK.EDU Date: 10/22/2009 10:16 AM Subject:Re: Accessing a Federated DB in AIX from VM Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU I'm not sure if Federated Support is available in DB2 for VSE VM, but minimally the DB2 for VM 7.5 client code would need to be installed on VM, which is basically everything except the database engine. I would suggest starting with the General Information manual. Or maybe the product announcement. Since you are in product support, I'm sure there are people in Toronto that you can ask. Anthony Pignataro wrote: Hello.. I have a customer who is looking to access a Federated Database residing in AIX from VM. No database in the VM environment. So VM would strictly be a 'launching pad' or the requestor environment and the Federated database in AIX would be the server. Can this be done? If so, is it documented anywhere or does anyone have an idea how to do it. DRDA? TCP/IP? Any help or suggestions would be appreciated. Tony Pignataro IBM - Information Technology Services America DB2/VM Support Poughkeepsie, NY -- Rich Smrcina Phone: 414-491-6001 http://www.linkedin.com/in/richsmrcina Catch the WAVV! http://www.wavv.org WAVV 2010 - Apr 9-13, 2010 Covington, KY
Fw: Accessing a Federated DB in AIX from VM
My customer just indicated what he meant to say was he wanted to go from a 'Federated' environment on AIX to a DB2/VM database. SOrry for the misinformation. Any idea what they would have to do to go from AIX to a DB2 server on VM? Tony Pignataro Information Technology Services America DB2/VM Support Poughkeepsie, NY, (845) 433-7617, Tie Line 8-293-7617 - Forwarded by Anthony Pignataro/Poughkeepsie/IBM on 10/22/2009 10:25 AM - From: Anthony Pignataro/Poughkeepsie/IBM To: IBMVM@LISTSERV.UARK.EDU Date: 10/22/2009 09:31 AM Subject:Accessing a Federated DB in AIX from VM Hello.. I have a customer who is looking to access a Federated Database residing in AIX from VM. No database in the VM environment. So VM would strictly be a 'launching pad' or the requestor environment and the Federated database in AIX would be the server. Can this be done? If so, is it documented anywhere or does anyone have an idea how to do it. DRDA? TCP/IP? Any help or suggestions would be appreciated. Tony Pignataro IBM - Information Technology Services America DB2/VM Support Poughkeepsie, NY
Re: NOLOG Option in the Directory
Nope! Tony Pignataro IBM Information Technology Services America DB2/VM Support From: Howard Rifkind vmes...@yahoo.com To: IBMVM@LISTSERV.UARK.EDU Date: 09/01/2009 01:11 PM Subject:NOLOG Option in the Directory Sent by:The IBM z/VM Operating System IBMVM@LISTSERV.UARK.EDU If the nolog option is included in a user directory entry can autolog1 log that user id on? Can that user id be xautologged? Thanks