Postupgrade Tasks

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

1. Run dbcc upgrade_object() for each database to explicitly re-compile the objects.
2. 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)

3. Run the updatease utility to install new system stored procedures and run the scripts for different options or licensed features.
4. 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.
5. 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.

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