Finding DB2 instances and databases

[Tim]

Hello Everyone

I'd like to create a script/program that can locate all servers running
DB2, finding out which instances are running/created and what databases
are running under them but have been told but IBM support that this
isn't currently possible for a client to do. I'd like to get a second
opinion since the CCA seems to be able to manage it without any
problems so the API must be there to do it.

The main reason why I'd like this is to ensure that our documentation
is correct. We have a fair number of servers, DB2 instances and
databases out there and we also have the nasty habit of moving them
around from time to time. Depending on who does this the documentation
is more or less up to date. Using some sort of discovery
script/program will reduce the need for documenation and ensure that
the documentation that we have is up to date with respect to what's
actually running.

thanks in advance
tim

[Gert van der Kooij]

In article <11**********************@f14g2000cwb.googlegroups .com>,
Tim (ku******@gmail.com) says...

Hello Everyone

I'd like to create a script/program that can locate all servers running
DB2, finding out which instances are running/created and what databases
are running under them but have been told but IBM support that this
isn't currently possible for a client to do. I'd like to get a second
opinion since the CCA seems to be able to manage it without any
problems so the API must be there to do it.

The main reason why I'd like this is to ensure that our documentation
is correct. We have a fair number of servers, DB2 instances and
databases out there and we also have the nasty habit of moving them
around from time to time. Depending on who does this the documentation
is more or less up to date. Using some sort of discovery
script/program will reduce the need for documenation and ensure that
the documentation that we have is up to date with respect to what's
actually running.

thanks in advance
tim

Hi,
Maybe it's an option to schedule a script on each DB2 server to
create a list of local instances and databases and mail it to an
administrator or put this list in a shared folder?

[Tim]

That would work but it requires more things to be installed on a given
server beyond what is already installed. Its something that I did
consider but it would be cleaner to avoid having to install extra
scripts on a server since I can see the Client Configuration Assistant
do what I'm after. I'm trying to get a zero administration solution if
possible.

[Jan M. Nelken]

Tim wrote:

Hello Everyone

I'd like to create a script/program that can locate all servers running
DB2, finding out which instances are running/created and what databases
are running under them but have been told but IBM support that this
isn't currently possible for a client to do. I'd like to get a second
opinion since the CCA seems to be able to manage it without any
problems so the API must be there to do it.

CCA uses Discovery protocol and API's which are not externalized and I am not
aware of any plans to externalise them soon.

Jan M. Nelken