Revision as of 20:08, 4 June 2006

ASE

Operating system part

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

Application part:

create a ase1500.rs file

SYBASE=/opt/sybase/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=/opt/sybase/ASE-15_0/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 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.rs

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.rs

• make a temp01.dat device
• enlarge database tempdb
• raise total memory
• enlarge the default datacache
• make a named cache for log
• raise number of locks
• create the dbcc databases