FW: Rolling a TSM instance to a new server/lpar

[Rhodes, Richard L.]

t Stor Manager <ADSM-L@VM.MARIST.EDU>
Cc: Ake, Elizabeth K. <a...@firstenergycorp.com>
Subject: Rolling a TSM instance to a new server/lpar

Hello,

Current:  TSM v6.3.5 on AIX 6100-09
New:  TSM v6.3.5 on AIX 7something

Well, it's time to rollover our TSM AIX servers.  We're purchases new pSeries 
chassis that are getting lpar'ed up to replace the existing systems.

New lpars will be AIX v7.
All storage is SAN based on either IBM or EMC storage arrays.
All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
  In rootvg lun:
 Whatever TSM/DB2 puts in /opt, /var/, /usr
 (tsm client stuff is in here)
  In non-rootvg luns:
 db2 vols
 db2 log vols (active/mirror/archive)
 db2 sqllib dir
 tsm stuff (dsmserv.opt, volhist, etc)
 tsm disk pools

We would like to
  - setup new/clean lpars with AIX v7 on the new chassis
  - install TSM/DB2 binaries
  - SWING THE non-rootvg luns from the old lpar to the new lpar
  - bring up TSM . . .
Is it really that easy


PROBLEM - I can't find anything on how to swing a DB2 database from one AIX 
lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around here.


Q)  Has anyone done a TSM storage swing like this?


We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX v7.  
I have to check this out.

Thanks

Rick





-
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.

Re: Rolling a TSM instance to a new server/lpar

[Maurice van 't Loo]

Hello Richard,

Our DR scenario and load balancing method is to "just" swing the lun's
between servers and start the TSM Instance.

You need to be sure that the passwd and groups files are the same, so the
permissions doesn't change. Also /etc/services is needed for some special
listening ports.
sqllib/db2nodes.cfg  contains the hostname, so you need to update this file
with the new hostname.

If you want (mail me directly for it)  I can share our "start-script" where
we set several things correct every time we boot the TSM Instance.

Regards,
Maurice van 't Loo



2016-05-06 18:55 GMT+02:00 Rhodes, Richard L. :

> Hello,
>
> Current:  TSM v6.3.5 on AIX 6100-09
> New:  TSM v6.3.5 on AIX 7something
>
> Well, it's time to rollover our TSM AIX servers.  We're purchases new
> pSeries chassis that are getting lpar'ed up to replace the existing systems.
>
> New lpars will be AIX v7.
> All storage is SAN based on either IBM or EMC storage arrays.
> All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
>   In rootvg lun:
>  Whatever TSM/DB2 puts in /opt, /var/, /usr
>  (tsm client stuff is in here)
>   In non-rootvg luns:
>  db2 vols
>  db2 log vols (active/mirror/archive)
>  db2 sqllib dir
>  tsm stuff (dsmserv.opt, volhist, etc)
>  tsm disk pools
>
> We would like to
>   - setup new/clean lpars with AIX v7 on the new chassis
>   - install TSM/DB2 binaries
>   - SWING THE non-rootvg luns from the old lpar to the new lpar
>   - bring up TSM . . .
> Is it really that easy
>
>
> PROBLEM - I can't find anything on how to swing a DB2 database from one
> AIX lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2
> around here.
>
>
> Q)  Has anyone done a TSM storage swing like this?
>
>
> We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX
> v7.  I have to check this out.
>
> Thanks
>
> Rick
>
>
>
>
>
> -
>
> The information contained in this message is intended only for the
> personal and confidential use of the recipient(s) named above. If the
> reader of this message is not the intended recipient or an agent
> responsible for delivering it to the intended recipient, you are hereby
> notified that you have received this document in error and that any review,
> dissemination, distribution, or copying of this message is strictly
> prohibited. If you have received this communication in error, please notify
> us immediately, and delete the original message.
>

Re: Rolling a TSM instance to a new server/lpar

[Shawn DREW]

I go through this exercise when performing DR tests and we swing over the 
storage.  Here is my cheat sheet:

- create instance owner user 

db2icrt -a server -s ese -u tsminstance tsminstance
su - tsminstance

#copy/validate:
~/sqllib/usercshrc
~/sqllib/userprofile
~/.bash_profile #or whatever shell profile to source the db2 env (. 
~/sqllib/db2profile)

