Sybase MAC OS X User Manual download pdf (Page 35)

CHAPTER 1 Installing Adaptive Server

For more information on

sp_syntax, see the Reference Manual. This script

includes syntax information for Transact-SQL, the system procedures, and the

Sybase utilities. When you execute this script, you install the SQL portion of

the

sybsyntax database.

When you first execute this script, it creates the

sybsyntax database and the

necessary tables and indexes. If you execute the script again, the previously

installed rows of information are deleted from the table in the database and then

reinstalled.

Default device for the sybsyntax database

By default, the sybsyntax script installs the sybsyntax database on the device

that is designated as the default database device.

If you have not changed the status of the master device (which is installed as

the default disk) or specified another default device, the script automatically

installs

sybsyntax on the master device. Sybase does not recommend this

configuration because

sybsyntax uses valuable space that is best left available

for future expansion of the

master database.

To avoid installing

sybsyntax on the master device, do one of the following:

•Us

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:

• Determine the device location where you plan to store the

sybsyntax

database.

• Make a copy of the original script. Be sure you can access this copy, in

case you experience problems with the edited script.

• Use a text editor to edit the script, if necessary, to change the default device

from the master device to a new default device.

• Comment out the following section, which specifies the default device:

/*create the database, if it does not exist */

1 2 ... 30 31 32 33 34 35 36 37 38 39 40 ... 53 54

No comments

Sybase MAC OS X User Manual Page 35