LFD

Information as collected from documents "InstSybServerLinux12.5.1.txt" and "InstSybServerLinux12.5.4.txt" as well as from actual experience installing the new server for Waregem on 11 September 2006 (under SLES 9) resp. for Altdorf on 12 March 2008 (under SLES 10).

Last updated: mkuhn 06:07, 23 July 2008 (EDT)

1. Pre-installation tasks

Add user "sybase"

# groupadd sybase
# useradd -g sybase -d /home/sybase -s /bin/bash -c "Sybase user" -m sybase
# passwd sybase
Password:

Unzip the installation software

# cd /backup/software/SybaseASE-12.5.4
# tar xzf ase1254linux32.tgz

Create essential directories (Note: if possible the directories "/SunRiseDatabase" and "/SunRiseDatabaseLog" should reside on different hard disks to improve performance)

# mkdir /opt/sybase       && chown sybase:sybase /opt/sybase
# mkdir /var/spool/sybase && chown sybase:sybase /var/spool/sybase

# mkdir /SunRiseDatabase && cd /SunRiseDatabase
# mkdir sybaseDatabase   && chown sybase:sybase sybaseDatabase

# mkdir /SunRiseDatabaseLog && cd /SunRiseDatabaseLog
# mkdir sybaseDatabase      && chown sybase:sybase sybaseDatabase

resp. (as an example)

# mkdir /opt/sybase       && chown sybase:sybase /opt/sybase
# mkdir /var/spool/sybase && chown chown sybase:sybase /var/spool/sybase

# ln -s /datenbank /SunRiseDatabase && cd /SunRiseDatabase
# mkdir sybaseDatabase              && chown sybase:sybase sybaseDatabase

# ln -s /logs /SunRiseDatabaseLog && cd /SunRiseDatabaseLog
# mkdir sybaseDatabase            && chown sybase:sybase sybaseDatabase

2. Installation of Sybase ASE

Installation under SLES 8 and SLES 9 and SLES 10

Set shared memory. (Example: For Basel a value of "2097152000" was configured)

# /sbin/sysctl -w kernel.shmmax=121634816

Become user "sybase" and start the installation

# su - sybase
$ cd /backup/software/SybaseASE-12.5.4
$ ./setup -console

InstallShield Wizard
Initializing InstallShield Wizard...
Searching for Java(tm) Virtual Machine...
Running InstallShield Wizard...

-------------------------------------------------------------------------------
Welcome to the InstallShield Wizard for Sybase Adaptive Server Enterprise Suite
version 12.5.4 GA

The InstallShield Wizard will install Sybase Adaptive Server Enterprise Suite
on your computer.
To continue, choose Next.
Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
 31) Switzerland(German)

   Please enter the number of the location you are installing. (1-37) [1] 31


LICENSE AGREEMENT
BELGIUM
...

Press ENTER to read the text [Type q to quit] q

I agree to the terms of the Sybase license for the install location
specified.(Y/N) [N]Y

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please enter the directory where you would like to install the products or
press ENTER to accept the default.

   Destination Directory [/opt/sybase]

   Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Choose the setup type that best suits your needs.

To select an item enter its number, or 0 when you are finished: [0] 2

[X] 2 - Full
        The program will be installed with all the products and features.

To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Please wait while the installer checks your system information...

-------------------------------------------------------------------------------
Sybase Adaptive Server Enterprise Suite will be installed in the following
location:
...
Press ENTER to read the text [Type q to quit] q 

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

Installing Sybase Adaptive Server Enterprise Suite. Please wait...

|-----------|-----------|-----------|------------|
0%         25%         50%         75%        100%
||||||||||||||||||||||||||||||||||||||||||||||||||

Creating uninstaller...

-------------------------------------------------------------------------------
The InstallShield Wizard has successfully installed Sybase Adaptive Server
Enterprise Suite. Choose Next to continue the wizard.

Press 1 for Next, 3 to Cancel or 4 to Redisplay [1]

Installation under SLES 8 and SLES 9

