Custom Search : Technical Guides Sybase Oracle UNIX Javascript

Technical Guides

Of Interest

Business Intelligence and Analytics

Oracle Training

Sybase » Administration » DBA » Install

Sybase ASE: Installing a new server via srvbuildres utility


Back in the day, Sybase used an install program called sybinit which worked really well .. then, the next generation Java-based installers happened; they are really sweet to look at, but are not efficient/intuitive nor easy to get running (requires X window system with Java which is now an Oracle product!). Those of us preferring simple terminal-based installers can leverage srvbuildres, which accepts a resource file name as a parameter. Here's a sample shell script which calls srvbuildres.
 #  Script needs 1 parameter:  resource_filename
 . /opt/sybase/product/15.0.3/
 sleep 2
 srvbuildres -s $SYBASE -I /opt/sybase/interfaces -r $rfile  | tee $lfile
Here's a sample resource file. a) Be sure that the host (MONTANA in this example) is ping-able. b) If using raw devices, check: /dev/rawctl, /etc/sysconfig/rawdevices, /etc/udev/rules.d/60-raw.rules
 sybinit.release_directory: USE_DEFAULT
 sybinit.product: sqlsrv
 sqlsrv.server_page_size 8K
 sqlsrv.server_name: HAMILTON
 sqlsrv.new_config: yes
 sqlsrv.do_add_server: yes
 sqlsrv.network_protocol_list: tcp
 sqlsrv.network_hostname_list: MONTANA
 sqlsrv.network_port_list: 4154
 sqlsrv.application_type: USE_DEFAULT
 sqlsrv.server_page_size: 8192
 sqlsrv.force_buildmaster: yes
 sqlsrv.master_device_physical_name: /sybase/dev/raw/HAMILTON_mst_1g_001
 sqlsrv.master_device_size: 1024
 sqlsrv.master_database_size: 128
 sqlsrv.errorlog: USE_DEFAULT
 sqlsrv.do_upgrade: no
 sqlsrv.sybsystemprocs_device_physical_name: /sybase/dev/raw/HAMILTON_ssp_1g_001
 sqlsrv.sybsystemprocs_device_size: 1024
 sqlsrv.sybsystemprocs_database_size: 512
 sqlsrv.sybsystemdb_device_physical_name: /sybase/dev/raw/HAMILTON_ssd_1g_001
 sqlsrv.sybsystemdb_device_size: 1024
 sqlsrv.sybsystemdb_database_size: 128
 #sqlsrv.tempdb_device_physical_name: /sybase/dev/raw/HAMILTON_tmp_4g_001
 #sqlsrv.tempdb_device_size: 4096
 #sqlsrv.tempdb_database_size: 2048
 sqlsrv.default_backup_server: HAMILTON_backup
 sqlsrv.do_configure_pci: no
 sqlsrv.sybpcidb_device_physical_name: PUT_THE_PATH_OF_YOUR_SYBPCIDB_DATA_DEVICE_HERE
 sqlsrv.sybpcidb_device_size: USE_DEFAULT
 sqlsrv.sybpcidb_database_size: USE_DEFAULT
 sqlsrv.do_optimize_config: no
 sqlsrv.avail_physical_memory: USE_DEFAULT
 sqlsrv.avail_cpu_num: USE_DEFAULT
When executed using srvbuildres, the resulting ASE server will be ready for further configuration. Note that the default (binary) sort order will be configured; it you want to change the sort order, you'll need to run (for example,)
 charset -Usa -Pmontana -S HAMILTON iso_1
 charset -Usa -Pmontana -S HAMILTON iso_1
 charset -Usa -Pmontana -S HAMILTON iso_1
and then .. in isql
 sp_configure 'default sortorder id',51,'iso_1'
 -- or
 sp_configure 'default sortorder id',53,'iso_1'
 -- or
 sp_configure 'default sortorder id',54,'iso_1'
Next, backup server needs to be built, using srvbuildres .. here's a sample resource file.
 srvbuild.release_directory: /opt/sybase/product/15.0.3
 srvbuild.product: bsrv
 srvbuild.server_name: HAMILTON_back
 srvbuild.new_config: yes
 srvbuild.do_add_backup_server: yes
 srvbuild.do_upgrade: no
 srvbuild.network_protocol_list: tcp
 srvbuild.network_hostname_list: MONTANA
 srvbuild.network_port_list: 3262
 srvbuild.language: USE_DEFAULT
 srvbuild.character_set: USE_DEFAULT
 srvbuild.tape_config_file: USE_DEFAULT
 srvbuild.errorlog: /opt/sybase/product/15.0.3/ASE-15_0/install/HAMILTON_back.log
