Installation guide

CHAPTER 10: Adaptive Server Upgrades...................69
Upgrading Adaptive Server ................................................69
Considerations for Component Integration Services......72
Preparing to Upgrade ..........................................................72
Changes in Adaptive Server Directories ...........................73
Performing Preupgrade Tasks ............................................74
Upgrade System Tables and Stored Procedures..........76
Reserved Words ...........................................................76
Running a Reserved Word Check .......................77
Addressing Reserved Words Conflicts................77
Quoted Identifiers ................................................78
Preparing the Database and Devices...........................78
The sybprocsdev device ...............................................79
Increasing the Size of the sybsystemprocs
Database .........................................................80
Increasing Device and Database Capacity for
System Procedures .........................................81
Upgrade to Adaptive Server 15.7 ESD #2 ..........................83
Upgrading Interactively Using sqlupgrade ....................83
Upgrading Noninteractively Using sqlupgraderes .........84
Manually Upgrading to Adaptive Server.......................85
Installation of Version 15.7 ESD #2 over an Existing
15.x Adaptive Server ................................................85
Determining the Adaptive Server Version ............86
Backing Up Adaptive Server ................................86
Installing Adaptive Server Using Binary Overlay
.........................................................................86
Postupgrade Tasks ..............................................................87
Running the instmsgs.ebf Script ...................................88
Restoring Functionality in Adaptive Server After
Upgrading.................................................................89
Reenabling Auditing ......................................................90
Contents
vi Adaptive Server Enterprise