-------------------------------------------------------------------------------
The Adaptive Server Enterprise suite contains a number of programs in addition
to the Adaptive Server Enterprise database server. At this point in the
installation you can choose to configure various products. If you select the
options on this screen, you will be given the option of specifying
configuration options for each product or to allow the installer to set default
values for these on the next screen. If you do not choose to configure the
products at this time, you can configure them using the ASE configuration
utility at a later time.

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

      To select an item enter its number, or 0 when you are finished: [0] 3
      To select an item enter its number, or 0 when you are finished: [0] 4
      To select an item enter its number, or 0 when you are finished: [0] 5
      To select an item enter its number, or 0 when you are finished: [0] 6
      To select an item enter its number, or 0 when you are finished: [0] 7

   [X]  1  -  Configure new Adaptive Server
   [X]  2  -  Configure new Backup Server
   [ ]  3  -  Configure new Monitor Server
   [ ]  4  -  Configure new XP Server
   [ ]  5  -  Configure new Job Scheduler
   [ ]  6  -  Configure Web Services
   [ ]  7  -  Configure new Full-Text Search SDS

      To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
You have chosen to configure the products listed below. You can accept default
configuration values or provide customized values for the configuration options
required by each product. If you do not select custom configuration below, this
installer will configure the products you have selected with default values. If
you accept default values at this time you can change the configuration values
for a product at later time.

Please select the products that you want to custom configure.

      To select an item enter its number, or 0 when you are finished: [0] 1
      To select an item enter its number, or 0 when you are finished: [0] 2

   [X]  1  -  Custom configure new Adaptive Server
   [X]  2  -  Custom configure new Backup Server

      To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please enter custom configuration values for the new Adaptive Server

   Adaptive Server Name [BIBWAR] sisisSYB
   Port Number [5000] 4000
   Error Log [/opt/sybase/ASE-12_5/install/sisisSYB.log] /var/spool/sybase/sisisSYB.errorlog
   Page Size
      1. 2k
      2. 4k
      3. 8k
      4. 16k
   Select a page size :  [1]
   Master Device [/opt/sybase/data/master.dat] /SunRiseDatabase/sybaseDatabase/masterDev
   Master Device Size (MB) [30] 200
   Master Database Size (MB) [6] 100
   System Procedure Device [/opt/sybase/data/sysprocs.dat] /SunRiseDatabase/sybaseDatabase/sysprocsDev
   System Procedure Device Size (MB) [132] 200
   System Procedure Database Size (MB) [132]
   System Device [/opt/sybase/data/sybsysdb.dat] /SunRiseDatabase/sybaseDatabase/sybsysdbDev
   System Device Size (MB) [1] 10
   System Database Size (MB) [1]

   Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
Please enter custom configuration values for the new Backup Server

   Backup Server Name [sisisSYB_BS] sisisSYBbackup
   Port Number [5001] 4001
   Error Log [/opt/sybase/ASE-12_5/install/sisisSYBbackup.log] /var/spool/sybase/sisisSYBbackup.errorlog

   Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
The installer will now configure new servers with the following values. Please
click Next to proceed with the server configurations.
...

   Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]
   
   Building Adaptive Server 'sisisSYB':
   Writing entry into directory services...
   Directory services entry complete.
   Building master device...
   Master device complete.
   Writing RUN_sisisSYB file...
   RUN_sisisSYB file complete.
   Starting server...
   Server started.
   Building sysprocs device and sybsystemprocs database...
   sybprocs 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.
   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 Adaptive Server...
   Server name added.
   Server 'sisisSYB' was successfully created.
   Building Backup Server 'sisisSYBbackup':
   Writing entry into directory services...
   Directory services entry complete.
   Writing RUN_sisisSYBbackup file...
   RUN_sisisSYBbackup file complete.
   Starting server...
   Server started.
   Setting server name in Adaptive Server...
   Server name added.
   Server 'sisisSYBbackup' was successfully created.

-------------------------------------------------------------------------------
   The installation was successful.

   Please check regularly for updates at http://www.sybase.com/downloads.

   If you have Sybase Software Asset Management Certificates to enter, this is
   done by running the tool /opt/sybase/SYSAM-1_0/bin/lmgr after the
   installation is complete.

   Press 3 to Finish or 4 to Redisplay [3]

Installation unter SLES 10

