Re: DB2 running in a Linux enviornment

2011-04-21 Thread Anthony Pignataro
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

Re: DB2 Connect and DB2 V7.5

2011-03-25 Thread Anthony Pignataro
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

Re: Restore DB2 Archive from old release to a newer release database

2011-03-17 Thread Anthony Pignataro
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

Re: DOC3820

2010-07-27 Thread Anthony Pignataro
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:

Re: DOC3820

2010-07-27 Thread Anthony Pignataro
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

DB2 on VM question

2010-03-18 Thread Anthony Pignataro
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

Re: DB2 on VM question

2010-03-18 Thread Anthony Pignataro
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

Accessing a Federated DB in AIX from VM

2009-10-22 Thread Anthony Pignataro
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

Re: Accessing a Federated DB in AIX from VM

2009-10-22 Thread Anthony Pignataro
, 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

Fw: Accessing a Federated DB in AIX from VM

2009-10-22 Thread Anthony Pignataro
/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

Re: NOLOG Option in the Directory

2009-09-01 Thread Anthony Pignataro
Nope! Tony Pignataro IBM Information Technology Services America DB2/VM Support From: Howard Rifkind vmes...@yahoo.com