Installation guide

1> sp_configure "number of locks", 9000
2> go
5.
Upgrade the internal Job Scheduler SQL code using:
1> use sybmgmtdb
2> go
1> dbcc upgrade_object
2> go
6.
Restart Adaptive Server.
7.
(Optional) Add more log space. Some 64-bit platforms require additional space for the
sybmgmtdb log:
1> use master
2> go
1> alter database sybmgmtdb LOG on sybmgmtdev=20
2> go
8.
To upgrade sybmgmtdb, run the installjsdb script that is included and save the
output to a file:
isql -Usa -Psa_password -Sservername -n -i$SYBASE/$SYBASE_ASE/
scripts/installjsdb
-ooutput_file
Note: When upgrading from Adaptive Server version 12.5.x to 15.5 and later, increase the
size of sybmgmtdb from 50MB to 90MB.
9.
Enable Job Scheduler to start when Adaptive Server starts:
sp_configure "enable job scheduler", 1
10.
To start Job Scheduler from isql, enter:
sybmgmtdb..sp_sjobcontrol @name=NULL, @option="start_js"
go
Upgrading Job Scheduler Templates
After upgrading to the new server, upgrade the templates and jobs created by Job Scheduler.
Note: Several changes impact the Job Scheduler templates. These changes make some
templates incompatible with earlier versions of the server. The current templates are version
3.0 in the XML files.
1.
Disable Job Scheduler.
2.
Update any environment variables, scripts, or applications that refer to the Job Scheduler
directory path. The Job Scheduler directory has been renamed and moved beneath the
ASE-15_0 directory. The new location is $SYBASE/$SYBASE_ASE/
jobscheduler .
Directories below jobscheduler remain the same.
3.
Copy files from the jobscheduler directory to the ASE-15_0 directory. If you are
installing the new server directories over the old server directories, the installer
automatically moves your files to the new jobscheduler directory.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 95