-------------------------------------------------------------------------------
The Adaptive Server Enterprise suite contains a number of programs in addition
to the Adaptive Server Enterprise database server. At this point in the
installation you can choose to configure various products. If you select the
options on this screen, you will be given the option of specifying
configuration options for each product or to allow the installer to set default
values for these on the next screen. If you do not choose to configure the
products at this time, you can configure them using the ASE configuration
utility at a later time.

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

   [X]  1  -  Configure new Adaptive Server
   [X]  2  -  Configure new Backup Server
   [X]  3  -  Configure new Monitor Server
   [X]  4  -  Configure new XP Server
   [X]  5  -  Configure new Job Scheduler
   [X]  6  -  Configure Web Services
   [X]  7  -  Configure new Full-Text Search SDS

      To select an item enter its number, or 0 when you are finished: [0] 1

   [ ]  1  -  Configure new Adaptive Server
   [ ]  2  -  Configure new Backup Server
   [ ]  3  -  Configure new Monitor Server
   [ ]  4  -  Configure new XP Server
   [ ]  5  -  Configure new Job Scheduler
   [ ]  6  -  Configure Web Services
   [ ]  7  -  Configure new Full-Text Search SDS

      To select an item enter its number, or 0 when you are finished: [0]

Press 1 for Next, 2 for Previous, 3 to Cancel or 4 to Redisplay [1]

-------------------------------------------------------------------------------
   The installation was successful.

   Please check regularly for updates at http://www.sybase.com/downloads.

   If you have Sybase Software Asset Management Certificates to enter, this is
   done by running the tool /opt/sybase/SYSAM-1_0/bin/lmgr after the
   installation is complete.

   Press 3 to Finish or 4 to Redisplay [3]

$ export SYBASE=/opt/sybase \
         SYBASE_ASE=ASE-12_5 \
         SYBASE_OCS=OCS-12_5 \
         LD_POINTER_GUARD=1
$ cd $SYBASE/$SYBASE_ASE/init/sample_resource_files
$ cp srvbuild.adaptive_server.rs sisisSYB.rs

$ vi sisisSYB.rs
sybinit.release_directory: /opt/sybase
sybinit.product: sqlsrv
sqlsrv.server_name: sisisSYB
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: altdorf
sqlsrv.network_port_list: 4000
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: /SunRiseDatabase/sybaseDatabase/masterDev
sqlsrv.master_device_size: 200
sqlsrv.master_database_size: 100
sqlsrv.errorlog: /var/spool/sybase/sisisSYB.errorlog
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /SunRiseDatabase/sybaseDatabase/sysprocsDev
sqlsrv.sybsystemprocs_device_size: 200
sqlsrv.sybsystemprocs_database_size: 132
sqlsrv.sybsystemdb_device_physical_name: /SunRiseDatabase/sybaseDatabase/sybsysdbDev
sqlsrv.sybsystemdb_device_size: 10
sqlsrv.sybsystemdb_database_size: 1
sqlsrv.default_backup_server: sisisSYBbackup

$ $SYBASE/$SYBASE_ASE/bin/srvbuildres -r sisisSYB.rs
Building Adaptive Server 'sisisSYB':
Writing entry into directory services...
Directory services entry complete.
Building master device...
Master device complete.
Writing RUN_sisisSYB file...
RUN_sisisSYB file complete.
Starting server...
Server started.
Building sysprocs device and sybsystemprocs database...
sybprocs device and sybsystemprocs database created.
Running installmaster script to install system stored procedures...
installmaster: 10% complete.
...
installmaster: 100% complete.
installmaster script complete.
Creating two-phase commit database...
Two phase commit 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 Adaptive Server...
Server name added.
Server 'sisisSYB' was successfully created.

$ cp srvbuild.backup_server.rs sisisSYBbackup.rs
$ vi sisisSYBbackup.rs
sybinit.release_directory: /opt/sybase
sybinit.product: bsrv
bsrv.server_name: sisisSYBbackup
bsrv.new_config: yes
bsrv.do_add_backup_server: yes
bsrv.do_upgrade: no
bsrv.network_protocol_list: tcp
bsrv.network_hostname_list: altdorf
bsrv.network_port_list: 4001
bsrv.language: USE_DEFAULT
bsrv.character_set: USE_DEFAULT
bsrv.tape_config_file: USE_DEFAULT
bsrv.errorlog: /var/spool/sybase/sisisSYBbackup.errorlog
sqlsrv.related_sqlsrvr: sisisSYB
sqlsrv.sa_login: sa
sqlsrv.sa_password: USE_DEFAULT

