Installation guide
4.
Copy the interfaces file and the configuration file from the 32-bit $SYBASE
directory to the 64-bit $SYBASE directory.
5.
Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_server file to the
equivalent 64-bit $SYBASE/$SYBASE_ASE/install directory.
6.
Edit the RUN_server file to reflect the new location of the interfaces,
configuration, and log files.
7.
Remove all references to the 32-bit $SYBASE directories from your
$PATH
definition.
8.
Change to the 64-bit $SYBASE directory and source the SYBASE.csh script (C shell).
9.
Change to the 64-bit $SYBASE/$SYBASE_ASE/install directory and execute:
startserver -f RUN_server
10.
After the 64-bit server starts, run installmaster, installmodel, and instmsgs.ebf.
11.
If you used dbccdb for dbcc checkstorage, run installdbccdb. This re-creates
tables in the dbccdb. This may cause you to lose data.
12.
Drop and re-create the compiled objects, such as stored procedures, triggers, views, and
defaults.
13.
If you have partitioned tables, update partition statistics.
14.
Run dbcc again on all databases to verify that they run cleanly.
Adaptive Server Components and Related Products
After you finish upgrading Adaptive Server, upgrade its components and related products.
Refer to
Using Sybase Failover in a High Availability System
for instructions on how to
upgrade an Adaptive Server configured with high availability.
Upgrading Job Scheduler
After upgrading to a new Adaptive Server, upgrade Job Scheduler.
Note: You must have $SYBASE/$SYBASE_OCS/bin directory in $PATH so the isql
executable is accessible. Use isql to perform all the steps in this task.
1.
Copy the directory services entry for JSAGENT (or jsagent) from the old server to the new
server.
2.
Make sure the new server is running.
3.
Stop the Job Scheduler:
1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
2> go
4.
Ensure that at least 9000 locks are configured. If the number of locks on the server is fewer
than 9000, increase it:
CHAPTER 10: Adaptive Server Upgrades
94 Adaptive Server Enterprise