Documentation Updates

Read about updates to the documentation released with Adaptive Server.

Upgrading Job Scheduler

The steps for upgrading Job Scheduler after an upgrade have changed for 15.7 SP121. After upgrading to a new server, upgrade Job Scheduler using these steps.

Note: The directory with the isql executable must be in your path:

UNIX - $SYBASE/$SYBASE_OCS/bin
Windows - %SYBASE%\%SYBASE_OCS%\bin

Copy the directory services entry for JSAGENT (or jsagent) from the old server to the new server.
Make sure the new server is running.
Ensure that at least 9000 locks are configured. If the number of locks on the server is fewer than 9000, increase it:
```
1> sp_configure "number of locks", 9000
2> go
```
Before you restart Adaptive Server and run Job Scheduler, run the installjsdb script to update Job Scheduler tables and stored procedures:
1. Disable Job Scheduler:
```
1> sp_configure "enable job scheduler", 0
2> go
1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
2> go
```
2. Run the installjsdb script:
  For UNIX:
```
isql –Usa –Psa_password –Sservername
–i$SYBASE/$SYBASE_ASE/scripts/installjsdb
```
  For Windows:
```
isql –Usa –Psa_password –Sservername
–i%SYBASE%\%SYBASE_ASE%\scripts\installjsdb
```
  The installjsdb script looks for the sybmgmtdb database.
3. Enable Job Scheduler:
```
 sp_configure "enable job scheduler", 1
```
4. To start Job Scheduler, either restart the server, or enter:
```
1> use sybmgmtdb
2> go
1> sp_sjobcontrol @name=NULL, @option="start_js"
2> go
```
Restart Adaptive Server if you restarted Job Scheduler manually.
(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
```

To upgrade sybmgmtdb, run the installjsdb script that is included, saving the output to a file:

For UNIX:

isql -Usa -Psa_password -Sservername -n -i$SYBASE/$SYBASE_ASE/scripts/installjsdb
-ooutput_file

For Windows:

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 at least 160MB. sybmgmtdb must have free log space of at least 60MB.