Resource File Examples

Specific rows are modified by the restore utility when creating or editing resource files.

Rows that are modified are shown in bold.

Resource file for the SAP ASE server on Windows platform
#
# --- This file was generated by Sybase Installer ---
#
sybinit.boot_directory:              C:\Sybase.carina
sybinit.release_directory:           C:\Sybase.carina
sqlsrv.do_add_server:                yes
sqlsrv.network_hostname_list:        OAKN00531664A
sqlsrv.network_port_list:            5000
sqlsrv.network_protocol_list:        tcp
sqlsrv.notes:
sqlsrv.connect_retry_delay_time:     5
sqlsrv.connect_retry_count:          5
sqlsrv.new_config:                   yes
#
sqlsrv.server_name:                  OAKN00531664A
sqlsrv.sa_password:                  Sybase4me
sqlsrv.sa_login:                     sa
sqlsrv.application_type:             MIXED
sqlsrv.server_page_size:             4k
#
# --- Set up master ----
#
sqlsrv.master_device_physical_name: C:\Sybase.carina\data\master.dat
sqlsrv.master_device_size:           73
sqlsrv.master_db_size:               26
sqlsrv.disk_mirror_name:
#
# --- Set up sybsystemprocs ----
#
sqlsrv.do_create_sybsystemprocs_device:         yes
sqlsrv.sybsystemprocs_device_physical_name:  
            C:\Sybase.carina\data\sysprocs.dat
sqlsrv.sybsystemprocs_device_size:              172
sqlsrv.sybsystemprocs_db_size:                  172
sqlsrv.sybsystemprocs_device_logical_name:      sysprocsdev
#
# --- Set up sybsystemdb ----
#
sqlsrv.do_create_sybsystemdb:                   yes
sqlsrv.do_create_sybsystemdb_db_device:         yes
sqlsrv.sybsystemdb_db_device_physical_name:  
            C:\Sybase.carina\data\sybsysdb.dat
sqlsrv.sybsystemdb_db_device_physical_size:     6
sqlsrv.sybsystemdb_db_size:	                 6
sqlsrv.sybsystemdb_db_device_logical_name:      systemdbdev
sqlsrv.tempdb_device_physical_name:  
            C:\Sybase.carina\data\tempdbdev.dat
sqlsrv.tempdb_device_size:	                  100
sqlsrv.tempdb_database_size:	                100
#
sqlsrv.errorlog:  
            C:\Sybase.carina\ASE-15_0\install\OAKN00531664A.log
sqlsrv.sort_order:                              bin_cp850
sqlsrv.default_characterset:                    cp850
sqlsrv.default_language:                        us_english
#
sqlsrv.preupgrade_succeeded:                    no
sqlsrv.network_name_alias_list:
sqlsrv.resword_conflict:                        0
sqlsrv.resword_done:                            no
sqlsrv.do_upgrade:                              no
sqlsrv.characterset_install_list:               cp850
sqlsrv.characterset_remove_list:
sqlsrv.language_install_list:                   us_english
sqlsrv.language_remove_list:
sqlsrv.shared_memory_directory:
sqlsrv.addl_cmdline_parameters:				
sqlsrv.eventlog:                                yes
sqlsrv.atr_name_shutdown_required:              yes
sqlsrv.atr_name_qinstall:                       no
#
sqlsrv.do_change_ase_service_account:           no
sqlsrv.ase_service_account_name:			
sqlsrv.ase_service_account_password:			
#
sybinit.charset:                                cp850
sybinit.language:                               us_english
sybinit.resource_file:
sybinit.log_file:
sybinit.product:                                sqlsrv
#
sqlsrv.default_backup_server:                   OAKN00531664A_BS
#
sqlsrv.xpserver_network_protocol_list:          tcp
sqlsrv.xpserver_network_hostname_list:          OAKN00531664A
sqlsrv.xpserver_network_port_list:              5002
#
sqlsrv.do_change_xp_service_account:            no
sqlsrv.xp_service_account_name:				
sqlsrv.xp_service_account_password:			
#
sqlsrv.do_configure_pci:                        yes
sqlsrv.sybpcidb_device_physical_name:  
            C:\Sybase.carina\data\sybpcidbdev_data.dat
sqlsrv.sybpcidb_device_size:	                48
sqlsrv.sybpcidb_database_size:                  48
#
sqlsrv.do_optimize_config:                      yes
sqlsrv.avail_physical_memory:                   2816
sqlsrv.avail_cpu_num:                           3
Resource file for Backup server on Windows platform
#
# --- This is a "sybatch.exe" sample resource file. ---
#
# This sample resource file will configure a new
# Backup Server "SYBASE_BS".
# 
sybinit.boot_directory:          C:\Sybase.carina
sybinit.release_directory:       C:\Sybase.carina
sybinit.product:                 bsrv
sqlsrv.server_name:              OAKN00531664A
sqlsrv.sa_login:                 sa
sqlsrv.sa_password:              Sybase4me
bsrv.do_add_backup_server:       yes
bsrv.server_name:                OAKN00531664A_BS
bsrv.errorlog: 
           C:\Sybase.carina\ASE-15_0\install\OAKN00531664A_BS.log
