Resource file attributes for Adaptive Server

Table A-1 shows the Adaptive Server resource file attributes, their default values, and other options.

The attributes in bold type are required, and all alpha values are case-sensitive.

The prefix of the attribute name varies, depending on whether the resource file was created by srvbuild or by sybinit (from a pre-11.5 SQL Server). The prefix is ignored by srvbuildres when processing the resource file.

The attribute names in Table A-1 are the attribute names provided in the sample resource file included in your Adaptive Server distribution.

Table A-1: Resource file attributes for Adaptive Server

Attribute

Default value [other options]

sybinit.release_directory

The value of $SYBASE at your site

sybinit.product

sqlsrv

sqlsrv.server_name

server_name

sqlsrv.new_config

yes (required value)

sqlsrv.do_add_server (to interfaces file)

yes [no]

sqlsrv.network_protocol_list

tcp

sqlsrv.network_hostname_list

hostname

sqlsrv.addl_cmdline_parameterst

null

sqlsrv.network_port_list

port_number

sqlsrv.master_device_physical_name

path_and_name_of_master_device

sqlsrv.master_device_size

60 (MB)

sqlsrv.master_database_size

26 (MB)

sqlsrv.errorlog

$SYBASE/$SYBASE_ASE/install/server_name.log

sqlsrv.do_upgrade

no (required value)

sqlsrv.sybsystemprocs_device_physical_name

path_and_name_of_sybsystemprocs_device

sqlsrv.sybsystemprocs_device_size

140 (MB)

sqlsrv.force_buildmaster

No

sqlsrv.server_page_size

4K (required)

sqlsrv.sybsystemprocs_database_size

140 (MB)

sqlsrv.sybsytemdb_device_physical_name

path_and_name_of_ sybsystemdb_device

sqlsrv.sybsystemdb_device_size

6 (MB)

sqlsrv.sybsystemdb_database_size

6 (MB)

sqlsrv.default_backup_server

backup_server_name

sqlsrv.do_configure_pci

no[yes]

sqlsrv.sybpcidb_device_physical_name

path_and_name_of_pci_device

sqlsrv.sybpcidb_device_size

pci_device_size

sqlsrv.sybpcidb_database_size

pci_database_size

sqlsrv.tempdb_device_physical_name

path of the sybsystemdb device

sqlsrv.tempdb_device_size

100 (MB)

sqlsrv.tempdb_database_size

100 (MB)

sqlsrv.do_optimize_config

no [yes]

sqlsrv.avail_physical_memory

available_RAM_for_ASE

sqlsrv.avail_cpu_num

available_number_of_CPU_for_ASE