Database Upgrades

Migrate an 16.0 15.x database to 16.0 database, set the system procedure security model, and review the post-migration compatibilty changes required to complete the migration.

• 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 the DBO system role, 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.
• Database Upgrade Procedures
  Procedures to upgrade SAP Sybase IQ 15 databases and set the system procedure security model.
• 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.
• 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.
• Hardware Changes
  Perform these steps to move your software to a new hardware platform.