HA200 SPS10 -SQL queries

Do you have information on SAP HANA Technology (Suse Linux, HANA Patches, DMIS and so on) then post it here.
Post Reply
User avatar
Hay Bouten
Posts: 130
Joined: Mon Dec 24, 2012 10:11 am
Location: Eindhoven, The Netherlands
Contact:

HA200 SPS10 -SQL queries

Post by Hay Bouten » Sun Aug 30, 2015 12:35 pm

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 Exercise 4: Installing the SAP HANA Interactive Education (SHINE) Content Exercise 5: Connecting to the SAP HANA Database and Opening the Administration Console 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::PO.Item";
  • Insert into statement: INSERT INTO "SAP_HANA_DEMO"."EPM.PO.Item_Part" SELECT * FROM "SAP_HANA_DEMO"."sap.hana.democontent.epm.data::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::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
I have also created two videos that show what happens when a node fails.
Video 1: In a scale-out system the Slave node fails:
https://youtu.be/PgrQadXwYVw

Video 2: In a scale-out system the Master node fails:
https://youtu.be/dFrUNUVuhZQ

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest