Sybase ASE Installation From Resource File

Sybase ASE Installation From Resource Files

1. Go To Software Product Download Center and Download appropriate Product
2. Generate License (no of engines,hostID,served(req license server) or unserved etc)
3. Talk to SA and ensure that all OS patches are up-to-date and NW drivers, SAN drivers etc are up to date.
4. Create an account Sybase and give it permissions on $SYBASE DIR as well as all raw devices and filesystem devices
5. Specify the license type
6. Have SA adjust OS Shared memory param for Sybase (UNIX /etc/projects; LINUX sysctl kernal.shmmax)
7. Work with SA and have RAW devices created for all databases except tempdb. For tempdb have filesystem device created. Ensure that Sybase is set to be owner of these devices. Its quite handy to create Links to Raw devices (ln -s /dev/hda4  /var/sybase/ASE1/master.dat)
8. Ask SA to install Sybase ASE Software
9. Copy resourcefile from $SYBASE/$SYBASE_ASE/init (srvbuilders -r <resourcefilename>). Following imp params

sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: ASE1
sqlsrv.network_hostname_list: <your hostname>
sqlsrv.network_port_list: 4000
sqlsrv.server_page_size: USE_DEFAULT
sqlsrv.master_device_physical_name: /var/sybase/ASE1/master.dev
sqlsrv.master_device_size: 100
sqlsrv.master_database_size: 60
sqlsrv.errorlog: /opt/sybase/admin/ASE1/errorlog
sqlsrv.sybsystemprocs_device_physical_name: /var/sybase/ASE1/sybsystemprocs.dev
sqlsrv.sybsystemprocs_device_size: 200
sqlsrv.sybsystemprocs_database_size: 200
sqlsrv.sybsystemdb_device_physical_name: /var/sybase/ASE1/sybsystemdb.dev
sqlsrv.sybsystemdb_device_size: 20
sqlsrv.sybsystemdb_database_size: 20
sqlsrv.tempdb_device_physical_name: /var/sybase/ASE1/tempdb.dev
sqlsrv.tempdb_device_size: 100
sqlsrv.tempdb_database_size: 100M
sqlsrv.default_backup_server: SYB_BACKUP

10 .The instmsgs.ebf file contains the latest update for Sybase error messages.isql -i $SYBASE/$SYBASE_ASE/scripts/instmsgs.ebf

11. Create backup serverver svrbuilders -r<backup Server RS>

12. Modify RUN_SYB_BACKUP as follows

          Change location of logfile with -e flag

13. Go ahead and create user databases

Ardent DBA