Installation guide

•
$SYBASE/interfaces
• $SYBASE/$SYBASE_ASE/servername.cfg – where servername is your
server name.
•
$SYBASE/$SYBASE_OCS/config/libtcl.cfg
•
$SYBASE/SYSAM-2_0/licenses/license.lic
16.
If you have enabled the Java in the database feature, create the sybpcidb database and
disable the feature during the installation.
17.
Set the environment variables by sourcing the SYBASE.[csh, sh, env] file.
Warning! Do not run the environment variable script more than once.
18.
Set the OLDSYBASE_ASE variable to the SYBASE_ASE appropriate to your older
server. If you are upgrading from 12.5 for example, it should be ASE-12_5.
If upgrading from Adaptive Server 12.5, and you are using sqlupgraderes to perform the
upgrade, enter:
setenv OLDSYBASE <old_$SYBASE_directory>
setenv OLDSYBASE_ASE ASE-12_5
Sybase recommends you also set the OLDSYBASE, and OLDSYBASE_OCS
environment variables to point to the old installation of Adaptive Server, so the upgrade
utility automatically populates input fields with the correct information as you upgrade.
See also
•
Managing Java in the Database During Installations and Upgrades on page 33
Upgrade System Tables and Stored Procedures
When you upgrade Adaptive Server, drop and re-create syscomments to include the new
and changed tables.
If you deleted text from the syscomments system table, drop and re-create the stored
procedures to again add the text. Sybase recommends that you use the sp_hidetext stored
procedure to hide text, rather than deleting text.
If you modified any system stored procedures without altering their names, back them up
before you upgrade Adaptive Server. The upgrade process overwrites these modified
procedures with default versions.
Reserved Words
Reserved words are pieces of SQL syntax that have special meaning when used as part of a
command.
Transact-SQL does not allow words that are part of command syntax to be used as identifiers
unless they are enclosed in quotation marks. If you are upgrading Adaptive Server, you see
errors when you run queries, stored procedures, or applications that use these identifiers in
your user databases.
CHAPTER 10: Adaptive Server Upgrades
76 Adaptive Server Enterprise