Sybase DC35823-01-1500-04 Default device for the sybsyntax database, Installing sybsyntax, 122

Installing online help for Transact-SQL syntax

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:

1Determine 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.

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

122 Adaptive Server Enterprise