HA200 SPS09-SQL queries

[Hay Bouten]

Easy solution Copy&Paste for HA200 SPS10

Exercise 2: Connect SAP HANA Studio to an SAP HANA database

• Role: sap.hana.admin.roles::Monitoring
• Role: sap.hana.ide.roles::SecurityAdmin
• Role: sap.hana.xs.lm.roles::Administrator

Exercise 3: Updating SAP HANA by a new support packag

• URL: https://wdflbmt719x:1129/lmsl/HDBLCM/SHS/index.html <= Attention change the x into 4 or 5
• The SAP HANA Database Installation Kit path: /data/training/install/REV100

Exercise 4: Installing the SAP HANA Interactive Education (SHINE) Content

• SAP HANA Application Lifecycle Management: http://wdflbmt719x:8020/sap/hana/xs/lm/index.html <= Attention change the x into 4 or 5
• SAP HANA Cockpit URL: http://wdflbmt719x:8020/sap/hana/admin/cockpit <= Attention change the x into 4 or 5
• SHINE Role: sap.hana.democontent.epm.roles::Admin
• SHINE URL: http://wdflbmt719x:8020/sap/hana/democo ... pad.html[b] <= Attention change the x into 4 or 5 [/b]

Exercise 5: Connecting to the SAP HANA Database and Opening the Administration Console

• SAP HANA Cockpit URL: http://wdflbmt719x:8020/sap/hana/admin/cockpit <= Attention change the x into 4 or 5

Exercise 6: Monitoring SAP HANA with DBACockpit

• Table name: sap.hana.democontent.epm.data::MD.Products

Exercise 7: Working with HDBSQL

• OS command: hdbsql -n localhost -i 20 -u SYSTEM -p <password_chosen_during_installation>
• SQL command: SELECT * FROM dummy
• OS command: hdbuserstore SET MYSYSTEM localhost:32015 SYSTEM <password_chosen_during_installation>
• OS command: hdbuserstore LIST
• OS command: command: hdbsql -U MYSYSTEM

Exercise 8: Starting and Stopping SAP HANA

• HDB info
• HDB stop
• HDB start
• sapcontrol -nr 20 –function Stop
• sapcontrol -nr 20 –function GetProcessList
• sapcontrol -nr 20 –function Start

Exercise 9: Configuring SAP HANA Studio

• Table name: sap.hana.democontent.epm.data::SO.item
• database parameter: content_vendor

Exercise 10: Table Administration

• Create table statement: CREATE TABLE "SAP_HANA_DEMO"."EPM.PO.Item_Part" like "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::EPM.PO.Item";
• Insert into statement: INSERT INTO "SAP_HANA_DEMO"."EPM.PO.Item_Part" SELECT * FROM "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::EPM.PO.Item";
• Check partitioning consistency statement: CALL CHECK_TABLE_CONSISTENCY('CHECK_PARTITIONING_DATA','SAP_HANA_DEMO','"EPM.PO.Item_Part"');

Exercise 11: Monitoring SAP HANA using Administration

• SQL trace filter: SAP_HANA_DEMO.EPM.PO.ITEM_PART
• SQL command: select * from "SAP_HANA_DEMO"."EPM.PO.Item_Part";

Exercise 12: Transporting Changes

• Create schema statement: create schema TRAIN01;
• Create table statement: create column table "TRAIN01"."PRODUCTS" like "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::EPM.MD.Products" with data;

Exercise 13: Backup and Recovery

• HANA parameter name: basepath_databackup
• HANA parameter name: basepath_logbackup
• Estimate size backup: select sum(allocated_page_size) from M_CONVERTER_STATISTICS;
• HANA parameter name: log_mode
• HANA parameter name: enable_auto_log_backup
• Find the backup_id: select * from M_BACKUP_CATALOG;
• Find the names of the backup files and their size: select * from M_BACKUP_CATALOG_FILES where BACKUP_ID ='<backup-id of your backup>';

Exercise 18: Configure Data Volume Encryption

• Quick start data volume encryption: alter system savepoint;

Exercise 19: Enable Audit Policy

• SQL statement: select * from “TRAIN01. “PRODUCTS”
• Read audit trail: select TIMESTAMP, USER_NAME, AUDIT_POLICY_NAME, STATEMENT_STRING from "PUBLIC". "AUDIT_LOG";

Exercise 20: Maintaining Users and Authorization

• New Package name: HA200_ROLE_PACKAGE
• New design-time role: ROLE_ANALYTIC_01
• New analytic privilege: AP_PURCHASE_OVERVIEW_DE
• New role: BASIC_ADMIN
• New role: BACKUP_ADMIN
• New role: DATA_ADMIN

Exercise 21: Installing a SAP HANA Scale Out System

• mkdir /hanaDist/shared
• mount -a
• df -h | grep /hanaDist
• Calculation View: PURCHASE_OVERVIEW