Sybase ADAPTIVE 15.0.2 User Manual

Page 82

Advertising
background image

Pre-upgrade tasks

66

Adaptive Server Enterprise

To upgrade using

sqlupgrade

:

1

Make sure your current server is running.

2

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

3

Source ASE150.csh before running

sqlupgrade

.

4

Execute

sqlupgrade

, by entering at the UNIX prompt:

$SYBASE/$SYBASE_ASE/bin/sqlupgrade

A

sqlupgrade

window now displays.

5

The first screen warns you to back up the databases, devices, and so on.
Click Next to proceed to the next screen.

6

Click OK.

7

The Next screen prompts you to enter the old Sybase directory, and the old
Adaptive Server directory.

8

Click OK. The Adaptive Server Selection window displays.

9

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.

10 Click OK. The SA Password window is displayed.

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

12 Click OK. The Specifying Upgrade Options window is displayed.

13 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.

14 Adaptive Server 11.9.x did not automatically create a

sybsystemprocs

database and device. Unless you have created one, the eligibility test fails.
The Back button launches the “Specify

sybsystemprocs

” window.

Enter the full path to the

sybsystemprocs

device and at least 124MB for the

sybsystemprocs

database. Click OK to continue with the eligibility test.

15 Click OK to upgrade your server.

Advertising