Sybase 15.0.2 - Manual (Page 59)

CHAPTER 3 Post-Installation Tasks
Installation Guide 45
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 instpbs2 and instpbs3 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 .
From the Adaptive Server scripts directory
(%SYBASE%\%SYBASE_ASE%\scripts), use
isql to log in to Adaptive
Server and run the script:
isql -Usa -P***** -Sserver_name -iscript_name
Where:
• server_name – represents the destination server for the database
• script_name – is the full path to and file name of the script to run
For example, to install pubs2 on a server named VIOLIN, enter:
isql -Usa -P***** -SVIOLIN
-i %SYBASE%\%SYBASE_ASE%\scripts\instpbs2
5 To install the image data associated with pubs2 ( pubs3 does not use image
data), run:
%SYBASE%\%SYBASE_ASE%\ isql -Usa -Ppassword