Difference between revisions of "Installation guidelines ASE 15.0"

From SybaseWiki
Jump to: navigation, search
Line 1: Line 1:
Content contributed by Luc Nieland (http://www.solstice.nl)
 
 
 
'''** TEMPORARILY UNDER REVIEW **'''
 
'''** TEMPORARILY UNDER REVIEW **'''
 +
 +
This page describes how to install and configure a Sybase ASE server.
  
 
===Get the software===
 
===Get the software===
Line 11: Line 11:
  
 
===Prepare the Operating System===
 
===Prepare the Operating System===
Make sure that the filesystem for the Sybase software is big enough. A full installation needs approx. 800 Mb so 3 Gb should give you enough room to handle upgrades too. The location to store the software is /opt/sybase/ase15.
+
Make sure that the filesystem for the Sybase software is big enough. A full installation needs approx. 800 Mb so 3 Gb should give you enough room to handle upgrades too. In this case we install the software in /opt/sybase/ase15. Database files will be stored on raw devices and/or in /var/sybase.
  
Become root and add a group "sybase" and a user "sybase" to the system.
+
Become root and add a group "sybase" and a user "sybase" to the system. Also create the needed directories.
  mkdir /opt/sybase
+
  mkdir -p /opt/sybase
 +
mkdir -p /var/sybase
 
  groupadd sybase
 
  groupadd sybase
 
  useradd -g sybase -d /opt/sybase sybase
 
  useradd -g sybase -d /opt/sybase sybase
  chown sybase:sybase sybase
+
  chown sybase:sybase /opt/sybase
 +
chown sybase:sybase /var/sybase
  
 
Enable the operating system to allow more than the default 500M for a single shared memory segment.
 
Enable the operating system to allow more than the default 500M for a single shared memory segment.
Line 26: Line 28:
 
*Linux /etc/sysctl (this is for Debian/Ubuntu, use a dot instead of the / in Redhat)
 
*Linux /etc/sysctl (this is for Debian/Ubuntu, use a dot instead of the / in Redhat)
 
  kernel/shmmax=33554432000
 
  kernel/shmmax=33554432000
 
Make directories, operatingsystem group and user:
 
mkdir    -p /var/sybase
 
chown    sybase:sybase /var/sybase
 
  
 
Create at least 5 raw-devices for master (200M), sybprocs(200M), sybsystemdb(200M), data01(32G) and log01(2G). Raw devices are never slower than cooked-devices. Also chown the raw-devs.
 
Create at least 5 raw-devices for master (200M), sybprocs(200M), sybsystemdb(200M), data01(32G) and log01(2G). Raw devices are never slower than cooked-devices. Also chown the raw-devs.
Line 42: Line 40:
  
 
===Determine your license policy===
 
===Determine your license policy===
Since ASE 15 you cannot run a production server with no license file. License file can reside on the network or on the local system. Think about the license policy that suits you best.
+
Since ASE 15 you cannot run a production server with no license file. License files can reside on the network or on the local system. Think about the license policy that suits you best.
  
When there is no valid license after the installation ASE will run under a grace time of 30 days. After that it will shutdown.
+
When there is no valid license after the installation ASE will run with a grace time of 30 days. After that it will shutdown and it cannot be rebooted anymore until you install a license.
  
 
===Installation===
 
===Installation===
Line 52: Line 50:
 
  <put the software in this directory>
 
  <put the software in this directory>
 
  tar -xf <software-distro>
 
  tar -xf <software-distro>
 +
 +
Start the installation.
 +
 
  ./setup -console
 
  ./setup -console
  
Line 60: Line 61:
 
At the possible options of the Product Edition choose the one that suits your situation. After installation you can reconfigure it, in case you picked the wrong option.
 
At the possible options of the Product Edition choose the one that suits your situation. After installation you can reconfigure it, in case you picked the wrong option.
  
At the list of possible servers to configure, deselect option 1 and 8. We will do it manually.
+
At the list of possible servers to configure, deselect all options. We will do it manually.
  
 
When the installation has finished succesful you can safely remove the work directory.
 
When the installation has finished succesful you can safely remove the work directory.
 +
===Setup your environment===
 +
In /opt/sybase/ase15 you will find a few files, like SYBASE.csh, SYBASE.sh and SYBASE.env. Depending on the type of shell you use you need to source in one of these. For instance, when your default shell is bash you should do this:
 +
 +
. /opt/sybase/ase15/SYBASE.sh
  
 +
By doing:
  
===Application Part===
+
  echo $SYBASE
create the resource file /opt/sybase/syb01/ase1500.rs
+
  SYBASE=/opt/sybase/syb01/ase1500
+
#
+
SYBROOT=${SYBASE}
+
SYBASE_ASE=ASE-15_0
+
SYBASE_OCS=OCS-15_0
+
INCLUDE=${SYBASE}/${SYBASE_OCS}/include:$INCLUDE
+
LIB=${SYBASE}/${SYBASE_OCS}/lib:$LIB
+
SYBASE_JRE=${SYBASE}/shared/jre142
+
SYBASE_SYSAM=SYSAM-2_0
+
SYBASE_UA=${SYBASE}/ua
+
SCROOT=${SYBASE}/shared/sybcentral43
+
SYBASE_WS=WS-15_0
+
export SYBASE SYBROOT SYBASE_ASE SYBASE_OCS INCLUDE LIB SYBASE_JRE SYBASE_SYSAM SYBASE_UA SCROOT SYBASE_WS
+
#
+
PATH=${SYBASE}/ua/bin:${PATH}
+
PATH=${SYBASE}/${SYBASE_ASE}/jobscheduler/bin:${PATH}
+
PATH=${SYBASE}/${SYBASE_ASE}/bin:${SYBASE}/${SYBASE_OCS}/bin:${SYBASE}/RPL-15_0/bin:${PATH}
+
export PATH
+
#
+
LD_LIBRARY_PATH=${SYBASE}/${SYBASE_ASE}/lib:${SYBASE}/{SYBASE_OCS}/lib:${SYBASE}/{SYBASE_OCS}/lib3p:${LD_LIBRARY_PATH}
+
LD_LIBRARY_PATH=${SYBASE}/DataAccess/ODBC/lib:${LD_LIBRARY_PATH}
+
export LD_LIBRARY_PATH
+
  
 +
it should return /opt/sybase/ase15.
 +
Is is fairly common to activite the SYBASE.sh script (or similar one) from your login script.
  
. ase1500.rs
+
===Create the server===
  
 
  cd $HOME
 
  cd $HOME

Revision as of 18:51, 30 May 2007

** TEMPORARILY UNDER REVIEW **

This page describes how to install and configure a Sybase ASE server.

Get the software

First download ASE.

For a licensed version you need to go here: http://sybase.subscribenet.com or to the eShop at sybase.com: http://eshop.sybase.com/eshop/buy?id=19517

To get a free download you can find several places here: http://www.sypron.nl/get_ase_soft.html

Prepare the Operating System

Make sure that the filesystem for the Sybase software is big enough. A full installation needs approx. 800 Mb so 3 Gb should give you enough room to handle upgrades too. In this case we install the software in /opt/sybase/ase15. Database files will be stored on raw devices and/or in /var/sybase.

Become root and add a group "sybase" and a user "sybase" to the system. Also create the needed directories.

mkdir -p /opt/sybase
mkdir -p /var/sybase
groupadd sybase
useradd -g sybase -d /opt/sybase sybase
chown sybase:sybase /opt/sybase
chown sybase:sybase /var/sybase

Enable the operating system to allow more than the default 500M for a single shared memory segment.

  • Solaris /etc/system
set shmsys:shminfo_shmmax = 4294967295
  • Linux /etc/sysctl (this is for Debian/Ubuntu, use a dot instead of the / in Redhat)
kernel/shmmax=33554432000

Create at least 5 raw-devices for master (200M), sybprocs(200M), sybsystemdb(200M), data01(32G) and log01(2G). Raw devices are never slower than cooked-devices. Also chown the raw-devs.

When you using filesystems, solaris 9 or newer and sybase 12.x , use the forecedirectio option tot mount the filesystem. Because this option is for the whole filesystemen, do not use this filesystem for other files than sybase datadevices.

An /etc/vfstab example:

/dev/md/dsk/d33  /dev/md/rdsk/d33   /var/sybase   ufs  2  yes    forcedirectio

Now, switch to the newly created user:

su - sybase

Determine your license policy

Since ASE 15 you cannot run a production server with no license file. License files can reside on the network or on the local system. Think about the license policy that suits you best.

When there is no valid license after the installation ASE will run with a grace time of 30 days. After that it will shutdown and it cannot be rebooted anymore until you install a license.

Installation

You should now be in the directory /opt/sybase. Make a work directory and put the downloaded Sybase software in it.

mkdir work
cd work
<put the software in this directory>
tar -xf <software-distro>

Start the installation.

./setup -console

Use /opt/sybase/ase15 as the destination directory. Assuming you store Sybase licenses on your local system, answer No at "Will licenses be obtained from the License Server?". Also, at "Do you want to configure email alerts?" answer No.

At the possible options of the Product Edition choose the one that suits your situation. After installation you can reconfigure it, in case you picked the wrong option.

At the list of possible servers to configure, deselect all options. We will do it manually.

When the installation has finished succesful you can safely remove the work directory.

Setup your environment

In /opt/sybase/ase15 you will find a few files, like SYBASE.csh, SYBASE.sh and SYBASE.env. Depending on the type of shell you use you need to source in one of these. For instance, when your default shell is bash you should do this:

. /opt/sybase/ase15/SYBASE.sh

By doing:

echo $SYBASE

it should return /opt/sybase/ase15. Is is fairly common to activite the SYBASE.sh script (or similar one) from your login script.

Create the server

cd $HOME
mkdir admin
mkdir MYINSTANCE01

Make some raw-devices, and make symbolic-links to them.

Make a resource file srvbuild-myase.rs to create the ASE:

sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: LUCSY05P
sqlsrv.new_config: yes
sqlsrv.do_add_server: no
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: avondster
sqlsrv.network_port_list: 8001
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.force_buildmaster: no
sqlsrv.master_device_physical_name: /opt/sybase/data/LUCSY05P/master.dat
sqlsrv.master_device_size: 200
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: /opt/sybase/data/LUCSY05P/sybprocs.dat
sqlsrv.sybsystemprocs_device_size: 200
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: /opt/sybase/data/LUCSY05P/sybsystemdb.dat
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: SYB_BACKUP

Build the Instance with the command:

srvbuildres -r srvbuild-myase.rs

Make a resource file sqlloc-myase.rs to the configure the charset-sortorder of the new ASE:

sybinit.release_directory: USE_DEFAULT
sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
sqlsrv.sa_login: sa
sqlsrv.sa_password: 
sqlsrv.default_language: french
sqlsrv.language_install_list: spanish,german
sqlsrv.language_remove_list: USE_DEFAULT
sqlsrv.default_characterset: cp437
sqlsrv.characterset_install_list: mac,cp850
sqlsrv.characterset_remove_list: USE_DEFAULT
sqlsrv.sort_order: dictionary

Now, re-configure the characterset and sortorder of the ASE:

sqllocres -r sqlloc-myase.rs

Configure tempdb as needed. See here http://www.petersap.nl/SybaseWiki/index.php/Tempdb_space_management how to do this.


Memory and cache tuning (in the sybase ASE) example:

sp_configure 'max memory','15000M'
  sp_cacheconfig 'default data cache','7000M',strict
    sp_poolconfig 'default data cache','5000M','2K'
    sp_poolconfig 'default data cache','2K','wash=200M'
    sp_poolconfig 'default data cache','2000M','16K'
    sp_poolconfig 'default data cache','16K','wash=200M'
 sp_cacheconfig 'tempdb_cache','1500M',mixed,strict
   sp_poolconfig 'tempdb_cache','7500M','2K'
   sp_poolconfig 'tempdb_cache','2K','wash=200M'
   sp_poolconfig 'tempdb_cache','7500M','16K'
   sp_poolconfig 'tempdb_cache','16K','wash=200M'
     sp_bindcache tempdb_cache,tempdb
     -- check with:  sp_helpdb tempdb
 sp_cacheconfig 'my_syslogs_cache','750M',logonly,strict
   sp_poolconfig 'my_syslogs_cache','750M','2K'
   sp_poolconfig 'my_syslogs_cache','2K','wash=200M'
     sp_bindcache my_syslogs_cache,syslogs (for all user databases, use <userdatabase>)
     -- check with:   sp_help syslogs (within the userdatabase)
sp_configure 'procedure cache size',208160

Some other re-config's:

sp_configure 'number of user connections',1000
sp_configure 'number of locks',20000
sp_configure 'number of open databases',30


  • create the dbcc databases