Post-upgrade tasks

Restoring functionality in Adaptive Server

To reset or enable options or functionality you had to change before the upgrade:

1Reset the configuration parameters.

If you changed any configuration parameters before upgrading, use sp_configure to set them back to their previous values.

2Use sp_dboption to reset any database options you disabled before upgrading.

3After you complete the upgrade, but before you use the upgraded Adaptive Server, verify that all scripts developed at your site point to Adaptive Server 15.0.2.

4Verify procedure cache allocation after upgrading.

This section is for information only. Adaptive Server ensures that procedure cache size after upgrade is the same as before upgrade, unless the original size was less than the default value.

If you are upgrading from a version of Adaptive Server that is earlier than version 12.5.x, procedure cache percent has been changed to procedure cache size. Adaptive Server now allocates memory dynamically and determines the size of the procedure and data caches in terms of megabytes. During the upgrade process, Adaptive Server converts the

procedure cache percent to an absolute value and sets procedure cache size based on this value.

For example, if procedure cache percent is configured as 20 percent of 200MB of memory, then the absolute value of procedure cache percent is 40MB. During the upgrade process, Adaptive Server converts procedure cache percent at 20 percent to procedure cache size at 40MB. If the value for procedure cache size is less than the default value, Adaptive Server sets procedure cache size to the default value. For example, if procedure cache percent is set to 10 percent in the example above, and the absolute value of 10 percent is less than the default value of procedure cache size, then procedure cache size is set to the default value.

With the introduction of dynamically reconfigured memory configuration parameters in Adaptive Server 12.5.x, an increase in Adaptive Server’s memory use does not decrease the size of the procedure cache or the data cache. That is, if your default data cache is set to 40MB, and you increase your procedure cache, the default data cache is still 40MB.

For more information about sp_configure, see the Reference Manual.

72

Adaptive Server Enterprise

Page 85 Page 87
Page 86
Image 86
Sybase 15.0.2 manual Restoring functionality in Adaptive Server, Post-upgrade tasks
Page 85 Page 87

15.0.2 specifications

Sybase 15.0.2, a product of the Sybase corporation (now SAP), is a relational database management system (RDBMS) that provides robust solutions for data management, security, and performance. This version builds upon its predecessors, offering improved features and enhancements that cater to both enterprises and developers.

One of the standout features of Sybase 15.0.2 is its advanced performance capabilities. The version introduces optimization enhancements such as the Query Optimizer, which is designed to ensure efficient execution of complex queries. This optimizer analyzes SQL statements and tables to choose the most efficient means of retrieval, thus reducing execution time and improving the overall performance of the database.

Sybase 15.0.2 supports improved scalability, allowing organizations to handle increased workloads without significant changes to their infrastructure. This scalability is crucial for businesses experiencing growth, as it ensures that performance remains consistent and reliable.

Another notable characteristic is the robust security architecture integrated within Sybase 15.0.2. The system includes features like data encryption, user authentication, and authorization mechanisms, making it suitable for environments that handle sensitive information. Database administrators can implement fine-grained access controls to manage user permissions effectively.

Moreover, Sybase 15.0.2 boasts support for a wide range of programming languages and frameworks. This versatility allows developers to build applications using their preferred tools, promoting productivity and ease of integration into existing systems. The database management system also supports various platforms, including Windows and UNIX, enabling diverse deployments across different environments.

In addition to these technological enhancements, Sybase 15.0.2 emphasizes data integrity through its robust transaction management system. It implements the ACID properties (Atomicity, Consistency, Isolation, Durability) to ensure that all database transactions are processed reliably, thereby maintaining the integrity of data even in high-transaction scenarios.

In conclusion, Sybase 15.0.2 is a feature-rich RDBMS that combines performance, scalability, security, and flexibility. Its advanced capabilities not only enhance data management for organizations but also provide a solid foundation for developers seeking to create efficient and secure applications. The improvements in this version make it a compelling choice for enterprises looking to optimize their database operations in an increasingly data-driven world.
Top Page Image Contents