Question & Answer
Question
User cannot create DB2 connection in Analytical project in Cloud Pak for Data (CPD) because of the error:
The assets request failed: CDICO0100E: Connection failed: Sql syntax error: [jcc][t4][10509][13454][4.28.11] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid ; or was not activated for the DB2 for z/OS subsystem. If you are connecting directly to ; the data server and using DB2 Connect Unlimited Edition for System z, perform the ; activation step by running the activation program in the license activation kit. ; If you are using any other edition of DB2 Connect, obtain the license file, ; db2jcc_license_cisuz.jar, from the license activation kit, and follow the installation ; directions to include the license file in the class path. ERRORCODE=-4230, SQLSTATE=42968
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m3p000000UoQtAAK","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Product Synonym
CPD,CP4D
Was this topic helpful?
Document Information
More support for:
IBM Cloud Pak for Data
Component:
Administration
Software version:
All Versions
Document number:
7003889
Modified date:
14 June 2023
UID
ibm17003889
Manage My Notification Subscriptions