$ $SYBASE/$SYBASE_ASE/bin/srvbuildres -r sisisSYBbackup.rs
Building Backup Server 'sisisSYBbackup':
Writing entry into directory services...
Directory services entry complete.
Writing RUN_sisisSYBbackup file...
RUN_sisisSYBbackup file complete.
Starting server...
Server started.
Server 'sisisSYBbackup' was successfully created.

Installation unter SLES 8, SLES 9 und SLES 10

Überprüfen, ob alle Server laufen.

$ export SYBASE=/opt/sybase \
         SYBASE_ASE=ASE-12_5
$ $SYBASE/$SYBASE_ASE/install/showserver
F S UID        PID  PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
0 S sybase   28831 28830  0  76   0 -  2263 -      16:32 pts/1    00:00:00 /opt/
sybase/ASE-12_5/bin/backupserver -e/var/spool/sybase/sisisSYBbackup.errorlog -N2
5 -C20 -M/opt/sybase/ASE-12_5/bin/sybmultbuf -SsisisSYBbackup
0 S sybase   28821 28820  0  75   0 - 18030 -      16:31 ?        00:00:00 /opt/
sybase/ASE-12_5/bin/dataserver -ssisisSYB -d/SunRiseDatabase/sybaseDatabase/mast
erDev -e/var/spool/sybase/sisisSYB.errorlog -c/opt/sybase/ASE-12_5/sisisSYB.cfg 
-M/opt/sybase/ASE-12_5

$ PATH=$SYBASE/OCS-12_5/bin:$PATH
$ export DSQUERY=sisisSYB LANG=de
$ isql -U sa -P
Msg 4017, Level 16, State 1:
Server 'sisisSYB':
Neither language name in login record 'german' nor language name in syslogins
'<NULL>' is an official language name on this SQL Server.  Using server-wide
default 'us_english' instead.
1> select @@version
2> go
 Adaptive Server Enterprise/12.5.4/EBF 13388/P/Linux Intel/Enterprise Linux/ase1
         254/2006/32-bit/OPT/Fri May 19 23:17:01 2006                            

Irgendwann wurde hier mal auch das folgende ausgegeben.

Msg 2401, Level 11, State 2:
Server 'sisisSYB':
Character set conversion is not available between client character set 'utf8'
and server character set 'iso_1'.
No conversions will be done.

Beim Bayerischen Landtag konnte innerhalb von PuTTY kein "@"-Zeichen angeben werden, da ansonsten gleich PuTTY versagte.

Set password for user "sa" (better than our 6 x):

1> sp_password null, xxxxxx
2> go
Password correctly set.
1> quit

Install german language support (optional):

$ $SYBASE/ASE-12_5/bin/langinstall -Pxxxxxx german iso_1
Loading datetime information from file /opt/sybase/locales/german/iso_1/common.loc.
Loading system messages from file /opt/sybase/locales/german/iso_1/server.loc.
7812 Messages processed.
Loading complete.
Summary: 0 deleted, 7410 inserted, 0 updated, 402 duplicates,   0 unsuccessful.

Vergrössern des Bereichs "tempdb" (typischerweise 1-2 GB auf Kundenrechnern).

$ isql -Usa -Pxxxxxx
1> disk init name="tempdev", physname="/SunRiseDatabase/sybaseDatabase/tempDev",
2> size="2g",
3> dsync=false
4> go
1> alter database tempdb on tempdev = 2048
2> go
Die Datenbank wird um 1048576 Seiten (2048,0 MByte) auf dem Plattenspeicher 
tempdev erweitert.
Warnung: Die Datenbank 'tempdb' benutzt ein unsicheres virtuelles Device
'tempdev'. Die Wiederherstellung dieser Datenbank kann nicht garantiert werden.
1> sp_addlogin sisis, sisis123
2> go
1> quit

Konfiguration des Sybase-Servers für SISIS-Sunrise

Es gibt einige Datenbankserver-weite Konfigurationsparameter welche für die eigenen Bedürfnisse angepasst werden müssen - die meisten "DEFAULT"-Werte sind dafür ungeeignet. Die folgenden Werte sind bloss Minimalwerte für eine Datenbank von etwa fünf SISIS-Sunrise-Benutzern.

Vor dem Ausführen muss die Datei "setparameters-SybaseASE-12.5.4.sh" angepasst werden.

