Viewing Status of Your #SAP #HANA Server Without HANA Studio
Viewing Status of Your #SAP #HANA Server Without HANA Studio: Today I wondered how HANA Studio works. So I traced HANA Studio connections. And discovered that it communicate with HANA server using SOAP requests.
There are some methods. But in this blog I will mentiion only 2 of them.
Before starting writing about them SOAP url is: https://host:5013/SAPControl
- The first one is about statuses of processes of HANA Server:
This SOAP request returns:
hdbdaemon HDB Daemon SAPControl-GREEN Running 2012 10 25 14:58:02 4:33:15 5479 hdbnameserver HDB Nameserver SAPControl-GREEN Running 2012 10 25 14:58:05 4:33:12 5546 hdbpreprocessor HDB Preprocessor SAPControl-GREEN Running 2012 10 25 14:58:21 4:32:56 5631 hdbindexserver HDB Indexserver SAPControl-GREEN Running 2012 10 25 14:58:24 4:32:53 5648 hdbstatisticsserver HDB Statisticsserver SAPControl-GREEN Running 2012 10 25 14:58:25 4:32:52 5656 hdbxsengine HDB XSEngine SAPControl-GREEN Running 2012 10 25 14:58:26 4:32:51 5671 sapwebdisp_hdb SAP WebDispatcher SAPControl-GREEN Running 2012 10 25 14:58:43 4:32:34 6096
As you see in response SOAP request returns every process of status.
- The other SOAP request returns Web Methods. But they work with authentication as I can see.
And this request returns:
Process List NodeWebmethod GetProcessList Access Points NodeWebmethod GetAccessPointList Protected Webmethods Attribute ABAPAcknowledgeAlerts,ABAPGetWPTable,ABAPReadRawSyslog,ABAPReadSyslog,AnalyseLogFiles,Bootstrap,ConfigureLogFileList,CreateSnapshot,DeleteSnapshots,EnqGetLockTable,EnqGetStatistic,EnqRemoveLocks,GetAccessPointList,GetAlerts,GetAlertTree,GetEnvironment,GetLogFileList,GetProcessParameter,GetQueueStatistic,GetStartProfile,GetTraceFile,GetVersionInfo,ICMGetCacheEntries,ICMGetConnectionList,ICMGetProxyConnectionList,ICMGetThreadList,InstanceStart,InstanceStop,ListDeveloperTraces,ListLogFiles,ListSnapshots,OSExecute,ParameterValue,ReadDeveloperTrace,ReadLogFile,ReadSnapshot,RestartInstance,RestartService,RestartSystem,SendSignal,SetProcessParameter,SetProcessParameter2,ShmDetach,Shutdown,Start,StartSystem,Stop,StopService,StopSystem,UpdateSystem,WebDispGetServerList,GetAgentConfig,MtChangeStatus,MtCustomizeWrite,MtDbsetToWpsetByTid,MtDestroyMarkNTry,MtReset,PerfCustomizeWrite,ReadDirectory,ReadFile,ReadProfileParameters,Register,SnglmgsCustomizeWrite,SystemObjectSetValue,ToolSet,ToolSetRuntimeStatus,TriggerDataCollection,Unregister,UtilAlChangeStatus DBServices Attribute YES StartPriority Attribute 0.3 SAPSYSTEM Attribute 00 SAPSYSTEMNAME Attribute CC2 SAPLOCALHOST Attribute imdbhdbcc2 INSTANCE_NAME Attribute HDB00 Webmethods Attribute Start,InstanceStart,Bootstrap,Stop,InstanceStop,Shutdown,ParameterValue,GetProcessList,GetStartProfile,GetTraceFile,GetAlertTree,GetAlerts,RestartService,StopService,GetEnvironment,ListDeveloperTraces,ReadDeveloperTrace,RestartInstance,SendSignal,GetVersionInfo,GetQueueStatistic,GetInstanceProperties,OSExecute,ReadLogFile,AnalyseLogFiles,ListLogFiles,GetAccessPointList,GetSystemInstanceList,StartSystem,StopSystem,RestartSystem,UpdateSystem,AccessCheck,GetProcessParameter,SetProcessParameter,SetProcessParameter2,ShmDetach,GetNetworkId,GetSecNetworkId,RequestLogonFile,CreateSnapshot,ReadSnapshot,ListSnapshots,DeleteSnapshots,ABAPReadSyslog,ABAPReadRawSyslog,ABAPGetWPTable,ABAPAcknowledgeAlerts,ICMGetThreadList,ICMGetConnectionList,ICMGetCacheEntries,WebDispGetServerList,EnqGetLockTable,EnqRemoveLocks,EnqGetStatistic
As you see above there are some web methods. You can test these by yourself.
You can test these methods with a simple HTML and Javascript code:
New NetWeaver Information at SAP.com
Very Helpfull