You will learn
- Connecting to a SAP HANA system.
- Verifying the status of SAP HANA dynamic tiering.
- Create extended storage for the Dynamic Tiering host.
Open SAP HANA Studio. In the SAP HANA Administration Console perspective, right click in the white space within the Systems view on the left. Next select the Add System… menu item to execute it. You can also press S.
Enter the Host Name and the Instance Number of the SAP HANA host you will connect to. When you are done, click Next. You can also press Alt+N.
SYSTEM” as the User Name and enter your Password. Click the Store user name and password in secure storage checkbox so you won’t have to re-enter your credentials when re-connecting to the system. Next click Finish or press Alt+F.
In the System view on the left side, double click on your system (format:
<SID> (SYSTEM)) to open up the “Overview” tab.
In the Overview tab and under General Information, check the status of SAP HANA Dynamic Tiering (It should be under Distributed System). If what you see is:
Right click on your system (format:
<SID> (SYSTEM)) located under the Systems view. Then select Open SQL Console to open a connected SQL console.
In the SQL console, paste in the following script:
CREATE EXTENDED STORAGE AT '<your.machine.name>' size 1000 MB;`
<your.machine.name>” with the host name of the machine where the Dynamic Tiering component is installed.
Click the Execute button to run the SQL script and create the extended storage
dbspace for SAP HANA Dynamic Tiering. You can also press F8. Make sure it completes successfully. Go back to the Verify Extended Storage Status section to verify that extended storage is set up successfully.
The “CREATE EXTENDED STORAGE” statement creates the warm store and the required
dbspace is a logical name for a container of files used to store the Dynamic Tiering table data and related objects.
Dbspaces are specialized to manage specific types of data. Types of
dbspaces used by Dynamic Tiering include
ES_DELTA etc. Creating the extended storage
dbspace is a prerequisite to creating extended tables.