Running the Database Scripts

Learn how to run the datbase scripts here.

Start the server instance.
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.
Use isql to log in to the instance. From the $SYBASE/$SYBASE_ASE/scripts directory, run the script:
```
isql -Usa -P***** -Sserver_name -iscript_name 
```
Where:
- server_name – represents the destination server for the database.
- script_name – is the 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

Note: The image data requires 10 MB 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.