Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

SQLAlchemy support for IBM Data Servers

Project Description

The IBM_DB_SA adapter provides the Python/SQLAlchemy interface to IBM Data Servers.

0.3.0 (2013/03/01)

This version is all new for version 0.8 of SQLAlchemy and will also work with version 0.7.

1. Python 2.5.x or Jython 2.5.x .
2. SQLAlchemy o.7.3 or above.
3. IBM_DB driver and IBM_DB_DBI wrapper 1.0.1 or higher

Install and Configuration
The IBM_DB_SA Python Egg component (.egg) can be installed using the standard setuptools provided by the Python Easy Install through Python Entreprise
Application Kit community portal:

Please follow the steps provided to Install "Easy Install" in the link above and follow up with these additional steps to install IBM_DB_SA:

1. To install IBM_DB_SA egg component available in the remote repositories
( or
> easy_install ibm_db_sa
$ sudo easy_install ibm_db_sa

2. To install IBM_DB_SA egg component from the downloaded .egg file
> easy_install ibm_db_sa-x.x.x-pyx.x.egg
$ sudo easy_install ibm_db_sa-x.x.x-pyx.x.egg

3. To install IBM_DB_SA from source
Standard Python setup should be used::
python install

A TCP/IP connection can be specified as the following::

from sqlalchemy import create_engine

e = create_engine("db2+ibm_db://user:pass@host[:port]/database")

For a local socket connection, exclude the "host" and "port" portions::

from sqlalchemy import create_engine

e = create_engine("db2+ibm_db://user:pass@/database")

Supported Databases
- IBM DB2 Universal Database for Linux/Unix/Windows versions 9.7 onwards
- Remote connections to i5/OS (iSeries)
- Remote connections to z/OS (DB2 UDB for zOS), only by default ibm_db drivers

Known Limitations in ibm_db_sa adapter for DB2 databases
1) Non-standard SQL queries are not supported. e.g. "SELECT ? FROM TAB1"
2) For updations involving primary/foreign key references, the entries should be made in correct order. Integrity check is always on and thus the primary keys referenced by the foreign keys in the referencing tables should always exist in the parent table.
3) Unique key which contains nullable column not supported
4) UPDATE CASCADE for foreign keys not supported
5) DEFERRABLE INITIALLY deferred not supported
6) Subquery in ON clause of LEFT OUTER JOIN not supported

Not Supported / Not Tested
- Python 3 has not yet been tested.
- pyodbc support has not been tested.
- zxjdbc/Jython support is not fully implemented.

ibm_db_sa for SQLAlchemy was first produced by IBM Inc., targeting version 0.4.
The library was ported for version 0.6 and 0.7 by Jaimy Azle.
Port for version 0.8 and modernization of test suite by Mike Bayer.
Release History

Release History

This version
History Node


History Node


History Node


History Node


Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting