Postupgrade Tasks

After you have upgraded, make sure your new Adaptive Server is up and running.

The upgrade process does not cause any changes in existing statistics, so you need not run update statistics on any tables after the upgrade. If you are upgrading from Adaptive Server version 15.x, however, restart the server to make the statistics available.

Warning! Running installpcidb drops and re-creates the sybpcidb database and all of the tables and data. The configuration returns to a default state. If you have made any changes to the pluggable component interface (PCI) configuration, you must make the same changes again after running installpcidb.

Run dbcc upgrade_object() for each database to explicitly re-compile the objects.
After upgrading from Adaptive Server Cluster Edition version 15.0.1 to 15.5 Cluster Edition, you must execute a one-time procedure for each of your user-created nodes to update the JAR and XML files.
If you upgraded from Adaptive Server version 12.5.2 or earlier, run dbcc checkcatalog with the fix option to ensure there are no issues with OAM pages:
```
dbcc checkcatalog (database_name, fix)
```
Run the updatease utility to install new system stored procedures and run the scripts for different options or licensed features.
If you have any system stored procedures that you had saved from before the upgrade (because you had modified them without altering their names), reload them now.
Execute:
```
dbcc gam (dbname,0,0,'check')
```
This command performs upgrade operations on text and image columns that are deferred during the Adaptive Server upgrade process, and prevents dbcc checkstorage from taking a long time when it is run for the first time after the upgrade.

Updating JAR and XML Files
After the upgrade process completes, SAP recommends that you configure the Sybase Control Center agent by updating its associated JAR and XML files to manage your cluster. This allows you to use the sybcluster utility and the Adaptive Server plug-in to manage the cluster.
Running the instmsgs.ebf Script
Run message-related scripts after upgrading from an Adaptive Server version 15.0.x to version 15.7 SP100.
Restoring Functionality in Adaptive Server After Upgrading
Restore functionality in the server after an upgrade.
Reenabling Auditing
If the server you upgraded from was configured for auditing, reenable auditing in the upgraded server.
Restoring Permissions
If the server you upgraded from had site-specific permissions on system stored procedures, restore those permissions in the upgraded server.
Reenabling Replication Server After the Dataserver Upgrade
If you disabled replication before the upgrade, you must reenable replication.

Parent topic: Adaptive Server Upgrades

Related concepts

How Compiled Objects Are Handled When Upgrading Adaptive Server

Related information

The updatease Utility