Changin Hostname ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dirk Deimeke - 01 Dec 2005 05:22 GMT

Hi,

one Windows administrator changed the servername (hostname) of one of
our database servers.

What changes do I have to to to get my databases connected?

The catalog statements have to be adjusted, I know.

I changed the admin configuration too and I don't know what to do with
the spm name.

Server is Windows 2003 standard, DB2 Version 8.1 Fixpack 7 (with special
build).

Any hints?

Kind regards

Dirk

Signature

Blog: http://www.deimeke.net/dirk/blog/

Reply to this Message

Hardy - 01 Dec 2005 06:52 GMT

edit your db2nodes.cfg and replace the old hostname to new one.

the file is located on $DB2_INSTALL_PATH/sqllib/$INSTANCE_NAME/

Reply to this Message

Mark Yudkin - 02 Dec 2005 10:01 GMT

Publish the databases in the Active Directory instead of cataloguing them on
the clients. That way you don't have to do anything whatsoever in the
clients when you change the location of a database (host rename can be
considered a location change), you merely have to alter the AD
configuration.

> Hi,
>
[quoted text clipped - 16 lines]
>
> Dirk

Reply to this Message

Dirk Deimeke - 02 Dec 2005 11:01 GMT

Mark Yudkin <myudkinATcompuserveDOTcom@boingboing.org> schrieb:

> Publish the databases in the Active Directory instead of cataloguing them on
> the clients. That way you don't have to do anything whatsoever in the
> clients when you change the location of a database (host rename can be
> considered a location change), you merely have to alter the AD
> configuration.

All the database are up and running, but I have problems to reach the
admin server ...

Unfortunately I have no access on ADS.

DIrk

Reply to this Message

Mark Yudkin - 02 Dec 2005 13:14 GMT

Talk to your system administrators. They should be very interested in
helping you use AD rather than having to recatalogue databases on hundreds
of client workstations (at least, the administrators where I've been have
always found it a good idea).

Did you issue a suitable UPDATE ADMIN CONFIGURATION command (after following
Hardy's advice)?

> Mark Yudkin <myudkinATcompuserveDOTcom@boingboing.org> schrieb:
>
[quoted text clipped - 11 lines]
>
> DIrk

Reply to this Message