SvrFailover – PB Docs 126

SvrFailover database parameter

Description

Specifies whether you want PowerBuilder to recognize and participate
in failover to a designated backup database server if the current
database server goes down.

note.png When to specify SvrFailover

You must specify the SvrFailover parameter before connecting
to the database.

Controls

  • ASE, SYC or SYJ SAP
    Adaptive Server Enterprise (12.0 and higher database connections
    only)

  • O90 Oracle9i

  • O10 Oracle 10g

  • ORA Oracle 11g

Syntax

Parameter

Description

value

Specifies whether you want PowerBuilder to
recognize and participate in failover to a designated backup database
server if the current database server goes down. Values are:

  • No

    (Default) PowerBuilder should not recognize or participate in
    failover.

  • Yes

    PowerBuilder should recognize and participate in failover.

Default

SvrFailover=’No’

Usage

Both Oracle and SAP support database server failover in Oracle
Version 8.1.5 or later and Adaptive Server 12 or later. For information
about how to configure failover for these database servers, see
your Oracle or Adaptive Server documentation. To avoid losing your PowerBuilder database connection
(as the result of a timeout) when a failover takes place, set the SvrFailover
parameter so that PowerBuilder recognizes and participates in the database
server failover.

Oracle also allows you some control over the failover process.
Three additional parameters allow you to specify the number of times
you want the database server to which you are connected to attempt
a failover, how long to wait between failover attempts, and whether PowerBuilder should
display a runtime dialog box indicating when a failover occurs.

This parameter cannot be set dynamically. The value set when
the connection is made remains in effect until it is disconnected.

Examples

To tell PowerBuilder to recognize and participate in
failover:

  • Database profile

    Select the Allow Server Failover check box on the Network
    page in the Database Profile Setup dialog box.

  • Application

    Type the following in code:

See Also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x