Showing posts with label COCKPIT. Show all posts
Showing posts with label COCKPIT. Show all posts

Tuesday, 1 December 2020

Determine Ports for SAP HANA Cockpit and Cockpit Manager

 The ports for SAP HANA cockpit and the cockpit manager can be determined in the XS console after the cockpit installation.

Prerequisites

  • You are logged in as <sid>adm user.
  • You know the XS organization manager user password. The password matches the master password, which is set during installation.

Context

Ports, through which the SAP HANA cockpit and the cockpit manager can be accessed, are assigned automatically by the installer. Once the cockpit installation is successfully completed, information about host and ports is displayed. If this information is no longer available, you can execute the following commands in the XS console to determine ports.

You can also assign free ports to SAP HANA cockpit during installation. For more information, see SAP Note 2389709 in Related Information.

Procedure

  1. Change to the directory that contains the XS Advanced installation:
    cd <sapmnt>/<SID>/xs/bin
    By default, <sapmnt> is /hana/shared.
  2. Log on to the SAP HANA XS advanced runtime. To do this, use the following command:
    ./xs-admin-login
  3. Enter the XS organization manager user password.
  4. Display a list of the applications running in the current space. In the command shell, run the following command:
    xs apps

    A list of all running apps is displayed. Information on host and ports are displayed in the urls column. The SAP HANA cockpit is listed as cockpit-web-app. The cockpit manager is listed as cockpit-admin-web-app.

Tuesday, 23 July 2019

SAP HANA COCKPIT NOTES 28: creating NEW tenant Database in HANA

Article About:

how to create new tenant database in HANA DB through HANA COCKPIT.

Content:

here are the steps to create new tenant database in HANA cockpit,

1.connect to system database --> navigate to overview page.

2. on the overview page, click the overall tenant statuses tile to open manage databases.



3.click on create tenant button.
3b. then click on create empty tenant option.



4. provide inputs 

  • tenant database name: SID
  • system user password: 
  • conform system user password: 
  • in Advanced settings:
                start Automatically  is enable by default.

Note: will have option to defined HOST and port details in case of distributive
          environment.

Have an option to add additional services based on tenant Database technical and business requirements.




5. Finally click on Create tenant database.





6.conformation screen is as below.                                                                                                             




7. the new tenant database need to add in resource groups by administrator through cockpit manager.      
open cockpit manager -->register resources-->register resource--> provide inputs like host name, instance name & number.



                                                                     OR 
create a tenant database using SQL query in HANA studio.with 3 steps.


step1:  open SQL cmd window from HANA studio.
step2:  Run the SQL query as shown in the below screenshot.
step3: finally execute it.



Sunday, 19 May 2019

SAP HANA COCKPIT NOTES 26:How to trouble shoot hana cockpit issues

troubleshooting method 1:


If you encounter issues with SAP HANA cockpit, you can use XS CLI commands to view services logs and application status. You can execute the XS CLI commands on the machine where the cockpit is installed, using the <SID>adm account, or remotely using the XSA Client. For complete details on logging into the SAP HANA XS advanced runtime console and on the XS CLI: Application Management commands, see SAP HANA Developer Guide for SAP HANA XS Advanced Model. 

troubleshooting method 2:

You can investigate potential issues by viewing the log file of a specific service with the command                                                          xs logs <APP> 

where <APP> is the name of the application whose log-file details you want to display in XS apps cmd.


EX:
In the log of cockpit-collection-svc, if you see: A collection could not be submitted for execution because the worker thread pool is exhausted, then consider increasing the collection worker thread pool in the data collection settings through the cockpit manager. Increase the threads incrementally, rechecking the log each time, until the issue is resolved.

troubleshooting method 3:



SAP HANA NOTES 25:View Logs to Troubleshoot the Cockpit

Find entries in the SAP HANA cockpit operational logs. 



Prerequisites

Your cockpit user has these roles: 
● Troubleshooting (a cockpit role).
● Space Auditor.


Context

View log entries to troubleshoot problems like missing monitoring data on cockpit pages, resource registration failure, and connection timeouts.


Procedure




Friday, 17 May 2019

SAP HANA NOTES 24: Send a Notification to Logged-In Users in HANA cockpit

Send a Notification to Logged-In Users in HANA cockpit


Send a pop-up alert to all users logged in to SAP HANA cockpit.

Prerequisites

Your cockpit user has one of these roles: 

● Cockpit Administrator
● Cockpit User Administrator

Procedure

  1. Connect to the Cockpit Manager.

     2.In the Cockpit Manager, select Active Sessions.                                                                    


3. (Optional.) Enter a user's name in the Search Sessions field to filter the list of users.

4.choose inform option. and enter the message. the screen looks like below.

 5.choose interrupt option from step2.                                                

6.Result looks like one pop-up screen.                                                                      




Note:  The message will display only in Cockpit screen, exception for cockpit manager screen. 

Thursday, 16 May 2019

SAP HANA COCKPIT NOTES 23: Managing Resources, Users, and Groups with the Cockpit APIs

Managing Resources, Users, and Groups with the Cockpit APIs




SAP HANA COCKPIT NOTES 21:Delete a Resource Group

Delete a Resource Group


Delete a resource group from the SAP HANA cockpit. 

Prerequsites

Your cockpit user has the assigned role Cockpit Resource Administrator. 

enjoy...

Wednesday, 15 May 2019

SAP HANA NOTES 18:IMPORT RESOURCES

IMPORT RESOURCES IN HANA COCKPIT








SAP HANA COCKPIT NOTES 17: EXPORT RESOURCES

Export Resources


Export registration information about resources in the form of a file you can use to import the resources into another system. 

