SAP HANA Command-Line Interface: Unterschied zwischen den Versionen

Aus MattWiki
(Die Seite wurde neu angelegt: „== Connect to Server == hdbsql -i 90 -d systemdb -u SYSTEM # Connect to System-DB with User SYSTEM == Manage Databases == alter system stop databas…“)
 
Keine Bearbeitungszusammenfassung
 
(4 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
== Connect to Server ==
== 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
  hdbsql -i 90 -d systemdb -u SYSTEM        # Connect to System-DB with User SYSTEM


== Manage Databases ==
When connected commands to quit again:
 
exit
quit
 
=== Manage Databases ===


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


== Activate Scriptserver ==
=== Scriptserver Activate / Remove ===


hdbsql -i 90 -d systemdb -u SYSTEM
Activate scriptserver to tenant database:
  alter database XE ADD 'scriptserver';
 
  quit
  alter database <databasename> ADD 'scriptserver';  # Use HXE as databasename on HXEHOST


Quelle: https://developers.sap.com/tutorials/xsa-calculation-views-anonymization-k.html
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';




Zeile 24: Zeile 48:


[[Category:SAP]]
[[Category:SAP]]
[[Category:HANA]]
[[Category:Terminal]]
[[Category:Terminal]]

Aktuelle Version vom 1. November 2020, 13:54 Uhr

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

Abgerufen von „https://otremba.net/w/index.php?title=SAP_HANA_Command-Line_Interface&oldid=2510“