Installation guide

Template Modified Files Datatype for <parameter> Changed
from varchar(5) to int
rebuild table
jst_reorg_rebuild_tables
@dump_flag
reclaim indexes
jst_reclaim_index_spac
@dump_flag
reclaim tables
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 16.0 servers.
If you have a job scheduled to run on a pre-16.0 server and you need it to also run on 16.0 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 any jobs you run on pre-16.0 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 9: Modified Job Scheduler Templates
Template Modified File Change Description Job Modifications
delete
statistics
jst_delete_statistics
Added @ptn_name as
third parameter.
Optional.
update
statistics
jst_update_statistics
Added @ptn_name as
fifth parameter,
@datachg_threshold
as the 10th parameter,
and added reference.
Required. Include values
(or NULL) for new param
eters.
rebuild
indexes
jst_reorg_rebuild_indexes
Added @ndx_ptn_name
as third parameter.
Required. Include value (or
NULL) for new parameter.
reclaim
indexes
jst_reclaim_index_space
Added @ptn_name as
third parameter.
Required. Include value (or
NULL) for new parameter.
reclaim
tables
jst_reclaim_table_space
Added @ptn_name as
second parameter.
Required. Include value (or
NULL) for new parameter.
multiple
jst_get_freespace ,
jst_get_usedspace
Replace reserved_pgs
and data_pgs with
reserved_pages and
data_pages.
No impact on job SQL.
94
©
2014 SAP SE or an SAP affiliate company. All rights reserved.
Installation Guide for Linux
SAP ASE Upgrades