CHAPTER 5 Upgrading Adaptive Server

vUpgrading Job Scheduler templates

1 Disable Job Scheduler before ugrading Job Scheduler templates.

2 Update any environment variables, scripts, or applications that refer to the Job Scheduler directory path. The Job Scheduler directory has been renamed and moved beneath the ASE-15_0directory. New location is $SYBASE/$SYBASE_ASE/jobscheduler.

Directories below jobscheduler remain the same.

3If you have any of your own files in the old Job Scheduler directory, copy them to the new 15.0.2 directory. If you are installing Adaptive Server over the old server directories, the installer will have moved your files to the new jobscheduler directory already.

4If you have modified any of the Sybase-supplied templates stored procedures or XML documents, do not overlay the new templates with your versions. If you do, you will lose the enhancements provided by the revised templates. Carefully merge your template changes into the Sybase template files, or better yet, rename your modified templates.

Note Sybase recommends that if you modify Sybase-supplied templates that you save the changes under new names and in new files.

5You may need to make minor modifications to jobs you created from 2.0 or earlier templates. In some templates, parameters changed from varchar(5) to int. The following table lists the templates that changed in version 2.1 and the changes you need to make to jobs created from them.

 

Table 5-1: Changed Job Scheduler templates

 

 

 

 

Modify jobs created

 

 

 

Template

Modified files

Change description

from this template

 

 

 

 

dump database

SybBackupDbToDiskTemplate.xml

Changed the datatype for the

Required, modify job SQL

 

jst_dump_databases

@use_srvr_name parameter

to change

 

from varchar(5) to int

@use_srvr_name to int

 

 

 

 

 

datatype.

 

 

 

 

dump database

SybBackupLogToDiskTemplate.xml

Changed the datatype for the

Required, modify job SQL

log

jst_dump_log

@truncate_flag and

to change @truncate_flag

 

@use_srvr_name parameters

and @use_srvr_name to

 

 

 

 

from varchar(5) to int

int datatype.

 

 

 

 

update

SybUpdateStatsTemplate.xml

Changed the datatype for the

Required, modify job SQL

statistics

jst_update_statistics

@index_flag parameter from

to change @index_flag to

 

varchar(5) to int

int datatype.

 

 

 

 

 

 

Installation Guide

81

Page 94 Page 96
Page 95
Image 95
Sybase 15.0.2 manual Upgrading Job Scheduler templates, Jstdumplog
Page 94 Page 96

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