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.
When to specify SvrFailover
You must specify the SvrFailover parameter before connecting to
the database.
Applies to
ASE or SYC SAP Adaptive Server Enterprise (12.0 and higher
database connections only)
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
|
1 |
SvrFailover='value' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether you want PowerBuilder to
|
Default value
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:
1SQLCA.DBParm="SvrFailover='Yes'"
See also