![Sybase Adaptive Server 15.0.2 Скачать руководство пользователя страница 99](http://html1.mh-extra.com/html/sybase/adaptive-server-15-0-2/adaptive-server-15-0-2_installation-manual_1416502099.webp)
CHAPTER 5 Upgrading Adaptive Server
Installation Guide
85
9
Manually restart Adaptive Server on each cluster node with trace flag
2209. Use the Adaptive Server command-line option
-T2209
.
Warning!
Do not use trace flag 2209 after the Adaptive Server
companionship is re-established.
10 Use the cluster system command to restart monitoring resources
associated with Adaptive Server on each cluster node.
11 Re-establish companionship by using
isql
to issue:
sp_companion <
primary_server_name
>, configure
go
If user databases exist on the secondary server, warning message may
display on the console. There is no need to take any action. You can safely
ignore them. The messages look similar to:
Msg 18739, Level 16, State 1:
Server 'svr2', Procedure 'sp_hacmpcfgvrfy', Line 102:
Database 'svr2_db1': a user database exists. Drop this
database and retry the configuration again.
12 Use the cluster command to offline and then online resource associated
with Adaptive Server. Use
isql
to connect to each Adaptive Server and
enter the command to verify the correct server companionship:
sp_companion
go
Console output on primary server is similar to the following:
Server 'svr1' is alive and cluster configured.
Server 'svr1' is configured for HA services.
Server 'svr1' is currently in 'Primary normal' mode.
(return status = 0)
Console output on secondary server is similar to the following:
Server 'svr2' is alive and cluster configured.
Server 'svr2' is configured for HA services.
Server 'svr2' is currently in 'Secondary normal'
mode.
(return status = 0)
Use the following steps to upgrade high availability-enabled Adaptive Servers
in active-passive configuration:
1
Use the cluster system command to bring Adaptive Server offline.
Содержание Adaptive Server 15.0.2
Страница 1: ...Installation Guide Adaptive Server Enterprise 15 0 2 HP UX...
Страница 104: ...Recovering from a failed upgrade 90 Adaptive Server Enterprise...
Страница 114: ...Enabling and changing e mail notifications 100 Adaptive Server Enterprise...
Страница 132: ...Upgrading compiled objects with dbcc upgrade_object 118 Adaptive Server Enterprise...
Страница 136: ...Removing an old server 122 Adaptive Server Enterprise...
Страница 144: ...Configuration using resource files 130 Adaptive Server Enterprise...
Страница 156: ...Increasing device and database capacity for system procedures 142 Adaptive Server Enterprise...
Страница 160: ...Index 146 Adaptive Server Enterprise...