Description
Specifies the amount of time (in milliseconds) you want PowerBuilder to wait between attempts to fail over to another database server if the current database server goes down.
When to specify FoDelay
You must specify the FoDelay parameter before connecting to the database.
Applies to
O90 Oracle9i
O10 Oracle 10g
ORA Oracle (for 11g and later)
Syntax
FoDelay='value'
Parameter |
Description |
---|---|
value |
Specifies the amount of time in milliseconds you want PowerBuilder to wait between attempts to fail over to an another database server. |
Default value
FoDelay='10'
Usage
You can enter a failover delay value only if you have enabled failover.
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 wait 20 milliseconds between attempts to fail over:
-
Database profile
Type 20 in the Delay box on the Network page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="FoDelay='20'"
See also