Re: Change IP Address

[Tom Tracy]

Gill -

I've done this (albeit not on a TSM server), and, although there might be a
command you could enter at the command line to make these changes, you can also
easily do this using smit.  If you enter 'smit tcpip', then select 'Minimum
Configuration & Startup', then select your network interface from the list,
you'll be able to change the host's IP address, network mask, default gateway
address - even your name server's IP address.  And, if you change 'Start Now' to
'Yes', I don't think you'll need to IPL the box.

A couple of caveats, though (from experience) - after you make the changes in
smit, check your /etc/hosts & /etc/resolv.conf files.  smit seems to not clean
up the old entries in these files and instead just adds the new entries.  You'll
want to remove the reference in /etc/hosts to the host's old IP address, and, if
you changed name servers, remove the reference to the old name server in
/etc/resolv.conf.  Not doing this can cause you grief (in my case, NIS freaked
out).

I hope this helps!  Good luck.

Tom Tracy
Sr. Database Administrator (& AIX Systems Administrator & TSM
Administrator.)
NTRS, LLC
[EMAIL PROTECTED]




From: "Gill, Geoffrey L." <[EMAIL PROTECTED]> on 07/02/2001 06:22 PM

Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>



 To:   [EMAIL PROTECTED]

 cc:   (bcc: Tom Tracy/ATL/NTRS)








 Subject: Change IP Address








For the AIX crowd out there,

I need to change the IP address on my ADSM server this weekend. I want to
know if there are any pitfalls I should look out for. It's not just an IP
change on the same network, I'll be changing the IP, NETMASK and Default
Gateway.

Questions:
Since I'm not totally AIX literate yet is there a command line command I can
use that will do all 3 at once?

Should I plan on rebooting the box after this change?

Thanks for the help.

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   [EMAIL PROTECTED]
Phone:  (858) 826-4062
Pager:   (888) 997-9614

DB2 Restores to Different DB / Node Using TSM

[Tom Tracy]

Hello:

I am new to the list and have a question for the other list subscribers who use
TSM to backup & restore DB2 UDB databases.  We currently are running DB2 UDB
v5.2 on AIX (soon to be upgraded to DB2 UDB v7.2) and TSM v4.1, also on AIX.  We
have had TSM installed for only 3 weeks, and are therefore not yet in
production.  Once in production, we will be using TSM to backup our databases
online & will be using the delivered DB2 user exit program to automatically
archive our transaction log files to TSM.  During my testing, I have identified
an issue (for us anyway) with restoring databases.

The vast, vast majority of the time we restore a given database, it is to a
different database, with a different name, on a different TSM client (I won't go
into the reasons for this - just suffice it to say we have to do this *a lot*).
I have been referring to a excellent new IBM RedPiece just published this May
titled "Backing up DB2 Databases Using Tivoli Storage Manager."  According to
this book, the mechanics that we would have to go through to restore a given
database to a different database on a different TSM client are pretty ugly.  The
restore itself isn't too bad (just set a couple of database level cfg
parameters), but performing the subsequent ROLLFORWARD in order to make the
restored database useable is where it gets really ugly - modifying the user
exit, recompiling it, and doing the ROLLFORWARD - then changing the user exit
back again.  And, this will only work if the target database has the exact same
name as the source database.

Is there not a better way to accomplish this?  Are there any third party tools
that would make this process less painful & more seamless?  Any and all help /
suggestions would be most appreciated.  Thanks!

Tom Tracy
Sr. Database Administrator
NTRC, LLC.
[EMAIL PROTECTED]