Filter
Top Products
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.