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