Db2 help needed

[Lan W via DBMonster.com]

Hi,

How to change the Db2 server's IP address? I have DB2 UDB 7.1 installed on
AIX 5.2 machine and DB2 UDB 8.1 installed on Linux machine.

Thanks!
Lan
--
Message posted via http://www.dbmonster.com

[Pierre Saint-Jacques]

I presume you now want to go to the Linux server instead of the AIX machine.
Easiest is to give the Linux server IPaddress the address of the AIX box and
a new address to your old AIX box, in your DNS hosts file.

If you can't play with actual adresses, then you play with names.
Change your AIX hostname to SOMENAME and then set your Linux server's
hostname NEWNAME, where newname is the former name of your old AIX db27.1
server.
SOMENAME keeps its IP address and NEWNAME should have the new address of the
Linux box.
This way nothing else needs to change and it is transparent to all your
users.

If, for whatever reason, you can't play with the hosts file, then, for each
workstation that needs to connect to Linux Server:
you will need to uncatalog both the DAS node and any instance nodes.
db2 list node directory
Identify and pick the ones that are of concern to you
db2 uncatalog node <dasnodename>
db2 uncatalog node <inst1name> ... etc.

Then you nedd to recatalog them using the command, for the DAS:
CATALOG ADMIN TCPIP NODE dasnodename REMOTE hostname [SYSTEM system-name]
[OSTYPE os-type] [WITH "comment string"]
and then for each instance:
CATALOG TCPIP NODE yourchoice REMOTE NEWNAME SERVER <INSTANCE svcename or
PORTNO>

HTH, Pierre.
--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Lan W via DBMonster.com" <fo***@DBMonster.com> a écrit dans le message de
news: 51***********@DBMonster.com...

Hi,

How to change the Db2 server's IP address? I have DB2 UDB 7.1 installed on
AIX 5.2 machine and DB2 UDB 8.1 installed on Linux machine.

Thanks!
Lan
--
Message posted via http://www.dbmonster.com

[Lan W via DBMonster.com]

Hi,

Thanks for reply. Actually, I need to change the two server's IP address to
something new, since we moved both server to a new location recently. No
relation between the two servers.
My question is how to change the DB2 server's IP address that has DB2 UDB 8.1
installed on a linux RHEL 3. aslo I need to do the same thing on the AIX
server.

kindly help!
Thanks!
Lan
Pierre Saint-Jacques wrote:

I presume you now want to go to the Linux server instead of the AIX machine.
Easiest is to give the Linux server IPaddress the address of the AIX box and
a new address to your old AIX box, in your DNS hosts file.

If you can't play with actual adresses, then you play with names.
Change your AIX hostname to SOMENAME and then set your Linux server's
hostname NEWNAME, where newname is the former name of your old AIX db27.1
server.
SOMENAME keeps its IP address and NEWNAME should have the new address of the
Linux box.
This way nothing else needs to change and it is transparent to all your
users.

If, for whatever reason, you can't play with the hosts file, then, for each
workstation that needs to connect to Linux Server:
you will need to uncatalog both the DAS node and any instance nodes.
db2 list node directory
Identify and pick the ones that are of concern to you
db2 uncatalog node <dasnodename>
db2 uncatalog node <inst1name> ... etc.

Then you nedd to recatalog them using the command, for the DAS:
CATALOG ADMIN TCPIP NODE dasnodename REMOTE hostname [SYSTEM system-name]
[OSTYPE os-type] [WITH "comment string"]
and then for each instance:
CATALOG TCPIP NODE yourchoice REMOTE NEWNAME SERVER <INSTANCE svcename or
PORTNO>

HTH, Pierre.

Hi,

[quoted text clipped - 4 lines]

Thanks!
Lan

--
Message posted via http://www.dbmonster.com

[Phil Sherman]

Linux - try looking in /etc/sysconfig/network-scripts
You should find a file ifcfg-eth0 (or similar) that contains information
about the adapter configuration. When using DHCP, this is where it's
told to use DHCP so I assume that a fixed address will be specified here.

I also think you can run the linux configurator and change the IP
address there, but it should end up in the same file.

As a last resort, you can add an ifcfg command to /etc/rc.local to
change to the new IP address.

You should also check Red Hat's info base to see if your question is
answered there. Your RHEL3 maintenance contract allows you to ask RH
using your support mechanism.

Don't forget that you will also probably have to change the default
router if you are on a different network segment.

Phil Sherman

