Postupgrade Tasks

After you have upgraded, make sure your new SAP ASE server is up and running.

1. To explicitly re-compile the objects, run dbcc upgrade_object() for each database.
2. If you upgraded from SAP ASE version 12.5.2 or earlier, ensure there are no issues with OAM pages by running dbcc checkcatalog with the fix option:

   dbcc checkcatalog (database_name, fix)

3. 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.
4. Execute:

   dbcc gam (dbname,0,0,'check')

   This command performs upgrade operations on text and image columns that are deferred during the SAP ASE upgrade process, and prevents dbcc checkstorage from taking a long time when it is run for the first time after the upgrade.

• Restoring Functionality in SAP ASE 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.