Filter
Top Products
CHAPTER 3 Post-Installation Tasks
Installation Guide Evaluation Version 43
Default devices for sample databases
The %SYBASE%\SYBASE_ASE%\scripts directory contains scripts for
installing the
us_english sample database, foreign language sample databases,
and the
image data associated with the U.S. English pubs2 sample database.
If you have not used
sp_diskdefault to change the status of the master device or
to specify another default device, the scripts install the sample databases on the
master device. Sybase does not recommend this configuration because it uses
valuable space that is best used for system tables. Each sample database
requires 3MB on a 2K server, and multiples of 3MB on a 4K, 6K, 8K, and 16K
server on your database device.
To avoid installing sample databases on the
master device, do one of the
following:
•Use
sp_diskdefault to specify a default device other than the master device.
For information on
sp_diskdefault, see the Reference Manual.
• Modify each sample database installation script to specify a different
device.
v Running the database scripts
1 Start Adaptive Server.
2 Determine the type (raw partition, logical volume, operating system file,
and so on) and location of the device where you will be storing the
pubs2
and pubs3 databases. You will need to provide this information later.
3 Make a copy of the original installpubs2 and installpubs3 scripts. Be sure
you can access the copies, in case you have problems with the edited
scripts.
4 Use a text editor to edit the script, if necessary, to specify a default device
other than the
master device, or use sp_diskdefault.
installpix2 Installs the image data that is used with the pubs2 database.
Note The master device size should be at least 30MB to install the full pubs2 database, including
the image data. Run the installpix2 script after you run installpubs2.
Script Description