To ensure a successful upgrade, review and perform preparatory tasks
as necessary. Depending on the old server configuration, you may not need to perform all
preparatory tasks.
Prerequisites
- You need
the master and system procedures files to upgrade the server. By default, the
master (master.dat)
and system procedures device (sybsytemprocs.dat) files are
installed in the %SYBASE%\data directory.
- The previously installed version of
the server must be running. If you are upgrading Backup Server, Historical
Server, or XP Server, those servers must not be running.
Task
Note:
Follow these steps only if you are performing a major
upgrade from an Adaptive Server version earlier than 15.x.
Skip these preparatory tasks if you plan to use sqlupgrade, which
performs these tasks automatically.
- Install Adaptive Server 15.7 SP100 into its own installation
directory.
- Check system and upgrade
requirements.
- Ensure that the directory to which your TEMP
environment variable points exists. The installation program uses this directory
to write files temporarily during the installation, which it locates through the
TEMP environment variable.
- If you are upgrading from Adaptive Server 12.5.4,
run syconfig.exe:
-
Select Upgrade Adaptive Server.
- Choose the server name.
- Log in to the server.
- Choose Command line, and add -T7841.
The -T7841 option is not required if you are upgrading from Adaptive Server version 12.5.4 to the current Adaptive Server under the IPv4 environment.
- Save the changes.
- Verify that the text of all stored procedures you upgrade is available in syscomments by either:
- Reinstalling the procedures with text, or,
- Removing and reinstalling the procedures after the upgrade.
This step can allow you to inspect the stored procedures for any hidden or unwanted text.
- Set the 'allow password downgrade' password policy option to
1 to ensure that passwords are encrypted with both
the old and new algorithms, in case you need to downgrade to an earlier version
of Adaptive Server.
- Make sure reserved words use quoted identifiers.
- Verify that users are logged off.
- Use dbcc to check for database integrity.
- Back up databases.
- Dump the transaction log.
- Verify that master is the default database for the "sa" user.
- Prepare the database and devices for upgrade using the preupgrade utility:
- Create a sybsystemdb database
if it does not already exist.
- Disable auditing by running sp_configure 'auditing', 0.
- If Job Scheduler is enabled, specify the path for Windows
platforms in detail by copying
%OLDSYBASE%\%OLDSYBASE_OCS\ini\libtcl.cfg to
%SYBASE%\%SYBASE_OCS\ini\libtcl.cfg, then
disable Job Scheduler.
- Obtain the current audit settings for the pre-15.7
Adaptive Server using sp_displayaudit; use this saved information to reenable
auditing after you complete the installation. See Reenabling
Auditing.
- If you made any site-specific changes to
the permissions for system stored procedures, obtain the current
permission settings for them using sp_helprotect;
then use this saved information to reenable the permissions after you
complete the installation. Pay special attention to:
- Any stored procedures that are not granted execute permission to
public, such as sp_addauditrecord,
sp_monitor, and
sp_sysmon.
- Any stored procedures where execute permission has been revoked
from public.
- Disable disk mirroring.
- Verify that your SYBASE environment variable points
to the location of the new server software files you just
installed.
Set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS
environment variables to the location of the server you are
upgrading, to avoid having to type this path when you run syconfig.exe.
Fix any problems that
preupgrade utility reports.
When there are no problems and the old server is ready for
upgrade, syconfig.exe automatically
starts the upgrade process when the preupgrade utility reports no errors.
You can safely ignore any warnings Adaptive Server issues about
configuration parameters not being set to the default, as these are only for
your information.
- Ensure that the procedure cache size is at least 150 percent of the default procedure cache size, or between 53,248
and 2,147,483,647 2K pages.
- Copy these files from earlier versions of the server to their corresponding Adaptive Server 15.x installation locations:
-
%SYBASE%\ini\sql.ini
-
%SYBASE%\SYBASE_ASE\servername.cfg – where servername is your server name
-
%SYBASE%\%SYBASE_OCS%\ini
directory
-
%SYBASE%\ini\libtcl.cfg
- If you have enabled the Java in the database feature, create the sybpcidb database and disable the feature during the installation.
- The sysconfig.exe file cannot connect to
an Adaptive Server that uses a named pipe directory service. Remove the named pipe directory service from the interfaces
file before upgrading Adaptive Server.
- Set the environment variables by sourcing the SYBASE.[csh,
sh, env] file.
Warning! Do not run the environment variable script more than once.
- Set the OLDSYBASE_ASE variable to the SYBASE_ASE
appropriate to your older server. If you are upgrading from 12.5
for example, it should be ASE-12_5.
SAP recommends you also set the OLDSYBASE, and OLDSYBASE_OCS
environment variables to point to the old installation of Adaptive Server,
so that the sqlupgraderes utility automatically populates
input fields with the correct information as you upgrade.