Installation guidelines ASE 15.0

From SybaseWiki
Revision as of 20:18, 27 May 2007 by Psap (Talk | contribs) (Prepare the Operating System)

Jump to: navigation, search

Content contributed by Luc Nieland (http://www.solstice.nl)

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. 1.4 Gb so 3 Gb should give you enough room to handle upgrades too. The location to store the software is /opt/sybase.

Become root and add a group "sybase" and a user "sybase" to the system.

mkdir /opt/sybase
groupadd sybase
useradd -g sybase -d /opt/sybase sybase
chown sybase:sybase 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

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.

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 generated user:

su - sybase

Application part:

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


. ase1500.rs
mkdir ase1500 tmp
cd tmp
gzip -d ase-15.0.0-ebf13194_linux-x86-32_official-release_express-ed.tgz
tar xvf ase-15.0.0-ebf13194_linux-x86-32_official-release_express-ed.tar
./setup -console

At some point it should display:

...
Sybase Adaptive Server Enterprise will be installed in the following location:
/opt/sybase/ase1500
with the following features:
 Sybase Servers
   Adaptive Server Enterprise
      ASE Agent Plugin
   Replicator
   ASE Web Services
   Job Scheduler
Connectivity
   Open Client
      Common ctlib files
      Common dblib files
   Embedded SQL/C
   Monitor Client Library
   Common Connectivity Components
ASE Data Providers

At the end choose to "not" to configure 8 possible server options. We do this by hand with reproducible resource files.


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