Introduction:
- Install new ASE cockpit server
- Add an ASE instance to the ASE cockpit
- Know how to navigate through ASE cockpit.
- Note: ASE Cockpit, IQ Cockpit, DBA Cockpit are separate tools.
Prerequisites:
Installation of ASE Cockpit: |
|
|
SAP ASE Cockpit has two predefined SAP ASE Cockpit Agent login accounts: sccadmin and uafadmin
|
The ASE COCKPIT REPOSITORY
- The SAP ASE Cockpit embedded repository stores information related to managed systems, as well as user preference data, operational data, statistics, and alert configuration.
- The ASE Cockpit repository is a SQLAnywhere server which can be accessed. See Managing SAP ASE from the Command LineMaanaging SAP ASE from the Command LineManaging SAP ASE from the Command Line
- Accessing the ASE cockpit Repository using dbisql or other tools of this nature is not supported.
- You can back up the repository database on demand, schedule automatic backups, restore the repository from backups, and configure repository purging options. Full and incremental backups are available. A full backup copies the entire repository. An incremental backup copies the transaction log, capturing any changes since the last full or incremental backup. (More on this in later slides).
The ASE Cockpit is automatically started when the install is complete. To bring it up – use any browser:
https://servername:port/cockpit
Basic Steps to Manually Configure ASE Cockpit:
Step 1 - Setup ASE Cockpit Network Ports
Step 2 - Add the existing ASE to the ASE Cockpit
Step 3 - Start ASE Cockpit server
Step 4 - Create technical user and set password
Step 5 - Set the ASE Cockpit Agent password
Step 6 – Register and Authenticate an ASE Cockpit Agent
Step 1 - Setup ASE Cockpit Network Ports
- Run $SYBASE/COCKPIT-4/bin/cockpit –p to change default port number.
Example: $ cockpit.sh -p db=port http=port https=port msg=port rmi=port tds=port
- Check for port conflicts between SAP ASE Cockpit and other software running on the same host. SAP ASE Cockpit cannot function properly if other services use its ports.
- Run cockpit --info port to verify that all ports are valid to use. When the “In Use” is marked “true”, you need to change the port number by re-running the cockpit –p command.
Step 2 - Add the existing ASE to the ASE Cockpit
- Create the ASE profile plugin in the SYBASE/COCKPIT-4 directory.
- Create a directory in $SYBASE/COCKPIT-4/plugins. The name of the directory is the ASE name. In this slide, we use the MyASE as an example.
- Copy the com.sybase.ase templates to the $SYBASE/COCKPIT-4/plugins/myASE directory to create the myASE plugin profile.
- Generate the encrypted password for ASE plugin profile.
- Edit the $SYBASE/COCKPIT-4/plugins/ASEservername/agent-plugin.xml file and enter ASE plugin profile information.
Step 3 - Start ASE Cockpit server
Example: [SAP bin]$ ./cockpit.sh
SAP>cockpit.sh Starting Cockpit Server...
---------- SYSTEM INFO ----------
Home Directory: /your/cockpit/directory/COCKPIT-4 Version:
Cockpit Server 4 SP11
Node: ServerName(10.123.45.76)
Log Message level: WARN
Platform: linux
Bitwidth: 64
OS Name: Linux
OS Version: 2.6.32-431.17.1.el6.x86_64
OS Architecture: amd64
Available Processors: 8
Total Physical Memory: 13925 MB
Free Physical Memory: 4236 MB
java.library.path: /your/cockpit/directory/COCKPIT-4/rtlib:/your/cockpit/directory/COCKPIT-4/bin/sa16/linux64/lib64
Java Home: /your/cockpit/directory/shared/SAPJRE-X_X_XXX_64BIT
Java Version: 1.8.0_45
Java VM Version: 8.1.008 25.45-b02 VM Process ID
VM Arguments: -Xms128m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/your/cockpit/directory/COCKPIT-4/log, -Dcom.sybase.home=/work/mairey/ASE_cockpit, -Dcom.sybase.ua.toplevel=/your/cockpit/directory/COCKPIT-4, -Dcom.sybase.ua.home=/your/cockpit/directory/COCKPIT-4, -Dcom.sybase.platform=linux, -Djava.library.path=/your/cockpit/directory/COCKPIT-4/rtlib:/your/cockpit/directory//COCKPIT-4/bin/sa16/linux64/lib64, -Djava.security.policy=/your/cockpit/directory/COCKPIT-4/conf/java.policy, -Djava.util.logging.manager=com.sybase.ua.util.logging.bridge.JavaToLog4jLogManager, -Dcom.sybase.security.BootstrapConfigurationURL=file:////your/cockpit/directory/COCKPIT-4/conf/csibootstrap.properties
Cockpit Web Console: https://ServerName:port/cockpit
Type help for more options cockpit>
|
Step 4 - Create technical user and set password
- In SAP ASE Cockpit, click the EXPLORE tab.
- In the left pane, click ASE Servers.
- In the left pane, do one of: Click the arrow to the right of the name. Click the Actions button.
- Select Create Cockpit Technical User.
- Click Technical User Credentials.
- On the Add Technical User - Technical User Credentials page, enter a password for the default user tech_user.
- tech_user is automatically granted the privilege to configure SAP ASE Cockpit settings.
- Technical User is a dedicated account used for creating and scheduling collection jobs and monitoring, and triggering alerts based on predefined thresholds
- Do not use the technical user account to log into SAP ASE Cockpit. The technical user account should only be used for creating and scheduling collections, monitoring, and triggering alerts.
- Click Finish.
Step 5 - Set the ASE Cockpit Agent password
- The password is in an encrypted form. Before you can set the password, you need to use the passencrypt utility to encrypt the agent password of your choice. The default agent password is “Sybase4me”.
Example: %$SYBASE/COCKPIT-4/bin /passencrypt -csi
Password: your_unseen_password_text
{SHA-256:oRx3DWtwcd4=}voH01Ddz8VUJywbkJ9Grg8IPqWPXSP89gKW5ytKtbf4= - Cockpit Agent password is stored in the csi_config.xml file. In a text editor, open the csi_config.xml file in $SYBASE/COCKPIT-4/conf.
- Search for the account name: Default SCC agent admin account: uafadmin
- Paste the new encrypted password into the value field of the password line. Be sure to paste inside the double quotes:
<options name="password" value="{SHA256:oRx3DWtwcd4=}voH01Ddz8VUJywbkJ9Grg8IPqWPXSP89gKW5ytKtbf4=" /> - Save the file and exit.
- To make the new password take effect, restart the SAP ASE Cockpit server on which the changes were made. The default password is “Sybase4me”.
Step 6 – Register and Authenticate an ASE Cockpit Agent
- In SAP ASE Cockpit, click the EXPLORE tab.
- In the left pane, click ASE Servers.
- In the left pane, do one of:
Click the arrow to the right of the name.
Click the Actions button. - Select Properties.
- In the left pane, select Agent.
- Enter the ASE server agent port number which is the RMI port number in Step 1 and click Register.
- Specify the user name and password, then click Authenticate.
- The default user name for the agent is uafadmin.
- Enter the agent user (the default is uafadmin) and password from Step 5.1.
References:
References:
2591017 - Introduction to ASE Cockpit
2133600 - How to manually add an ASE server to ASE Cockpit? - ASE 16.0 SP02 PL02
2307016 - How to manually configure ASE Cockpit on an existing ASE installation without GUI installer ?
2294093 - After installing ASE Cockpit - when clicking on the errorlog tab, an error occurs.
2332101 - Can sql commands be run inside SAP ASE Cockpit?
16 Comments
Former Member
Note the first link to KBA 2133600 is incorrect - it takes you to 2122600
Marilyn Airey
Thank you for the correction - I have updated the link.
Glenn Brown
Thanks for the info Marilyn, I believe (or have read) that Cockpit is a 1:1 installation? We have 4 SAP ASE servers within our organisation. Does this mean that I have to install Cockpit on each server? Or can I monitor all 4 servers from the 1 installation on a single server?
Marilyn Airey
You can monitor any number of ASE's which are on the same host. So if you have 4 different ASE servers on 4 different machines, you will need on ASE Cockpit for each of them.
Marilyn Airey
Let me be a bit more clear. If you have multiple ASE servers running on the SAME host, then you can have them all on a single ASE Cockpit. If the servers are on different hosts, then you must have a cockpit running each of those servers. One ASE Cockpit per host.
Glenn Brown
Thanks Marilyn, that's quite clear. After installation is there any need to reboot the operating system? From the documentation above it doesn't seem so???
Regards
Glenn
Marilyn Airey
No, there is no need to reboot the OS.
Tyler Klier
Does anyone know if this supports Sybase 15.7? It's hard to be certain from the documentation, as some things seem to indicate it is and others that it is not.
Thank you!
Diego Hernandez
Hi Tyler,
SYBASE ASE 15.7 FOR BUS. SUITE
Maintenance Type
Date
Comment
Further Information
31.12.2020
You can check SAP Note1554717
Regards
Tyler Klier
Yeah, I know. Thank you though!
Marilyn Airey
You will need to install the COCKPIT from a ASE 16.0 SP02 or higher. Items to note:
Tyler Klier
Awesome, exactly the info I was looking for. Thank you!
Madan Agrawal
I have sybase 16 SP06 but i cannot see folder COCKPIT/cockpit or anything related to cockpit in my sybase location. How can i install it?
Diego Hernandez
Hi Madan,
you need to check this URL
https://yourhostname:port/sap/bc/webdynpro/sap/dba_cockpit
and also inside sifc sap - bc - webdynpro - sap - dba_cockpit
Regards
Marilyn Airey
If ASE Cockpit is installed it will be in $SYBASE/COCKPIT-4/
If the directory is not there - you can do a custom install and select only the COCKPIT.
The gui install - just click on custom, and the items you want to install.
In the non-gui mode, it is a little trickier.
When asked pick 4 - for a custom install
Choose Install Set
------------------
Please choose the Install Set to be installed by this installer.
->1- Typical
2- Typical SAP ASE, database always-on option
3- Full
4- Custom
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
:4
Then select a number (1-22) to turn on or off the item to install.
So if you select a number like 1
then back
You will see that the item is either selected, or deselected. Keep entering a number and back until you have the items you want installed.
Choose Product Features
-----------------------
ENTER A COMMA_SEPARATED LIST OF NUMBERS REPRESENTING THE FEATURES YOU WOULD
LIKE TO SELECT, OR DESELECT. TO VIEW A FEATURE'S DESCRIPTION, ENTER
'?<NUMBER>'. PRESS <RETURN> WHEN YOU ARE DONE:
1- [-] SAP Adaptive Server Enterprise
2- |-[ ] Additional SAP ASE Language Modules
3- [ ] SAP ASE Data Movement for HADR
4- [-] Open Client
5- |-[ ] DB-Library
6- |-[ ] Embedded SQL/C
7- |-[ ] Embedded SQL/Cobol
8- |-[ ] XA Interface Library for SAP ASE Distributed Transaction Manager
9- |-[ ] Additional Connectivity Language Modules
10- |-[ ] SAP ASE Extension Module for Python
11- |-[ ] SAP ASE Database Driver for PERL
12- |-[ ] SAP ASE Extension Module for PHP
13- [ ] jConnect 16.0 for JDBC
14- [ ] SAP ASE ODBC Driver
15- [ ] OData Server for SAP ASE
16- [ ] Interactive SQL
17- [ ] QPTune
18- [-] SySAM License Utilities
19- |-[ ] SySAM License Server
20- [X] Cockpit
21- |-[X] SAP ASE Cockpit
22- |-[X] Remote Command and Control Agent for SAP ASE
Press <ENTER> to install above selected features or choose the corresponding
number to change the feature selection:
Marilyn Airey
There is new documentation:
Managing SAP ASE from the Command Line Guide
Find information on accessing the Repository and Monitor Statistics.