Upgrading Job Scheduler

 

 

 

Modify jobs created

Template

Modified files

Change description

from this template

 

 

 

 

rebuild indexes

SybRebuildIndexTemplate.xml

Changed the datatype for the

Required, modify job SQL

 

jst_reorg_rebuild_indexes

@dump_flag parameter from

to change @dump_flag to

 

varchar(5) to int

int datatype.

 

 

 

 

 

 

rebuild table

SybRebuildTableTemplate.xml

Changed the datatype for the

Required, modify job SQL

 

jst_reorg_rebuild_tables

@dump_flag parameter from

to change @dump_flag to

 

varchar(5) to int

int datatype.

 

 

 

 

 

 

reclaim indexes

SybReclaimIndexTemplate.xml

Required, modify job SQL to

Required, modify job SQL

 

jst_reclaim_index_spac

change @dump_flag to int

to change @resume_flag

 

datatype.

to int datatype.

 

 

 

 

 

 

reclaim tables

SybReclaimTableTemplate.xml

Changed the datatype for the

Required, modify job SQL

 

jst_reclaim_table_space

@resume_flag parameter

to change @resume_flag

 

from varchar(5) to int

to int datatype.

 

 

 

 

 

 

6Some Job Scheduler templates were modified to support new 15.0.2 Adaptive Server functionality. The changes are related to new parameters for specifying a partition name or a datachange value for the Adaptive Server command that have added these options. If you have jobs created from any of the enhanced templates, modify the SQL of the jobs for 15.0.2 servers.

Note If you have a job scheduled to run on a pre-15.0.2 server and you need it to run on 15.0.2 servers too, leave the existing job alone and create a new job for 15.0.2 servers as the job commands will be different.

Jobs intended to run on pre-15.0.2 servers do not need to be modified. The following table lists the templates that changed in version 3.0 and the changes you need to make to jobs created from them.

Note All templates listed below, except Delete Statistics, are incompatible with pre-15.0.1 servers. Do not use them to create jobs that will be scheduled on pre-15.0.1 servers; you must use the 2.1 or 2.2 versions for pre-15.0.1 servers.

 

Table 5-2: Modified Job Scheduler templates

 

 

 

 

Modify jobs created

Template

Modified file

Change description

from this template

 

 

 

 

delete statistics

SybDeleteStatsTemplate.xml

Added @ptn_name as

Optional.

 

jst_delete_statistics

third parameter.

 

 

 

 

 

 

 

 

82

Adaptive Server Enterprise

Page 95 Page 97
Page 96
Image 96
Sybase 15.0.2 manual SybDeleteStatsTemplate.xml
Page 95 Page 97

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