db2set -i tsminstance DB2CODEPAGE=819
db2 update dbm cfg using dftdbpath /instanceDIR
db2 catalog database tsmdb1
db2 list database directory

# copy/validate db backup stanza
vi /opt/tivoli/tsm/client/api/bin64/dsm.sys


This message and any attachments (the "message") is intended solely for the 
addressees and is confidential. If you receive this message in error, please 
delete it and immediately notify the sender. Any use not in accord with its 
purpose, any dissemination or disclosure, either whole or partial, is 
prohibited except formal approval. The internet can not guarantee the integrity 
of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore 
be liable for the message if modified. Please note that certain functions and 
services for BNP Paribas may be performed by BNP Paribas RCC, Inc.


Unless otherwise provided above, this message was sent by BNP Paribas, or one 
of its affiliates in Canada, having an office at 1981 McGill College Avenue, 
Montreal, QC, H3A 2W8, Canada. To the extent this message is being sent from or 
to Canada, you may unsubscribe from receiving commercial electronic messages by 
using this link: www.bnpparibas.ca/en/unsubscribe/ 
. See www.bnpparibas.ca 
 for more information on BNP Paribas, in Canada.

Re: Rolling a TSM instance to a new server/lpar

[Rhodes, Richard L.]

Thanks for the help.

I am somewhat familiar with db2ilist (and db2iset, db2idrop) from a 
"Inconsistent Home Directory" problem when we upgraded to TSM v6.   

Will have to test. . . .

Thanks!

Rick



-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of 
Michael Prix
Sent: Friday, May 06, 2016 2:52 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: Rolling a TSM instance to a new server/lpar

Hello Richard,

  gererally yes, it's that easy, but some more steps:

- on the old server do a "db2ilist" and for each instance reported do a 
"db2icrt " on the new server.

- be sure to have the same TSM-Server levels on old and new server, otherwise
you have to perform a "db2iupdt " for each instance. Naturally,
you can only upgrade, and the instance has to be mounted when performing the
command.

To find the full paths to the programs mentioned is left as an exercise for
the reader.

-- 
Michael Prix On Fr, 2016-05-06 at 16:55 +, Rhodes, Richard L. wrote:
> Hello,
> 
> Current:  TSM v6.3.5 on AIX 6100-09
> New:  TSM v6.3.5 on AIX 7something
> 
> Well, it's time to rollover our TSM AIX servers.  We're purchases new
> pSeries chassis that are getting lpar'ed up to replace the existing systems.
> 
> New lpars will be AIX v7.
> All storage is SAN based on either IBM or EMC storage arrays.
> All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
>   In rootvg lun:
>  Whatever TSM/DB2 puts in /opt, /var/, /usr
>  (tsm client stuff is in here)
>   In non-rootvg luns:
>  db2 vols
>  db2 log vols (active/mirror/archive)
>  db2 sqllib dir
>  tsm stuff (dsmserv.opt, volhist, etc)
>  tsm disk pools
> 
> We would like to
>   - setup new/clean lpars with AIX v7 on the new chassis
>   - install TSM/DB2 binaries
>   - SWING THE non-rootvg luns from the old lpar to the new lpar
>   - bring up TSM . . .
> Is it really that easy
> 
> 
> PROBLEM - I can't find anything on how to swing a DB2 database from one AIX
> lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around
> here.
> 
> 
> Q)  Has anyone done a TSM storage swing like this?
> 
> 
> We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX
> v7.  I have to check this out.
> 
> Thanks
> 
> Rick
> 
> 
> 
> 
> 
> -
> The information contained in this message is intended only for the personal
> and confidential use of the recipient(s) named above. If the reader of this
> message is not the intended recipient or an agent responsible for delivering
> it to the intended recipient, you are hereby notified that you have received
> this document in error and that any review, dissemination, distribution, or
> copying of this message is strictly prohibited. If you have received this
> communication in error, please notify us immediately, and delete the
> original message.


-
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.

Re: Rolling a TSM instance to a new server/lpar

[Michael Prix]

