0

When navigating here https://www.ibm.com/docs/en/db2-warehouse?topic=installing-mac-os-x I get the "installDSDriver.sh" but that doesnt help as I dont see where I can download a dmg or something. I need this as i am using unixODBC to load the db2 driver and then be able to run some automated tests that are using db2 database

I have also seen this https://www.ibm.com/docs/en/db2/11.5?topic=system-macos which may work but the lift to get this working would not be worth it for the existing automation tests.

The way I am currently able to connect to db2 at all is via jdbc (using myeclipse) but again would need the driver locally to be able to run these tests.

If anyone can point me in the right direction that would be greatly appreciated

System Apple M3 with OSX 14.3

Improve this question

1 Answer 1

Reset to default
0

For apple silicon, you have to use x64 emulation, and install an x64 Db2 client.

That is because at present date there is no native Db2-driver for apple silicon available from IBM corporation.

The x64 unixODBC can use the tiny footprint clidriver from IBM (for x64 emulation). That has a zero install option (i.e. it is a zipfile (or gzip file) that you can unzip and use if you are emulating x64).

Read about clidriver on the Db2 Knowledge Center pages. You might need to read many of the pages to learn all the required steps, and also all the configuration options. But that is not programming, just reading the docs...

In addition, if your target database is running EITHER on Z/OS (native) or on i-series, then additionally may need a license file (Db2-connect personal) , depending on your server setup/configuration.

Although to remotely access Db2 for i-series, you should definitely not use clidriver but instead use the driver that comes with the i-series access odbc option. This has bindings for ODBC access (although its implementation may be java). If using the i-series access ODBC driver, you need to carefully study ALL of the documentation provided with that option. For any queries relating to that product, refer to IBM, via your IBM i support channel.

When your Db2 database runs on Linux, or Unix or Windows or cloud then you do NOT need a license file with clidriver.

For macos , try unzip and untar from here: https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/macos64_odbc_cli.tar.gz

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

thanks for that. So i do need a license for it. What is really confusing me the driver that comes with i-series access odbc option is a jdbc driver in jar form whereas odbcinst.ini would expect a .so or lyb file
Also when using the iseries access odbc option i keep seeing this error "unixODBC][IBM][System i Access ODBC Driver]Missing system name needed for connection. (ODBC::Error)"
You should mark the answer as accepted if it helped you. Your connection string for odbc should use a correct database-name (the i-series access tooling should be able to show you the correct name). Refer to you IBM i support channel for operational support for that odbc access option.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.