TABLE partition in SAP HANA using HANA studio

HOW TO CREATE NEW PACKAGE IN HANA USING HANA STUDIO

Types of SAP HANA Packages

There are two types of packages in SAP HANA; Structural and Non-structural.

1. Structural: In a structural package, the modeling content is organized in a structured fashion in a logical package tree. The structural packages only contain sub-packages and do not contain information objects. This prevents undesired creation of objects.

2. Non-structural: The non-structural packages, on the contrary, are not organized and contains both sub-packages and information objects.

A delivery unit is a collection of several packages, used for transporting content from one HANA system to another.

Backup

Default location of HANA DB backup.

SAP HANA NOTES 16: HOW to check multi-tenant databases list in HANA studio(HDBSQL console)

1. login to HANA studio.
2. open the HDBSQL console.
3. run the below command.

enjoy...

HANA DB backup using HANA studio

what is contained in the backup file?

The data backup includes not only data, but also data structure that are required for restore of DB.

why to take backup on regular basis?

To save data during disk failures

Pre-requsites:

DB user with roles: Backup Admin
                                Backup Operator

                                Catalog read

Note: same roles are enough for performing the recovery of HDB also.

SQL query for check the backup size:

select sum (allocated_page_size) from M_converter_Stastistics

select volume id, sum (allocated_page_size) from M_Converter_Stasticstics) group by volume id,

based on the out put of the above query --> make space arrangements.

Process:

Method1

• Open HANA studio.
• select the correct system for backup amomgs all systems.
• Right click
• choose backup
• choose type as full / differential /incremental 
• specify the location and prefix for the backup file.
• conform 

Method 2

• Open HANA studio.
• login to system
• open hdbsql
• execute the query:

BACKU DATA USING FILE ('/usr/sap/<SID>/HDBXX/backup/data')