Postupgrade Tasks

After you have upgraded to the new version of Adaptive Server, perform these tasks to make sure your new Adaptive Server is up and running.

Note:

After the upgrade, you do not need to run update statistics on any tables. The upgrade process does not cause any changes in existing statistics. However, if you are upgrading from 15.x version, restart the server to make the statistics available.

  1. If you upgraded from Adaptive Server version 12.5.2 or lower, after the upgrade you must run dbcc checkcatalog with the fix option to ensure there are no issues with OAM pages. 
    dbcc checkcatalog (database_name, fix)
  2. The new system stored procedures must be installed before any application activity starts. The scripts can be installed using the following isql commands: 
    isql -Usa -P<sa_password> -S<server_name> 
-i$SYBASE/$SYBASE_ASE/scripts/<script_name> -o<output_file>
    The output of the script is saved in output_file. If you are using dbcc upgrade_object, Sybase recommends that you read the Upgrading compiled objects with dbcc upgrade_object topic in the Troubleshooting the Server section of this book.
  3. If you have modified the system stored procedures without altering their original names, executing some of these scripts overwrites your modifications. You must reload the modified stored procedures after running these scripts:
    • installcommit – If you use two-phase commit or distributed transactions, you must rerun the installcommit SQL script to restore the following stored procedures:

      • sp_start_xact

      • sp_abort_xact

      • sp_remove_xact

      • sp_stat_xact

      • sp_scan_xact

      • sp_probe_xact

    • installsecurity – Run this script if the Adaptive Server Auditing functionality was enabled in your earlier installation.

    • installhasvss – Run this script if the HA functionality is enabled and the HA feature is currently in use in the upgraded installation of Adaptive Server.

    • installmsgsvss – Run this script if the RTDS ASE MESSAGING functionality is enabled and the RTDS ASE MESSAGING feature is being used in this installation.

    • installpcidb – Run this script if Java in the database feature was enabled in your earlier installation.

    • installjsdb – Run this script if Job Scheduler functionality was enabled in your earlier installation.

Parent topic: Upgrade