DB2 Client Configuration Assistant Help!

[GregE240]

Long shot this I know, but does anyone out there know the DB2 Client Config Assistant in W2K/NT4?

Basically I need to change a hostname on a database - its currently pointing at ServerA and I need it to point at ServerB.

I'd need to automate it but it doesn't store it in the Registry, possibly some sort of config file?

If anyone can tell me where I'd be really grateful!

Thanks,
Greg

[plotloss]

Chill Jules.

I'm on the Mother F**ker...

[plotloss]

1. Issue

DB2 LIST ADMIN NODE DIRECTORY SHOW DETAIL

Example Output:

Node Directory

Number of entries in the directory = 1

Node 1 entry:

Node name = MYNODE
Comment = Local workstation
Protocol = LOCAL
Instance name = DB2DAS00
Remote instance name =
System = MYSYSTEM
Operating system type = NT


Write down the node name.


2. Issue DB2 UNCATALOG NODE node_name
where node_name denotes the node name from step 1.

3. Issue DB2 CATALOG ADMIN LOCAL NODE node_name
INSTANCE DB2DAS00
SYSTEM system_name
OSTYPE NT
WITH "My Local Machine"

where node_name denotes the node name you wrote down in step1,
system_name denotes your desired new system name.

Note that this is a single command, if using the db2 CLP you may
want to replace " with ".

4. Issue DB2 TERMINATE

5. Issue DB2SET -G DB2SYSTEM=system_name

where system_name is new system name.

Automating it, not sure, perhaps throw key strokes at a dos window to allow the entry of the above?

[GregE240]

Thanks Matt.

Didn't work though. The client version is 7.2.

Basically, if I bring up the Client Config Assistant, there is one entry for the live database we are connecting to. I could go in manually and change the host name over the weekend but I want to automate it? I think you're on the right lines - some sort of DB2 command is required.

Any ideas?

[plotloss]

Bugger.

Back on it.

I'd make a crap CrimeLord...

[GregE240]

Any joy Matt?

[plotloss]

Havent had much time, sorry mate, will continue poking after luncheon.

Anything here?