Default Devices for Sample Databases

The Adaptive Server installation includes scripts for installing the us_english sample database, foreign language sample databases, and the image data associated with the US English pubs2 sample database.

These scripts are located in $SYBASE/SYBASE_ASE/scripts.

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 recommends you do not use 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.

Use a text editor to edit the script, if necessary, to specify a default device other than the master device, or use sp_diskdefault. See sp_diskdefault in Reference Manual: Procedures.