Installation guide

Running the Database Scripts
After you determine your default device, run the scripts to install the sample databases.
Prerequisites
Back up the original installpubs2 and installpubs3 scripts, in case you have
problems with the edited scripts.
Task
1.
Start Adaptive Server.
2.
Go to the Adaptive Server scripts directory at $SYBASE/$SYBASE_ASE/scripts.
3.
Use isql to log in to Adaptive Server and run the script:
isql -Usa -P*****-Sserver_name -iscript_name
where:
• server_name – is the destination server for the database.
• 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
4.
Install the image data associated with pubs2:
isql -Usa -Ppassword -Sservername
-i$SYBASE/$SYBASE_ASE/scripts/installpix2
The pubs3 database does not use image data.
For more information about running these scripts, see the
Adaptive Server Configuration
Guide .
Installing the interpubs Database
The interpubs database is similar to pubs2, and contains French and German data.
Prerequisites
Back up the original installintpubs script, in case you experience problems with the
edited script.
Task
1.
Set your terminal to display 8-bit characters.
2.
Verify that iso_1, iso_15, Roman8, Roman 9, or UTF-8 is installed as either the default
character set or as an additional character set.
CHAPTER 9: Postinstallation Tasks
62 Adaptive Server Enterprise