Skip to content

DB2 LUW and Multi-tenancy in the Cloud

November 18, 2015

DB2 LUW is supremely positioned and designed to inherently support multi-tenancy, whether or not the original designers intended it to be :). Since a database in DB2 is more like a system in SQL Server and Oracle, meaning databases in DB2 are physically separated in DB2. So you can use multiple databases per instance or more likely multiple database schemas in a DB2 database to implement multi-tenancy. With this design, multi-tenants can be assigned to separate bufferpools and even physical disk by by using multiple storage groups for tablespaces. There is a good paper on DB2 multi-tenancy in the cloud here, http://www.ibm.com/developerworks/data/library/techarticle/dm-1201dbdesigncloud/

and my friend in the IBM Toronto Lab, Enzo Cialini has a nice presentation on this. He presented this last year at the Central PA DB2 Users Group in Harrisburg.  Stay tuned and secure.

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: