Repository navigation
Fail to connect to IBMi from Ubuntu Server #1023
Description
Hello,
1/
We have installed DB2_RTC_12_1_Linux_x86-64.tar.gz
Using DB2_CUEi_QS_Activation_12.1 we have activated the license.
db2licm -l is showing :
Product name: "DB2 Connect Unlimited Edition for iSeries"
License type: "Client Device"
Expiry date: "Permanent"
Product identifier: "db2consv"
Version information: "12.1"
2/
We have this source code :
import os
import ibm_db
os.environ['IBM_DB_HOME'] = '/opt/ibm/db2/V12.1/'
os.environ['LD_LIBRARY_PATH'] = '/opt/ibm/db2/V12.1/lib/' + (':' + os.environ.get('LD_LIBRARY_PATH', '') if os.environ.get('LD_LIBRARY_PATH') else '')
conn_str = "DATABASE=C6008454;HOSTNAME=cavinfor;PORT=446;PROTOCOL=TCPIP;UID=;PWD=;"
try:
conn = ibm_db.connect(conn_str, '', '')
print("Connexion réussie à DB2")
ibm_db.close(conn)
except Exception as e:
print(f"Échec de connexion: {e}")
3/
Execution fails :
root@SV-NESSIET:/opt/ibm# python3 test.py
Échec de connexion: [IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968 SQLCODE=-1598
Activity
Earammak commentedon Jul 11, 2025
@cavamacmoe , It says that you do not have db2connect license. Please refer to the document for License requirement: https://github.com/ibmdb/python-ibmdb#Licenserequirements
cavamacmoe commentedon Jul 11, 2025
I have license
e have activated the license.
db2licm -l is showing :
Product name: "DB2 Connect Unlimited Edition for iSeries"
License type: "Client Device"
Expiry date: "Permanent"
Product identifier: "db2consv"
Version information: "12.1"
Earammak commentedon Jul 11, 2025
@cavamacmoe , Can you share " db2level " command output.
Earammak commentedon Jul 11, 2025
@cavamacmoe I hope you referred this page: https://github.com/ibmdb/python-ibmdb?tab=readme-ov-file#troubleshooting-sql1598n-error .
bimalkjha commentedon Jul 11, 2025
@cavamacmoe You have installed DB2_RTC client as
/opt/ibm/db2/V12.1/and then installedibm_dband trying to connect to iSeries server but gettingSQL1598Nerror, right?I think the issue lies in how you installed
ibm_db. Please note thatibm_dbusesdb2 odbc driverfor connectivity. So, when we installibm_db, by defaultibm_dbdownloads its ownodbc/clidriverfrom ibm hosted site and use it rather than any existing client/driver in the system. Your RTC client too has odbc driver and you want ibm_db to use it. For that you need to instruct ibm_db to use existing RTC client and do not download its own clidriver by settingIBM_DB_HOMEenvironment variable before installation of ibm_db.But, above steps too will not work as ibm_db on linux is a precompiled wheel package which includes
clidrivertoo. So, correct commands would be as below:Above pip command will install
ibm_dbfrom source code and not from the precompiled wheel image. So, your system should have gcc compiler to compile native c++ codes of ibm_db which interacts with odbc driver.If you install
ibm_dbusingpip install ibm_db --no-binary :all: --no-cache-dircommand, it will use/opt/ibm/db2/V12.1/lib/libdb2.so.1file for connectivity. You have installed license file for it and it should connect to iSeries server without any error.But,
ibm_dbrequires odbc header files too during compilation of native c++ code. So, make sure you have/opt/ibm/db2/V12.1/includedirectory too. If you do not have this directory, installation ofibm_dbwill fail. I think RTC client do not has include directory which contains SQL and CLI header files.DB2 CLIENTinstaller comes with include directory. Also,IBM Data Server Driver packagecomes with include directory.Note that you can use
ibm_dbwithIBM Db2 Data Server Driver Package,IBM Db2 Client PackageandIBM DB2 Serverinstallations only. Theclidriverthatibm_dbdownloads by default is a minimized version ofIBM Db2 Data Sever Packagewhich includesincludedirectory too. Theclidriverdownloaded fromfix-centraldo not come withincludedirectory.If you can get db2connect license file f.e.
db2consv_is.lic, you can copy it under...\site_package\clidriver\licensedirectory. Thisclidriveryou get when you installibm_dbusingpip install ibm_dbcommand on Linux.ibm_dbuses thisclidriverfor connectivity and if it has license file under license directory, connection to iSeries will succeed.So, you have below options to fix this issue:
clidriver/includedirectory to/opt/ibm/db2/V12.1/then set IBM_DB_HOME and install ibm_db. It should work. Just run below commands on your Linux system and it should work:Let us know which one you tried. Thanks.
cavamacmoe commentedon Jul 15, 2025
@bimalkjha :
I tried "pip install ibm_db --no-binary :all: --no-cache-dir" before but include files were missing
"wget https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/v12.1.0/linuxx64_odbc_cli.tar.gz" solve my problem.
Thanks you very much