SYBASE TUTORIALS: July 2022

Sybase history

Sybase is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was founded in 1984, and the headquarters offices are in Emeryville, CA.

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server developed by Sybase Corporation.

SAP acquired Sybase in 2010 to drive forward the realization of its in-memory computing vision, now it is part of SAP AG. Sybase was the first enterprise DBMS for the Linux operating system and it is also available for Microsoft Windows.

Sybase products list:

· Sybase Adaptive Server Enterprise (Sybase ASE)

· Sybase IQ

· Sybase Replication Server

· Sybase SQL Anywhere

· Sybase Power Designer

Sybase Adaptive Server Enterprise (Sybase ASE)

SAP Adaptive Server Enterprise is a high-performance SQL database server that uses a relational management model to meet rising demand for performance, reliability, and efficiency in every industry.

Versions:

Sybase SQL server 4

Sybase 10

Sybase 11

Sybase 12

Sybase 15

Sybase 16

Sybase IQ

Deliver high-performance decision-support for mission-critical business intelligence, analytics and data warehousing. SAP IQ is a column-based in-disk relational database with a low-cost environment.

Sybase Replication Server

Get real-time data updates from anywhere in the enterprise. Deliver seamless data management, integration and synchronization from SAP and non-SAP data to satisfy mission-critical tasks.

Sybase SQL Anywhere

Enable secure, reliable data management for servers where no DBA is available and synchronization for tens of thousands of mobile devices, Internet of Things (IoT) systems, and remote environments.

Sybase Power Designer

View change impact with a blueprint of current enterprise architectures. Automatically capture architecture layers, tap into a powerful metadata repository and easily share information.

How to check table statistics last update in Sybase

Issue:

You would like to know how to check database statistics last updated date/time & percent rows modified in tables of your SAP Sybase ASE Environment.

Resolution:

The statistics are stored in the system tables systabstats and sysstatistics.

isql -Usa -SASETST -X -w4000
password:

>use TST
>go

>select id, moddate, datachange ("emp", NULL, NULL) as datachange from ..sysstatistics where id=object_id("emp")

>go

Note that the "datachange" column result is expressed in percentage, it is based on the number of rows remaining after a change.

For example, if a table has five rows and one row is deleted, datachange reports a value of 25 % since the current row count is 4 and the datachange counter is 1.

Update statistics in Sybase

The update statistics command helps the server make the best decisions about which indexes to use when it processes a query, by providing information about the distribution of the key values in the indexes.

The update statistics commands create statistics, if there are no statistics for a particular column, or replaces existing statistics if they already exist.

The statistics are stored in the system tables systabstats and sysstatistics.

update statistics <table> - Generates statistics for the leading column in each index on the table.
update statistics <table> <index> - Generates statistics for all columns of the index
update index statistics <table> - Generates statistics for all columns in all indexes on the table.
update all statistics <table> - Generates statistics for all columns of a table.

https://infosybase.blogspot.com/2022/07/how-to-check-table-statistics-last.html

tempdb full in Sybase

Tempdb :

provides a storage area for temporary tables and other temporary working storage needs.

The space in tempdb is shared among all users of all databases on the server.

Certain activities may make it necessary for you to increase the size of tempdb:

*Large temporary tables.

*A lot of activity on temporary tables, which fills up the tempdb logs.

*Large or many simultaneous sorts. Subqueries and aggregates with group by also cause some tempdb activity.

Use alter database to increase the size of tempdb. tempdb is initially created on the master device. You can add space to tempdb from the master device or from any other database device.

If you run update index statistics against large tables, the command fails with error number 1105 if tempdb is not large enough.

You can create and manage multiple temporary databases in addition to the system temporary database, tempdb. Multiple temporary databases reduce contention on system catalogs and logs in tempdb.

https://infosybase.blogspot.com/2020/07/how-to-create-additional-tempdb-in.html

How to find which spid is filling tempdb ?

Make sure you have mon tables activated,Once verified you can issue the following select statement:

>select SPID, DBName, ObjectName, PartitionSize from master..monProcessObject where DBID = tempdb_id(SPID) order by SPID

>go

Actions to be taken when tempdb is full:

1.Check error log

cd $SYBASE/ASE*/install/

cat ASETST.log | grep "tempdb"

2.Try login to the system using isql

If you are not able to login ,only option is to kill the sybase instance in OS level.

3.Find out the space free in tempdb using the below command

>select lct_admin(‘logsegment_freepages’dbid)

>go

4.try running dum tran with truncate only

>dump tran tempdb with truncate_only

>go

if still not releasing the space then try the below command

5. try running dump tran with no_log

>dump tran tempdb with no_log

>go

6.Find process from syslogshold/sysprocesses and check the tempdb pages

>select *from syslogsholds

>go

>select pssinfo(<spid no>,<tempdb_pages>)

>go

inform application team about condition ask for killing culprit SPID if he says yes then

7.kill the process

>kill <spid no>

>go

If user says no than alter the tempdb

use the disk init command to initialize the disk and then alter the tempdb

>alter database tempdb on <device_name>='2G'

>go

7. you can also use lct_admin(‘abort’,0,2) to kill all suspended transactions.

8.If still not able to clear the space ,take the final approval and restart the server.

Recommendation :

Ask application team to check the query while running the large batches and ask them to tune the query, use frequent commits and also make sure to run the jobs in small batches.

https://infosybase.blogspot.com/2020/07/best-practices-for-shutdown-sap-ase.html

https://infosybase.blogspot.com/2020/07/difference-between-shutdown-and.html

Sybase database refresh

We are going to perform the database refresh from prod to test by following the below steps.

Production server instance name :-ASEPPRD01

Source database name:-PRD

Test server instance name:-ASETST01

Target database name:-TST

Steps Involved in Database refresh:

Dump Database:

SCP

BCP (out)

LOAD database

Online database

Delete bcp out tables

BCP (in)

1) Dump Database

Dump database is used to make backup copy of the entire database.

isql -Usa -SASEPRD01 -X -w4000

password:

dump database PRD to '/sybase/dump/ASEPRD01/PRD22072022.dmp'

2)SCP

This command is used to copy files from source server ASEPRD01 to target Server ASETST01.

cd /sybase/dump/ASEPRD01

scp PRD22072022.dmp sybatst@10.15.8.11:/sybase/dump/ASETST01/

3)BCP out

This is OS level command used take copy of below system tables sysusers,sysalternates and sysprotects in order to sync the user alias and permission etc.

bcp TST..sysusers out ‘/sybase/BCP/ASETST01/TST_sysusers.out’ -Usa -SASETST01 -c -n

bcp TST..sysalternates out ‘/sybase/BCP/ASETST01/TST_sysalternates.out’ -Usa -SASETST01 -c -n

bcp TST..sysprotects out ‘/sybase/BCP/ASETST01/TST_sysprotects.out’ -Usa -SASETST01 -c -n

4)Load database

isql -Usa -SASETST01 -X -w2000

password:

use master

load database TST from "/sybase/dump/ASETST01/PRD22072022.dmp"

Online database TST

use TST

5)Delete bcp out tables

Once database is online then delete entries from below table so that we can perform bcp in operation.

use TST

select @@servername,getdate()

delete from TST..sysusers

delete from TST..sysprotects

delete from TST..sysalternates

6)BCP in

bcp TST..sysusers in '/sybase/BCP/ASETST01/TST_sysusers.out' -Usa -SASETST01 -c -n

bcp TST..sysalternates in '/sybase/BCP/ASETST01/TST_sysalternates.out' -Usa -SASETST01 -c -n

bcp TST..sysprotects in '/sybase/BCP/ASETST01/TST_sysprotects.out' -Usa -SASETST01 -c -n

7)How to check db refresh completed successfully ?

i)MDA table master..monOpenDatabases

Select DBID,BackupInProgress,LastBackupFailed,TransactionLogFull,DBName,BackupStartTime,LastCheckpointTime,LastTranLogDumpTime from master..monOpenDatabases

ii)Check backup log

cd $SYBASE/ASE*/install

cat ASETST01_BS.log | grep -i 'LOAD is complete'

Sybase installation steps

Prerequisites:

Os level user: sybase

Hostname: sybasetest

Download the software from service market place and extract the software under /sybase/software

ASE16_XXXXX.TAR

tar -xvf ASE16_XXXXX.TAR

