Home

	Expand Search

Installation Guide Adaptive Server Enterprise for Linux/Intel

Appendix A Alternative Installation Methods

Resource file installation

Resource file installation

You can create an Adaptive Server or Backup Server, using values specified in a resource file that defines the attributes for the server.

Resource files are ASCII format template files that contain configuration variables. To use the template files, edit the resource file, replace variables with desired values, and execute the svrbuildres utility. The svrbuildres utility uses the variables to create servers.

Resource files allow you to create servers in batch mode. You can create servers on multiple systems from the same resource file by editing a few values in that file. Within a single resource file, you can create only one server at a time.

The server files must already exist on the computer before the servers can be created. Use procedures in Chapter 4, "Installing Sybase Servers ".

You cannot install Monitor Server, XP Server or FTS using resource files.

To install an Adaptive Server or Backup Server using resource files:

1. Edit a resource file as described in "Editing a resource file".

2. Execute the srvbuildres utility, using the edited resource file as described in "Using srvbuildres".

Editing a resource file

You can edit a resource file by:

• Editing a sample resource file

• Editing the resource file created by the srvbuild utility

Sample resource files for creating Adaptive Server and Backup Server are included in your Adaptive Server distribution in:

$SYBASE/$SYBASE_ASE/init/sample_resource_files.

Edit these files to specify the attributes for the servers you want to create.

Note the following:

• If you use USE-DEFAULT as the Adaptive Server name, the utility substitutes the name of the computer on which it is running for the server name. If you use USE-DEFAULT, do not create Backup Server entries in the resource file. They are created automatically using the default name.

• To create a server with a different name, change the Adaptive Server name and use the new name with the "_BK" extensions for Backup Server. For example, the Backup Server for PIANO should be PIANO_BK.

• The master device size must be at least 30MB.

• The system procedure device and sybsystemprocs database sizes must be at least 100MB.

• The auditing entries in the resource file are not supported and will not be processed by the utility. To enable auditing, see the Adaptive Server Configuration Guide.

You can create a resource file by running the srvbuild utility. A new file containing the values you specified for the Adaptive or Backup servers is written to:

$SYBASE/$SYBASE_ASE/init/logs/srvbuildMMDD.VVV-servername.rs.

Edit these files to specify the attributes for the servers you want to create.

Warning!

Be sure to edit the resource file generated by srvbuild to change attributes, such as device names, that may be different on another system.

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

The attributes in bold type are required.

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-2 shows the Backup Server resource file attributes, their default values, and other options.

The attributes in bold type are required.

All 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-2 are the attribute names provided in the sample resource file included in your Adaptive Server distribution.

Using srvbuildres

To execute srvbuildres at the UNIX prompt enter:

$SYBASE/$SYBASE_ASE/bin/srvbuildres -r resource_file

where resource_file specifies the resource file containing the attributes that describe the server to build.

Unlike srvbuild, the srvbuildres utility does not require any X libraries.

When you have completed resource file installation, go to Chapter 5, "Post-Installation Tasks".

Troubleshooting resource file installations

If you encounter problems during the build, configure, or upgrade of Adaptive Server using the srvbuild[res], sqlloc[res], or sqlupgrade[res], it may be that these utilities did not allow enough time for Adaptive Server to shut down properly.

You can set the environment variable SYBSHUTWAIT to force the utilities to wait for Adaptive Server to shutdown. For example:

% setenv SYBSHUTWAIT 120

This forces the utility to wait for 2 minutes to allow Adaptive Server to shut down before proceed with the next task.