DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
Criaz91
Participant



Joined: 09 Nov 2017
Posts: 8

Points: 111

Post Posted: Tue Mar 13, 2018 3:57 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Unix
Additional info: SQL1598N An attempt to connect to the database server faile
Hey guys!

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

Code:
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:

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

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16307
Location: Germany
Points: 92471

Post Posted: Tue Mar 13, 2018 6:08 am Reply with quote    Back to top    

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.wss?uid=swg21635635

_________________

Image
Rate this response:  
Not yet rated
Criaz91
Participant



Joined: 09 Nov 2017
Posts: 8

Points: 111

Post Posted: Wed Mar 14, 2018 3:02 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Criaz91
Participant



Joined: 09 Nov 2017
Posts: 8

Points: 111

Post Posted: Mon Mar 26, 2018 7:27 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54225
Location: Sydney, Australia
Points: 294087

Post Posted: Tue Mar 27, 2018 2:57 am Reply with quote    Back to top    

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

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours