SAP ASE Sybase Install Over Linux & Baseline Configuration.

We will put together a very simple and intuitive puzzle with which you will be able to size what you need so that you can carry out this course. You will be able to use these resources in the future and whenever you want.

We will list the components required to approach this course.

It is very important to prepare the resources before starting... Here we will tell you what to keep in mind.

We will use a free software called VirtualBox that will help us to contain and manage the Linux virtual machine on which we will install SAP ASE 16.

A Little action...

We must take into account some recommendations for the successful installation of the Ubuntu 18.0.4 Desktop 64-bit Linux operating system

Let's do it! Let's know the installation requirements for Linux and apply them.

We will show you where the installer file for Linux Ubuntu version 18.04 Deskto 64-bit is located.

Let's download and install Linux Ubuntu 18.04 Desktop 64-bit

After knowing and fulfilling the Linux installation prerequisites, we will proceed with the installation.

It is very helpful to know some tips before you start. Here we will tell you which ones...

Installing Linux Ubuntu 18.04 Dekstop step by step.

You will learn how to start and stop your Linux virtual machine.

It is prudent for you to know a few things that will happen the first time you log in with a Linux Ubuntu account.

We will use a resource of the operational system Linux Ubuntu  called terminal to interact with the machine and with SAP ASE. Here we will tell you how to Access this resource.

Being able to have full access to the common directory shared by Windows and Linux is very useful. Here we will see what are the settings that must be made from the Ubuntu Linux operating system.

Just as it is desirable to have a common folder between Windows and Linux, it is also useful to make the Copy & Paste commands work between both machines, so here we will see how to actívate this feature.

If you enable bash mode, you can make the operational system auto-complete paths and commands, as well as use the up and down arrows to repeat commands among others.

Although we could use the root or vboxuser account for the installation of SAP ASE 16, good practices invite to create an independent and autonomous account for this purpose.

It avoids many problems and inconveniences to set the appropriate permissions to access the machine's resources. Here we will see how!

Finally, we will see how to register with the system using the ase16 account.

After finishing this practice, you will have installed Linux Ubuntu 18.04 Desktop 64-bit.

We will tell you how to add some components to the operating system for a successful SAP ASE installation.

Make sure that you have the appropriate SAP ASE installation permissions.

SAP ASE installers are compressed, so it is necessary to decompress them in two phases, the first one is to unpack the file with .tgz extensión.

The previous step (unzipping the .tgz file) creates a .tar file that needs to be unpacked. Here we will show you how.

SAP ASE requires some libraries installed in the operational system for its operation. Here we will list them and see how to download and install them.

After running this lab we will be sure that the minimum requirements for SAP ASE 16 installation on Linux Ubuntu are met.

Finally, we will see how to install SAP ASE step by step.

Let's remember how to open / use a terminal in the Ubuntu Linux operating system.

We will show how to invoke the SAP ASE installation program.

We will assign the installation directory for SAP ASE 16.

We tell you which is the type of SAP ASE license suggested for this installation.

Do you agree with the licensing terms? Yes!

More about licensing and disk space requirements for SAP ASE 16.

The first phase of the installation (copying files) will start at shortly...

The installer file contains several services. For now, we recommend you to choose only the ones that are essential for the operation of SAP ASE 16.

We will select the appropriate path to contain the database files (devices).

We will define among many other attributes the name of our SAP ASE.

We will define the port number where SAP ASE will listen and respond to queries.

We will define the name and location of the file where certain situations of the SAP ASE execution are registered.

Depending on the type of application SAP ASE will serve, the way SAP ASE writes (page size) and the language it will use must be configured.

Here we will define how the information is treated in SAP ASE.

It is possible to enlist SAP ASE to use some of its own administration tolos.

You could have a database to practice on... We will define the path where the master database device will be located.

We will define the initial device size for the master database.

Other system databases will be installed automatically.

...more system database settings

Another system database is sybsystempdb. Here are its settings and definitions.

One of the most important databases of the system is the tempdb. here are its definitions and initial settings.

Additional services that are not needed at the moment, we recommend turning them off.

We will configure the name and port of the service with which SAP ASE takes and recovers Database backups.

Scope and error logging of the Backup Server.

Definition of the XP Server listening port and its evento log file.

The installation of SAP ASE 16 will start shortly.

You may see an alert at the end of the installation process. Not to worry, let's continue...

This final adjustment will allow everything to run smoothly.

Verifying environment...

If you can see the SAP ASE version, we have succeeded. Congratulations!

Some final adjustments part one...

Some final adjustments part two..

Finally! we are going to connect to SAP ASE 16.

After finishing the installation, SAP ASE is up... We will see how to stop it properly.

We are going to run SAP ASE.

It's time for fun... Now, we invite you to do it yourself...

Welcome to the chapter where we will create the configuration baseline for SAP ASE 16.

We will tell you why it is important to know and apply this concept in any version of SAP ASE for any platform (LUNIX/LINUX/Windows).

We will see where you can find the SAP ASE 16 configuration file.

Do you know what is the default name of SAP ASE 16.

There are several ways to make adjustments to the SAP ASE configuration. Here we will talk about one of them.

Some SAP ASE parameters have outstanding relevance over the rest. Here we will tell you which ones.

This is the most relevant thing you should know about memory configuration in SAP ASE.

This is the most relevant thing you should know about processors & pools configuration in SAP ASE.

It is important that you know how to convert page values from 2K to MB or GB and viceversa as SAP ASE uses this pattern for some of its configuration parameters.

Memory is perhaps one of the most important inputs for SAP ASE. Here we will tell you what you need to know about it.

It is very important to find a balance for the configuration of the processors, so here we will tell you what you need to know in this regard.

The write and read system is vital and has many components that are configurable in SAP ASE. Let's start with this one.

Spaces in memory must be dedicated to attend the different queries. Here we will talk about the most important ones.

We will see how to control the number of users that can access SAP ASE.

We will give you an overview of all parameters and their suggested initial values (Baseline Configuration).

Let's take a look at the most used commands to make adjustments to the SAP ASE configuration.

Now we invite you to do it yourself. When you have finished you will have learned how to create a configuration baseline for SAP ASE 16.