Sybase ADAPTIVE 15.0.2 - Manual (Page 76)

Pre-upgrade tasks
60 Adaptive Server Enterprise
4 Verify that you unloaded Adaptive Server 15.0.2 in a different directory
than your previous Adaptive Server installation.
If you overwrote your previous server installation:
a Restore it from your most recent backup.
b Reinstall the product files for Adaptive Server in a different directory.
c Continue with the upgrade.
5 Verify that your operating system is at the proper version level and has all
operating system patches needed for Adaptive Server.
Checking RUN_server file location
Verify the name and location of the runserver file. Be sure the runserver file
for your current server is located in:
• $SYBASE/install directory for version 11.9.x
• $SYBASE/$SYBASE_ASE/install for version 12.0.x and higher
Verify that the file is renamed RUN_servername, where servername is the
name of the old server. The servername must appear exactly as it appears in the
interfaces file.The RUN_servername file for a server SYBASE is called
RUN_SYBASE. If the RUN_servername file for your current Adaptive Server
is named, you must change the name during the upgrade process.
Procedure text is required for upgrade
If you created any compiled objects or stored procedures in a pre-11.9.3 server,
then removed the
syscomments text, the upgrade succeeds but you will
encounter runtime problems. To upgrade stored procedures, the stored
procedure text must be available in
syscomments .
To successfully upgrade to Adaptive Server version 15.0.2:
• Reinstall the procedures with text, or
• Remove them and reinstall them after the upgrade.
You can also hide the text using the sp_hidetext stored procedure.