nek wrote:
Greetings,
Platform is W2K, DB2 V8.1 FP2.
We have a large number of servers in different cities and I would like
to occasionally update 'db cfg' parameters whenever needs arise.
Instead of connecting to each server (via remote desktop connection)
to do this, is it possible to write script containing 'db2 update db
cfg for dbname..' and other info such as 'connecting to IP addresses
of all servers' etc.. so that change can be applied to all nominated
servers in ONE hit?
I'll skip the question on why you'd want to change a DB config parameter
on all of your instances databases.
Anyway, provided that all of your instances and databases are cataloged
on one system, you should be able to write the following commands in a
script:
attach to <an_instance> [user <id> using <pw>]
update db cfg for <db> using ...
[repeat for other databases in this instance]
detach
[repeat all steps for other instances/databases
You can see the progress of this by running 'db2 -v yourscript'
Good luck,
-----= 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! =-----