By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Finding DB2 instances and databases

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?
Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.