Hello Richard,
in addition to my mail, keep in mind:
- Instanceuser and -group
- settings under /etc/security/ belonging to this user.
- /etc/tunables/nextboot
- Stanzas in /etc/services belonging to the TSM-Instance ( often to be found
at the end consisting of 5-6 consecutive lines, naming schema DB2_
till DB2__END)
-- 
Michael Prix
On Fr, 2016-05-06 at 16:55 +, Rhodes, Richard L. wrote:
> Hello,
> 
> Current:  TSM v6.3.5 on AIX 6100-09
> New:  TSM v6.3.5 on AIX 7something
> 
> Well, it's time to rollover our TSM AIX servers.  We're purchases new
> pSeries chassis that are getting lpar'ed up to replace the existing systems.
> 
> New lpars will be AIX v7.
> All storage is SAN based on either IBM or EMC storage arrays.
> All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
>   In rootvg lun:
>  Whatever TSM/DB2 puts in /opt, /var/, /usr
>  (tsm client stuff is in here)
>   In non-rootvg luns:
>  db2 vols
>  db2 log vols (active/mirror/archive)
>  db2 sqllib dir
>  tsm stuff (dsmserv.opt, volhist, etc)
>  tsm disk pools
> 
> We would like to
>   - setup new/clean lpars with AIX v7 on the new chassis
>   - install TSM/DB2 binaries
>   - SWING THE non-rootvg luns from the old lpar to the new lpar
>   - bring up TSM . . .
> Is it really that easy
> 
> 
> PROBLEM - I can't find anything on how to swing a DB2 database from one AIX
> lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around
> here.
> 
> 
> Q)  Has anyone done a TSM storage swing like this?
> 
> 
> We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX
> v7.  I have to check this out.
> 
> Thanks
> 
> Rick
> 
> 
> 
> 
> 
> -
> The information contained in this message is intended only for the personal
> and confidential use of the recipient(s) named above. If the reader of this
> message is not the intended recipient or an agent responsible for delivering
> it to the intended recipient, you are hereby notified that you have received
> this document in error and that any review, dissemination, distribution, or
> copying of this message is strictly prohibited. If you have received this
> communication in error, please notify us immediately, and delete the
> original message.

Re: Rolling a TSM instance to a new server/lpar

[Michael Prix]

Hello Richard,

  gererally yes, it's that easy, but some more steps:

- on the old server do a "db2ilist" and for each instance reported do a 
"db2icrt " on the new server.

- be sure to have the same TSM-Server levels on old and new server, otherwise
you have to perform a "db2iupdt " for each instance. Naturally,
you can only upgrade, and the instance has to be mounted when performing the
command.

To find the full paths to the programs mentioned is left as an exercise for
the reader.

-- 
Michael Prix On Fr, 2016-05-06 at 16:55 +, Rhodes, Richard L. wrote:
> Hello,
> 
> Current:  TSM v6.3.5 on AIX 6100-09
> New:  TSM v6.3.5 on AIX 7something
> 
> Well, it's time to rollover our TSM AIX servers.  We're purchases new
> pSeries chassis that are getting lpar'ed up to replace the existing systems.
> 
> New lpars will be AIX v7.
> All storage is SAN based on either IBM or EMC storage arrays.
> All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
>   In rootvg lun:
>  Whatever TSM/DB2 puts in /opt, /var/, /usr
>  (tsm client stuff is in here)
>   In non-rootvg luns:
>  db2 vols
>  db2 log vols (active/mirror/archive)
>  db2 sqllib dir
>  tsm stuff (dsmserv.opt, volhist, etc)
>  tsm disk pools
> 
> We would like to
>   - setup new/clean lpars with AIX v7 on the new chassis
>   - install TSM/DB2 binaries
>   - SWING THE non-rootvg luns from the old lpar to the new lpar
>   - bring up TSM . . .
> Is it really that easy
> 
> 
> PROBLEM - I can't find anything on how to swing a DB2 database from one AIX
> lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around
> here.
> 
> 
> Q)  Has anyone done a TSM storage swing like this?
> 
> 
> We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX
> v7.  I have to check this out.
> 
> Thanks
> 
> Rick
> 
> 
> 
> 
> 
> -
> The information contained in this message is intended only for the personal
> and confidential use of the recipient(s) named above. If the reader of this
> message is not the intended recipient or an agent responsible for delivering
> it to the intended recipient, you are hereby notified that you have received
> this document in error and that any review, dissemination, distribution, or
> copying of this message is strictly prohibited. If you have received this
> communication in error, please notify us immediately, and delete the
> original message.

Re: Rolling a TSM instance to a new server/lpar

[Efim]

