Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 57
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
sqlupgrade or
sqlupgraderes.
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.
sqlupgrade, sqlupgraderes, or preupgrade runs various checks to determine how
much space you must add to the old server to successfully upgrade.
As part of the pre-upgrade tasks,
sqlupgrade, sqlupgraderes, or preupgrade
scans all databases and catalogs and determines how much free space is
required to upgrade successfully.
sqlupgrade,sqlupgraderes, or preupgrade
searches for the largest catalog, then calculates the required free space by
doubling the size of the largest catalog, and adding 10 percent for logging the
upgrade changes for each catalog.
During the pre-upgrade process,
sqlupgrade, sqlupgraderes, or preupgrade
returns informational messages as it checks the old server. You must fix all
reported problems, and run
sqlupgrade, sqlupgraderes, or preupgrade cleanly
before beginning the upgrade process. Once the old server is eligible to be
upgraded,
sqlupgrade, sqlupgraderes, or preupgrade 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.