Installation guide

the initial and final steps. Doing so flushes free space accounting figures, object statistics,
and runs checkpoint on the database to minimize recovery work during the upgrade
process.
2.
Use the installer to load the new software from the CD or DVD.
Navigate to the CD or DVD drive and enter ./setup.bin.
3.
Install Adaptive Server 15.7 ESD #2 into the existing $SYBASE installation path.
Note: Once files are loaded into your $SYBASE directory, select not to configure the new
server, and click Continue to finish the installation.
4.
Restart Adaptive Server by using :
$SYBASE/$SYBASE_ASE/install/startserver [-f RUN_server_name file]
5.
Run select @@version. The server should now be at version 15.7 ESD #2.
6.
In Adaptive Server version 15.7, several changes were made to the system stored
procedures and many new error messages have been added. After performing a binary
overlay, you must perform the postinstallation tasks before running installmaster or
instmsgs.ebf.
7.
Once the server has been brought up on the new binary and and you have completed the
upgrade of system tables, shut down, then restart Adaptive Server. This prevents incorrect
table statistics from being stored in memory, and which may lead to poorly optimized
query plans.
See also
• Chapter 9, Postinstallation Tasks on page 57
Postupgrade Tasks
After you have upgraded, make sure your new Adaptive Server is up and running.
The upgrade process does not cause any changes in existing statistics, so you need not run
update statistics on any tables after the upgrade. If you are upgrading from Adaptive Server
version 15.x, however, restart the server to make the statistics available.
1.
Run dbcc upgrade_object() for each database to explicit re-compile the objects
2.
If you upgraded from Adaptive Server version 12.5.2 or earlier, run dbcc checkcatalog
with the fix option to ensure there are no issues with OAM pages:
dbcc checkcatalog (database_name, fix)
3.
Install new system stored procedures before starting any application activities:
isql -Usa -Psa_password -Sserver_name
-i$SYBASE/$SYBASE_ASE/scripts/script_name -ooutput_file
The output of the script is saved in output_file. See How Compiled Objects are
Handled When Upgrading Adaptive Server on page 101 if you are using dbcc
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 87