Installation guide

f) Disable disk mirroring.

g) Verify that your SYBASE environment variable points to the location of the new server software files you

just installed.

Fix any problems that preupgrade utility reports.

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/interfaces

○ $SYBASE/$SYBASE_ASE/<servername>.cfg – where <servername> is your server name.

○ $SYBASE/$SYBASE_OCS/config/libtcl.cfg

○ $SYBASE/SYSAM-2_0/licenses/license.lic

16. If you have enabled the Java in the database feature, create the sybpcidb database and disable the feature

during the installation.

17. Set the environment variables by sourcing the SYBASE.[csh, sh, env] file.

Caution

Do not run the environment variable script more than once.

18. Disable LDAP using:

sp_configure 'enable ldap' , 0

10.5.1 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.

10.5.2 Reserved Words

Reserved words are pieces of SQL syntax that have special meaning when used as part of a command.

Transact-SQL does not allow words that are part of command syntax to be used as identifiers unless they are

enclosed in quotation marks. If you are upgrading SAP ASE, you see errors when you run queries, stored

procedures, or applications that use these identifiers in your user databases.

Note

Before upgrading, use sp_renamedb to change the name of any user database that is a reserved word.

Installation Guide for Linux

SAP ASE Upgrades