We were doing this for a few years, but in fact actually moved to DB2 on Intel because we were having performance issues with Linux for System z. From what I've heard on the internet I think it was simply a Linux for z tuning issue, but the inhouse VSE/VM sysprogs and (distributed) Linux admins spent months trying to tune it, but in the end management directed them to just go to Intel. Frustrating, because I think if we'd contacted some outside experts we could have got it working; but...
Anyway, we now actually have DB2 and Federation Server running on Intel, and we use Federation Server to access our Oracle (on Intel) databases. So we go z/VSE application -> remote DB2 / Fed Server -> Oracle. We get adequate performance, that's all I'll say. Of course that's only for one more week! A week from tonight we cut over to z/OS. So we'll have z/OS application -> DB2 for z/OS -> remote DB2 / Fed Server -> Oracle. Wheee!!!! :-) I added an additional step because on z/OS the application address space communicates with the DB2 address space, which then communicates with the remote DB2 server. On VSE the application address space itself goes directly (using DRDA) to the remote server. I'd be glad to answer more specific questions, but I don't know how to get you "numbers or statistics". Frank -- Frank Swarbrick Applications Architect - Mainframe Applications Development FirstBank Data Corporation - Lakewood, CO USA P: 303-235-1403 On 5/22/2010 at 1:09 PM, in message <[email protected]>, Arye Shemer <[email protected]> wrote: > Has anyone had experience with z/VSE connected to DB2 on zLinux ? > > If yes, it would be much appreciated to get some performance > information like number of queries per second or any other numbers. > > Thank you, > > Arye. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: GET IBM-MAIN INFO > Search the archives at http://bama.ua.edu/archives/ibm-main.html >>> The information contained in this electronic communication and any document attached hereto or transmitted herewith is confidential and intended for the exclusive use of the individual or entity named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any examination, use, dissemination, distribution or copying of this communication or any part thereof is strictly prohibited. If you have received this communication in error, please immediately notify the sender by reply e-mail and destroy this communication. Thank you. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
