Default devices for sample databases

The $SYBASE/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. This configuration is not recommended because it uses valuable space that is best used for system tables. Each sample database requires 3MB on your database device.

To avoid installing sample databases on the master device, either:

StepsRunning 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.

    From the Adaptive Server scripts directory ($SYBASE/$SYBASE_ASE/scripts), use isql to log into Adaptive Server and run the script:

    isql -Usa -P -Sserver_name -iscript_name 

    where server_name represents the destination server for the database and 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
  5. 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

NoteThe 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 if you want to use or test the image datatype. Sybase does not supply any tools for displaying image data. You must use appropriate screen graphics tools to display the images after you have extracted them from the database.

For more information about running these scripts, see Configuring Adaptive Server Enterprise