Syncsort / DFSORT LPA
I thought this came up in the past but for those of you that have Syncsort and DFSORT on your systems for DB2 8 etc. In LPA how do you have it coded which do you have first or does order not matter? We have a ISV product which seems to be picking up DFSORT even though we have both in LPA we only have DFSORT there for the DB2 v8 people we are only licensed for Syncsort. For DB2 its working fine for the ISV product its failing saying DFSORT isn't licensed, we removed the DFSORT modules from LPA and its working fine again. We prefer having both in LPA coexisting if we could. Thanks Andy Internet: Mailto:[EMAIL PROTECTED] The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message. -- 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
Re: Syncsort / DFSORT LPA
Make sure the DFSORT libs follow the SyncSort libs in LPA. Don Imbriale -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Andy White Sent: Thursday, November 09, 2006 2:32 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Syncsort / DFSORT LPA I thought this came up in the past but for those of you that have Syncsort and DFSORT on your systems for DB2 8 etc. In LPA how do you have it coded which do you have first or does order not matter? We have a ISV product which seems to be picking up DFSORT even though we have both in LPA we only have DFSORT there for the DB2 v8 people we are only licensed for Syncsort. For DB2 its working fine for the ISV product its failing saying DFSORT isn't licensed, we removed the DFSORT modules from LPA and its working fine again. We prefer having both in LPA coexisting if we could. Thanks *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** -- 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
Re: Syncsort / DFSORT LPA
On Thu, 9 Nov 2006 14:31:59 -0500, Andy White [EMAIL PROTECTED] wrote: I thought this came up in the past but for those of you that have Syncsort and DFSORT on your systems for DB2 8 etc. In LPA how do you have it coded which do you have first or does order not matter? We have a ISV product which seems to be picking up DFSORT even though we have both in LPA we only have DFSORT there for the DB2 v8 people we are only licensed for Syncsort. For DB2 its working fine for the ISV product its failing saying DFSORT isn't licensed, we removed the DFSORT modules from LPA and its working fine again. We prefer having both in LPA coexisting if we could. I don't recall if it came up here, but I'm sure it is documented pretty well in info APAR II14047. Here is the order I have: hlq.SYNCSORT.SYNCLPA hlq.SYNCSORT.SYNCRENT SYS1.SICELPA Mark -- Mark Zelden Sr. Software and Systems Architect - z/OS Team Lead Zurich North America / Farmers Insurance Group - GITO mailto:[EMAIL PROTECTED] z/OS and OS390 expert at http://searchDataCenter.com/ateExperts/ 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
Re: Syncsort / DFSORT LPA
I just have to ask: why do would an installation need both sort products unless you're at an ISV where you have to test your product with both? Tim Hare Senior Systems Programmer Florida Department of Transportation (850) 414-4209 -- 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
Re: Syncsort / DFSORT LPA
We put only SYS1.SICELPA in LPA. Since this data set only has the DFSORT SVC, it did not matter whether it was before or after syncsort's LPA modules. We put SYS1.SICELOAD and SYS1.SORTLPA *after* syncsort's libraries in the link list. These steps were per instructions in II14047. II14047 describes several alternative options for installing the two sort products so they can successfully coexist. Perhaps your ISV product is attempting to detect which sort product to use. With the introduction of DB2 Version 8's requirement for DFSORT, perhaps your problem is actually within the ISV product. Is this ISV product at a current level? In any event, I'd certainly go to the ISV and open a problem with them. Their own sort product detection logic may be defective. Brian On Thu, 9 Nov 2006 14:31:59 -0500, Andy White wrote: I thought this came up in the past but for those of you that have Syncsort and DFSORT on your systems for DB2 8 etc. In LPA how do you have it coded which do you have first or does order not matter? We have a ISV product which seems to be picking up DFSORT even though we have both in LPA we only have DFSORT there for the DB2 v8 people we are only licensed for Syncsort. For DB2 its working fine for the ISV product its failing saying DFSORT isn't licensed, we removed the DFSORT modules from LPA and its working fine again. We prefer having both in LPA coexisting if we could. Thanks Andy -- 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
Re: Syncsort / DFSORT LPA
DFSORT is needed for DB2 V8, even if you license/use SyncSort. But it does NOT require that DFSORT be licensed - it just needs to be accessible by certain DB2 utilities and functions. Don Imbriale -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tim Hare Sent: Thursday, November 09, 2006 3:09 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Syncsort / DFSORT LPA I just have to ask: why do would an installation need both sort products unless you're at an ISV where you have to test your product with both? *** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. *** -- 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
Re: Syncsort / DFSORT LPA
Brian Peterson wrote on 11/09/2006 12:09:23 PM: ... II14047 describes several alternative options for installing the two sort products so they can successfully coexist. ... Right. Here's a link to informational APAR II14047: http://www.ibm.com/support/docview.wss?uid=isg1II14047 Frank Yaeger - DFSORT Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration = DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ -- 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
Re: Syncsort / DFSORT LPA
If you use Syncsort as your sort product and you have DB2 v8, you will need the DFSORT to make it work. IBM will let you use 'very limited' amount, just for DB2 v8 which requires it. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Tim Hare Sent: Thursday, November 09, 2006 3:09 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Syncsort / DFSORT LPA I just have to ask: why do would an installation need both sort products unless you're at an ISV where you have to test your product with both? Tim Hare Senior Systems Programmer Florida Department of Transportation (850) 414-4209 -- 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
Re: Syncsort / DFSORT LPA
On Thu, 9 Nov 2006 15:09:06 -0500 Tim Hare [EMAIL PROTECTED] wrote: :I just have to ask: why do would an installation need both sort products :unless you're at an ISV where you have to test your product with both? Because, for whatever reason, DB2 insists on using DFSORT - it does not allow the customer to choose the sort product to use. But the bright side is that one can use DFSORT for free if only used with DB2. -- Binyamin Dissen [EMAIL PROTECTED] http://www.dissensoftware.com Director, Dissen Software, Bar Grill - Israel Should you use the mailblocks package and expect a response from me, you should preauthorize the dissensoftware.com domain. I very rarely bother responding to challenge/response systems, especially those from irresponsible companies. -- 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
Re: Syncsort / DFSORT LPA
I just have to ask: why do would an installation need both sort products unless you're at an ISV where you have to test your product with both? May be it is in a state of unfinished or perpetual conversion ... some of us went though this over years gone ... :-) -- 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
Re: Syncsort / DFSORT LPA
I just have to ask: why do would an installation need both sort products unless you're at an ISV where you have to test your product with both? You haven't been following the DB2 V8 requirements. Even SYNCSORT customers have to have a subset of DFSORT installed. DB2 V8 will not talk to SYNCSORT. It's a free licence (for V8). When in doubt. PANIC!! -- 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
