SAP HANA Command-Line Interface: Unterschied zwischen den Versionen

Aus MattWiki
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 11: Zeile 11:


  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 21:
  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';




Version vom 1. Februar 2020, 14:51 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

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=2217“