Upgrading job scheduler – Sybase 15.0.2 User Manual

Page 93

Advertising
background image

CHAPTER 5 Upgrading Adaptive Server

Installation Guide

79

7

Back up all existing databases before upgrading. Once you have done so,
select Yes.

8

When the upgrade is complete, the

syconfig

utility displays the message,

“Upgrade completed successfully.” Select OK.

Repeat this procedure to upgrade Monitor Server.

Note

To check the upgrade, use the Windows Notepad to view the log file in

%SYBASE%\%SYBASE_ASE%\init\logs

Upgrading Job Scheduler

After upgrading to the new Adaptive Server, perform the following steps to
upgrade Job Scheduler.

Note

You must have $SYBASE/$SYBASE_OCS/bin directory in $PATH so the

isql

executable is accessible.

v

Upgrading Job Scheduler

1

Copy the directory services entry for JSAGENT (or jsagent) from the old
server to the new server.

2

Make sure your new server is running.

3

Stop the Job Scheduler. From

isql

, issue:

sybmgmtdb..sp_js_wakeup "stop_js", 1

go

4

Ensure that at least 9000 locks are configured. If the number of locks on
the server is less than 9000, use

sp_configure

to increase the number of

locks:

sp_configure "number of locks", 9000

5

Upgrade the internal Job Scheduler SQL using

isql

:

use sybmgmtdb

go

dbcc upgrade_object

go

Advertising