We just went from DB2 v9 to v12 M500. Had to upgrade clients to 11.5. Doug
. On Dec 15, 2022, at 08:35, Clark, Kevin <[email protected]> wrote: Looks like you'll need to be at least V11.1.??? for Data Sever Client https://www.ibm.com/docs/en/db2-for-zos/12?topic=aclid-v12r1mnnn-application-compatibility-levels-data-server-clients-drivers V9.5 reach EOS many years ago. We just ran a scan to locate software version and still have a few 9.5 versions out there after upgrading to V11.5 Client. It's worth the effort to upgrade everywhere as soon as possible , to avoid these type of road blocks going forward with DB2 upgrades Kevin -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Binyamin Dissen Sent: Thursday, December 15, 2022 4:39 AM To: [email protected] Subject: Re: DB2 V12 DB2 connect v9.5 problem EXTERNAL EMAIL – USE CAUTION: This email is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments. Perhaps I am missing something, but the V12R1M500 is the BIND APPLCOMPAT on the mainframe. The client doesn't need any V12 services (or V9, for that matter). How can I bind the PACKAGE so that the client side APPLCOMPAT (of *) is acceptable? Or how can I tell IBM DB2 Client 9.5 to set APPLCOMPAT? Don't see any obvious option or command to set it. On Thu, 15 Dec 2022 08:50:53 +1100 Attila Fogarasi <[email protected]> wrote: :>Normally this is due to a back-level client driver which doesn't support :>M502. Installing a new driver on the client system is the usual remedy if :>M502 is really needed (function used in the applications). Otherwise you :>can rebind the package specifying V12R1M500 which should work with the :>existing back-level driver. :> :>On Wed, Dec 14, 2022 at 9:42 PM Binyamin Dissen <[email protected]> :>wrote: :> :>> I am getting :>> :>> DSNL076I -DBCG DSNLXSVC DDF CONNECTION REJECTED DUE 794 :>> TO INCOMPATIBLE APPLCOMPAT VALUES. :>> LUWID=P3EBC7B8.H043.DC8D7A13DC85 :>> CLIENTAPPLCOMPAT=* :>> PACKAGEAPPLCOMPAT=V12R1M502 :>> PACKAGE=NULLID.SQLC2G13.41414141414E4758 :>> :>> I cannot figure out how to set the client level APPLCOMPAT or bind the :>> nullid :>> package to match. -- Binyamin Dissen <[email protected]> https://urldefense.com/v3/__http://www.dissensoftware.com__;!!EwdynJtshnZ7iu3ntw!mBf5f2W_JigNcVHMOLqhTM86-k5x_toZh3jvLl_OuUmDUFrK7qXje1qQMsDdzasPcfYf2S5d4w6SQFc1sXoaetg$ Director, Dissen Software, Bar & Grill - Israel ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ******************************************************************************* Unauthorized interception of this communication could be a violation of Federal and State Law. This communication and any files transmitted with it are confidential and may contain protected health information. This communication is solely for the use of the person or entity to whom it was addressed. If you are not the intended recipient, any use, distribution, printing or acting in reliance on the contents of this message is strictly prohibited. If you have received this message in error, please notify the sender and destroy any and all copies. Thank you. ATENCIÓN: Si habla español, tiene a su disposición servicios gratuitos de asistencia lingüística. Llame al 855-258-6518 注意：如果您使用繁體中文，您可以免費獲得語言援助服務。請致電 855-258-6518 CareFirst BlueCross BlueShield, CareFirst BlueChoice, Inc. and all of their corporate affiliates comply with applicable federal civil rights laws and do not discriminate on the basis of race, color, national origin, age, disability or sex. ******************************************************************************* ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
