This functionality would require that DB2 for OS/390 have a Run Time client available. I do not know if that is the case. Otherwise you would need the whole database engine for simple client requests. And, this may be financially unrealistic. It certainly works (I've done it from VSE), but even there only the entire DB2 package is available.
We are pushing this for VM & VSE as well since the functionality of DB2 on those operating systems is severely backlevelled. On Friday 18 October 2002 02:42 pm, you wrote: > I think this is technically possible. But I don't know if it is financially > a good idea or technically. We have a new 2066-0A2 (z/800) with an IFL > (which only runs z/VM & Linux/390). What I was wondering, could the DB2 > data base itself run on the Linux/390 system, using the IFL's CPU > resources. The OS/390 side would only have a "client" ability. I hope that > makes sense. What I want is for a job on the OS/390 side of the machine to > use a DB2 connection to the Linux/390 side of the machine to do the actual > data base work. I realize this would not be as efficient as doing it > locally. So some of my questions: > > 1) It is technically feasible? > > 2) It is financially feasible? > Cost of DB2 on Linux/390 on a z/800 with 1 IFL. > Cost of the "client" portion of DB2 on OS/390. Does this exist > separately from DB2 itself? > > 3) How well will it perform? E.g. "If you do it that way, you'll only get > ??% of the throughput that you would natively." > > 4) Can the "client" on OS/390 do the data base backups for the DB2 on the > Linux/390 side? This is so that we could use our 3490E tapes and our OS/390 > tape management system. > > 5) If #4 is NO, then would it be feasible to backup the DB2 tables to > Linux/390 DASD, perhaps "tar" the output, then "ftp" it to the OS/390 > system? What about dedicating a Linux/390 DASD partition(s) to this > function and backing that up using OS/390 (which is possible, the how to is > in a RedBook from IBM). > > 6) Is this so stupid that I should be ashamed that I even asked the > question? > > My problems are: > > 1) CPU required to run DB2 on the OS/390 system - that system is very CPU > constrainted and is likely to be even on the new machine. > > 2) The actual money to get DB2 on OS/390. Cost of OS/390 version vs. cost > of Linux/390 version + OS/390 "client". -- Rich Smrcina Sytek Services, Inc. Milwaukee, WI [EMAIL PROTECTED] [EMAIL PROTECTED] Catch the WAVV! Stay for Requirements and the Free for All! Update your S/390 skills in 4 days for a very reasonable price. WAVV 2003 in Winston-Salem, NC. April 25-29, 2003 For details see http://www.wavv.org
