SAP HANA
Articles in the SAP HANA category (18).
Articles in the SAP HANA category (18).
- HANA: backup paths and Backint fallback — Change HANA backup paths and enable log_backup_backint_fallback.
- HANA: create a backup user and manage privileges — Create a HANA user for a backup tool, grant its privileges and list them.
- HANA: hdbsql queries for connections, backups and version — SAP HANA SQL queries to list connections, tenants, backups and get the version.
- HANA: hdbuserstore, hdbsql and storage snapshot — Store HANA credentials, connect with hdbsql and prepare a snapshot for an external backup tool.
- HANA: password policy and password reset — Temporarily relax the HANA password policy, reset a password, then restore it.
- Install SAP HANA 2.0 on Linux with hdblcm — Walkthrough of an interactive SAP HANA 2.0 installation with hdblcm: prerequisites, parameters, post-install checks with hdbsql.
- SAP and SAP HANA: discovery, stop and start on Linux — Discover SAP systems and stop/start SAP HANA and application instances with HDB and sapcontrol.
- SAP HANA and S/4HANA: automate the installation with Ansible — Pointer to SAP's blog series on automated HANA and S/4HANA deployment with Ansible.
- SAP HANA backup with Veeam: snapshot and Backint plug-in — Install and configure SAP HANA backup on Linux with Veeam: pre-freeze/post-thaw scripts, SAP HANA plug-in, retention and Ansible update.
- SAP HANA: connect to SYSTEMDB with hdbsql — hdbsql command and SAP HANA Studio wizard to connect to the system database of a multi-container HANA system.
- SAP HANA: detailed memory usage analysis — Pointer to an SAP step-by-step guide for analysing HANA memory usage.
- SAP HANA: find SQL port numbers with M_SERVICES — Query SYS.M_SERVICES to list the SQL ports of a SAP HANA instance.
- SAP HANA: hdbsql, backup and backup catalog from the command line — hdbsql cheat sheet: connection, ports, status queries, SYSTEMDB and tenant backups, scripts and backup catalog cleanup.
- SAP HANA: maintenance and troubleshooting queries on system views — SQL queries on the SYS and _SYS_REPO views: custom objects, settings, users, privileges, expensive statements and calculation views.
- SAP HANA: quick checks with hdbsql and sapcontrol — Common commands to list tenants, sapinit services and the status of SAP instances with hdbsql and sapcontrol.
- Schedule and read SAP HANA statistics server alerts — SQL to schedule SAP HANA alert checks and read current alerts and last checks.
- Start and stop a SAP HANA and SAP environment with sapcontrol — Ordered start and stop of a HANA database, SAP systems (sapcontrol) and an NFS server on Linux.
- Start and stop a SAP system on HANA with sapcontrol — Start and stop order for a SAP system and its HANA database using HDB and sapcontrol.