Preupgrade Tasks

To ensure a successful upgrade, review and perform preparatory tasks as necessary. Depending on the old server configuration, you may not need to perform all preparatory tasks.

1. Install SAP ASE 16.0 into the old ASE directory.
2. Check system and upgrade requirements.
3. Ensure that the directory to which your TEMP environment variable points exists.
4. If you are upgrading from SAP ASE 12.5.4, run syconfig.exe:
   1. Select Upgrade Adaptive Server.
   2. Choose the server name.
   3. Log in to the server.
   4. Choose Command line, and add -T7841.
5. Verify that the text of all stored procedures you upgrade is available in syscomments by either:
   • Reinstalling the procedures with text, or,
   • Removing and reinstalling the procedures after the upgrade.
   This step can allow you to inspect the stored procedures for any hidden or unwanted text.
6. Make sure reserved words use quoted identifiers.
7. Verify that users are logged off.
8. Use dbcc to check for database integrity.
9. Back up databases.
10. Dump the transaction log.
11. Verify that master is the default database for the "sa" user.
12. Prepare the database and devices for upgrade using the preupgrade utility. See preupgrade in the Utility Guide for more information. After preupgrade finds no errors by exiting with status 0 (zero):
    1. Create a sybsystemdb database if it does not already exist.
    2. Disable auditing by running sp_configure 'auditing', 0.
    3. If Job Scheduler is enabled, copy %OLDSYBASE%\%OLDSYBASE_OCS%\libtcl*.cfg to %SYBASE%\%SYBASE_OCS%.
    4. If Job Scheduler if enabled, disable it.
    5. Obtain the current audit settings for the pre-16.0 SAP ASE using sp_displayaudit; use this saved information to reenable auditing after you complete the upgrade.
    6. If you made any site-specific changes to the permissions for system stored procedures, obtain the current permission settings for them using sp_helprotect; then use this saved information to reenable the permissions after you complete the installation. Pay special attention to
       • Any stored procedures that are not granted execute permission to public, such as sp_addauditrecord, sp_monitor, and sp_sysmon.
       • Any stored procedures where execute permission has been revoked from public.
    7. Disable disk mirroring.
    Fix any problems that preupgrade utility reports.

    When there are no problems and the old server is ready for upgrade, syconfig.exe automatically starts the upgrade process when the preupgrade utility reports no errors.

    You can safely ignore any warnings SAP ASE issues about configuration parameters not being set to the default, as these are only for your information.

13. If you are upgrading from a nonclustered 12.5.4, 15.0.2, 15.5, or 15.7 server, and archive database access has been applied in the lower version server, disable the related functionality before upgrading.
14. Ensure that the procedure cache size is at least 150 percent of the default procedure cache size, or between 53,248 and 2,147,483,647 2KB pages.
15. Copy these files from earlier versions of the server to their corresponding SAP ASE 15.x installation locations:
    • %SYBASE%\ini\sql.ini
    • %SYBASE%\%SYBASE_ASE%\servername.cfg – where servername is your server name
    • %SYBASE%\%SYBASE_OCS%\ini directory
    • %SYBASE%\ini\libtcl.cfg
16. If you have enabled the Java in the database feature, create the sybpcidb database and disable the feature during the installation.
17. The sysconfig.exe file cannot connect to an SAP ASE that uses a named pipe directory service. Remove the named pipe directory service from the interfaces file before upgrading SAP ASE.
18. Disable LDAP using:

    sp_configure 'enable ldap' , 0

• Upgrade Stored Procedures
  If you modified any system stored procedures without altering their names, back them up before you upgrade SAP ASE. The upgrade process overwrites these modified procedures with default versions.
• Reserved Words
  Reserved words are pieces of SQL syntax that have special meaning when used as part of a command.
• Preparing the Database and Devices
  Before starting the upgrade process, confirm that you have enough space for the upgrade to succeed.
• The sybprocsdev device
  Sybase system procedures are stored in the sybsystemprocs database, which is stored in the sysprocsdev device. You may need to increase the size of sysprocsdev before upgrading SAP ASE.