Installation guidelines ASE 15.0

From SybaseWiki
Revision as of 10:34, 9 October 2006 by Luc (Talk | contribs) (Operating system part)

Jump to: navigation, search

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

Operating system part

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/Ubunt, use a dot instead of the / in Redhat)
kernel/shmmax=33554432000

Make operatingsystem group and user:

[root@server]# groupadd -g 9999 syb01
[root@server]# useradd -g 9999 -u 9999 -d /opt/sybase/syb01 syb01
[root@server]# mkdir /opt/sybase
[root@server]# mkdir /opt/sybase/syb01
[root@server]# mkdir /var/sybase
[root@server]# mkdir /var/sybase/syb01
[root@server]# chown sybase01:syb01 /opt/sybase/syb01 /var/sybase/syb01

Also create the raw-devices (never slower than cooked-devices). Also chown these.

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 - syb01

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
  • make a temp01.dat device
  • enlarge database tempdb


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