Skip to Content

With ASE 16 SP2 the ASE COCKPIT was released as new administration console. As the existing documentation about build up and usage is still fragmented I want to present here a short walkthrough how i got it to run.
I will tackle here:
Installation
Configuration and repository database
Updating
Outlook (for me)

As my use case is driven by the need for the Capture/Replay feature I had a server with an already existing ASE 16.0.02.06HF1 which should not be interrupted by getting the ASE Cockpit running.
The information and links provided here might not be complete and not be valid for all use cases and functions the ASE Cockpit is offering.

Installation:

The ASE Cockpit is shipped as part of the SAP ASE FOR BUSINESS SUITE software package but in the actual state there is no integration in SWPM so installation has to be done with the regular setup.bin. As i do not have open X11 ports the non graphic way is the one i went. I removed some screens for the sake of overview which are not really relevant like legal stuff.

<software drop location>> setup.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...

Graphical installers are not supported by the VM. The console mode will be used instead...

................................................

===============================================================================
Choose Install Folder
---------------------

Where would you like to install?

  Default Install Folder: /sybase/AS9

ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
      :

................................................
===============================================================================
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- Customize...

ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
   : 4

===============================================================================
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-  |-[X] 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-  |-[X] SAP ASE Extension Module for Python
   11-  |-[X] SAP ASE Database Driver for PERL
   12-  |-[X] SAP ASE Extension Module for PHP
   13- [X] jConnect 16.0 for JDBC
   14- [X] SAP ASE ODBC Driver
   15- [ ] OData Server for SAP ASE
   16- [X] Interactive SQL
   17- [X] 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

Please choose the Features to be installed by this installer.: 5,10,11,12,13,14,16,17

===============================================================================
Software License Type Selection
-------------------------------

What would you like to do?

  ->1- Install licensed copy of SAP Adaptive Server Enterprise

    2- Install Free Developer Edition of SAP Adaptive Server Enterprise

    3- Install Express Edition of SAP Adaptive Server Enterprise

    4- Evaluate SAP Adaptive Server Enterprise


Enter one of the options above: back

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

