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.
Running the database scripts
Start Adaptive Server.
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.
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.
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/installpubs2
To install the image data associated with pubs2 (pubs3 does not use image data), run:
isql -Usa -Ppassword -Sservername \ -i $SYBASE/$SYBASE_ASE/scripts/installpix2
The image data requires a fair amount of space—there are six pictures, two each in the PICT, TIFF, and Sun raster file formats. Run installpix2 script only to use or test the image datatype. Sybase does not supply any tools for displaying image data. You must use appropriate window graphics tools to display the images after you have extracted them from the database.
For more information about running these scripts, see the configuration guide for your platform.