Hi, Internally - for SQL - DB2 uses it's own sort routine and does not turn to external product. For utilities (reorg, load) it turns to external sort product
Isaac Yassin -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of R.S. Sent: Friday, January 13, 2006 10:24 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: IBM bundling ... Shane Ginnane wrote: >>>>DB2 absolutely requires DFSORT for some of its internal functions. >>>>Syncsort is documented to not work with DB2. DB2 comes with a > > "subset" > >>>>license for this purpose. I.e. you don't have a general DFSORT > > license. > >>>See the following Informational APAR for more information on this: >>>http://www.ibm.com/support/docview.wss?uid=isg1II14047 >> >>Is there a description somewhere of why this special, internal-only >>interface was added? Why should DB2 care what sort product a site >>uses, > > to > >>the point of mandating installation and use of an IBM product even if >>an installation has chosen another? >> >>This seems to me to be the same kind of bundling that got Microsoft in > > such > >>hot water... > > > Why all the angst ???. > How is this any different to LDAP requirements for RACF ???. IMHO it is fair. You can choose cometition offering. HSM requires DSS product, because they needed it. HSM does not require RMM for example. 3494 does not require RMM. DB2 requires some sort. They used DFSORT, because the code is always included, but they left to customers the choice of sort product. What's wrong with that ? Should DB2 rely on "any sort product" ? I don't think so, consider customer that has no sort. Should DB2 authors create their own sort code ? -- Radoslaw Skorupka Lodz, Poland ---------------------------------------------------------------------- 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 ---------------------------------------------------------------------- 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
