CHAPTER 1 Installing Adaptive Server
25
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 */