Apple Silicon / M1 / M2 / M3 Support for IBM ODBC/CLI Driver

i troud hard to enable Excel to use the ODBC-Drivers, but at one point, i am stuck: after opening the iodbc-Admin 64 i can't find nor add any driver.

What i did: install the IBM-Driver-Package...macarm64_odbc_cli.tar.gz, extracted and started CLI_Driver.
Also i installed the recommended Unix-ODBC-Driver-Package using brew.

But: i cannot find the file odbc.ini and even if i could, i do not now what to enter in there.
Anyone out here already working with it?

Installing through pip on the M4Pro processor resulted in a failure when importing ibm_db,

Error message: Symbol not found: _SQLAllocHandle

What preparations do I need?

Thanks for updating the pypi package!
https://pypi.org/project/ibm-db/

Love it!

Driver packages downloadable at the link below (eg. macarm64_odbc_cli.tar) include libdb2.dylib but not libdb2o.dylib which historically has been a 64bit version required for interfacing with 64bit unixodbc builds. libdb2 works with ibm_db Python and seemingly pyodbc fine, but does not work with arrow-odbc (segfault), turbodbc (bad data). I found libdb2o in a dsdriver package (v12.1.0_macos_dsdriver.dmg) and it does work with arrow-odbc and turboodbc as expected (which are much faster for certain applications). Will you package libdb2o in the macarm64_odbc_cli.tar release as well? Those releases are automatically installed with ibm_db into site-packages/clidriver which makes them easy to get and consistently reference within Python code. https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/

Amazing! Thanks @Vijaya.

Does anyone have a direct link to the 64bit ODBC arm64 driver? I can't seem to find it on fixcentral

Hi,

I see the status changed to delivered and we are able to use the nodeJs module. Thanks a lot!

However, the python libary is still from march 23 - can you please also update the pip module to 3.3.0?

Thanks in advance

We are planning to release ARM support for open source drivers including python packages in pypi by Jan 2025 or before.

Thanks Vijaya, perhaps a silly question, but how can folks test the development release, whilst we wait for it to be made generally available ? Thanks in advance, Dave

Will leave it in "Development" until open source drivers are updated.

Hi,
thanks for delivering. Any plans for updating the Python packages on pypi?

Only ARM driver binaries are available for MAC from 12.1 release. So one can use 12.1 driver binaries for ARM architecture machines(M1/M2/M3) and 11.5 driver binaries for INTEL architecture machines. On November 14th 2024, all drivers except open source drivers(Python, Go, Node.js etc) for 12.1 are released. Open Source drivers also will be released in sometime as it will have the work of uploading the 12.1 ARM odbc/cli binaries for opensource and building the open source drivers with arm64 odbc/cli binaries.

I have downloaded the new Db2 12.1 Data Server Driver for macOS.

While I am happy to report that it works on a Mac with an M1 chip, it looks like IBM didn't build universal binaries – so the drivers support ONLY M1 chips.  Developers working on currently supported machines using Intel chips (like a 2019 MacBook Pro) will be out of luck:
 

$ sw_vers
ProductName:		macOS
ProductVersion:		15.1
BuildVersion:		24B83


$ /tmp/clidriver/bin/db2level
-bash: /tmp/clidriver/bin/db2level: Bad CPU type in executable


$ file /tmp/clidriver/bin/db2level
/tmp/clidriver/bin/db2level: Mach-O 64-bit executable arm64

2 steps forward, 1 step back.  <sigh>

I am still not able to download the Python Library to connect to DB2 on my Mac. Link shared by you is only for ODBC connection. Above idea was rasied for the same. but look like it is still not addressed

Attaching the error i am getting while install IBM_DB package

╰─ pip install ibm_db ─╯
Collecting ibm_db
Downloading ibm_db-3.2.3.tar.gz (210 kB)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 210.2/210.2 kB 1.9 MB/s eta 0:00:00
Installing build dependencies ... done
Getting requirements to build wheel ... error
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> [2 lines of output]
Detected 64-bit Python
Arm64 architecture is not supported. Please install intel-only (x64) version of python and then install ibm_db.
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
error: subprocess-exited-with-error

× Getting requirements to build wheel did not run successfully.
│ exit code: 1
╰─> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

https://www.ibm.com/support/pages/download-db2-121-clients-and-drivers

Where can i download this new db2 odbc/cli driver from? (can't see new Nov 14 release of driver yet, just older ones).
Can't wait to try it!

I'm having trouble finding the new 12.1 driver. I think new drivers are not available at https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/ . Please share a link where I can download the driver.

Vijaya, I still don't see the apple Silicon driver released with the GA. If possible please share the link for Python Driver

Db2 12.1 is released today as committed.

I still dont see the driver supporting this on MacOS running on Apple sillicon. I waited for 14 Nov, but looks like IBM is yet to release it. Any link from where we can download this?