Add DB2 10.5 Support

Registered by Matt Riedemann

Add the code to sqlalchemy-migrate to support the ibm_db_sa engine to talk to DB2.

The minimum version of DB2 supported would be 10.5 for handling unique constraints with nullable columns.

Support running unit tests against DB2 10.5 Express-C on x86_64.

Depends on getting ibm_db_sa into openstack-requirements: https://review.openstack.org/#/c/48745/

Note that there are some existing DB2 blueprints for other projects but they will depend on this one (except Keystone):

Chef: https://blueprints.launchpad.net/openstack-chef/+spec/db2-support

Oslo: https://blueprints.launchpad.net/oslo/+spec/openstack-db2-support

Nova: https://blueprints.launchpad.net/nova/+spec/db2-database

Cinder: https://blueprints.launchpad.net/cinder/+spec/db2-database

Glance: https://blueprints.launchpad.net/glance/+spec/db2-database

Keystone already has the support: https://github.com/openstack/keystone/commit/052e7d525146c235f3c4ddc729ee6e1ac18a1337

============

Note that the patches are already available, they just need to be pushed up to OpenStack.

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
Matt Riedemann
Definition:
New
Series goal:
Proposed for trunk
Implementation:
Implemented
Milestone target:
None
Started by
Matt Riedemann
Completed by
Matt Riedemann

Related branches

Sprints

Whiteboard

The project does not appear to be on a milestone schedule, but we'd be targeting icehouse-1 since this is a pre-req for the other core projects having DB2 support.

Gerrit topic: https://review.openstack.org/#q,topic:bp-db2-support,n,z

Addressed by: https://review.openstack.org/55572
    Add DB2 10.5 Support

======

DB2 support is in the 0.9 release of sqlalchemy-migrate.

-- mriedem

(?)

Work Items

Work items:
Contribute the patches to Gerrit: DONE
Get CI to run UT against DB2: DONE

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.