We're in the process of upgrading to DB2 v11 CM (I know we're late). With that, some of our distributed applications that use the DB2 JDBC drivers or DB2 Connect have begun receiving errors similar to the following:
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DB2ELOC.DB2LIC.SY-
SLIC.6F41366357454677 NOT FOUND IN PLAN DISTSERV. REASON 04
DSNT418I SQLSTATE = 51002 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXEPM SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -100 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF9C' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
We believe this is because they need a new license file to enable the JDBC driver and DB2 Connect to work with DB2 v11. If you disagree, please let me know.
In the past, we've provided these files to the application teams and had them put the license file on their server along with the JDBC or DB2 Connect software. With more and more applications using these things, however, this can become difficult and time consuming.
My understanding is that with the unlimited license, there's a way to enable these products on the mainframe side and then the apps would not have to worry about the license file. Unfortunately, I've found various information on how to do this from the server side but not how to do it from the mainframe side.
Can someone please help and tell me how this can be done with DB2 v11 or where to look for this information?
My preference is to be able to execute something on the mainframe for each DB2 data sharing group rahther than have to execute something on the server then have whatever apps use the JDBC drivers or DB2 Connect not have to include the license file on the server side.
Thanks in advance.