Bookmark and Share
RSS

Recent Posts

Upgrading Data Server Clients and Drivers for Db2 12

April 3, 2018

As you move to new function levels in Db2 for z/OS Version 12, you'll need to upgrade your remote Db2 data server clients and drivers. IBM's Db2 12 Knowledge Center provides instructions.

With Db2 function levels, keeping data server drivers current is critical. If you choose not to upgrade, you could alternatively have the data server driver packages bound into separate package collections. Each collection would have a unique name identifying the function level for the application.

For background, I wrote about the application compatibility subsystem parameter (APPLCOMPAT) when it was introduced in Db2 11. The IBM Knowledge Center lists valid application compatibility values for Db2 12.

If you're running with an older client and driver and the active function level is higher than M500, it could trigger a DSNL076I error message:

DSNL076I   csect-name DDF CONNECTION REJECTED DUE TO INCOMPATIBLE APPLCOMPAT VALUES. LUWID=luw-idCLIENTAPPLCOMPAT=clientapplcompat-value PACKAGE APPLCOMPAT=package-applcompat-value PACKAGE=package THREAD-INFO=thread-information

Your application will also receive SQLCODE -30025, which looks like this:

-30025   EXECUTION FAILED BECAUSE FUNCTION IS NOT SUPPORTED BY THE SERVER WHICH CAUSED TERMINATION OF THE CONNECTION: LOCATION location PRODUCT ID identifier REASON reason-code (sub-code)

If you've moved from function level M500 to M501 and dealt with this issue, please share your experiences in comments.

Posted April 3, 2018| Permalink

comments powered by Disqus