Here are some more screens following including user creation and ports. I`m sticking with the standard for the time being.
After the then executed installation we have software installed below %SYBASE/COCKPIT-4 and a running cockpit process.
From the design the cockpit it is a 1:1 tool. So if you install ASE and cockpit in a bundle I would hope this matching is done automatically but I never tried it out. In my scenario the next step is to do this binding manually. There is SAPNOTE 2133600 providing a script to do this:

<script location>>/create_cockpit.sh

################### ASE COCKPIT GENERATOR ###################
Please enter the $SYBASE path where Cockpit is installed: /sybase/AS9
Cockpit directory is COCKPIT-4
Please enter the $SYBASE path for the ASE to be added: /sybase/AS9
Found ASE-16_0 as SYBASE_ASE in /sybase/AS9
Use this value? [y/n]:  y
Please enter ASE server name to be added: AS9
Please enter the path and filename for AS9's errorlog: /sybase/AS9/ASE-16_0/install
File not found: /sybase/AS9/ASE-16_0/install
Please re-enter
Please enter the path and filename for AS9's errorlog: /sybase/AS9/ASE-16_0/install/AS9.log
Please enter the path and filename for AS9's RUN_server file: /sybase/AS9/ASE-16_0/install/RUN_AS9
Please enter sa_role admin login for AS9: sapsa
Please enter password for sapsa:
Please enter password for sapsa again:
<<<<<<Installation Summary>>>>>>

$SYBASE of ASE to be added:  /sybase/AS9
SYBASE_ASE for added ASE:    ASE-16_0
$SYBASE of Cockpit:          /sybase/AS9
Cockpit directory:           COCKPIT-4
ASE to be added:             AS9
Errorlog for added ASE:      /sybase/AS9/ASE-16_0/install/AS9.log
RUN_file for added ASE:      /sybase/AS9/ASE-16_0/install/RUN_AS9
Administrator login:         sapsa
Encrypted password:          1-AAAAEgQQD8qFQNNwZvheT2jGuNf+8Oh/8zjS7pAV8nMNZPMNVn9l9W1JByTvdrHt2ASuLbQrN0ItMeNGRggDvwg3PJUZc5VZ1YSjJm2J/k9K0i3Q2mM=

Continue with this [y] or make changes [n]: y
Creating /sybase/AS9/COCKPIT-4/plugins/AS9
Preparing plugins directory for AS9
Finished adding AS9 to /sybase/AS9/COCKPIT-4/plugins/AS9
Please restart your Cockpit server to connect to AS9

Now your cockpit is configured. I went with sapsa as user at this point as it is a user I anyways use with sa_role. long term this for sure needs more thoughts about separation of duties.
As you need a restart first (and i was not able to get a command line to it in this state) I had to kill the cockpit process with OS means.
Afterwards starting works fine with:

/sybase/AS9/COCKPIT-4/bin/cockpit.sh start
Starting Cockpit Server...

---------- SYSTEM INFO ----------

Home Directory:       /sybase/AS9/COCKPIT-4
Version:              Cockpit Server 4 SP11
Node:                 ls5393.wdf.sap.corp(10.21.12.34)
Log Message level:    WARN


Platform:              linux
Bitwidth:              64
OS Name:               Linux
OS Version:            3.0.101-108.21-default
OS Architecture:       amd64


Available Processors:  48
Total Physical Memory: 258471 MB
Free Physical Memory:  154103 MB


java.library.path:     /sybase/AS9/COCKPIT-4/rtlib:/sybase/AS9/COCKPIT-4/bin/sa16/linux64/lib64
Java Home:             /sybase/AS9/shared/SAPJRE-8_1_029_64BIT
Java Version:          1.8.0_121
Java VM Version:       8.1.029 25.51-b02
VM Process ID          10930@ls5393
VM Arguments:          -Xms128m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/sybase/AS9/COCKPIT-4/log, -Dcom.sybase.home=/sybase/AS9, -Dcom.sybase.ua.toplevel=/sybase/AS9/COCKPIT-4, -Dcom.sybase.ua.home=/sybase/AS9/COCKPIT-4, -Dcom.sybase.platform=linux, -Djava.library.path=/sybase/AS9/COCKPIT-4/rtlib:/sybase/AS9/COCKPIT-4/bin/sa16/linux64/lib64, -Djava.security.policy=/sybase/AS9/COCKPIT-4/conf/java.policy, -Djava.util.logging.manager=com.sybase.ua.util.logging.bridge.JavaToLog4jLogManager, -Dcom.sybase.security.BootstrapConfigurationURL=file:////sybase/AS9/COCKPIT-4/conf/csibootstrap.properties, -Djava.security.properties=/sybase/AS9/COCKPIT-4/conf/java.security

Cockpit Web Console:
https://ls5393.wdf.sap.corp:4283/cockpit

Type help for more options

As you do not want to loose the cockpit if you loose your shell you might want to use one of the many tools to decouple the session from the connection like screen.

Now you are in the position to use the link provided during cockpit startup to first access the Cockpit.

Configuration:

Java:

There are for sure many configuration possibilities for the various options the ASE Cockpit offers. I’m just describing the ones I needed to get my main goal Capture/Reply to run.
The cockpit is running on the server as a Java tool. By default it is configured to use 128mb of memory which is not enough to process replays of a certain size. There are various help pages like help.sap.com out describing how to configure this, sadly none of them worked for me. There are documentation enhancement requests out and when you are reading this it might already be fixed. For me it helped to set two additional environment variables:

COCKPIT_MEM_INIT=4096
COCKPIT_MEM_MAX=10240

Setting the initial and maximum allowed memory values for the cockpit. If everything went right you can see the values as VM arguments at cockpit start time.

VM Process ID          10930@ls5393
VM Arguments:          -Xms4096m, -Xmx10240m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/sybase/AS9/COCKPIT-4/log, -Dcom.sybase.home=/sybase/AS9, -Dcom.sybase.ua.toplevel=/sybase/AS9/COCKPIT-4, -Dcom.sybase.ua.home=/sybase/AS9/COCKPIT-4, -Dcom.sybase.platform=linux, -Djava.library.path=/sybase/AS9/COCKPIT-4/rtlib:/sybase/AS9/COCKPIT-4/bin/sa16/linux64/lib64, -Djava.security.policy=/sybase/AS9/COCKPIT-4/conf/java.policy, -Djava.util.logging.manager=com.sybase.ua.util.logging.bridge.JavaToLog4jLogManager, -Dcom.sybase.security.BootstrapConfigurationURL=file:////sybase/AS9/COCKPIT-4/conf/csibootstrap.properties, -Djava.security.properties=/sybase/AS9/COCKPIT-4/conf/java.security

Repository database:

Capture and Replay is based around a repository database named sybcatdb. The recommendation is to install this database not on the same server you are using for replay. Where ever you decide to place it you need a database, user, and many stored procedures.

Database:

Replays for systems I`m  experimenting have about 10gb/hour so I choose to start with a 60gb data/ 5gb log database:

