April 18, 2019

Installing Sybase on Your Linux Server - page 3

Why Look at Sybase?

  • July 18, 2002
  • By Alexander Prohorenko

In the srvbuild program (shown in Figure 1), we can choose what to install: Adaptive server or Backup server. The Backup server (necessary for creationg of backup/reserve copy) can be installed to a completely different computer. In this example, we can skip this option and not install it.

Fill all the other fields with server names (based on your own taste) and click OK. The next window displays Server Attribute Editor (see Figure 2).

We need to pay attention here so that this server will work.

  • Master device path - path where service base master will be located. Sybase bases can be located in files and also in raw devices. To optimize speed of working of our Sybase server I recommend using raw devices. It's a pity, but max size of device (but not of base!) in Sybase can not be more than 2 Gb, and we need to count on that when we are doing server configuration.
  • Master device size - size for device where master base will be located.
  • Master database size - startup size of master base. In the future this base can be increased, but the limiting size is "master device size".
  • Sybsystemprocs device path - path where service base of system functions will be located. Usually file can be used--these subroutines will not be used very often.
  • Sybsystemprocs device size - size for device where sybsystemprocs will be located. Use default value.
  • Sybsystemprocs database size - choose it like we did with sybsystemprocs device size.

Please make sure you configure the user sybase to have write rights to the directory or device where will the database will be kept. (Also, remember the TCP port number where the server will be working. We may need this in future.)

After all fields are appropriately filled, click on OK. The Server Attribute Editor will display the Backup server attributes (see Figure 3).

Here, we need to configure Backup server. We have two fields here that are important to note:

  • Language - russian (for example).
  • Codepage - cp1251 or koi8r, it depends on which codepage we will be using for keeping our data.

Click the Build Servers button and a special script will be executed that will start the servers and create the necessary service databases.

This can take some time, just be patient. Once everything is finished, a dialog box will appear asking to localize your server. I recommend skipping this step. If you need to do this later, it can be easily done manually--a process we will describe in the next section.

To proceed, click on No to close this dialog, then on OK in the next window. This brings us back to the original srvbuild dialog box. To close it, click on the Exit button.

To configure Sybase to be auto-started after each computer reboot we need to configure the system a bit more:

chkconfig -add sybase
chkconfig sybase on
chkconfig --list sybase
sybase      0:off  1:off  2:off  3:on   4:on   5:on   6:off

Sybase is now installed. The only thing we have ahead is to localize it. In this case we will make Sybase able to work with the Russian language.

Most Popular LinuxPlanet Stories