Storage Architecture with Native Cloud Object Support

Support for native cloud object storage introduces a new multi-tier storage architecture for table spaces that allows the native storage of data pages for data base objects (for example, column-organized tables) in cloud object storage.

For more information on table spaces, see Table Spaces.

In the diagram below we show the multiple components that are part of the storage architecture of a typical IBM® Db2® Warehouse as a Service deployment model, in this example with 2 compute nodes and 4 database partitions on each: the first compute node runs database partitions 0, 1, 2 and 3, and the second compute node runs database partitions 4, 5, 6, and 7. In the diagram below you can see the three levels of storage that are part of this architecture that supports cloud object storage:

• Reliable durable file storage is associated with each of the Db2 Database Partitions - this is an existing element in the IBM Db2 Warehouse as a Service architecture that is maintained in the current generation to enable a simple path towards adoption of the object storage medium for existing databases.
• A new layer of local storage in fast SSD/NVMe disks that are only associated with the compute node they are attached to, and that as the diagram shows are used as a local cache for the objects in object store. In the diagram we show multiple local disks, one per Db2 Database Partition, just to show that each Db2 Database Partitions manages its own portion of the local cache independently from the others.
• In the object storage layer, there are objects within the object storage layer that are associated with each of the database partitions.