FoDelay

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

SvrFailover