DB2 LUW and Multi-tenancy in the Cloud

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.