SAP HANA Command-Line Interface: Unterschied zwischen den Versionen

Aus MattWiki
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
== HDB ==
== HDB ==


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


== HDBSQL ==
== HDBSQL ==
Zeile 11: Zeile 10:


  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
When connected commands to quit again:
exit
quit


=== Manage Databases ===
=== Manage Databases ===
Zeile 16: Zeile 20:
  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 33: Zeile 48:


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

Aktuelle Version vom 1. November 2020, 12: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“