Installation guide

4.
If you modified Sybase-supplied templates, stored procedures, or XML documents, do not
overlay the new templates with your modified versions. If you do, you 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: If you modify Sybase-supplied templates, save the changes under new names and in
new files.
5.
You 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 must
make to the SQL code in the jobs created from the templates.
Table 9. Changed Job Scheduler Templates
Template Modified Files Datatype for <parameter>
Changed from varchar(5)
to int
dump database
SybBackupDbToDiskTem-
plate.xml
jst_dump_databases
@use_srvr_name
dump database
log
SybBackupLogToDiskTem-
plate.xml
jst_dump_log
@truncate_flag and
@use_srvr_name
update statistics
SybUpdateStatsTem-
plate.xml
jst_update_statistics
@index_flag
rebuild indexes
SybRebuildIndexTem-
plate.xml
jst_reorg_rebuild_in-
dexes
@dump_flag
rebuild table
SybRebuildTableTem-
plate.xml
jst_reorg_rebuild_ta-
bles
@dump_flag
reclaim indexes
SybReclaimIndexTem-
plate.xml
jst_reclaim_index_spac
@dump_flag
CHAPTER 10: Adaptive Server Upgrades
96 Adaptive Server Enterprise