Hi,
I think that this instruction from p.3  is what you are looking for:
http://www-01.ibm.com/support/docview.wss?uid=swg27018195 

if you want to change mount points name in the non-root luns the only way is 
restore tsm db with relocation. This is preffered metod in all cases because 
you can test it without stoping production.

AIX version chose:

Recommended levels from TSM side:
http://www-01.ibm.com/support/docview.wss?rs=663=SSGSG7=ServerRequirements=AIX=swg21052220=en_US=utf-8=en

Recommended levels from DB2 side:
http://www-01.ibm.com/support/docview.wss?uid=swg21165448

So you can use:

TL03: Service Pack 2 or higher (due to AIX APAR IV53587)
TL02: Service Pack 2 or higher
TL01: Service Pack 6 or higher

Efim


> 6 мая 2016 г., в 19:55, Rhodes, Richard L.  
> написал(а):
> 
> Hello,
> 
> Current:  TSM v6.3.5 on AIX 6100-09
> New:  TSM v6.3.5 on AIX 7something
> 
> Well, it's time to rollover our TSM AIX servers.  We're purchases new pSeries 
> chassis that are getting lpar'ed up to replace the existing systems.
> 
> New lpars will be AIX v7.
> All storage is SAN based on either IBM or EMC storage arrays.
> All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
>  In rootvg lun:
> Whatever TSM/DB2 puts in /opt, /var/, /usr
> (tsm client stuff is in here)
>  In non-rootvg luns:
> db2 vols
> db2 log vols (active/mirror/archive)
> db2 sqllib dir
> tsm stuff (dsmserv.opt, volhist, etc)
> tsm disk pools
> 
> We would like to
>  - setup new/clean lpars with AIX v7 on the new chassis
>  - install TSM/DB2 binaries
>  - SWING THE non-rootvg luns from the old lpar to the new lpar
>  - bring up TSM . . .
> Is it really that easy
> 
> 
> PROBLEM - I can't find anything on how to swing a DB2 database from one AIX 
> lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around here.
> 
> 
> Q)  Has anyone done a TSM storage swing like this?
> 
> 
> We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX v7. 
>  I have to check this out.
> 
> Thanks
> 
> Rick
> 
> 
> 
> 
> 
> -
> The information contained in this message is intended only for the personal 
> and confidential use of the recipient(s) named above. If the reader of this 
> message is not the intended recipient or an agent responsible for delivering 
> it to the intended recipient, you are hereby notified that you have received 
> this document in error and that any review, dissemination, distribution, or 
> copying of this message is strictly prohibited. If you have received this 
> communication in error, please notify us immediately, and delete the original 
> message.

Rolling a TSM instance to a new server/lpar

[Rhodes, Richard L.]

Hello,

Current:  TSM v6.3.5 on AIX 6100-09
New:  TSM v6.3.5 on AIX 7something

Well, it's time to rollover our TSM AIX servers.  We're purchases new pSeries 
chassis that are getting lpar'ed up to replace the existing systems.

New lpars will be AIX v7.
All storage is SAN based on either IBM or EMC storage arrays.
All TSM/DB2 pieces/parts are on separate luns from AIX/rootvg.
  In rootvg lun:
 Whatever TSM/DB2 puts in /opt, /var/, /usr
 (tsm client stuff is in here)
  In non-rootvg luns:
 db2 vols
 db2 log vols (active/mirror/archive)
 db2 sqllib dir
 tsm stuff (dsmserv.opt, volhist, etc)
 tsm disk pools

We would like to
  - setup new/clean lpars with AIX v7 on the new chassis
  - install TSM/DB2 binaries
  - SWING THE non-rootvg luns from the old lpar to the new lpar
  - bring up TSM . . .
Is it really that easy


PROBLEM - I can't find anything on how to swing a DB2 database from one AIX 
lpar to a new/clean lpar.  We're a Oracle shop - no one knows DB2 around here.


Q)  Has anyone done a TSM storage swing like this?


We are planning a TSM v7.1 upgrade.  We may need to do this to get to AIX v7.  
I have to check this out.

Thanks

Rick





-
The information contained in this message is intended only for the personal and 
confidential use of the recipient(s) named above. If the reader of this message 
is not the intended recipient or an agent responsible for delivering it to the 
intended recipient, you are hereby notified that you have received this 
document in error and that any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately, and delete the original message.