Next steps .. Setting the sort order Build a second resource file, with the desired sort order .. here's a sample resource file.
 sybinit.release_directory: USE_DEFAULT
 sqlsrv.server_name: KANSAS
 sqlsrv.sa_login: sa
 sqlsrv.sa_password: chiefs123
 sqlsrv.default_language: english
 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
 sqlsrv.sort_order: nocase
 sqlsrv.sort_order: altnoacc
 -- Then run this command
 sqllocres -r
Next steps ..
  • Set device # max (e.g. 32), then create devices
  • Alter tempdb, should be 20% of full data/db size
  • Create user-defined tempdbs
  • BCP in syslogins, to tempdb, if migrating from another server. Then insert into master..syslogins as needed.
  • Create Databases, and set DB options
  • Create Roles
  • Load databases (if migrating)
  • Bind applications / logins to tempdb's .. use: sp_tempdb 'show'
  • Set Max Memory
  • Create cache's
  • Bind tempdb's to cache's
  • .. see other config/post installation steps on this site

Sybase : Related Topics

Sybase : Administration : Post-installation check
Sybase : Administration : Device initialization
Sybase : Administration : Database Creation
Sybase : Administration : A backup routine
Sybase : Administration : Striping Dump Devices
Sybase : Administration : Moving the transaction log to another device
Sybase : Administration : Adding a segment to a database
Sybase : Administration : Configuring the cache
Sybase : Administration : Apply multiple transaction dumps
Sybase : Administration : Database maintenance procedure
Sybase : Administration : Database maintenance script
Sybase : Administration : Server configuration
Sybase : Administration : Dealing with a Corrupted Database
Sybase : Administration : Dealing with a Server Failure
Sybase : Administration : DBCC Notes
Sybase : Administration : Create proxy tables and external logins
Sybase : Administration : Renaming a database
Sybase : Administration : Reorg: rebuilding a table
Sybase : Administration : Sybase ASE 15 Enhancements
Sybase : Administration : Setting the thresholds
Sybase : Administration : Apply a transaction dump
Sybase : Administration : Security Tasks
Sybase : Administration : Setting Process Priorities
Sybase : Administration : Sybase ASE Architecture Overview
Sybase : Administration : Drop an alias, with objects linked to login
Sybase : Administration : Display grants, effective rights to objects
Sybase : Administration : Displaying access information from sysprotects
Sybase : Administration : Database Engines: Status and Settings
Sybase : Administration : Replication Server 15 Configuration
Sybase : Administration : Loading data into Sybase IQ from a Remote Server
Sybase : Administration : Sybase IQ Overview
Sybase : Administration : Sybase IQ Functions
Sybase : Administration : Sybase IQ - Remote Access From ASE
Sybase : Administration : Sybase IQ : Procedure Profiling / Monitoring
Sybase : Administration : Sybase IQ: Restoring a Database from Dump Files
Sybase : Administration : Sybase IQ: Minimize Storage option
Sybase : Administration : Sybase IQ: Index Types
Sybase : Administration : Sybase IQ: HUGEPAGE Support
Sybase : Administration : Sybase IQ: Database Creation (Raw Devices)
Sybase : Administration : Sybase IQ : Repairing Problems / Troubleshooting Corruption
Sybase : Administration : Sybase IQ : Moving / Re-allocating / Re-org
Sybase : Administration : Sybase IQ: Sysmon / System Performance Analysis
Sybase : Administration : Sybase IQ: Monitoring Connections / Processes
Sybase : Administration : Sybase IQ: Copying users/logins between databases
Sybase : Administration : Sybase IQ: Managing User Accounts
Sybase : Administration : Sybase ASE: Database Schema Compare
Sybase : Administration : Sybase IQ: Listing tables, ordered by size allocated
Sybase : Administration : Sybase IQ : Comparing grants / permissions between servers
Sybase : Administration : Sybase ASE: Database page size
Sybase : Administration : Sybase ASE: Managing users and roles
Sybase : Administration : Sybase ASE: Setting resource limits for users
Sybase : Administration : Sybase ASE: Setting up user assigned custom tempdbs
Sybase : Administration : Sybase ASE: Setting up the transaction log cache using logiosize
Sybase : Administration : Sybase IQ: Server Startup Switches
Sybase : Administration : Sybase ASE: Managing Identity Columns
Sybase : Administration : Sybase IQ: Working with options and server settings
Sybase : Administration : Sybase IQ: Monitoring and Troubleshooting via System Procedures

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site

Get the latest Rocket99 news and tech tips via

Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site

Copyright © 2016 Stoltenbar Inc All Rights Reserved.