DBI DB2 Federated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry - 14 Jul 2004 13:58 GMT

Hi All,

Im using DBI/DBD to connect to a db2 federated database. Id like to
detect if the different databases in the federated groups are active.
DBI provides the $dbh->ping command, but this only tells me is the
main database is active. How can I detect if the other databases are
active.

Thanks

Terry

Reply to this Message

Rob Wilson - 14 Jul 2004 14:56 GMT

> Hi All,
>
[quoted text clipped - 7 lines]
>
> Terry

Attempt to select from a nickname for each remote data source. I've
done this on some systems by creating a special nickname just for this
purpose.

Signature

Rob Wilson
rob_wilson_at_ameritech.net (replace _at_ with @)

Reply to this Message