Home

	Expand Search

Installation Guide Adaptive Server Enterprise for IBM RISC System/6000 AIX

Chapter 8 Upgrading Sybase Servers

Upgrading to Adaptive Server 12.5

Upgrading to Adaptive Server 12.5

To assist with the upgrade process, Sybase recommends that you set the OLDSYBASE environment variable to point to the old installation of Adaptive Server. If you set the OLDSYBASE environment variable to the old installation of the Adaptive Server, the upgrade utility will automatically populate input fields with the correct information as you perform the upgrade.

Back up all existing Sybase installations. Installing Adaptive Server files into an existing Sybase installation directory overwrites the previous installation.

Warning!

If you install Adaptive Server files into the same directory as the currently installed version, the new version overwrites the old one. If this occurs, the upgrade cannot complete, because you must have both the old and the new versions of Adaptive Server to perform an upgrade.

Use either of the following methods to upgrade Adaptive Server:

• sqlupgrade - provides an X-Windows or Motif GUI for the upgrade process. See "Using sqlupgrade".

• sqlupgraderes - provides a noninteractive, file-based interface for the upgrade process. sqlupgraderes allows you to upgrade Adaptive Server using a resource file. This is useful for customer sites that want to upgrade many similar servers. See "Using sqlupgraderes".

Backup Server, Monitor Server, and XP Server cannot be upgraded using sqlupgraderes.

Using sqlupgrade

sqlupgrade verifies that the server is eligible for the upgrade. Perform all pre-upgrade tasks before running sqlupgrade.

To upgrade using sqlupgrade:

1. Make sure your current server is running.

2. Verify that your SYBASE environment variable points to the location of the new Adaptive Server software files you just unloaded.

   You also can set the OLDSYBASE environment variable to the location of the server you are upgrading, to avoid typing this path when you run sqlupgrade.

3. Verify that you have performed the tasks mentioned on the screen, before beginning the upgrade.

   sqlupgrade automatically copies the interfaces file entry of the server you are upgrading from the old interfaces file to the new interfaces file.

4. Execute sqlupgrade in either of the following ways:

   • At the UNIX prompt, enter:

     $SYBASE/$SYBASE_ASE/bin/sqlupgrade 

     A sqlupgrade screen is displayed.

   • Alternatively, you may access sqlupgrade through the asecfg utility. Then click on the Upgrade an Existing Server button.

5. Click OK.

6. The Specify Sybase Directories screen of sqlupgrade is displayed. Provide the installation directory location for both the new server version and your current server.

   If the SYBASE environment variable is set, sqlupgrade displays the value of the SYBASE environment variable as the directory location for the new server version.

   If the OLDSYBASE environment variable is set, sqlupgrade displays that value as the directory location for your current server.

7. Enter the name of the component directory that contains the new server version. For example, ASE-12_5.

8. Enter the full path of the old Sybase release directory. For example, /opt/sybase-12.0.

   If the OLDSYBASE environment variable is set, sqlupgrade displays that value as the directory location for the old server.

9. In the field, "Enter the name of the component directory which contains the old version" enter the Adaptive Server component directory. For example, ASE-12_0.

   If you are upgrading from a version earlier than 12.0, leave this field blank. Beginning with Adaptive Server 12.0, the directory structure changed.

10. Click OK. The Adaptive Server Selection screen displays.

11. From the list of server names provided, select the server you want to upgrade.

    If the server you are upgrading is not running, sqlupgrade prompts you to start the server. The server you are upgrading must be running.

12. Click OK. The SA Password screen is displayed.

13. Enter the password for the System Administrator (sa) login.

14. Click OK. The Specifying Upgrade Options screen is displayed.

15. Specify an upgrade option.

    The upgrade eligibility tests verify that your current server meets the requirements for upgrading to the new version. (The online help provides a partial list of what the upgrade eligibility tests check.) If your current server fails the upgrade eligibility test, you must fix the problem.

    Adaptive Server 11.9.x did not automatically create a sybsystemproc database and device. Unless you created one, the eligibility test will fail. The Back button launches the "Specify sybsystemprocs" screen.

    Enter the full path to the sybsystemproc device and 105MB for the sybsystemproc database. Click OK to continue with the eligibility test.

16. Click OK to upgrade your server.

    sqlupgrade displays the Status Output screen.View the Status Output screen for the completion status and informational messages about the upgrade process.

    Warning!

    Do not interrupt the upgrade, and do not try to connect to Adaptive Server or run any stored procedures while the upgrade is in progress.

    You can also check the progress of the upgrade by viewing the sqlupgrade log in $SYBASE/$SYBASE_ASE/init/logs/sqlupgradeMMDD.NNN.

    After all pre-upgrade checks are successful, the old server is shutdown and the new Adaptive Server dataserver binary is started on the old master device. sqlupgrade internally runs the upgrade binary to perform the upgrade.

    If the upgrade is successful, a "Done" message is displayed in the Status Output screen.

    On some UNIX platforms, the sqlupgrade utility may not return you to the command prompt even though the upgrade has completed successfully. To exit the utility, force an exit by pressing Ctrl + C.

17. The upgrade process:

    • Creates the RUN_servername file

    • Runs installmaster and installjconnect scripts

When the upgrade completes successfully, you can:

• Click OK to specify another server to upgrade, or

• Exit sqlupgrade, and go to "Post-upgrade tasks".

• See "Upgrading compiled objects with dbcc upgrade_object ".

Using sqlupgraderes

You can upgrade Adaptive Server in noninteractive mode by using values from a resource file that defines the attributes for the server to be upgraded.

To upgrade an Adaptive Server using a resource file, either:

1. Edit the sample resource file included in your Adaptive Server distribution in $SYBASE/$SYBASE_ASE/init/sample_resource_files/upgrade.rs. Use an ASCII text editor to edit the resource file as described in the Appendix, "Alternative Installation Methods"

2. Run the sqlupgrade utility. This utility creates a new file containing the values you specified for that upgrade session, and writes it to:

   $SYBASE/$SYBASE_ASE/init/logs/sqlupgradeMMDD.NNN-server_name.rs

   where server_name is the name of the upgraded server.

   Warning!

   Be sure to change device names in the resource file, if necessary, before executing the resource file using sqlupgraderes.

   For details on the attributes used in a resource file, see "Resource file attributes for upgrading Adaptive Server ".

Table 8-1 shows the resource file attribute names, their default values, and other options, which you use in the resource file for upgrading Adaptive Server. The sample resource file in the $SYBASE_ASE/init/sample/upgrade file included in your Adaptive Server distribution shows examples of these attributes.

All attributes are required. And all values are case sensitive.

If the resource file you are modifying was created by sqlupgrade, the prefix of the attribute name may vary. sqlupgraderes ignores this prefix when processing the resource file.

When you have finished editing your resource file, you can run the file using sqlupgraderes.

sqlupgraderes is a command-line tool; therefore, unlike sqlupgrade, it does not require any X libraries.

To execute sqlupgraderes, at the UNIX prompt, enter:

$SYBASE/$SYBASE_ASE/bin/sqlupgraderes -r resource_file