HOME

Install SYBASE ASE Server
This page describes 'how to install SYBASE ASE server from command line?'
SYBASE server is installed using command srvbuildres.
It requires only a resource file which contains information about the ASE server to be created.
ie # srvbuildres
This program requires a resource file for its input.
Usage: srvbuildres -r resource_file

Find a model resource file

# cat dbserver.rs
srvbuild.release_directory: /usr/sybase
srvbuild.product: sqlsrv
srvbuild.server_name: DBSERVER
srvbuild.new_config: yes
srvbuild.do_add_server: yes
srvbuild.do_upgrade: no
srvbuild.network_protocol_list: tcp
srvbuild.network_hostname_list: UNIXSERVER
srvbuild.network_port_list: 5200
srvbuild.master_device_physical_name: /dev/dbserver_master
srvbuild.master_device_size: 200
srvbuild.master_database_size: 100
srvbuild.errorlog: /usr/sybase/ASE-12_5/install/DBSERVER.log
srvbuild.sybsystemprocs_device_physical_name: /dev/dbserver_sybsysp
srvbuild.sybsystemprocs_device_size: 200
srvbuild.sybsystemprocs_database_size: 150
srvbuild.sybsystemdb_device_physical_name: /dev/dbserver_sybsys
srvbuild.sybsystemdb_device_size: 200
srvbuild.sybsystemdb_database_size: 100
srvbuild.default_backup_server: DBSERVER_back

#srvbuildres -r dbserver.rs

Install SYBASE Backup Server
Find a model resource file to create backup server

# cat dbserver_back.rs
srvbuild.release_directory: /usr/sybase
srvbuild.product: bsrv
srvbuild.server_name: DBSERVER_back
srvbuild.do_add_backup_server: yes
srvbuild.new_config: yes
srvbuild.do_upgrade: no
srvbuild.network_protocol_list: tcp
srvbuild.network_hostname_list: UNIXSERVER
srvbuild.network_port_list: 5201
srvbuild.language: USE_DEFAULT
srvbuild.character_set: USE_DEFAULT
srvbuild.tape_config_file: USE_DEFAULT
srvbuild.errorlog: /usr/sybase/ASE-12_5/install/DBSERVER_back.log

#srvbuildres -r dbserver_back.rs

Some ASE setup/useful commands
Say suppose you want to create a database 'db_abc' with data size 1GB and log size 512MB
1. Create physical device/raw device in unix machine. Use smitty tool if the server is IBM/AIX
2. Map the created devices to sybase logical devices

isql -Usa -SDBSERVER -Ppassword
disk init name = 'data_dev1_abcdb', physname='/dev/rdata_dev1_abcdb', size = 524288
The above value 524288 = 1024 * 512 ie (Size of device) * ( Block Size)
disk init name = 'log_dev1_abcdb', physname='/dev/rlog_dev1_abcdb', size = 262144

create database db_abc on data_dev1_abcdb = 1024 log on log_dev1_abcdb = 512

Other Commands sp_addlogin 'db_user', 'user_pwd', 'db_abc'
sp_role 'grant', 'dtm_tm_role', db_user

Adding user as database owner
sp_adduser db_user, 'dbo', 'user_group'

syntax: sp_addsegment segname, dbname, devname
sp_addsegment ncsdata_seg1, 'tcsdev1', 'ncs2_dev1_db1'

HOME