Upgrading Interactively Using sqlupgrade

Use the interactive sqlupgrade tool to upgrade SAP ASE using an X-Windows or Motif GUI.

Prerequisites

Set the OLDSYBASE_ASE variable to the SYBASE_ASE that is appropriate to your older server. If you are upgrading from 15.7 for example, OLDSYBASE_ASE should be ASE-15_0.

We recommend that you also set the OLDSYBASE, and OLDSYBASE_OCS environment variables to point to the older version installation of SAP ASE, so the upgrade utility that you run from the new $SYBASE directory automatically populates input fields with the correct information as you upgrade.

Source SYBASE.csh before running sqlupgrade if you have not already so.

Make sure your old server is running. If the server you are upgrading is not running, sqlupgrade prompts you to start the server.

Task

Verify that you have backed up databases, devices, and so on, and click Next.
Enter:
```
$SYBASE/$SYBASE_ASE/bin/sqlupgrade
```
The available command options for sqlupgrade are:
- -s sybase_dir – specifies the value to use for the SYBASE environment variable.
- -r resource_file – executes the specified resource file.
- -D data_directory – specifies a working directory that differs from the default $SYBASE directory. This allows users other than the sa to configure and use SAP ASE without the need to have access permission to the $SYBASE directory. If you do not use -D, SAP ASE uses $SYBASE as the default.
- -v – prints the version number and copyright message for sqlupgraderes and then exits.
In the Specify Sybase Directories dialog, enter:
- The full path of the new SAP ASE release directory.
- The full path of the data directory for the new SAP ASE release directory. This field allows you to specify a working directory that differs from the default $SYBASE directory, which allows users other than the sa to configure and use SAP ASE without the need to have access permission to the $SYBASE directory.
- The name of the component directory that contains the new SAP ASE version.
- The full path of the old release directory.
- The name of the component directory that contains the earlier version of SAP ASE.
- The name of the component directory that contains the earlier version of Open Client/Server Library.
Click OK.
Select the server to upgrade from the list of servers.
Enter the password for the sa login, then click OK.
Specify an upgrade option, then click OK. sqlupgrade performs a preupgrade review to verify that your current server meets the requirements for upgrade to the new version.

If your current server fails the preupgrade review, fix the problem based on the information from the results of the test.
Click OK to upgrade your server.
You see the Status Output window, which shows the completion status and informational messages about the upgrade process.

Warning! Do not interrupt the upgrade, connect to SAP ASE, or run any stored procedures while the upgrade is in progress.
You can also check progress by viewing the sqlupgrade log in $SYBASE/$SYBASE_ASE/init/logs/sqlupgradeMMDD.NNN, where:
- MM – is the month.
- DD – is the date.
- NNN – is a three-digit number identifying the sqlupgrade server upgrade session.
After all preupgrade checks are successful, sqlupgrade shuts the old server down, then starts the new SAP ASE dataserver binary on the old master device.

When the upgrade succeeds, you can:

Click OK to specify another server to upgrade, or
Exit sqlupgrade and perform post-upgrade tasks.

The upgrade process:

Creates the RUN_servername file, which contains the information required to restart the server
Runs the installmaster script to create system procedures

To verify that the upgrade was successful, log in to the server and run:

select @@version – SAP ASE should return 16.0.
sp_configure "upgrade version" – SAP ASE should return 16000000 (16 million).