SAP HANA Command-Line Interface

Aus MattWiki

HDB

HDB stop              # Stop HANA Server
HDB start             # Start HANA Server
HDB info              # Info about HANA Server

HDBSQL

Connect to Server

hdbsql -i 90 -d systemdb -u SYSTEM        # Connect to System-DB with User SYSTEM

When connected commands to quit again:

exit
quit

Manage Databases

alter system stop database <databasename>         # Stop Database

Scriptserver Activate / Remove

Activate scriptserver to tenant database:

alter database <databasename>  ADD 'scriptserver';  # Use HXE as databasename on HXEHOST

Quelle: https://developers.sap.com/tutorials/xsa-calculation-views-anonymization-k.html

Remove scriptserver from tenant database, example for HXE database at HXEHOST:

alter database HXE REMOVE 'scriptserver' at 'hxehost:39043';
alter database HXE REMOVE 'scriptserver' at 'hxehost:39046';
alter database HXE REMOVE 'scriptserver' at 'hxehost:39049';
alter database HXE REMOVE 'scriptserver' at 'hxehost:39052';



Quellen

  • SAP HANA Administration Guide for SAP HANA Platform 2.0 SPS 04:

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/c22c67c3bb571014afebeb4a76c3d95d.html