Setting up your environment for Native Cloud Object Storage

Set up requirements

IBM Db2 Warehouse 11.5.9 allows the user to enable Native Cloud Object Storage (NCOS) at deployment time. There are a few steps in order to complete NCOS configuration:
  • Set up the two pre-requisites: the cloud object storage bucket and the local storage for the caching tier.
  • Deploy your Db2 instance with Native Cloud Object Storage support enabled through the Db2uInstance custom resource (CR).
  • Configure your Db2 instance and database with the remote storage access alias, remote storage group and two remote table spaces - one regular table space and one user temporary table space.

After these, these remote table spaces backed by cloud object storage can be used to create both column-organized tables and column-organized Declared Global Temporary Tables in object storage.

NCOS in Db2 Warehouse AWS

Db2 Warehouse hosted on Amazon Web Services includes the support of Native Object Storage within its managed service and comes out of the box configured for users to directly exploit this feature. This includes the provisioning of the Object Storage container (bucket) and the configuration of the storage hierarchy, including two remote table spaces - one regular table space OBJSTORESPACE1 and one user temporary table space OBJSTORESPACEUTMP1. These can then be used to create both column-organized tables and column-organized Declared Global Temporary Tables in object storage.