DSXchange

Posted: **Tue Mar 13, 2018 3:57 am**

Hey guys!

When I open datastage (11.3.1) and I run ETL job, then it fails on the following error:

APT_CombinedOperatorController,0: Fatal Error: Fatal: SQLExecDirect: DB2 error info message '[IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968

I think it is happening only with jobs which are connecting to DB2 z/OS.

Our engine tier is on SUSE linux (infopshere infromation server 11.3.1 + WAS + DB2 LUW). I'm getting this error after I upgraded DB2 LUW from 10.5 to 11.1 version. I upgraded our instances and local databases (XMETA, IADB). And I also applied the following licenses:

Code: Select all

Product name:                     "DB2 Enterprise Server Edition"
License type:                     "Restricted"
Expiry date:                      "Permanent"
Product identifier:               "db2ese"
Version information:              "11.1"
Features:
IBM DB2 Performance Management Offering:              "Not licensed"

Product name:                     "DB2 Connect Enterprise Edition"
License type:                     "User"
Expiry date:                      "Permanent"
Product identifier:               "db2consv"
Version information:              "11.1"
Concurrent connect user policy:   "Disabled"
Enforcement policy:               "Soft Stop"
Number of licensed authorized users: "10"

Something is needed to do on Client side too? Thanks in advance

Posted: **Tue Mar 13, 2018 6:08 am**

Did you apply a new license file? The following IBM note indicates that this might be your issue: http://www-01.ibm.com/support/docview.w ... wg21635635

Posted: **Wed Mar 14, 2018 3:02 am**

I installed DB2 11.1 LUW, and my license is now (I removed DB2 connect, because I thinkg it's not needed for me):

DB21085I This instance or install (instance name, where applicable:
"db2inst1") uses "64" bits and DB2 code release "SQL11010" with level
identifier "0201010F".
Informational tokens are "DB2 v11.1.0.0", "s1606081100", "DYN1606081100AMD64",
and Fix Pack "0".
Product is installed at "/opt/ibm/db2/V11.1_1".

I think it's ok. Somehow infosphere doesn't like db2 11.1...I can connect from engine tier to databases via "db2 connect"... but if I open datastage client jobs are aborting on license issue.

Posted: **Mon Mar 26, 2018 7:27 am**

Issue solved, I don't know why but our "/opt/IBM/InformationServer/Server/DSEngine/bin/uv" file was empty, so I recovered it and actually it solved our licensing issue.

Posted: **Tue Mar 27, 2018 2:57 am**

You really need to find out how uv became empty. This is one of the fundamental executables of the DataStage Engine.

DSXchange

Connect to the db failed because of a licensing problem

Connect to the db failed because of a licensing problem