Exploring the remote table spaces

IBM® Db2® Warehouse as a Service is configured with two remote table spaces, one for user data and the other one for user temporary tables.

These can be seen through the MON_GET_TABLESPACE table function, which includes column CACHING_TIER to identify that these table spaces are using the multi-tier cache that includes both the buffer pools and the local on-disk cache on fast storage.

SELECT VARCHAR(TBSP_NAME, 30) AS TBSP_NAME, 
       MEMBER, 
       TBSP_TYPE, 
       CACHING_TIER
FROM TABLE(MON_GET_TABLESPACE('',-2)) AS T

TBSP_NAME                      MEMBER TBSP_TYPE  CACHING_TIER 
------------------------------ ------ ---------- ------------ 
…
OBJSTORESPACE1                      0 DMS        ENABLED
OBJSTORESPACEUTMP1                  0 DMS        ENABLED
…

In addition, you can also see that the two table spaces are defined on remote containers using the MON_GET_CONTAINER table function, that show both the CONTAINER_TYPE as FILE_REMOTE and the CONTAINER_NAME using the internally defined IBMDEFAULREMTALIAS remote storage access alias, which contains all the information required to access the AWS S3 object storage container (bucket).

SELECT VARCHAR(CONTAINER_NAME,40) AS CONTAINER_NAME,  
       VARCHAR(TBSP_NAME,20) AS TBSP_NAME, 
       CONTAINER_TYPE 
FROM TABLE(MON_GET_CONTAINER('',0))

CONTAINER_NAME                           TBSP_NAME            CONTAINER_TYPE
---------------------------------------- -------------------- ----------------
…
FILE_REMOTE://IBMDEFAULTREMALIAS           OBJSTORESPACE1       DB2REMOTE
FILE_REMOTE://IBMDEFAULTREMALIAS           OBJSTORESPACEUTMP1   DB2REMOTE