SAP ASE Business Suite AMC Configuration

Disclaimer: These materials are provided for informational purposes only. This document is based on a scenario where TST is the SID and aseamctest is the hostname. This is a sandobox and not a customer system so I think these informations can be displayed on the web with no copyright issues.

Problem

ASE Cockpit is discontinued by SAP starting 1st Jan 2021.

ASE Cockpit is built on top of Adobe Flash Player. Adobe has declared the end-of-life of Adobe Flash effective 2020. In turn Google,Microsoft and Mozilla has announced that the browsers Chrome,IE and Firefox will no longer support Adobe Flash Player post 31st Dec 2020.

Solution

SAP built an ASE administration tool named SAP ASE Administration and Management Console(AMC). it is in the similar lines of ASE Cockpit but does not have all the features of ASE Cockpit yet. SAP is going to develop this tool as replacement of ASE Cockpit in future.

SAP ASE AMC is released along with SAP ASE database version 16.0 SP04 PL00 in January 2021. It will not support the previous versions of ASE database and can administer the databases installed on the same server. Remote administration is not possible as of now.

Installation

SAP ASE AMC is delivered with ASE installation media and can be installed together with ASE database or independently.

To install AMC, run setup.bin file from ASE installation media either in GUI mode or Console mode and then select Administration and Management Console

GUI Mode

Next

Next

Then Proceed with the installation

Console Mode

Proceed with the installation

Once the installation is done, A directory named AMC  will be created under the installation folder (in this case it is /sybase/TST)

AMC Configuration

Post installation of AMC, We need to configure it to add the current database details so that it will connect to database and send/fetch the data.

Go to AMC folder under the installation directory and there will be a file named AMC.properties.template. Take a backup of this file and rename it to AMC.properties

Open the file AMC.properties and update the database values as below.

ase-host = hostname os ASE database

ase.port = post number of ASE (default is 4901)

server_name = SID of ASE database

Once the above details are updated, follow the below steps to start AMC

Login with syb<sid> user and go to AMC/scripts folder (in this case it is /sybase/TST/AMC/scripts)  and run start_AMC.sh script (i.e., ./start_AMC.sh)

It should give the AMC URL as http://<hostname>:8080/

Access the above mentioned URL and the below webpage should be displayed.

From this console we can restart the ASE database, Monitor ASE usage, Perform backup and recovery, Perform and monitor Automatic Table Management (ATM)

As the post configuration, we need to run few scripts that are delivered with AMC. Please follow the below steps to run these scripts

Go to folder AMC/scripts (i.e., /sybase/TST/AMC/scripts) and below files will be displayed

We need to execute the scripts install_jobscheduler.sh,install_helper_procedures.sh,install_baldr.sh in the below format

./install_jobscheduler.sh <server_name> <user> <password> <job_scheduler_port>

Ex : ./install_jobscheduler.sh TST sa <password> 4904

./install_helper_procedures.sh <server_name> <user> <password> <Scripts_Directory>

Ex : ./install_helper_procedures.sh TST sa <password> /sybase/TST/AMC/scripts

./install_baldr.sh <server_name> <user> <password> <Scripts_Directory> <sapsa_password>

Ex : ./install_baldr.sh TST sa <password> /sybase/TST/AMC/scripts <sapsa_password>

As these scripts are delivered by SAP, there are few corrections in these scripts. Please update the below corrections.

1. Comment the line mkdir $DEVICE_LOCATION in install_jobscheduler.sh and install_baldr.sh scripts. These two scripts uses sybmgmtdb and saptools database respectively. Irrespective of checking whether these two databases are existing, these scripts creates those databases. So if we comment the above mentioned line, it will bypass the creation of those databases and uses the existing databases.

2. Add -X to line munber 55 in install_baldr.sh and it should be as below

$SYBASE/$SYBASE_OCS/bin/isql -U${USERNAME} -S${SERVERNAME} -P${PASSWORD} -X -i $TEMP_DIR/create_saptools_db.sql

This line is used to login to ASE with isql, Without -X value, database will not accept the password for Business Suite systems. Passing -X to isql makes the password encrypted.

3. Update the scripts stop_server.sh and start_server.sh with below parameters. AMC uses these these scripts to start/stop ASE

SERVERNAME=${1}
USERNAME=${2}
PASSWORD=${3}

4. Replace diagserver with dataserver in line number 19 of start_server.sh script. It should look like below.

$SYBASE/$SYBASE_ASE/bin/dataserver -d $SYBASE/db/master.dat -c $SYBASE/default.cfg -M $SYBASE/db -i $SYBASE -s $SERVERNAME &

Thank you

Naveen