IBM Db2 11.1 Certification Guide

Converting DMS tablespaces to use automatic storage

To simplify storage management, you can convert to an existing DMS tablespace to use automatic storage by using these steps:

1. Identify the tablespace that you want to convert from DMS non-automatic storage to DMS automatic storage. Then, identify the storage group that you want the tablespace to use.
2. You can use the MON_GET_TABLESPACE () table function to find the candidate for the conversion. A sample SQL statement is as follows:

    SELECT SUBSTR (TBSP_NAME, 1, 12) AS TBSP_NAME, 
    TBSP_ID, TBSP_TYPE, TBSP_CONTENT_TYPE, 
    TBSP_USING_AUTO_STORAGE FROM TABLE (MON_GET_TABLESPACE ('', -2)) AS     T WHERE TBSP_USING_AUTO_STORAGE=0;

3. You can use the ADMIN_GET_STORAGE_PATHS () table function to find ...