On Fri, 21 Dec 2007 18:28:18 -0500, Dave Barry <[EMAIL PROTECTED]> wrote:
>Job A on system A issues static SQL query to DB2 on system B. Which is >faster: > >1) DDF call to DB2 on system B via APPC over FICON CTC > >or > >2) Local call to DB2 member of datasharing group w/ FICON CF links? > >Considering the overhead of DRDA protocol and independent enclave >creation/classification/scheduling, etc., I would guess option 2 is more >efficient in terms of CPU and response time. I'm just not sure how to >determine in theory to what degree. > >db > #2 for sure. BTDTGTTS. That is the whole point of high speed data sharing (|| sysplex). Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - ZFUS G-ITO mailto:[EMAIL PROTECTED] z/OS Systems Programming expert at http://expertanswercenter.techtarget.com/ Mark's MVS Utilities: http://home.flash.net/~mzelden/mvsutil.html ---------------------------------------------------------------------- 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
