Pre-Upgrade Checklist

  1. Install the most recent version of the operating system, or at least the certified release for ASE.

  2. Check that you have enough disk space. See your installation guide for requirements.

  3. Check that each database has at least 10% free space. This is needed by the upgrade.

  4. Check your applications to assess impact from SQL changes. See Chapter 5, “Implement: Making Required Application Changes”.

  5. Check for new reserved words, including those in scripts and applications. See the section “New Reserved Words” in Chapter 6 of this manual.

  6. Replace obsolete environment variables in applications and scripts. See the installation guide or the white paper Technical Issues in ASE 11.9.x and 12.0 Upgrade.

  7. Record size and device fragment information for all databases. You can query the sysdevices and sysusages tables for this information.

  8. Make a note of the default character set and sort order. See the System Administration Guide for information about character sets and sort order.

  9. Verify that sybsystemprocs is large enough and that all device fragments, if there are multiple fragments, contain both log and data segments. See the section “sybsystemdb”in Chapter 6, “Implement: Making Database Administration Changes”.

Just before upgrading, be sure to do the following:

  1. Set master as the default database for “sa”.

  2. If the locations of your error log and configuration file are not the default locations, change them to the default location.

  3. Back up the following:

  4. bcp out critical system tables:

  5. On NT, if server is an automatic service, change the service type for ASE to manual.

  6. Stop mirroring.

  7. Disable auditing: sp_auditoption “enable auditing”, “off”

  8. Set trunc log on chkpt off in all databases.

  9. Save the server configuration (.cfg) file.