Preupgrade Tasks

Learn necessary preupgrade tasks here.

You need the master and system procedures files to upgrade the server. By default, the master (master.dat) and system procedures device (sybsytemprocs.dat) files are installed in the %SYBASE%\data directory.

Note: If you are upgrading Adaptive Server, the previously installed version of the server must be running. If you are upgrading Backup Server, Historical Server, Monitor Server, or XP Server, those servers must not be running.
  1. Ensure that the directory to which your TEMP environment variable points exists. The installation program uses the directory to write files temporarily during the installation, which it locates through the TEMP environment variable.
  2. If you are upgrading from Adaptive Server 12.5.4, run syconfig.exe and choose:
    1. Configure Adaptive Server.
    2. Choose the server name.
    3. Log onto the server.
    4. Choose Command line and add -T7841. If you are upgrading from Adaptive Server version 12.5.4 to the current Adaptive Server Release, under the IPv4 environment, the -T7841 option is not required.
    5. Save the changes.
  3. To upgrade stored procedures, the stored procedure text must be available in syscomments. Do one of the following:
    • Reinstall the procedures with text.
    • Remove them and reinstall them after the upgrade.
  4. Set the password policy option 'allow password downgrade' to 1.
    Then passwords are encrypted with old and new algorithms aiding in transition should you ever downgrade to an earlier version.
  5. Reserved words are resolved using quoted identifiers.
  6. Verify that users are logged off.
  7. Check database integrity.
  8. Back up databases.
  9. Dump the transaction log.
  10. Make sure that master is the default database for the “sa” user.
  11. Prepare the database and devices for upgrade using the preupgrade utility.
    1. Create a sybsystemdb database if it does not already exist.
    2. Disable auditing using the command: 
      sp_configure 'auditing', 0
    3. Save the current audit settings for the pre-15.5 Adaptive Server using the command: 
      sp_displayaudit
  12. Disable disk mirroring.
  13. Verify that your SYBASE environment variable points to the location of the new server software files you just installed.

    Set the OLDSYBASE, OLDSYBASE_ASE, and OLDSYBASE_OCS environment variable to the location of the server you are upgrading, to avoid having to type this path when you run syconfig.exe.

  14. Disable Job Scheduler.
  15. If Job Scheduler is enabled, specify the path for Windows platforms in detail:
    1. Copy %OLDSYBASE%\%OLDSYBASE_OCS\ini\libtcl.cfg to %SYBASE%\%SYBASE_OCS\ini\libtcl.cfg.
  16. Ensure that the procedure cache size is at a minimum of 150 percent of the default procedure cache size, or between 53248 and 2147483647 2K pages.
  17. Copy the following files from earlier versions of the server to their corresponding Adaptive Server 15.x installation location.

    • %SYBASE%\ini\sql.ini

    • %SYBASE%\SYBASE_ASE\<servername>.cfg

    • %SYBASE%\%SYBASE_OCS%\ini directory

    • %SYBASE%\ini\libtcl.cfg

  18. If the Java in the database feature is enabled, create the sybpcidb database. The sybpcidb database stores configuration information for the Pluggable Component Interface (PCI) and all Pluggable Component Adapter (PCA) components. This database is used by installpcidb script. For example: 
    1> disk init
2> name = “sybpcidb_dev”,
3> physname = “${SYBASE}/data/sybpcidb_dev.dat”,
4> size = '24MB'
5> go
1> create database sybpcidb on sybpcidb_dev = 24
2> go
  19. Set the environment variables by sourcing the SYBASE.[csh, sh, env]. file. Running the environment variable script multiple times can cause problems. Only run it once.
Parent topic: Preparing to Upgrade