• Passwort für Sybase-Benutzer "sa"
• Passende Parameter können allenfalls unter Zuhilfenahme der unter Sybase ASE 12.5.4 gesetzten Parameterwerte gefunden werden, welche in der Datei "/tmp/SybaseASE-12.5.4-Parameter.txt" gespeichert wurden.
• Üblicherweise anzupassen ist die "number of user connections".
• Der Parameter "max online engines" sollte auf die tatsächliche Anzahl Prozessoren (wie von "top" gesehen) minus 1 gesetzt werden - aber höchstens auf die Hälfte der vorhandenen Prozessoren (Standard ist "1"). Der Wert von "3" passt beispielsweise auf einen Rechner mit 6 Prozessoren. Derselbe Wert wird dann für den Parameter "number of engines at startup" eingetragen.

# cd /backup/software/AdminKuhn/Sybase/ASE-12.5.4
# chown sisis:sisis setparameters-SybaseASE-12.5.4.sh
# su sisis
$ vi setparameters-SybaseASE-12.5.4.sh
PASSWORD="xxxxxx"
ENGINES=1
$ ./setparameters-SybaseASE-12.5.4.sh
$ exit

Falls der Sybase-Server Leistungsprobleme hat, so sollte die Systemleistung gemessen und die Konfigurationswerte den Ergebnissen entsprechend angepasst werden.

Neustart von Sybase

Das benötigte Startskript "sybase" ist üblicherweise auf dem alten Rechner im Verzeichnis "/etc/init.d" zu finden.

Installation des Sybase-Startskripts im Verzeichnis "/etc/init.d".

# cp /backup/software/SybaseASE-12.5.4/sybase /etc/init.d
# chown root:root /etc/init.d/sybase && chmod 744 /etc/init.d/sybase

Falls der Sybase-Server unter SLES 10 läuft, so muss die Variable "LD_POINTER_GUARD" am Beginn des Startskripts eingefügt und exportiert werden.

# vi /etc/init.d/sybase
LD_POINTER_GUARD=1
export LD_POINTER_GUARD

Neustarten des Sybase-Servers um sicherzustellen, das allen ÄNderungen übernommen werden.

# /etc/init.d/sybase stop
# /etc/init.d/sybase start
kernel.shmmax = 486539264
Starting Sybase ASE ... RUN_sisisSYB RUN_sisisSYBbackup 
# tail -f /var/spool/sybase/sisisSYB.errorlog

You should compare the boot time of the ASE with and without async i/o.

Überprüfen der Sybase-Server

Es muss sichergestellt werden, dass beide Sybase-Server (sisisSYB, sisisSYBbackup) und alle konfigurierten "online engines" laufen.

# su - sybase
$ export LANG=de \
         SYBASE=/opt/sybase \
         SYBASE_ASE=ASE-12_5
$ $SYBASE/ASE-12_5/install/showserver
F S UID        PID  PPID  C PRI  NI ADDR SZ WCHAN  STIME TTY          TIME CMD
0 S sybase   29066 29057  0  75   0 - 43067 -      17:08 ?        00:00:00 /opt/
sybase/ASE-12_5/bin/dataserver -ONLINE:1,0,0xea02ca58, 0xeeaf1000, 0x9204000, 0x
1159
0 S sybase   29062 29061  0  84   0 -  2264 -      17:08 pts/1    00:00:00 /opt/
sybase/ASE-12_5/bin/backupserver -e/var/spool/sybase/sisisSYBbackup.errorlog -N2
5 -C20 -M/opt/sybase/ASE-12_5/bin/sybmultbuf -SsisisSYBbackup
0 S sybase   29057 29056  0  75   0 - 45210 -      17:08 ?        00:00:00 /opt/
sybase/ASE-12_5/bin/dataserver -d/SunRiseDatabase/sybaseDatabase/masterDev -e/va
r/spool/sybase/sisisSYB.errorlog -c/opt/sybase/ASE-12_5/sisisSYB.cfg -M/opt/syba
se/ASE-12_5 -ssisisSYB

Anzeigen aller Sybase-Server.

$ $SYBASE/OCS-12_5/bin/isql -Usa -Pxxxxxx -SsisisSYB
1> sp_helpserver
2> go
1> quit

Hinweise

IP-address of the server and port number as found in the file "$SYBASE/interfaces":

sisisSYB
        master tcp ether machine-name 4000
        query tcp ether machine-name 4000

sisisSYBbackup
        master tcp ether machine-name 4001
        query tcp ether machine-name 4001