Lan W via DBMonster.com wrote:

Hi,

Thanks for reply. Actually, I need to change the two server's IP address to
something new, since we moved both server to a new location recently. No
relation between the two servers.
My question is how to change the DB2 server's IP address that has DB2 UDB 8.1
installed on a linux RHEL 3. aslo I need to do the same thing on the AIX
server.

kindly help!
Thanks!
Lan
Pierre Saint-Jacques wrote:

I presume you now want to go to the Linux server instead of the AIX machine.
Easiest is to give the Linux server IPaddress the address of the AIX box and
a new address to your old AIX box, in your DNS hosts file.

If you can't play with actual adresses, then you play with names.
Change your AIX hostname to SOMENAME and then set your Linux server's
hostname NEWNAME, where newname is the former name of your old AIX db27.1
server.
SOMENAME keeps its IP address and NEWNAME should have the new address of the
Linux box.
This way nothing else needs to change and it is transparent to all your
users.

If, for whatever reason, you can't play with the hosts file, then, for each
workstation that needs to connect to Linux Server:
you will need to uncatalog both the DAS node and any instance nodes.
db2 list node directory
Identify and pick the ones that are of concern to you
db2 uncatalog node <dasnodename>
db2 uncatalog node <inst1name> ... etc.

Then you nedd to recatalog them using the command, for the DAS:
CATALOG ADMIN TCPIP NODE dasnodename REMOTE hostname [SYSTEM system-name]
[OSTYPE os-type] [WITH "comment string"]
and then for each instance:
CATALOG TCPIP NODE yourchoice REMOTE NEWNAME SERVER <INSTANCE svcename or
PORTNO>

HTH, Pierre.

Hi,

[quoted text clipped - 4 lines]

Thanks!
Lan

[Pierre Saint-Jacques]

Phil, thanks as I had no clue (not using Red Hat) as to to where to go.
I've kept a copy of this for further use.
Merci, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Phil Sherman" <ps******@ameritech.net> a écrit dans le message de news:
9K*****************@newssvr19.news.prodigy.com...

Linux - try looking in /etc/sysconfig/network-scripts
You should find a file ifcfg-eth0 (or similar) that contains information
about the adapter configuration. When using DHCP, this is where it's told
to use DHCP so I assume that a fixed address will be specified here.

I also think you can run the linux configurator and change the IP address
there, but it should end up in the same file.

As a last resort, you can add an ifcfg command to /etc/rc.local to change
to the new IP address.

You should also check Red Hat's info base to see if your question is
answered there. Your RHEL3 maintenance contract allows you to ask RH using
your support mechanism.

Don't forget that you will also probably have to change the default router
if you are on a different network segment.

Phil Sherman

Lan W via DBMonster.com wrote:

Hi,

Thanks for reply. Actually, I need to change the two server's IP address
to
something new, since we moved both server to a new location recently.
No
relation between the two servers. My question is how to change the DB2
server's IP address that has DB2 UDB 8.1
installed on a linux RHEL 3. aslo I need to do the same thing on the AIX
server.

kindly help!
Thanks!
Lan
Pierre Saint-Jacques wrote:

I presume you now want to go to the Linux server instead of the AIX
machine.
Easiest is to give the Linux server IPaddress the address of the AIX box
and a new address to your old AIX box, in your DNS hosts file.

If you can't play with actual adresses, then you play with names.
Change your AIX hostname to SOMENAME and then set your Linux server's
hostname NEWNAME, where newname is the former name of your old AIX db27.1
server.
SOMENAME keeps its IP address and NEWNAME should have the new address of
the Linux box.
This way nothing else needs to change and it is transparent to all your
users.

If, for whatever reason, you can't play with the hosts file, then, for
each workstation that needs to connect to Linux Server:
you will need to uncatalog both the DAS node and any instance nodes.
db2 list node directory
Identify and pick the ones that are of concern to you
db2 uncatalog node <dasnodename>
db2 uncatalog node <inst1name> ... etc.

Then you nedd to recatalog them using the command, for the DAS:
CATALOG ADMIN TCPIP NODE dasnodename REMOTE hostname [SYSTEM system-name]
[OSTYPE os-type] [WITH "comment string"]
and then for each instance:
CATALOG TCPIP NODE yourchoice REMOTE NEWNAME SERVER <INSTANCE svcename or
PORTNO>

HTH, Pierre.

Hi,

[quoted text clipped - 4 lines]

Thanks!
Lan