SAP HANA Command-Line Interface: Unterschied zwischen den Versionen

Aus MattWiki
K (Matt verschob die Seite SAP HANA HDBSQL Command Line Interface nach SAP HANA Command-Line Interface, ohne dabei eine Weiterleitung anzulegen)
Keine Bearbeitungszusammenfassung
Zeile 1: Zeile 1:
== Connect to Server ==
== HDB ==
 
=== Start / Stop HANA Server ===
 
HDB stop
HDB start
 
== HDBSQL ==
 
=== Connect to Server ===


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


== Manage Databases ==
=== Manage Databases ===


  alter system stop database <databasename>        # Stop Database
  alter system stop database <databasename>        # Stop Database


== Activate Scriptserver ==
=== Activate Scriptserver ===


  hdbsql -i 90 -d systemdb -u SYSTEM
  hdbsql -i 90 -d systemdb -u SYSTEM

Version vom 1. Februar 2020, 14:31 Uhr

HDB

Start / Stop HANA Server

HDB stop
HDB start

HDBSQL

Connect to Server

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

Manage Databases

alter system stop database <databasename>         # Stop Database

Activate Scriptserver

hdbsql -i 90 -d systemdb -u SYSTEM
alter database XE  ADD 'scriptserver';
quit

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


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