disk init name = "sybcatdb_data_002",physname="/sybase/AS9/sapdata_1/sybcatdb_data_001.dat",size="30G", directio=true
disk init name = "sybcatdb_data_003",physname="/sybase/AS9/sapdata_2/sybcatdb_data_002.dat",size="30G", directio=true
disk init name = "sybcatdb_log_001",physname="/sybase/AS9/saplog_1/sybcatdb_log_001.dat",size="5G", directio=true
go
CREATE DATABASE sybcatdb ON sybcatdb_data_001 = '30G' LOG ON sybcatdb_log_001 = '5G' WITH DURABILITY = FULL , LOB_COMPRESSION = 100, INROW_LOB_LENGTH = 2000
go
alter database sybcatdb ON sybcatdb_data_002 = "30G"
go

You also need the following db options, but if you don`t set them the installsybcatdb which is shipped with the software is doing that for you:

exec sp_dboption "sybcatdb","select into/bulkcopy/pllsort", true
exec sp_dboption "sybcatdb","trunc log on chkp", true
exec sp_dboption "sybcatdb","abort tran on log full", true
go
user:

I went with a user with the same name as the database, but of course you are absolutely free here.

use master
go
EXEC sp_addlogin sybcatdb, "<put password here>", sybcatdb
go
use sybcatdb
go
exec sp_changedbowner "sybcatdb"
go
Stored procedures:

The SW provides a install script installsybcatdb which needs to be pushed in and as with all install scripts the sa user is a good choice here.
If everything went fine you now can go back to your GUI and connect to your repository:

It will disconnect you after a certain amount of inactivity. Please remember to reconnect.

Update:

In the actual state there are no update functionalities present so there is only the greenfield approach possible:
– stop cockpit
– remove %SYBASE/COCKPIT-4
– reinstall
At least for me it did not work to keep the configuration or the repository database. After overwriting  %SYBASE/COCKPIT-4 with new software or executiing of the new installsybcatdb over an existing database I ended up with not operable functions. As this is a new functionality we for sure can look forward to have update features for this or even a sap hostctrl integration.

Outlook:

The feature is offering great possibilityes for me as a member of a IT database team. It has still some challenges in regards of functionalities and use case support but it seems we are on the right way. Lets stay tuned what the next versions will bring.

 

 

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Marco SILVA

    Hello,

    Can we have a cockpit like that with the SAP ASE service on SAP Cloud Platform? What is the best way to consume this kind of cloud database form an SAPUI5 application? Or is it even possible?

    Thank you in advance for your time!

    Best regards,

    Marco Silva

     

    (0) 
    1. Martin Luik
      Post author

      Hi

      Thy for the questions. Sadly i have no answers.

      I will get into contact with the product team to find it out but this might take some time.

       

      kind regards

      Martin

      (0) 
      1. Martin Luik
        Post author

        Hi

        Sry for the long delay.

        sadly i have to say that i can not answer this question as im not from product management and im not avare of the roadmap.

        Your Support/Sales contact should be the right direction to answer this question.

         

        kind regards

        Martin

        (0) 

Leave a Reply