Prerequisites

  • Your cockpit user has the assigned role Cockpit Resource Administrator
  • The resources you're exporting are running and available on the network.

Tuesday, 14 May 2019

SAP HANA COCKPIT NOTES 14: configuring cockpit settings,Setting Connection Timeout


Introduction:


In the Cockpit Manager, as a cockpit administrator, you can select Settings to configure data collection, proxy server settings, and the connection timeout period, and to control whether or not SAP HANA Cockpit displays auto-created groups.




TASK 1:DATA COLLECTION


As a cockpit administrator, you can reconfigure the default, pre configured SAP HANA cockpit global settings for collecting monitoring data, such as system status, alert counts, and other data from registered resources.

Navigation

In the Cockpit Manager, select Cockpit Settings, and then Data Collection.

If necessary, you can change the defaults to specify:
● How many worker threads the collection service should use. Increasing threads can improve response time but uses more memory. The default is 5 threads.
● Whether and how often the cockpit collects system status and alert counts. The default is 60 seconds.
● Whether and how often the cockpit collects key performance area monitoring data from each managed resource.The default is 5 minutes.

There may be a brief lag before your changes in values take effect.

Note: 

You can also modify the collection settings for a specific resource by editing the details of that resource. Doing so overrides the global settings for that particular resource. See Override Data Collection for a Resource.


Tip: 
  • The cockpit can support 1000s of registered resources.
 If the System Health Monitor displays ‘Not Collected’ for specific resources, you may wish to investigate the collection service log for rejected collections and reconfigure the worker threads accordingly.
Screenshots for the above scenario Task1:

step1: cockpit manager -->cockpit settings-->Data collection
Resultant screen look likes below:

Task 2:setting connection timeout



screenshot for the above timeout scenario:



Task 3: setting proxy server



screenshots for the above TASK 3: SETTING PROXY SERVER

cockpit manager--> cockpit settings--proxy                                                                                           


resultant screen:


TASK 4: Specifying Display of Auto-Generated Groups



As a cockpit administrator, you can choose whether or not SAP HANA cockpit displays resources as part of auto-created resource groups, or solely as part of resource groups that you create.

 A resource group—a named set of one or more registered resources—controls management and monitoring privileges. When you assign a cockpit user to a resource group that you have created, you enable the user to monitor and manage the group's resources through the cockpit. Each registered resource also belongs to a usage type resource group. These auto-created groups of resources (Production, Test, Development) are based on the system usage type of each resource. System usage type is configured during system installation, or later using the global.ini file with the usage parameter in the system_information section.

You can choose to hide one or more of the auto-created groups through the Cockpit Manager by selecting Settings, then Display, and deselecting or selecting each box. Opting to hide the auto-created groups does not affect the system usage type associated with the resource. It simply prevents the cockpit from organizing the display of resources by auto-created group.



screenshots for the above TASK4: scenario


SAP HANA NOTES 13: Delete a Cockpit User or Revoke Cockpit Access

As the cockpit user administrator, you can delete cockpit users. However, you will need to decide whether the underlying business user should remain.


content

Some cockpit users may have been created outside of the cockpit manager; their original purpose may have been to access other applications. Other cockpit users have been created through the cockpit manager for the sole purpose of accessing the cockpit. When you delete a cockpit user, you can choose to:
● Allow the underlying business user to remain (so that it can be used to access other applications), and only revoke the access to the cockpit.
● Completely delete the user.

Procedure

1.Connect to the Cockpit Manager and sign in as a cockpit user administrator. You can reach the Cockpit Manager by entering the Cockpit Manager URL created during cockpit installation, or by following the Manage Cockpit link in the cockpit. The URL takes this form: 
                                 https://<cockpit-host>:<port-number>

Monday, 13 May 2019

SAP HANA NOTES 12: Edit Settings for a Cockpit User

Edit Settings for a Cockpit User



SAP HANA COCKPIT NOTES 11: Grant a cockpit user access to specific groups

Grant a cockpit user access to specific groups


Add or remove resource groups from the list of groups that a specific user can access.


SAP HANA COCKPIT NOTES 10:creating cockpit user

creating cockpit user


As a cockpit user administrator, you can create new cockpit users, or allow existing business users to access the SAP HANA cockpit.

Context

 The Create User wizard allows you to create cockpit users by entering new credentials or by choosing to provide cockpit access to existing business users that have been created through other means. 


Procedure


1. Connect to the Cockpit Manager and sign in as a cockpit user administrator.
the URL takes this form: 

https://<cockpit-host>:<port-number>

2. In the Cockpit Manager, select Cockpit Users.
 3. Select Create User. 
4. In the Create User wizard, do one of the following: 
○ Select the checkbox to enable an existing business user to access the cockpit, then select the user from the drop-down list. 
○ Enter a new user name, enter and confirm a password, and enter an e-mail address.




Saturday, 11 May 2019

SAP HANA COCKPIT NOTES 8: Setup and Administration with the Cockpit Manager


  • The Cockpit Manager configuration tool is an application separate from the SAP HANA cockpit itself.
  • The functionality visible in the Cockpit Manager depends on the role(s) assigned to the user accessing the Cockpit Manager.

The purpose of HANA COCKPIT MANAGER:




Note: creation of cockpit users,register resource,create resource groups,add resources to resource groups & grant cockpit users access to resources groups,modify settings related to the configuration of the cockpit can also be done in COCKPIT also. but proper Privileges is required.


 

Friday, 10 May 2019

SAP HANA COCKPIT Notes 7:Authorizations Needed for Monitoring and Administration

 To connect to the resource with a database user with appropriate database privileges.



1. To be able to connect to a resource and see minimum monitoring information   
  • CATALOG READ 
  • SELECT privilege on the schema _SYS_STATISTICS.