Changing hostname ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dirk Deimeke - 28 Nov 2005 15:47 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

Reply to this Message

Gregor Kovač - 30 Nov 2005 11:40 GMT

Hi!

In SQLLIB/DB2/db2nodes.cfg you have to change the hostname in order to DB2
even start.

Best regards,
Kovi

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

Reply to this Message

Dirk Deimeke - 01 Dec 2005 15:20 GMT

Gregor Kovaè <gregor.kovac@mikropis.si> schrieb:

> In SQLLIB/DB2/db2nodes.cfg you have to change the hostname in order to DB2
> even start.

Ok. Thank you!

I already replaced all occurrences.

Dirk

Reply to this Message

Dirk Deimeke - 01 Dec 2005 15:25 GMT

Gregor Kovaè <gregor.kovac@mikropis.si> schrieb:

> In SQLLIB/DB2/db2nodes.cfg you have to change the hostname in order to DB2
> even start.

I found the SPM_NAME of every instance which carries the hostname and
db2set has hostname informations in DB2INSTOWNER and DB2ACCOUNTNAME.

Is it safe to change them?

Kind regards

Dirk

Reply to this Message

Gregor Kovač - 05 Dec 2005 13:29 GMT

Hi!

This SPM_NAME parameter is derived from the hostname as the documentation
(http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/admin/r0000339.htm)
says, but you can change it at will.
You can also read more at
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.ud
b.doc/ad/c0006975.htm

This parameter is valid in two-phase commit environments.

Best regards,
Kovi

> Gregor Kova? <gregor.kovac@mikropis.si> schrieb:
>
[quoted text clipped - 9 lines]
>
> Dirk

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Reply to this Message

Dirk Deimeke - 08 Dec 2005 15:19 GMT

Gregor Kovaè <gregor.kovac@mikropis.si> schrieb:

> This parameter is valid in two-phase commit environments.

Thanks a lot!

Dirk

Reply to this Message