bsrv.network_port_list:          5001
bsrv.network_hostname_list:      OAKN00531664A
bsrv.network_protocol_list:      tcp
bsrv.character_set:              cp850
bsrv.language:                   us_english
bsrv.network_name_alias_list:
bsrv.notes:
bsrv.connect_retry_delay_time:   5
bsrv.connect_retry_count:        5
bsrv.addl_cmdline_parameters:
Resource file for the SAP ASE server on UNIX/Linux:
sybinit.release_directory:            USE_DEFAULT
sybinit.product:                      sqlsrv
sqlsrv.server_name:                   qpamd7srv
sqlsrv.sa_password:                   dbasql
sqlsrv.new_config:                    yes
sqlsrv.do_add_server:                 yes
sqlsrv.network_protocol_list:         tcp
sqlsrv.network_hostname_list:         qpamd7
sqlsrv.network_port_list:             6008
sqlsrv.application_type:              MIXED
sqlsrv.server_page_size:              4K
sqlsrv.force_buildmaster:             no
sqlsrv.master_device_physical_name: 
           /qpamd7_eng2/hlam/ase157esd3/data/master.dat
sqlsrv.master_device_size:            60M
sqlsrv.master_database_size:          26M
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name: 
           /qpamd7_eng2/hlam/ase157esd3/data/sysprocs.dat
sqlsrv.sybsystemprocs_device_size:    USE_DEFAULT
sqlsrv.sybsystemprocs_database_size:  USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name: 
           /qpamd7_eng2/hlam/ase157esd3/data/systemdb.dat
sqlsrv.sybsystemdb_device_size:       USE_DEFAULT
sqlsrv.sybsystemdb_database_size:     USE_DEFAULT
sqlsrv.tempdb_device_physical_name: 
           /qpamd7_eng2/hlam/ase157esd3/data/tempdb.dat
sqlsrv.tempdb_device_size:            USE_DEFAULT
sqlsrv.tempdb_database_size:          USE_DEFAULT
sqlsrv.default_backup_server:         SYB_BACKUP
#sqlsrv.addl_cmdline_parameters: 
#PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
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
# If sqlsrv.do_optimize_config is set to yes, 
#both sqlsrv.avail_physical_memory and 
#sqlsrv.avail_cpu_num need to be set.
sqlsrv.do_optimize_config:            no
sqlsrv.avail_physical_memory: 
PUT_THE_AVAILABLE_PHYSICAL_MEMORY_FOR_ASE_IN_OPTIMIZATION
sqlsrv.avail_cpu_num: 
PUT_THE_AVAILABLE_NUMBER_CPU_FOR_ASE_IN_OPTIMIZATION
Resource file for Backup server on UNIX/Linux platform
	
sybinit.release_directory:            USE_DEFAULT
sybinit.product:                      bsrv
bsrv.server_name:                     SYB_BACKUP
bsrv.new_config:                      yes
bsrv.do_add_backup_server:            yes
bsrv.do_upgrade:                      no
bsrv.network_protocol_list:           tcp
bsrv.network_hostname_list:           qpamd7
bsrv.network_port_list:               6010
bsrv.language:                        USE_DEFAULT
bsrv.character_set:                   USE_DEFAULT
bsrv.tape_config_file:                USE_DEFAULT
bsrv.errorlog:                        USE_DEFAULT
sqlsrv.related_sqlsrvr:               qpamd7srv
sqlsrv.sa_login:                      sa
sqlsrv.sa_password:                   dbasql
#bsrv.addl_cmdline_parameters: 
PUT_ANY_ADDITIONAL_COMMAND_LINE_PARAMETERS_HERE
Resource file for sqlloc utility on UNIX/Linux platform
	
sybinit.release_directory:            USE_DEFAULT
sqlsrv.server_name:                   PUT_YOUR_SERVER_NAME_HERE
sqlsrv.sa_login:                      sa
sqlsrv.sa_password: 
sqlsrv.default_language:              USE_DEFAULT
sqlsrv.language_install_list:         USE_DEFAULT
sqlsrv.language_remove_list:          USE_DEFAULT
sqlsrv.default_characterset:          USE_DEFAULT
sqlsrv.characterset_install_list:     USE_DEFAULT
sqlsrv.characterset_remove_list:      USE_DEFAULT
sqlsrv.sort_order:                    USE_DEFAULT

Resource file for XP server on UNIX/Linux platform
	
sybinit.release_directory:      USE_DEFAULT
sybinit.product:                xp
xp.server_name:                 PUT_YOUR_SERVER_NAME_HERE
xp.new_config:                  yes
xp.do_add_xp_server:            yes
xp.do_upgrade:                  no
xp.network_protocol_list:       tcp
xp.network_hostname_list:       PUT_YOUR_HOSTNAME_HERE
xp.network_port_list:           PUT_YOUR_PORT_NUMBER_HERE
sqlsrv.related_sqlsrvr:         PUT_YOUR_ADAPTIVE_SERVER_NAME_HERE
sqlsrv.sa_login: sa
sqlsrv.sa_password:             USE_DEFAULT