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

Change DB2 client config from remote system?

P: n/a
Howdy

I'm new to working with DB2 Universal, so I'm not very familiar with
the tools. I usually only use the Java Control Center and
Configuration Assistant.

I have several clients on the local LAN connecting to an DB2 Universal
8.2 server. If that server goes down for some reason, I'd like to
remotely shut down the client applications (I can do that), then
change the DB2 configuration on the clients to connect to the backup
server.

I was hoping that the client configuration would be in some sort of
text file so I could edit it over a network share, but it appears to
be a binary file. Is there a way to change the client config over a
ntework like this?

I don't want the users to have to go to each machine to change the
configuration, or to have to directly use an IBM program.

Thanks
DK
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Ian
David Knaack wrote:
Howdy

I'm new to working with DB2 Universal, so I'm not very familiar with
the tools. I usually only use the Java Control Center and
Configuration Assistant.

I have several clients on the local LAN connecting to an DB2 Universal
8.2 server. If that server goes down for some reason, I'd like to
remotely shut down the client applications (I can do that), then
change the DB2 configuration on the clients to connect to the backup
server.

I was hoping that the client configuration would be in some sort of
text file so I could edit it over a network share, but it appears to
be a binary file. Is there a way to change the client config over a
ntework like this?


You could write a program that runs on each client PC and calls the
appropriate DB2 APIs to make this change.
If you catalog the connections using hostnames (not IP addresses)
and you use DNS, you could update your DNS server (or, better, point
clients at an alias, which you can change as needed).

The best solution here is probably to investigate using an HA cluster
tool, so you can fail over the IP address from one server to the
other.
Of course in Stinger, automatic client reroute will provide another
solution.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

P: n/a
We flick the DNS alias to alter the machine, and use LDAP cataloguing to
keep connection configuration information central. Finally, we replicate all
disk in hardware (Hitachi SAN).
"David Knaack" <da*********@cox.net> wrote in message
news:7a**************************@posting.google.c om...
Howdy

I'm new to working with DB2 Universal, so I'm not very familiar with
the tools. I usually only use the Java Control Center and
Configuration Assistant.

I have several clients on the local LAN connecting to an DB2 Universal
8.2 server. If that server goes down for some reason, I'd like to
remotely shut down the client applications (I can do that), then
change the DB2 configuration on the clients to connect to the backup
server.

I was hoping that the client configuration would be in some sort of
text file so I could edit it over a network share, but it appears to
be a binary file. Is there a way to change the client config over a
ntework like this?

I don't want the users to have to go to each machine to change the
configuration, or to have to directly use an IBM program.

Thanks
DK

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.