Default Devices for the Sample Databases

Learn how to set up the default devices for the 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.

Start Adaptive Server.
Determine the type (raw partition, logical volume, operating system file, and so on) and location of the device where you store the pubs2 and pubs3 databases. You must 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.
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.
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
```
For example, to install pubs2 on a server named VIOLIN, enter:
```
isql -Usa -P***** -SVIOLIN -i %SYBASE%\%SYBASE_ASE%\scripts\instpbs2
```

To install the image data associated with pubs2 (pubs3 does not use image data), run:

%SYBASE%\%SYBASE_ASE%\ isql -Usa -Ppassword -Sservername

   -i%SYBASE%\%SYBASE_ASE%\scripts\instpix2