this command will extract the software .

Installation steps:

cd /sybase/software/ebf28238

sybase@sybasetest:/sybase/software/ebf28238> ./setup.bin -i console

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

===============================================================================

SAP Adaptive Server Enterprise (created with InstallAnywhere)

-------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...

===============================================================================

Introduction

------------

InstallAnywhere will guide you through the installation of SAP Adaptive Server

Enterprise 16.0 SP03 PL05.

It is strongly recommended that you quit all programs before continuing with

this installation.

Respond to each prompt to proceed to the next step in the installation. If

you want to change something on a previous step, type 'back'.

You may cancel this installation at any time by typing 'quit'.

PRESS <ENTER> TO CONTINUE:

===============================================================================

Choose Install Folder

---------------------

Where would you like to install?

Default Install Folder: /opt/sap

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

: /sybase

INSTALL FOLDER IS: /sybase

IS THIS CORRECT? (Y/N): Y

===============================================================================

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

:

===============================================================================

Software License Type Selection

-------------------------------

What would you like to do?

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

2- Install Express Edition of SAP Adaptive Server Enterprise

3- Evaluate SAP Adaptive Server Enterprise

Enter one of the options above:

===============================================================================

End-user License Agreement

--------------------------

1) Americas and Asia Pacific 2) Argentina

3) Asia Pacific Region - General 4) Australia

5) Belgium(English) 6) Brazil

7) Canada 8) Denmark

9) Europe,Middle East, and Africa - General 10) France(English)

11) France(French) 12) Germany(English)

13) Hong Kong 14) India

15) Italy(English) 16) Italy(Italian)

17) Japan 18) Korea

19) Latin America Countries - Other than Argent 20) Malaysia

21) Mexico 22) Netherlands

23) New Zealand 24) Norway

25) People's Republic of China(PRC) 26) Singapore

27) South Africa 28) Spain(English)

29) Spain(Spanish) 30) Sweden

31) Switzerland(English) 32) Taiwan

33) United Kingdom 34) United States of America

35) Any Other Locations

Please enter the number of the location you are installing. (1-35) (Default:

1): 34

LICENSE AGREEMENT

General (applies to all countries,

except those for which a specific

country/language version is posted)

IMPORTANT NOTICE: READ THIS LICENSE AGREEMENT CAREFULLY

BEFORE USING THE ENCLOSED PROGRAM. YOU MAY USE THE PROGRAM

ACQUIRED ONLY IN THE COUNTRY IN WHICH THIS LICENSE WAS

ACCEPTED, AND ONLY IN ACCORDANCE WITH THE FOLLOWING TERMS

AND CONDITIONS. IF YOU DO NOT AGREE TO BE BOUND BY THESE

TERMS, YOU MAY NOT USE THE PROGRAM. BY DOWNLOADING,

INSTALLING, OR USING THE PROGRAM IN ANY WAY, YOU ACKNOWLEDGE

THAT YOU HAVE READ, UNDERSTAND AND AGREE TO THE TERMS OF

THIS AGREEMENT. IF YOU DO NOT AGREE WITH THESE TERMS,

PRESENT YOUR RECEIPT OR OTHER PROOF OF PURCHASE, TOGETHER

WITH THE PROGRAM MEDIA, DOCUMENTATION AND PACKAGING (IF ANY)

TO THE ENTITY FROM WHICH YOU OBTAINED THIS PRODUCT WITHIN 30

DAYS TO REQUEST A REFUND. THIS IS A LICENSE AND NOT A SALE.

Press ENTER to read the text [Type 'back' and press ENTER to skip the text]

: back

I agree to the terms of the SAP license for the install location specified.

(Y/N): Y

===============================================================================

SySAM License

-------------

Enter the SAP Adaptive Server Enterprise license key(s) or specify the license

server where license key(s) were previously deployed.

->1- Specify license keys

2- Use previously deployed license server

3- Continue installation without a license key

Enter one of the options above: 3

===============================================================================

Product Licenses

----------------

Please select the product edition and license type you would like to

configure.

Product Edition

->1- Enterprise Edition

2- Small Business Edition

3- Unknown

Enter one of the options above:

License Type

->1- CP : CPU License

