Installation guide

Database Description
install-
pubs2
Installs the pubs2 sample database. This database contains data that represents a
publishing operation. Use this database to test your server connections and to learn
Transact-SQL. Most of the examples in the Adaptive Server documentation query the
pubs2 database.
Note: The master device size should be at least 30MB to install the full pubs2
database, including the image data.
install-
pubs3
Installs the pubs3 sample database. This updated version of pubs2 uses refer-
ential integrity. In addition, its tables are slightly different than the tables used in
pubs2. Where noted, the Adaptive Server documentation uses the pubs3 data-
base in its examples.
install-
pix2
Installs the image data that is used with the pubs2 database.
Run the installpix2 script after you run installpubs2.
The image data requires 10MB—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.
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 on a default device.
These scripts are located in $SYBASE/$SYBASE_ASE/scripts.
By default, these scripts install the sample databases on the master device. Because the
databases use valuable space on the master device that is best reserved 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—Sybase recommends that you change the default to a
device other than the master device.
To change the default location where the scripts install these databases, use sp_diskdefault.
See sp_diskdefault in Reference Manual: Procedures . Alternatively, use a text editor to revise
the script directly.
CHAPTER 9: Postinstallation Tasks
Installation Guide 61