Skip to Content

Creating and Removing Extended Storage

Creating and removing Extended Storage using SAP HANA Studio and SAP HANA Cockpit
You will learn
  • Creating Extended Storage using SAP HANA Studio, SAP HANA Cockpit
  • Removing Extended Storage using SAP HANA Studio, SAP HANA Cockpit
  • Step 1

    The first step after you have installed Dynamic Tiering system on your SAP HANA is to create an extended storage dbspace. After installation you have the esserver running but the extended storage is not created yet.

    As discussed in Create Extended Storage, you can create the extended storage in SAP HANA Studio using a SQL console by executing the following:

    sql
    Copy
    CREATE EXTENDED STORAGE AT '<your.machine.name>' size 1000 MB;
    

    Make sure to replace “<your.machine.name>” with your Dynamic Tiering hostname in the statement above.

    To create extended storage in SAP HANA Cockpit first navigate to your resource. Then scroll down to “Dynamic Tiering Links” and click on “Configure Dynamic Tiering”.

    Configure Dynamic Tiering

    You will be taken to a page where you can enter the size and the host name for the extended storage. You can enter the Dynamic Tiering host name and set the size as desired. Once the fields are populated, you can click the “Create” button on the bottom right to add the extended storage.

    Create Extended Storage on Cockpit

    The “Delta” store option is also available here. If you want a delta enabled store, you must create the extended storage with the “Delta” option as “ON”. This is how you are able to create delta enabled extended tables as well.

    Note: If you have created the extended storage without delta enabled, you will not be able to create delta enabled extended tables. You will need to drop and re-add the extended storage with the delta option switched “ON”.

    Under Dynamic Tiering Links, which link do you select?

  • Step 2

    To remove extended storage in SAP HANA Studio, simply execute the following in a SQL console:

    sql
    Copy
    DROP EXTENDED STORAGE CASCADE
    
    Drop Extended Storage Tables in SAP HANA Studio

    Once you have executed the above statement, under the Systems view, refresh “<SID>(TPCH)”. Then click on the drop down arrows in the following order: <SID>(TPCH) > Catalog > TPCH > Tables. You should notice how there no longer exist any extended storage tables.

    Extended Storage Tables Dropped in SAP HANA Studio

    Note: The term “CASCADE” means that any dependent object on the extended storage will also be deleted. Therefore, if you have any extended tables, they will be deleted along with their data.

    Ignore this line. it is used for formatting.

    To remove extended storage in SAP HANA Cockpit, Navigate again to “Configure Dynamic Tiering”.

    Configure Dynamic Tiering

    You should see the following and locate the “Delete” button in the bottom right of the window.

    Remove Extended Storage

    Once you click on “Delete”, you should see the following show up. The “Restrict” option checks if there are any objects relying on the extended storage. If there are any, the delete will not occur. On the other hand, the “Cascade” option will delete all dependencies of the extended storage(the extended tables).

    Restrict and Cascade Option
Back to top