Postupgrade Tasks

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

Note: 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.
  1. 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)
  2. Install new system stored procedures before starting any application activities:
    isql -Usa -Psa_password -Sserver_name 
-i$SYBASE/$SYBASE_ASE/scripts/script_name -ooutput_file
    The output of the script is saved in output_file. See How Compiled Objects are Handled When Upgrading Adaptive Server if you are using dbcc upgrade_object to upgrade compiled objects such as check constraints, rules, triggers, and views.
  3. Run the scripts for different options or licensed features:
    • installcommit – if you use two-phase commit or distributed transactions, re-run installcommit to restore:
      • sp_start_xact
      • sp_abort_xact
      • sp_remove_xact
      • sp_stat_xact
      • sp_scan_xact
      • sp_probe_xact
    • installsecurity – if you used auditing in your earlier installation.
    • installhasvss – if you enabled high-availability functionality, and are using this feature in this installation.
    • installmsgsvss – if you enabled real-time messaging functionality, and you are using this feature in this installation.

    • installpcidb – if you enabled the Java in the database feature in your earlier installation.

    • installjsdb – if you enabled Job Scheduler in your earlier installation.
  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.
Parent topic: Adaptive Server Upgrades