Learning notes from the learning journey: Installing and Administering SAP HANA to take the Certification "SAP Certified Associate - Database Administrator - SAP HANA".
- Using Database Explorer: START: To start we must connect to SAP HANA Cockpit and look for "Database Explorer" / connect to "Open SQL Console". You must do it because not all admin tasks can be done in Cockpit.
ADD DB: It's possible to add databases that are already connected to the cockpit. Also, it's possible to add a multi/single tenant and add another database.
The user account used when a tenant db connection is automatically added to the database explore is the personal SAP HANA database user.
- Importing and Exporting Database Content:
IMPORT: The database must have been previously exported, and the user import must have Object privileges (insert/update, drop, and create) in the target schema, and import for system privilege finally, binary files must have been generated on the SAP system as in the destination system.
**More than 1GB, use SAP HANA host to avoid sending large amounts of data across the network.
EXPORT: Column-store tables can be exported in CSV and binary. Row-stored, only in CSV.
Display table information:
Must have privileges to display catalog object definitions.
System user doesn't have full access to every table in every schema.Using the SQL Console:
CREATE TABLE: by default, tables are kept in the column storage. They can be created in SQL Console or cmd hdbsql, however, in either of them, the user must have CREATE ANY permission.
MANUAL LOAD: It's relevant to understand the total memory and RAM used to load the table, or actively free up memory.
- Using the SAP HANA Statement Library: STATEMENT LIBRARY: Collection of SQL statements db analysis. (Found in Database Explorer).
MINI CHECKS USAGE: SQL that assists in monitoring the SAP HANA system, collecting historical performance data and system alerts.
Top comments (0)