System catalog changes during upgrade – Sybase 15.0.2 User Manual

Page 75

Advertising
background image

CHAPTER 5 Upgrading Adaptive Server

Installation Guide

61

c

Run the upgrade process.

Note

Adaptive Server issues advisory warnings when configuration

parameters are not set to the default. These do not require any action.

The

preupgrade

and

upgrade

utilities are internally called by syconfig.exe or

sybatch.exe.

Each new version of Adaptive Server contains features that introduce new
parameters, commands, reserved words, and so on. For this reason,

preupgrade

is for preparing the old server for upgrade.

syconfig.exe, sybatch.exe, or preupgrd.exe runs various checks to determine
how much space you must add to the old server to successfully upgrade the old
server to the new.

As part of the pre-upgrade tasks, syconfig.exe, sybatch.exe, or preupgrd.exe
scans all databases and catalogs and determines how much free space is
required to upgrade successfully. Essentially, syconfig.exe, or sybatch.exe
searches for the largest catalog, then calculates the required free space by
doubling the size of the largest catalog, and adding approximately 10 percent
for logging the upgrade changes for each catalog.

During the pre-upgrade process, syconfig.exe, sybatch.exe, or preupgrd.exe
returns informational messages as it checks the old server. You must fix all
reported problems, and run syconfig.exe, sybatch.exe, or preupgrd.exe cleanly
before beginning the upgrade process. Once the old server is eligible to be
upgraded, syconfig.exe, sybatch.exe, or preupgrd.exe shuts down the old
server, starts the new server against the existing databases, and begins the
upgrade process.

System catalog changes during upgrade

Adaptive Server version 15.0.2 introduces some new system catalogs and some
changes to existing catalogs.

The catalog upgrade in 15.0.2 may affect your existing applications. If you are
upgrading, see the release bulletin for your platform for a complete list of
catalogs that are affected.

Advertising