2- SF : Standby CPU License

3- SR : Server License

4- SV : Standby Server License

5- DT : Development and Test License

6- EV : Evaluation License

7- OT : Other License

8- SS : Standalone Seat License

9- DV : Developer License

10- NA : Not Applicable or Other License

11- AC : OEM Application Deployment CPU License

12- BC : OEM Application Deployment Standby CPU License

13- AR : OEM Application Deployment Server License

14- BR : OEM Application Deployment Standby Server License

15- AO : OEM Application Deployment Other License

16- LP : Application Specific CPU License

17- LF : Application Specific Standby CPU License

18- LR : Application Specific Server License

19- LV : Application Specific Standby Server License

20- Unknown

Enter one of the options above:

===============================================================================

SySAM Notification

------------------

Please configure the SySAM email alert mechanism. When configured, specified

recipients will receive email notifications about SySAM events that may need

administrator attention.

Do you want to configure email alerts? (Y/N): N

===============================================================================

Pre-Installation Summary

------------------------

Please Review the Following Before Continuing:

Product Name:

SAP Adaptive Server Enterprise

Install Folder:

/sybase

Product Features:

SAP Adaptive Server Enterprise,

Open Client,

DB-Library,

jConnect 16.0 for JDBC,

Interactive SQL,

QPTune,

SySAM License Utilities,

Remote Command and Control Agent for SAP ASE,

SAP ASE ODBC Driver,

SAP ASE Extension Module for Python,

SAP ASE Database Driver for PERL,

SAP ASE Extension Module for PHP,

Cockpit,

SAP ASE Cockpit

Disk Space Information (for Installation Target):

Required: 1,950,091,659 Bytes

Available: 17,439,690,752 Bytes

PRESS <ENTER> TO CONTINUE:

===============================================================================

Ready To Install

----------------

InstallAnywhere is now ready to install SAP Adaptive Server Enterprise onto

your system at the following location:

/sybase

PRESS <ENTER> TO INSTALL:

===============================================================================

Installing...

-------------

[==================|==================|==================|==================]

[------------------|------------------|------------------|------------------]

===============================================================================

Configure New Servers

---------------------

The SAP Adaptive Server Enterprise includes products that require

configuration. If you choose to configure the products on this screen, you

will be given the option to specify custom values for each product. If you

choose not to configure the products now, you can configure them later.

Please deselect any products that you do not want to configure now :

[ ] 1 - Configure new SAP ASE

[ ] 2 - Configure new Backup Server

[ ] 3 - Configure new XP Server

[ ] 4 - Configure new Job Scheduler

[ ] 5 - Enable Self Management

[ ] 6 - Configure Historical Monitoring Data Repository

[ ] 7 - Configure Cockpit

NOTE: The Historical Monitoring Data Repository should only be configured

if you are using SAP ASE in SAP Business Applications. Use in a standalone SAP

ASE is not supported.

To select an item enter its number, or 0 when you are finished: (Default: 0)

: 1

[X] 1 - Configure new SAP ASE

[ ] 2 - Configure new Backup Server

[ ] 3 - Configure new XP Server

[ ] 4 - Configure new Job Scheduler

[ ] 5 - Enable Self Management

[ ] 6 - Configure Historical Monitoring Data Repository

[ ] 7 - Configure Cockpit

NOTE: The Historical Monitoring Data Repository should only be configured

if you are using SAP ASE in SAP Business Applications. Use in a standalone SAP

ASE is not supported.

To select an item enter its number, or 0 when you are finished: (Default: 0)

: 2

[X] 1 - Configure new SAP ASE

[X] 2 - Configure new Backup Server

[ ] 3 - Configure new XP Server

[ ] 4 - Configure new Job Scheduler

[ ] 5 - Enable Self Management

[ ] 6 - Configure Historical Monitoring Data Repository

[ ] 7 - Configure Cockpit

NOTE: The Historical Monitoring Data Repository should only be configured

if you are using SAP ASE in SAP Business Applications. Use in a standalone SAP

ASE is not supported.

To select an item enter its number, or 0 when you are finished: (Default: 0)

: 0

===============================================================================

Configure Servers with Different User Account

---------------------------------------------

Do you want to configure the server(s) under different user account?

1- Yes

->2- No

Enter one of the options above:

===============================================================================

User Configuration Data Directory

---------------------------------

Enter the directory where you want to store user data files such as interfaces

file, RUN_<server> file, error log, etc.. The files for the server(s) you

about to create will be placed in this directory.

Data Directory (Default: /sybase):

===============================================================================

Configure New SAP ASE

---------------------

SAP ASE Name (Default: sybasetest): TEST

System Administrator's Password:

Confirm System Administrator's Password:

The 'System Administrator's Password' does not match.

PRESS <ENTER> TO CONTINUE:

System Administrator's Password:

Confirm System Administrator's Password:

Host Name (Default: sybasetest.corp.pep.pvt): sybasetest

Port Number (Default: 5000): 50121

Error Log (Default: /sybase/ASE-16_0/install/TEST.log): /sybase/ASE-16_0/install/TEST.log

Application Type

->1- Mixed (OLTP/DSS)

2- Online Transaction Proccessing (OLTP)

3- Decision Support Systems (DSS)

Select an application type:

Page Size

1- 2k

->2- 4k

3- 8k

4- 16k

Select a page size: 1

->1- us_english

Default Language:

1- cp437 : Code Page 437, (United States) character set.

2- cp850 : Code Page 850 (Multilingual) character set.

3- iso15 : ISO_8859-15:1998, Latin9, Western Europe

->4- iso_1 : ISO 8859-1 (Latin-1) - Western European 8-bit character set.

5- mac : Macintosh default character set for Western European locales.

6- roman8 : Hewlett-Packard proprietary character set for European locales.

7- roman9 : Hewlett-Packard proprietary character set for European locales.

8- utf8 : Unicode 3.1 UTF-8 Character Set

Default Character Set:

->1- bin_iso_1 : Binary ordering, for the ISO 8859/1 or Latin-1 character set

(iso_1).

2- dictionary_iso_1 : General purpose dictionary ordering.

3- espdict_iso_1 : Spanish dictionary ordering.

4- espnoaccents_iso_1 : Spanish case and accent insensitive dictionary order.

5- espnocase_iso_1 : Spanish case insensitive dictionary order.

6- noaccents_iso_1 : Dictionary order, case insensitive, accent insensitive.

7- nocase_iso_1 : Dictionary order, case insensitive.

8- nocasepref_iso_1 : Dictionary order, case insensitive with preference.

Default Sort Order: 7

Enable SAP ASE for SAP ASE Cockpit monitoring

1- No

->2- Yes

Do you want to enable SAP ASE for SAP ASE Cockpit monitoring?: 1

Optimize SAP ASE Configuration

->1- No

2- Yes

Do you want to optimize SAP ASE configuration?:

Create sample databases

->1- No

2- Yes

Do you want to create sample databases?:

Master Device (Default: /sybase/data/master.dat): /sybase/data/master.dat

Master Device Size (MB) (Default: -1): 500

Master Database Size (MB) (Default: 18): 150

System Procedure Device (Default: /sybase/data/sysprocs.dat): /sybase/data/sysprocs.dat

System Procedure Device Size (MB) (Default: -1): 1000

System Procedure Database Size (MB) (Default: 196): 250

System Device (Default: /sybase/data/sybsysdb.dat): /sybase/data/sybsysdb.dat

System Device Size (MB) (Default: -1): 100

System Database Size (MB) (Default: 3):

Tempdb Device (Default: /sybase/data/tempdbdev.dat): /sybase/data/tempdbdev.dat

Tempdb Device Size (MB) (Default: -1): 8192

Tempdb Database Size (MB) (Default: 100): 8192

Enable PCI

->1- No

2- Yes

Do you want to configure PCI/JAVA?:

===============================================================================

Configure New Backup Server

---------------------------

Backup Server Name (Default: TEST_BS):

Port Number (Default: 5000): 50122

Error Log (Default: /sybase/ASE-16_0/install/TEST_BS.log): /sybase/ASE-16_0/install/TEST_BS.log

Allow Hosts (Default: ):

===============================================================================

New Server Configuration Summary

--------------------------------

SAP ASE

SAP ASE Name TEST

System Administrator's Password

Enable SAP ASE for SAP ASE Cockpit monitoring false

Technical user tech_user

Technical user password ****

Host Name sybasetest

Port Number 50121

Application Type Mixed (OLTP/DSS)

Create sample databases false

Page Size 2k

Error Log

/sybase/ASE-16_0/install/TEST.log

Default Language us_english

Default Character Set iso_1

Default Sort Order nocase_iso_1

Master Device /sybase/data/master.dat

Master Device Size (MB) 500

Master Database Size (MB) 150

System Procedure Device /sybase/data/sysprocs.dat

System Procedure Device Size (MB) 1000

System Procedure Database Size (MB) 250

System Device /sybase/data/sybsysdb.dat

System Device Size (MB) 100

System Database Size (MB) 3

Tempdb Device /sybase/data/tempdbdev.dat

Tempdb Device Size (MB) 8192

Tempdb Database Size (MB) 8192

Enable PCI false

Optimize SAP ASE Configuration false

Backup Server

Backup Server Name TEST_BS

Port Number 50122

Error Log /sybase/ASE-16_0/install/TEST_BS.log

Do you want to continue? (Default: yes): yes

===============================================================================

Configure New SAP ASE

---------------------

Building SAP Adaptive Server Enterprise 'TEST':

Writing entry into directory services...

Directory services entry complete.

Building master device...

Master device complete.

Writing RUN_TEST file...

RUN_TEST file complete.

Starting server...

Server started.

Set SA password...

SA password is set.

Building sysprocs device and sybsystemprocs database...

sysprocs device and sybsystemprocs database created.

Running installmaster script to install system stored procedures...

installmaster: 10% complete.

installmaster: 20% complete.

installmaster: 30% complete.

installmaster: 40% complete.

installmaster: 50% complete.

installmaster: 60% complete.

installmaster: 70% complete.

installmaster: 80% complete.

installmaster: 90% complete.

installmaster: 100% complete.

installmaster script complete.

Creating two-phase commit database...

Two phase commit database complete.

Extending tempdb database ...

Extending tempdb database complete.

Installing common character sets (Code Page 437, Code Page 850, ISO Latin-1,

Macintosh and HP Roman-8)...

Character sets installed.

Setting server name in SAP Adaptive Server Enterprise...

Server name added.

Setting optimization goal...

Setting optimization goal complete.

Server 'TEST' was successfully created.

===============================================================================

Set SAP ASE Default Language

----------------------------

Installing character set 'ISO Latin-1' in the SAP Adaptive Server

Enterprise...

Warning: Character set 'ISO Latin-1' is already installed in the SAP Adaptive

Server Enterprise.

Installing character set 'ISO_8859-15:1998' in the SAP Adaptive Server

Enterprise...

Character set 'ISO_8859-15:1998' was successfully installed in the SAP

Adaptive

Server Enterprise.

Installing character set 'roman9' in the SAP Adaptive Server Enterprise...

Character set 'roman9' was successfully installed in the SAP Adaptive Server

Enterprise.

Installing character set 'UTF-8' in the SAP Adaptive Server Enterprise...

Character set 'UTF-8' was successfully installed in the SAP Adaptive Server

Enterprise.

Installing sort order 'Dictionary order, case insensitive' in the SAP Adaptive

Server Enterprise...

Sort Order 'Dictionary order, case insensitive' was successfully installed in

the SAP Adaptive Server Enterprise.

Making 'Dictionary order, case insensitive' the SAP Adaptive Server

Enterprise's default sort order...

The SAP Adaptive Server Enterprise's default sort order is now 'Dictionary

order, case insensitive'.

Done

===============================================================================

Configure New Backup Server

---------------------------

Building Backup Server 'TEST_BS':

Writing entry into directory services...

Directory services entry complete.

Writing RUN_TEST_BS file...

RUN_TEST_BS file complete.

Starting server...

Server started.

Server 'TEST_BS' was successfully created.

===============================================================================

Installation Completed

----------------------

The installation was successful.

Please check regularly for updates at http://service.sap.com.

If you have not done so, obtain license files from the SAP Support Portal at

https://support.sap.com/licensekey.

PRESS <ENTER> TO EXIT THE INSTALLER:

sybase@sybasetest:/sybase/software/ebf28238>