Connect to the db failed because of a licensing problem

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
Criaz91
Participant
Posts: 8
Joined: Thu Nov 09, 2017 6:24 am

Connect to the db failed because of a licensing problem

Post by Criaz91 »

Hey guys!

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

Code: Select all

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
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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
Criaz91
Participant
Posts: 8
Joined: Thu Nov 09, 2017 6:24 am

Post by Criaz91 »

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.
Criaz91
Participant
Posts: 8
Joined: Thu Nov 09, 2017 6:24 am

Post by Criaz91 »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You really need to find out how uv became empty. This is one of the fundamental executables of the DataStage Engine.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply