Provides Python interface for connecting to IBM Db2 for LUW and IBM Db2 for z/OS
- The ibm_db contains:
- ibm_db driver: Python driver for IBM Db2 for LUW and IBM Db2 for z/OS databases. Uses the IBM Data Server Driver for ODBC and CLI APIs to connect to IBM Db2 for LUW.
- ibm_db_dbi: Python driver for IBM Db2 for LUW that complies to the DB-API 2.0 specification.
For more information on the APIs supported by ibm_db, please refer to below link:
https://github.com/ibmdb/python-ibmdb/wiki/APIs
Install Python 3.7 <= 3.12. The minimum python version supported by driver is python 3.7 and the latest version supported is python 3.12.
Please follow detailed installation instructions as documented here: ibm_db Installation on z/OS
- SQL1598N Error - It is expected in absence of valid db2connect license. Please click here and read instructions.
Important: The driver for IBM DB2 is not compatible with Apple Silicon and will have to run in emulated mode. Please support this request for an Apple Silicon version of the driver to show IBM that you are interested in a native solution.
Several things might be necessary to get
ibm_dbworking on the Apple Silicon architecture:
- Open new terminal and run command
arch -x86_64 /bin/bash or arch -x86_64 /bin/zsh.- Verify the output of
gcc -vcommand. It should showTarget: x86_64-apple-darwin21in output.- Install Intel Version of Python like: https://www.python.org/ftp/python/3.9.11/python-3.9.11-macosx10.9.pkg
- Check output of commands
python --version,which pythonandfile /usr/local/bin/pythoncommands. It should show/usr/local/bin/python: Mach-O 64-bit executable x86_64- Check this link for detailed instructions about installation of ibm_db on MacOS M1/M2 Chip system.
If you face problems due to missing python header files while installing the driver, you would need to install python developer package and retry install. e.g:
zypper install python-devel
or
yum install python-devel
-
If a db2 client or server or dsdriver or clidriver is already installed in the system and user has already set installed path to
PATHenvironment variable, then user need to set environment variableIBM_DB_HOMEmanaully to the installed path before installingibm_db. -
To verify it, just execute
db2levelcommand before installation ofibm_db. If it works, note down the install directory path and set system level environment variableIBM_DB_HOMEas install path shown in output ofdb2levelcommand. -
If user has installed clidriver in
F:\DSDRIVERand if the "PATH" environment variable hasF:\DSDRIVER\bin, then user should also setIBM_DB_HOMEtoF:\DSDRIVER.
Db2 V11.5.4 clidriver is built with GCC version 8.4.0 and hence you may need to upgrade to this version if you face problems due to old version of the GCC compiler in your environment while loading the ibm_db library.
- You may need to install gcc, python, pip, python-devel, libxml2 and pam if not already installed. Refer to Installation for more details.
To install ibm_db from source code after clone from git, or to know the detialed installation steps for various platforms, please check INSTALL document.
- Python Wheels are built for Linux, MacOS and Windows operating systems for multiple python versions (from python version 3.7 to 3.11). For other platforms, package gets installed from source distribution.
You can install the driver using pip as:
pip install ibm_db
This will install ibm_db and ibm_db_dbi module.
Note:
When we install ibm_db package on Linux, MacOS and Windows, pip install ibm_db command install
prebuilt Wheel package that includes clidriver too and ignores IBM_DB_HOME or IBM_DB_INSTALLER_URL
environment variables if set. Also, auto downloading of clidriver does not happen as clidriver is
already present inside wheel package.
To inforce auto downloading of clidriver or to make setting of environment variable IBM_DB_HOME
effective, install ibm_db from source distribution using below command:
pip install ibm_db --no-binary :all: --no-cache-dir
If you have to use your own URL for clidriver.tar.gz/.zip please set environment variable
IBM_DB_INSTALLER_URL=full_path_of_clidriver.tar.gz/.zip
When ibm_db get installed from wheel package, you can find clidriver under site_packages directory
of Python. You need to copy license file under site_packages/clidriver/license to be effective, if any.
Note: For windows after installing ibm_db, recieves the below error when we try to import ibm_db :
Python 3.11.4 (tags/v3.11.4:d2340ef, Jun 7 2023, 05:45:37) [MSC v.1934 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import ibm_db
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: DLL load failed while importing ibm_db: The specified module could not be found.
>>>
We need to make sure to set dll path of dependent library of clidriver before importing the module as:
import os
os.add_dll_directory('path to clidriver installation until bin')
import ibm_db
e.g:
os.add_dll_directory('C:\\Program Files\\IBM\\CLIDRIVER\\bin')
import ibm_db
Refer https://bugs.python.org/issue36085 for more details.
yum install python gcc pam wget python-devel.x86_64 libxml2
use, `yum install python3` to install python 3.x
if pip or pip3 does not exist, install it as:
wget https://bootstrap.pypa.io/get-pip.py
docker cp get-pip.py /root:<containerid>
cd root
python2 get-pip.py or python3 get-pip.py
Install python ibm_db as:
pip install ibm_db
or
pip3 install ibm_db
- Uninstalling the ibm_db driver :
pip uninstall ibm_dbThe ODBC and CLI Driver(clidriver) is automatically downloaded at the time of installation and it is recommended to use this driver. However, if you wish to use an existing installation of clidriver or install the clidriver manually and use it, you can set IBM_DB_HOME environment variable as documented below:
-
Environment Variables:
IBM_DB_HOME :Set this environment variable to avoid automatic downloading of the clidriver during installation. You could set this to the installation path of ODBC and CLI driver in your environment.
e.g:Windows : set IBM_DB_HOME=C:/Users/userid/clidriver Other platforms: export IBM_DB_HOME=/home/userid/clidriver
Note: You must need to install ibm_db using command pip install ibm_db --no-binary :all: --no-cache-dir
on Linux, Windows and MacOS to make setting of IBM_DB_HOME effective.
You are required to set the library path to the clidriver under IBM_DB_HOME to pick this version of the ODBC and CLI Driver.
e.g:
Windows:
set LIB=%IBM_DB_HOME%/lib;%LIB%
AIX:
export LIBPATH=$IBM_DB_HOME/lib:$LIBPATH
MAC:
export DYLD_LIBRARY_PATH=$IBM_DB_HOME/lib:$DYLD_LIBRARY_PATH
Other platforms:
export LD_LIBRARY_PATH=$IBM_DB_HOME/lib:$LD_LIBRARY_PATH
The ODBC and CLI driver is available for download at Db2 LUW ODBC and CLI Driver. Refer to (License requirements) for more details on the CLI driver for manual download and installation.
- Installing using Anaconda distribution of python
conda install -c conda-forge ibm_db
- Supported Platform for Anaconda Installation
| Platform | Architecture | Supported | Version |
|---|---|---|---|
| Linux | amd64 (x86_64) | Yes | Latest |
| Linux | ppc64le | Yes | Latest |
| Darwin | Mac OS x64 | Yes | Latest |
| Windows | x64 | Yes | Latest |
| Windows | x32 | Yes | Latest |
Install Intel/x64 version of python on M1 Chip system. Check this link for detailed instructions.
$ python
Python 3.6.5 (default, May 10 2018, 00:54:55)
[GCC 4.3.4 [gcc-4_3-branch revision 152973]] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import ibm_db
>>> #For connecting to local database named pydev for user db2inst1 and password secret, use below example
>>> #ibm_db_conn = ibm_db.connect('pydev', 'db2inst1', 'secret')
>>> #For connecting to remote database named pydev for uid db2inst and pwd secret on host host.test.com, use below example
>>> # Connect using ibm_db
>>> conn_str='database=pydev;hostname=host.test.com;port=portno;protocol=tcpip;uid=db2inst1;pwd=secret'
>>> ibm_db_conn = ibm_db.connect(conn_str,'','')
>>>
>>> # Connect using ibm_db_dbi
>>> import ibm_db_dbi
>>> conn = ibm_db_dbi.Connection(ibm_db_conn)
>>> # create table using ibm_db
>>> create="create table mytable(id int, name varchar(50))"
>>> ibm_db.exec_immediate(ibm_db_conn, create)
<ibm_db.IBM_DBStatement object at 0x7fcc5f44f650>
>>>
>>> # Execute tables API
>>> conn.tables('DB2INST1', '%')
[{'TABLE_CAT': None, 'TABLE_SCHEM': 'DB2INST1', 'TABLE_NAME': 'MYTABLE', 'TABLE_TYPE': 'TABLE', 'REMARKS': None}]
>>>
>>> # Insert 3 rows into the table
>>> insert = "insert into mytable values(?,?)"
>>> params=((1,'Sanders'),(2,'Pernal'),(3,'OBrien'))
>>> stmt_insert = ibm_db.prepare(ibm_db_conn, insert)
>>> ibm_db.execute_many(stmt_insert,params)
3
>>> # Fetch data using ibm_db_dbi
>>> select="select id, name from mytable"
>>> cur = conn.cursor()
>>> cur.execute(select)
True
>>> row=cur.fetchall()
>>> print("{} \t {} \t {}".format(row[0],row[1],row[2]),end="\n")
(1, 'Sanders') (2, 'Pernal') (3, 'OBrien')
>>> row=cur.fetchall()
>>> print(row)
[]
>>>
>>> # Fetch data using ibm_db
>>> stmt_select = ibm_db.exec_immediate(ibm_db_conn, select)
>>> cols = ibm_db.fetch_tuple( stmt_select )
>>> print("%s, %s" % (cols[0], cols[1]))
1, Sanders
>>> cols = ibm_db.fetch_tuple( stmt_select )
>>> print("%s, %s" % (cols[0], cols[1]))
2, Pernal
>>> cols = ibm_db.fetch_tuple( stmt_select )
>>> print("%s, %s" % (cols[0], cols[1]))
3, OBrien
>>> cols = ibm_db.fetch_tuple( stmt_select )
>>> print(cols)
False
>>>
>>> # Close connections
>>> cur.close()
True
>>> # Dropping the table created
>>> drop = "drop table mytable"
>>> stmt_delete = ibm_db.exec_immediate(ibm_db_conn,drop)
>>> conn1.tables('DB2INST1','MY%')
[]
>>>
>>> ibm_db.close(ibm_db_conn)
True- Secure Database Connection using SSL/TSL - ibm_db supports secure connection to Database Server over SSL same as ODBC/CLI driver. If you have SSL Certificate from server or an CA signed certificate, just use it in connection string as below:
Using SSLServerCertificate keyword
connStr = "DATABASE=<DATABASE_NAME>;HOSTNAME=<HOSTNAME>;PORT=<SSL_PORT>;UID=<USER_ID>;PWD=<PASSWORD>;" +
"SECURITY=SSL;SSLServerCertificate=<FULL_PATH_TO_SERVER_CERTIFICATE>;"
conn = ibm_db.connect(connStr,'','')
Note the two extra keywords Security and SSLServerCertificate used in connection string.
SSLServerCertificateshould point to the SSL Certificate from server or an CA signed certificate. Also,PORTmust beSSLport and not the TCPI/IP port. Make sure Db2 server is configured to accept connection on SSL port elseibm_dbwill throw SQL30081N error.
Value of
SSLServerCertificatekeyword must be full path of a certificate file generated for client authentication. It normally has*.armor*.certor*.pemextension.ibm_dbdo not support*.jksformat file as it is not a certificate file but a Java KeyStore file, extract certificate from it using keytool and then use the *.cert file.
ibm_dbuses IBM ODBC/CLI Driver for connectivity and it do not support a*.jksfile as keystoredb askeystore.jksis meant for Java applications. Note that*.jksfile is aJava Key Storefile and it is not an SSL Certificate file. You can extract SSL certificate from JKS file using belowkeytoolcommand:
keytool -exportcert -alias your_certificate_alias -file client_cert.cert -keystore keystore.jks
Now, you can use the generated client_cert.cert as the value of SSLServerCertificate in connection string.
Do not use keyworkds like
sslConnection=truein connection string as it is a JDBC connection keyword and ibm_db ignores it. Corresponding ibm_db connection keyword forsslConnectionisSecurityhence, useSecurity=SSL;in connection string instead.
ibm_dbsupports only ODBC/CLI Driver keywords in connection string: https://www.ibm.com/docs/en/db2/11.5?topic=odbc-cliodbc-configuration-keywords
- To connect to dashDB in IBM Cloud, use below connection string:
connStr = "DATABASE=database;HOSTNAME=hostname;PORT=port;PROTOCOL=TCPIP;UID=username;PWD=passwd;Security=SSL";
We just need to add Security=SSL in connection string to have a secure connection against Db2 server in IBM Cloud.
Note: You can also create a KeyStore DB using GSKit command line tool and use it in connection string along with other keywords as documented in DB2 Infocenter.
- If you have created a KeyStore DB using GSKit using password or you have got *.kdb file with *.sth file:
Using SSLClientKeyStoreDB and SSLClientKeyStoreDBPassword keyword
connStr = "DATABASE=<DATABASE_NAME>;HOSTNAME=<HOSTNAME>;PORT=<SSL_PORT>;UID=<USER_ID>;PWD=<PASSWORD>;" +
"SECURITY=SSL;SSLClientKeyStoreDB=<FULL_PATH_TO_KEY_STORE_DB>;SSLClientKeyStoreDBPassword=<KEYSTORE_PASSWD>;"
conn = ibm_db.connect(connStr,'','')
Using SSLClientKeyStoreDB and SSLClientKeyStash keyword
connStr = "DATABASE=<DATABASE_NAME>;HOSTNAME=<HOSTNAME>;PORT=<SSL_PORT>;UID=<USER_ID>;PWD=<PASSWORD>;" +
"SECURITY=SSL;SSLClientKeyStoreDB=<FULL_PATH_TO_KEY_STORE_DB>;" +
"SSLClientKeyStash=<FULL_PATH_TO_CLIENT_KEY_STASH>;"
conn = ibm_db.connect(connStr,'','')
If you have downloaded
IBMCertTrustStorefrom IBM site, ibm_db will not work with it; you need to downloadSecure Connection Certificates.zipfile that comes for IBM DB2 Command line tool(CLP).Secure Connection Certificates.ziphas *.kdb and *.sth files that should be used as the value ofSSLClientKeystoreDBandSSLClientKeystashin connection string.
-
More examples can be found under 'ibm_db_tests' folder.
-
API Documentation has examples for each API.
-
Jupyter Notebook examples can be found here -> Other Examples
-
Connection to
Db2 for z/OSorDb2 for i(AS400) Server usingibm_dbdriver from distributed platforms (Linux, Unix, Windows and MacOS) is not free. It requires either client side or server side license. -
Connection to
Db2 for LUWServer usingibm_dbdriver is free. -
ibm_dbreturns SQL1598N error in absence of a valid db2connect license. SQL1598N error is returned by the Db2 Server to client. To suppress this error, Db2 server must be activated with db2connectactivate utility OR a client side db2connect license file must exist. -
Db2connect license can be applied on database server or client side. A db2connect license of version 11.5 is required for ibm_db.
-
For activating server side license, you can purchase either
Db2 Connect Unlimited Edition for System z®orDb2 Connect Unlimited Edition for System i®license from IBM. -
Ask your DBA to run db2connectactivate utility on Server to activate db2connect license.
-
If database Server is enabled for db2connect, no need to apply client side db2connect license.
-
If Db2 Server is not db2connectactivated to accept unlimited number of client connection, you must need to apply client side db2connect license.
-
db2connectactivate utility and client side db2connect license both comes together from IBM in a single zip file.
-
Client side db2connect license is a
db2con*.licfile that must be copied underclidriver\licensedirectory. -
If you have a
db2jcc_license_cisuz.jarfile, it will not work for ibm_db.db2jcc_license_cisuz.jaris a db2connect license file for Java Driver. For non-Java Driver, client side db2connect license comes as a file namedb2con*.lic. -
If environment variable
IBM_DB_HOMEorIBM_DB_INSTALLER_URLis not set,ibm_dbautomatically downloads open source driver specific clidriver from https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli and save assite_packages\clidriver. Ignores any other installation. -
If
IBM_DB_HOMEorIBM_DB_INSTALLER_URLis set, you need to have same version of db2connect license as installed db2 client. Check db2 client version usingdb2levelcommand to know version of required db2connect license. The license file should get copied under$IBM_DB_HOME\licensedirectory. -
If you do not have db2connect license, contact IBM Customer Support to buy db2connect license. Find the
db2con*.licfile in the db2connect license shared by IBM and copy it under.../site_packages/clidriver/licensedirectory or$IBM_DB_HOME\licensedirectory (if IBM_DB_HOME is set), to be effective. -
To know more about license and purchasing cost, please contact IBM Customer Support.
-
To know more about server based licensing viz db2connectactivate, follow below links:
- Activating the license certificate file for Db2 Connect Unlimited Edition.
- Unlimited licensing using db2connectactivate utility.
If you have copied db2con*.lic file under clidriver/license directory, but still getting SQL1598N Error; try below options:
-
cd clidriver/bindirectory and run./db2levelcommand. Make sure you have the db2connect license of same major and minor version as of clidriver. -
Make sure the user running python program has read permission for license file.
-
Make sure the user running python program has read-write permission for
clidriver/licenseandclidriver/cfgcachedirectories as license check utility need to create some cache files undercfgcacheandlicensedirectories. -
Validate your license file and connectivity using below db2cli command:
db2cli validate -connstring "connection string as used in python program" -displaylic
OR
db2cli validate -database "dbname:hostname:port" -userid dbuser -passwd dbpasswd -connect -displaylic
If you intend to install the clidriver manually, Following are the details of the client driver versions that you can download from CLIDRIVER to be able to connect to databases on non-LUW servers. You would need the client side license file as per Version for corresponding installation.:
| Platform | Architecture | Cli Driver | Supported | Version |
|---|---|---|---|---|
| AIX | ppc | aix32_odbc_cli.tar.gz | Yes | V11.5.8 |
| others | aix64_odbc_cli.tar.gz | Yes | V11.5.8 | |
| Darwin | x64 | macos64_odbc_cli.tar.gz | Yes | V11.5.8 |
| Linux | x64 | linuxx64_odbc_cli.tar.gz | Yes | V11.5.8 |
| s390x | s390x64_odbc_cli.tar.gz | Yes | V11.5.8 | |
| s390 | s390_odbc_cli.tar.gz | Yes | V11.1 | |
| ppc64 (LE) | ppc64le_odbc_cli.tar.gz | Yes | V11.5.8 | |
| ppc64 | ppc64_odbc_cli.tar.gz | Yes | V10.5 | |
| ppc32 | ppc32_odbc_cli.tar.gz | Yes | V10.5 | |
| others | linuxia32_odbc_cli.tar.gz | Yes | V11.5.8 | |
| Windows | x64 | ntx64_odbc_cli.zip | Yes | V11.5.8 |
| x32 | nt32_odbc_cli.zip | Yes | V11.5.8 | |
| Sun | i86pc | sunamd64_odbc_cli.tar.gz | Yes | V10.5 |
| sunamd32_odbc_cli.tar.gz | Yes | V10.5 | ||
| sparc | sun64_odbc_cli.tar.gz | Yes | V11.1 | |
| sparc | sun32_odbc_cli.tar.gz | Yes | V11.1 |
You can refer to ODBC and CLI Driver installation for details on how to install the driver manually.
Use following pypi web location for downloading source code and binaries ibm_db: https://pypi.python.org/pypi/ibm_db . You can also get the source code by cloning the ibm_db github repository as :
git clone [email protected]:ibmdb/python-ibmdb.git
Your feedback is very much appreciated and expected through project ibm-db:
- ibm-db issues reports: https://github.com/ibmdb/python-ibmdb/issues
- ibm_db discuss: http://groups.google.com/group/ibm_db
See CONTRIBUTING
The developer sign-off should include the reference to the DCO in remarks(example below):
DCO 1.1 Signed-off-by: Random J Developer <[email protected]>
python3 -m pip install --upgrade pip
For RHEL use
yum install python3-dev
For Ubuntu use
apt-get install python3-dev
- Once the above steps works fine, try re-installing ibm_db.
If connection fails with SQL30081N error - means ibm_db installation is correct and there is some issue with connection string. Please check database connection info and use correct connection string. If you are using SSL connection, port must be SSL port and connection string must have Security=SSL; and SSLServerCertificate=<full path of cert.arm file>;.
-
If
import ibm_dbfails withSymbol not found: ___cxa_throw_bad_array_new_lengtherror ormallocerror: Please follow instructions as documented here. -
If you run into errors for libdb2.dylib as below:
>>> import ibm_db
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: dlopen(/usr/local/lib/python3.5/site-packages/ibm_db.cpython-35m-darwin.so, 2): Library not loaded: libdb2.dylib
Referenced from: /usr/local/lib/python3.5/site-packages/ibm_db.cpython-35m-darwin.so
Reason: image not foundYou would need to set DYLD_LIBRARY_PATH to point to lib folder as per the installation location of clidriver in your environment. Assuming the driver is installed at /usr/local/lib/python3.5/site-packages/clidriver, you can set the path as:
export DYLD_LIBRARY_PATH=/usr/local/lib/python3.5/site-packages/clidriver/lib:$DYLD_LIBRARY_PATH
If the issue is not resolved even after setting DYLD_LIBRARY_PATH, you could refer: MAC OS Hints and Tips
If you hit following error while attempting to connect to a database:
>>> import ibm_db
>>> ibm_db.connect("my_connection_string", "", "")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
Exception: [IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004 SQLCODE=-1042Set DYLD_LIBRARY_PATH to point to icc folder as per the installation location of clidriver in your environment.
export DYLD_LIBRARY_PATH=/usr/local/lib/python3.5/site-packages/clidriver/lib/icc:$DYLD_LIBRARY_PATH
In case of similar issue in windows platform
set PATH=<clidriver_folder_path>\bin\amd64.VC12.CRT;%PATH%
In case of the error seen while building wheel use the following flag along with ibm_db for installation
To install the package ibm_db it is necessary at first to install the build dependency package - wheel:
pip3 install wheel
Install ibm_db with the pip flag --no-build-isolation:
pip3 install ibm_db --no-build-isolation
-
If you have installed
ibm_dbon IBM i and need help, please open an issue here. -
If you have installed
ibm_dbon distributed platform and want to connect to AS400 server, you must have to use db2connect license.ibm_dbdo not work withIBM i Accessdriver.
Tests displaying Python ibm_db driver code examples are located in the ibm_db_tests directory. A valid config.py will need to be created to configure your Db2 settings. A config.py.sample exists that can be copied and modified for your environment.
- Set Environment Variables DB2_USER, DB2_PASSWD accordingly.
For example, by sourcing the following ENV variables:
For Linux
export DB2_USER=<Username>
export DB2_PASSWD=<Password>
For windows
set DB2_USER=<Username>
set DB2_PASSWD=<Password>
- OR
If not using environment variables, update user and password information in
config.json file.
The config.py should look like this:
test_dir = 'ibm_db_tests' # Location of testsuite file (relative to current directory)
file_path = 'config.json'
with open(file_path, 'r') as file:
data = json.load(file)
database = data['database'] # Database to connect to
hostname = data['hostname'] # Hostname
port = data['port'] # Port Number
env_not_set = False
if 'DB2_USER' in os.environ:
user = os.getenv('DB2_USER') # User ID to connect with
else:
user = data['user']
env_not_set = True
if 'DB2_PASSWD' in os.environ:
password = os.getenv('DB2_PASSWD') # Password for given User ID
else:
password = data['password']
env_not_set = True
if env_not_set == True:
warnings.warn("Warning: Environment variable DB2_USER or DB2_PASSWD is not set.")
print("Please set it before running test file and avoid")
print("hardcoded password in config.json file." )Point the database to mydatabase as created by the following command.
The tests that ibm_db driver uses depends on a UTF-8 database. This can be created by running:
CREATE DATABASE mydatabase USING CODESET UTF-8 TERRITORY US
Some of the tests utilize XML functionality only available in version 9 or later of Db2. While Db2 v8.x is fully supported, two of the tests (test_195.py and test_52949.py) utilize XML functionality. These tests will fail on version 8.x of Db2.
In order to run the entire python driver testsuite on Linux, run this command at the command prompt:
python ibmdb_tests.py
To run a single test, set the environment variable, SINGLE_PYTHON_TEST, to the test filename you would like to run, followed by the previous command.
In order to run the entire python driver testsuite on Windows, run this command at the command prompt:
python ibmdb_tests.py
To run a single test, set the environment variable, SINGLE_PYTHON_TEST, to the test filename you would like to run, followed by the previous command.
If trusted context is not set up, there will be two failures related to trusted context. When thick client has been used then additional three failures related to create, recreate DB.
ibm_db do not work with arm64 version of python, use x64 version.
- The rowcount for select statements can not be generated.
- Some warnings from the drivers are not caught by the wrapper. As such these might go unnoticed.
- Podman: Follow the instructions provided on the official Podman website to install Podman on your M1 Mac.
- Docker: Alternatively, you can install Docker using the native Apple Silicon version or the Rosetta-translated Intel version. Choose the method that best fits your requirements.
- Download and install the Intel version of Python 3.8 from the official Python website.
- After installation, ensure that you set the interpreter to Python 3.8 in your development environment.
- For M1 Macs, ensure compatibility by specifying the platform architecture during Docker build commands: docker build -t <image_name> . --platform=linux/amd64 Alternatively, if you're using Podman: podman build -t <image_name> . --platform=linux/amd64
- If you're using an Intel Mac or running Docker with Rosetta translation, use the following command to build your Docker image: docker build -t <image_name> .
- These steps are tailored for M1 Macs to ensure seamless installation and configuration of IBM DB and Docker support.
- Verify that your Dockerfile and any dependencies are compatible with the specified platform architecture. Follow these steps carefully to set up IBM DB and Docker support on your M1 Mac environment. If you encounter any issues or have further questions, feel free to seek assistance from the community or relevant support channels. Happy coding!
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent