Hana Start Stop Commands - Sap Hana Tutorials Free - S_4 Hana.docx

HANA System hangs with high CPU usage? Root cause: Problem caused by the configuration of transparent huge page What to Check 1. Check Transparent Huge Page whether it is set to [never] by running the command "cat /sys/ kernel/mm/transparent_hugepage/enabled" Fix Apply KBA 2031375 - SAP HANA: Transparent HugePages (THP) setting on Lin Expensive Statements Trace Activation HANA ADMIN TASKS File: global.ini Property: expensive_statement Default: Inactive HANA Studio You activate and configure the expensive statements trace in the Administration editor on either the Trace Configuration tab or the Performance tab. Additional Info: You can configure the expensive statement trace How to Install PCA - BW on HANA, PCA Migration Post Copy Automation? The functionality of BW PCA is delivered via notes and support packages. However, in order to use the tool, you need a license key for LVM. This key is an add-on. SAP Notes for PCA Note 1614266 system copy: Post copy Automation (PCA) / LVM Note 1707321 BW System Copy: Note analyzer Post Copy Auto Submit HANA ERROR What hardware does SAP HANA run on? HANA appliances must be certified and come either as ADMIN pre-built appliances from your vendor of choice or as a custom build using your storage and networks "Tailored Datacenter Integration" or TDI. SAP maintain a list of certified hardware platforms which currently includes Cisco, Dell, Fujitsu, Hit If HANA is available the following services will be active for each system: nameserver indexserver preprocessor Where to Check these services? HANA Studio--> Administrator Editor--> Overview Tab How to Start/Stop HANA HANA ADMIN TASKS, HANA DATABASE Database Services ? We can Start and stop individual database services Nameserver , indexserver, statistics server, xsengine etc.,) Hana Studio --> Administrator Editor-->Landscape--> Services tab --> stop/start/kill/start missing service Navigator View--> Rt. Click System to Start--> Start Hana Studio--> Navigator View--> Rt. Click System to Start--> Stop How to Export list of HANA ADMIN TASKS, SAP HANA STUDIO HANA Systems SAP Hana Studio ---> File-->Export Expand Hana Studio Folder Landscape--->Next--> Choose system to export and target file location --> Export Finish Homogeneous System Copy on SAP HANA 1. Use SAP HANA Studio to create a database backup. For a full description of the procedure and the SAP HANA backup options, refer to SAP HANA Database - Backup and Recovery Guide on SAP Help Portal. a) In SAP HANA Studio, right-click the database HANA Sample Landscape with 4 Nodes HANA Management Console Screen shows a sample configuration with 4 nodes Three Nodes are Active One Node is Standby Tags: HANA Active Nodes status screen, HANA MC, HANA

Management console, Hana standby nodes, HANA Master Node, HANA slave node. HANA BASIS ADMINISTRATOR TASKS AND ACTIVITIES What are the activities performed by HANA BASIS ADMINISTRATOR in HANA Projects? HANA SW and OS will be pre-installed by HW Vendor HW Vendor HANA client software installation on server by HW Vendor HW Vendor Setup roles for admin, consumers, HANA modelers Basis How to check if SAP HANA ADMIN TASKS, HANA INSTALL STEPS Host Agent installed Command to check SAP Host Agent installed: Run the following Command ./sapcontrol nr 00 -function CheckHostAgent Output SAPHostAgent NOT Installed What is HANA OSS Message component HANA ADMIN TASKS? What is the component to open oss message regarding SAP HANA Installation errors "BC-DB-HDB-INS" O comments How to start HANA database with HANA studio? How to start and stop the SAP HANA database with the SAP HANA studio? Launch the SAP HANA studio and open the administration console perspective. If the administration console perspective does not open automatically, you can open it manually from Window > Open Perspective > Administration HANA ADMIN TASKS, HANA DATABASE, HANA ERRORS, SUM FOR HANA Sequence of Steps to Start SAP HANA 1. Start the SAP HANA database. 2. Start the Sybase Replication Server. 3. Start the Sybase ECDA. 4. Start the Sybase Replication Agent. 5. Start the Bl client (for example, Microsoft Excel). What is the location for HANA error Logs? These log files are available in HANA studio on the Diagnosis Files tab page of the administration screen. Additional Info: You can turn on and configure several traces from the Trace Configuration tab in HANA Studio. Trace files can be found here: /usr/sap/<SlD>/HDB<system number>