SAP ASE
Skip to end of metadata
Go to start of metadata

Introduction:

This presentation is the information disigned to:
  • 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:

• ASE16 SP02 software or above
• Use setup.bin  or setup.exe to install software 
• Install the full software including the ASE cockpit to monitor existing ASE instance(s).                                                                                                                                                                 

Installation of ASE Cockpit:

  • 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.

 

  • The port number selected must be available.

  • Be sure and make note of these ports.

SAP ASE Cockpit has two predefined SAP ASE Cockpit Agent login accounts:  sccadmin and  uafadmin

  • These two logins can only be used to authenticate against the SAP ASE Cockpit Agent.

  • Do not use these user accounts to log in to the SAP ASE Cockpit.

  • The sccadmin and uafadmin are not placed in the ASE server they are for the cockpit repository.

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

  1. Create the ASE profile plugin in the SYBASE/COCKPIT-4 directory.
  2. 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.
  3. Copy the com.sybase.ase templates to the $SYBASE/COCKPIT-4/plugins/myASE directory to create the myASE plugin profile.      
  4. Generate the encrypted password for ASE plugin profile.
  5. Edit the $SYBASE/COCKPIT-4/plugins/ASEservername/agent-plugin.xml file and enter ASE plugin profile information. 
•Please see KBA 2133600 for details. A script provided in this KBA to simplify the above steps.

Step 3 - Start ASE Cockpit server


•Run cockpit.sh in /$SYBASE/COCKPIT-4/bin directory to start the 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>

  • Copy the https into a web browser. It may take times to display the Cockpit login panel. After you see the panel, login as sa and enter sa password.
  • ASE configuration windows will display when ASE cockpit parameter was not set. Set these values and apply the changes.

Step 4 - Create technical user and set password


  1. In SAP ASE Cockpit, click the EXPLORE tab.
  2. In the left pane, click ASE Servers.
  3. In the left pane, do one of: Click the arrow to the right of the name.  Click the Actions button.
  4. Select Create Cockpit Technical User.
  5. Click Technical User Credentials.
  6. On the Add Technical User - Technical User Credentials page, enter a password for the default user tech_user.
    1. tech_user is automatically granted the privilege to configure SAP ASE Cockpit settings.
    2. Technical User is a dedicated account used for creating and scheduling collection jobs and monitoring, and triggering alerts based on predefined thresholds
    3. 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.
  7. Click Finish.

Step 5 - Set the ASE Cockpit Agent password


  1. 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=
  2. 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.
  3. Search for the account name: Default SCC agent admin account: uafadmin
  4. 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=" />
  5. Save the file and exit.
  6. 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


  1. In SAP ASE Cockpit, click the EXPLORE tab.
  2. In the left pane, click ASE Servers.
  3. In the left pane, do one of:
    Click the arrow to the right of the name.
    Click the Actions button.
  4. Select Properties.
  5. In the left pane, select Agent.
  6. Enter the ASE server agent port number which is the RMI port number in Step 1 and click Register.
  7. Specify the user name and password, then click Authenticate.
  8. The default user name for the agent is uafadmin.
  9. 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?

Changing the UAFADMIN or SCCADMIN Password



  • No labels

16 Comments

  1. Former Member

    Note the first link to KBA 2133600 is incorrect - it takes you to 2122600

  2. Marilyn Airey

    Thank you for the correction - I have updated the link.

  3. 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?

  4. 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.

  5. 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.

  6. 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

  7. Marilyn Airey

    No, there is no need to reboot the OS.

  8. 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!

    1. Diego Hernandez

      Hi Tyler,

      SYBASE ASE 15.7 FOR BUS. SUITE

      Maintenance Type

      Date

      Comment

      Further Information

      End of standard vendor support (regular maintenance phase)

      31.12.2020


      You can check SAP Note1554717

      Regards

      1. Tyler Klier

        Yeah, I know. Thank you though!

  9. Marilyn Airey

    You will need to install the COCKPIT from a ASE 16.0 SP02 or higher.  Items to note: 

    1.  You should install the COCKPIT in its own directory. 
    2.  If the ASE 15.7 does not support a feature in the COCKPIT it will fail on that feature.   
    3.  ASE COCKPIT does use Adobe Flash.
    4.  A new product will be introduced shortly to replace ASE Cockpit.

  10. Tyler Klier

    Awesome, exactly the info I was looking for. Thank you!

  11. 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?

  12. 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

  13. 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:


  14. Marilyn Airey

    There is new documentation:
    Managing SAP ASE from the Command Line Guide 

    Find information on accessing the Repository and Monitor Statistics.