Installation guide

Template Modified Files Datatype for <parameter>
Changed from varchar(5)
to int
reclaim tables
SybReclaimTableTem-
plate.xml
jst_reclaim_table_space
@resume_flag
6.
Some Job Scheduler templates have been modified to support new server functionality.
These changes are related to new parameters for specifying a partition name, or a data
change value for the new server commands that added these options. If you have jobs
created from any of the enhanced templates, modify the SQL of the jobs for the 15.7 ESD
#2 servers.
If you have a job scheduled to run on a pre-15.7 ESD #2 server and you need it to also run
on 15.7 ESD #2 servers, leave the existing job alone and create a new job for 15.7 ESD #2
servers, as the job commands are different.
You need not modify jobs you run on pre-15.7 ESD #2 servers. 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 10. Modified Job Scheduler Templates
Template Modified File Change Descrip-
tion
Job Modifications
delete statis-
tics
SybDeleteStat-
sTemplate.xml
jst_delete_sta-
tistics
Added @ptn_name as
third parameter.
Optional.
update sta-
tistics
SybUpdateStat-
sTemplate.xml
jst_update_sta-
tistics
Added @ptn_name as
fifth parameter, @da-
tachg_threshold as
the 10th parameter,
and added reference.
Required. Include val-
ues (or NULL) for new
parameters.
rebuild in-
dexes
SybRebuildIndex-
Template.xml
jst_reorg_re-
build_indexes
Added
@ndx_ptn_name as
third parameter.
Required. Include val-
ue (or NULL) for new
parameter.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 97