Database Upgrades

Use these procedures to upgrade SAP Sybase IQ 15 simplex and multiplex databases.

1. Preparing for a Database Upgrade
   Perform these tasks before upgrading a database to version 16.0.
2. Changes to System Procedures that Perform Privileged Operations
   As part of the enhanced security of role-based security, the way in which privileged system procedures run has changed. Pre-16.0, a privileged system procedure ran with the privileges of its owner, typically dbo, and is referred to as the SYSTEM PROCEDURE DEFINER model. With 16.0, privileged system procedures run with the privileges of the person executing it, and is referred to as the SYSTEM PROCEDURE INVOKER model.
3. Upgrading SAP Sybase IQ 15 Databases
   Perform these steps to upgrade SAP Sybase IQ 15 simplex and multiplex databases to SAP Sybase IQ 16.0.
4. Post Upgrade Status
   SAP Sybase IQ 16 databases upgraded from SAP Sybase IQ 15.x are initially set to run in SAP Sybase IQ 15.x compatibility mode. To complete the change from 15.x to 16.0, you must explicitly change several 15.x compatibility settings to complete the 16.0 upgrade.
5. Regrant the Ability to Run Privileged System Procedures After Upgrade
   The method to regrant the ability to run privileged system procedures after an upgrade depends on the underlying security model of the procedure.
6. Logical Servers
   An SAP Sybase IQ 16.0 multiplex database upgrade changes the way users access multiplex servers. Starting with SAP Sybase IQ 15.4, logical servers provide the only means to access the multiplex server nodes.