Download View this document as PDF

CHAPTER 5
6
Upgrading Adaptive Server
Some Job Scheduler templates were modified to support new 15.0.3
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.3
servers.
Note If you have a job scheduled to run on a pre-15.0.3 server and you
need it to run on 15.0.3 servers too, leave the existing job alone and create
a new job for 15.0.3 servers as the job commands are different.
Jobs intended to run on pre-15.0.3 servers do not need to be modified. The
following table lists the templates that changed in version 3.0 and the
changes you must 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
are 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-3: Modified Job Scheduler templates
Template
delete statistics
update
statistics
rebuild indexes
Modified file
SybDeleteStatsTemplate.xml
jst_delete_statistics
SybUpdateStatsTemplate.xml
jst_update_statistics
SybRebuildIndexTemplate.xml
jst_reorg_rebuild_indexes
reclaim indexes
SybReclaimIndexTemplate.xml
jst_reclaim_index_space
reclaim tables
SybReclaimTableTemplate.xml
jst_reclaim_table_space
Installation Guide
Change description
Added @ptn_name as
third parameter.
Added @ptn_name as
fifth parameter and
@datachg_threshold as
the 10th parameter and
added reference
Added @ndx_ptn_name
as third parameter.
Added @ptn_name as
third parameter
Added @ptn_name as
second parameter
Modify jobs created
from this template
Optional.
Required, modify job SQL
to include values (or NULL)
for new parameters.
Required, modify job SQL
to include value (or NULL)
for new parameter.
Required, modify job SQL
to include value (or NULL)
for new parameter.
Required, modify job SQL
to include value (or NULL)
for new parameter.
89