A DPE showing whether the archiving server is offline

[Natty]

I am looking for a DPE that shows the connection state of an archiving server. The RDB Manager has been configured correctly so far. I have been looking to the DPE "_RDBArchive.dbConnection.connected" (boolean) but its state doesn't switch when I unplug the ethernet wire linking the archiving server to the dedicated network.

Do you know any other DPE which would fit?

[Gertjan van Schijndel]

When the rdb manager has detected the lost connection to the database it will set this dpe. In my experience it can take a couple of minutes before the manager detects the lost connection. When it takes much longer than you should the settings which are mentioned in the online help under -> System management -> Database -> RDB Archiving -> Requirements and Installation -> First-Time Installation -> Point I.8
.) Add the line "(ENABLE=BROKEN)" in 'tnsnames.ora'
.) Windows: Set the registry entry 'HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\Tcpip\\Parameters\\KeepAliveTime' to 180000
.) Linux: Set the 'sysctl.conf' config entry 'net.ipv4.tcp_retries2' to 2

[Natty]

I have already done these things but the dpe state still doesn't switch when connection to the database is lost. Lost connection is detected after UI restart only.

[leoknipp]

Restarting the UI will not have an effect on a dp element written by the RDB manager.
Are you using a dpConnect() to get the state of the dp element?

The RDB manager does not have a real watchdog implemented for the connection to the Oracle database. E.g. if the connection to the Oracle db is lost and not data is written or read the RDB manager will not detect that the connection is lost.
In normal conditions where data is written all the time the RDB manager will detect quickly if the connection is lost.

Best Regards
Leopold Knipp
Senior Support Specialist