DBI DB2 Federated

[Terry]

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

[Rob Wilson]

Re: DBI DB2 Federated

Terry wrote:[color=blue]
> 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[/color]

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.

--
Rob Wilson
rob_wilson_at_a meritech.net (replace _at_ with @)