Default device for the sybsyntax database, Installing sybsyntax – Sybase DC35823-01-1500-04 User Manual

Page 138

Advertising
background image

Installing online help for Transact-SQL syntax

122

Adaptive Server Enterprise

You can install any of these scripts, depending on the need for Sybase
information on your server. The first script you execute creates the

sybsyntax

database and the needed tables and indexes. Any scripts that you execute after
the first one add to the existing information in the database. If you execute a
script that was executed previously, the previously installed rows of
information are deleted from the table in the database and then reinstalled.

Warning!

The ins_syn_cl and ins_syn_os scripts conflict. If you execute both

scripts, errors occur.

Default device for the sybsyntax database

The

sybsyntax

database requires 3MB on your database device. By default, the

sybsyntax

installation scripts install the

sybsyntax

database on the device that is

designated as the default database device.

If you have not used

sp_diskdefault

to change the status of the master device

(which is installed as the default disk) or to specify another default device, the
scripts install

sybsyntax

on the master device. Sybase does not recommend this

configuration because

sybsyntax

uses valuable space, which is best left

available for future expansion of the master database.

To avoid installing

sybsyntax

on the master device, do one of the following:

Use

sp_diskdefault

to specify a default device other than the master device. For

information about

sp_diskdefault

, see the Reference Manual.

Modify each

sybsyntax

installation script that you plan to execute to

specify a different device, as explained in the following section.

Installing sybsyntax

For each

sybsyntax

installation script you want to execute:

1

Determine the type (raw partition, logical volume, operating system file,
and so on) and location of the device where you plan to store the

sybsyntax

database. You will need to provide this information later.

2

Make a copy of the original script. Be sure you can access this copy, in
case you experience problems with the edited script.

Advertising