Re: migrate 32bit database -> 64bit TSM server?
On Sep 18, 2006, at 1:24 PM, Richard Rhodes wrote: While I'm not sure, I think the problem is deeper than just the database. It might also be byte ordering and other issues with you data on tape. In other words, even if IBM came up with a way to export/import the db to a different type of server (which they could . . . .Oracle did it), it might still require a conversion of the data on all your tapes. TSM's Restore DB should remain a recovery vehicle, and I agree with the consensus that there should be some kind of Migrate DB function. Such a function gets "interesting" in areas with hardware dependencies; but whereas the family of TSM servers constitutes a superset of all the understanding needed, it should be do-able. I don't see any need for conversion of storage pool data, given that it is stored as the client sent it, regardless of its OS type or machine architecture (or byte order, derived therefrom). The server only needs to know what volume a file is on, and its media index. Keep in mind that it is the client which ultimately restores file system data, not the server. Richard Sims
Re: migrate 32bit database -> 64bit TSM server?
While I'm not sure, I think the problem is deeper than just the database.
It might also be
byte ordering and other issues with you data on tape. In other words, even
if IBM
came up with a way to export/import the db to a different type of server
(which they
could . . . .Oracle did it), it might still require a conversion of the
data on all your tapes.
Paul Zarnowski
<[EMAIL PROTECTED]
> To
Sent by: "ADSM: ADSM-L@VM.MARIST.EDU
Dist Stor cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> Re: migrate 32bit database -> 64bit
TSM server?
09/18/2006 12:18
PM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
Thanks Victoria.
Ok, so now I know it won't work (in addition to not being supported).
Next questions:
1. How hard would it be for IBM to do something to help users do this?
2. How many TSM sites would actually want to do this?
I.e., is there reason to submit a requirement for this, or are we just
trying to do something that not many folks ever want to do?
At 11:32 AM 9/18/2006, Victoria Ortepio wrote:
>Hi Paul,
>
>
>
>No, it cannot be done. We've proved it here by taking a TSM data snapshot
>
>and attempting to restore it a newly built TSM server on LINUX. This is
>
>the result. Unfortunately, the EXPORT / IMPORT option is your only
>
>alternative. You may selectively choose what to export out to cut down
>
>the conversion time.
>
>
>
>
>
>Tivoli Storage Manager for Linux/i386
>
>Version 5, Release 2, Level 7.0
>
>Licensed Materials - Property of IBM
>
>(C) Copyright IBM Corporation 1990, 2003. All rights reserved.
>
>U.S. Government Users Restricted Rights - Use, duplication or disclosure
>
>restricted by GSA ADP Schedule Contract with IBM Corporation.
>
>
>
>ANR7800I DSMSERV generated at 01:59:13 on Dec 8 2005.
>
>ANR7801I Subsystem process ID is 6806.
>
>ANR0900I Processing options file /usr/tivoli/tsm/server/bin/dsmserv.opt.
>
>ANR8200I TCP/IP driver ready for connection with clients on port 1500.
>
>ANR0200I Recovery log assigned capacity is 5696 megabytes.
>
>ANR0201I Database assigned capacity is 15888 megabytes.
>
>ANR4621I Database backup device class TSM-DATABASE.
>
>ANR4622I Volume 1: /TSM03S/40709557.dbs.
>
>ANR4632I Starting point-in-time database restore (no commit).
>
>ANR8340I FILE volume /TSM03S/40709557.dbs mounted.
>
>ANR1368W Input volume /TSM03S/40709557.dbs contains sequence number
>16777216;
>
>volume sequence number 1 is required.
>
>[EMAIL PROTECTED] bin]#
>
>
>
>Please refer to this website for info:
>
>
>
>http://www-1.ibm.com/support/docview.wss?uid=swg21189573
>
>
>
>
>
>Regards,
>
>
>
>Vicki
>
>Verizon Business
>
>Piscataway, NJ
>
>
>
>
>
>-Original Message-
>From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
>Paul Zarnowski
>Sent: Monday, September 18, 2006 10:39 AM
>To: ADSM-L@VM.MARIST.EDU
>Subject: Re: [ADSM-L] migrate 32bit database -> 64bit TSM server?
>
>
>
>We are considering moving our server from AIX to another unix OS
>
>(probably Linux). I was hoping that we could just restore a backup
>
>of our DB to a Linux server and have it point to the same tapes. But
>
>the initial feedback I've gotten indicates that this is not
>
>supported. No one has told me that it won't work, just that it's not
>
>supported. Given how long it would take to export/import all of our
>
>(archive) data, this leaves us with some difficult choices. It sure
>
>would be nice if TSM had a supported way of doing this more
>
>efficiently than export/import.
>
>
>
>The other problem with export/import is that all of our clients would
>
>then have to change their config files to point to the new
>
>server. If we could simply restore the DB onto the new server, that
>
>new server could inherit the same hostname and port numbers as the
>
>old server, making the whole server migration transparent to our
>
>hundreds of end users.
>
>
>
>At 03:46 AM 9/17/2006, Mark Stapleton wrote:
>
> >You will not be able to move your TSM db from Windows to Linux (or from
>
> >any OS to any other dissimilar OS). The file structures are too
different.
Re: migrate 32bit database -> 64bit TSM server?
>> On Mon, 18 Sep 2006 12:18:36 -0400, Paul Zarnowski <[EMAIL PROTECTED]> said: > 2. How many TSM sites would actually want to do this? > I.e., is there reason to submit a requirement for this, or are we just > trying to do something that not many folks ever want to do? I think that it's a small minority who'd use such a facility, and getting smaller all the time; especially with things like the TSM Express stuff coming along. Now, I'm _in_ that minority, and it might in fact be a majority of us ADSM-L denizens. But we already know we're the creme de la creme ;) - Allen S. Rout - Remember, tomorrow is Talk Like A Pirate Day! http://www.talklikeapirate.com/
Re: migrate 32bit database -> 64bit TSM server?
Hi Paul, I am sure that there are many Tivoli customers that need this function, just as we do. Our migration to another platform is a cost reduction requirement. You will see that there will be a cost increase just to perform the EXPORT. You will require a clone of hardware on the receiving side to convert your data. So choose your EXPORTed data wisely. We many just export out all archive data, which still is a tremendous amount, and pick and choose backup data. FYI, the EXPORT does NOT export everything over to the new TSM server. Manual in input is necessary. (i.e. Admin schedules, home grown command scripts) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Zarnowski Sent: Monday, September 18, 2006 12:19 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] migrate 32bit database -> 64bit TSM server? Thanks Victoria. Ok, so now I know it won't work (in addition to not being supported). Next questions: 1. How hard would it be for IBM to do something to help users do this? 2. How many TSM sites would actually want to do this? I.e., is there reason to submit a requirement for this, or are we just trying to do something that not many folks ever want to do? At 11:32 AM 9/18/2006, Victoria Ortepio wrote: >Hi Paul, > > > >No, it cannot be done. We've proved it here by taking a TSM data snapshot > >and attempting to restore it a newly built TSM server on LINUX. This is > >the result. Unfortunately, the EXPORT / IMPORT option is your only > >alternative. You may selectively choose what to export out to cut down > >the conversion time. > > > > > >Tivoli Storage Manager for Linux/i386 > >Version 5, Release 2, Level 7.0 > >Licensed Materials - Property of IBM > >(C) Copyright IBM Corporation 1990, 2003. All rights reserved. > >U.S. Government Users Restricted Rights - Use, duplication or disclosure > >restricted by GSA ADP Schedule Contract with IBM Corporation. > > > >ANR7800I DSMSERV generated at 01:59:13 on Dec 8 2005. > >ANR7801I Subsystem process ID is 6806. > >ANR0900I Processing options file /usr/tivoli/tsm/server/bin/dsmserv.opt. > >ANR8200I TCP/IP driver ready for connection with clients on port 1500. > >ANR0200I Recovery log assigned capacity is 5696 megabytes. > >ANR0201I Database assigned capacity is 15888 megabytes. > >ANR4621I Database backup device class TSM-DATABASE. > >ANR4622I Volume 1: /TSM03S/40709557.dbs. > >ANR4632I Starting point-in-time database restore (no commit). > >ANR8340I FILE volume /TSM03S/40709557.dbs mounted. > >ANR1368W Input volume /TSM03S/40709557.dbs contains sequence number >16777216; > >volume sequence number 1 is required. > >[EMAIL PROTECTED] bin]# > > > >Please refer to this website for info: > > > >http://www-1.ibm.com/support/docview.wss?uid=swg21189573 > > > > > >Regards, > > > >Vicki > >Verizon Business > >Piscataway, NJ > > > > > >-Original Message- >From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of >Paul Zarnowski >Sent: Monday, September 18, 2006 10:39 AM >To: ADSM-L@VM.MARIST.EDU >Subject: Re: [ADSM-L] migrate 32bit database -> 64bit TSM server? > > > >We are considering moving our server from AIX to another unix OS > >(probably Linux). I was hoping that we could just restore a backup > >of our DB to a Linux server and have it point to the same tapes. But > >the initial feedback I've gotten indicates that this is not > >supported. No one has told me that it won't work, just that it's not > >supported. Given how long it would take to export/import all of our > >(archive) data, this leaves us with some difficult choices. It sure > >would be nice if TSM had a supported way of doing this more > >efficiently than export/import. > > > >The other problem with export/import is that all of our clients would > >then have to change their config files to point to the new > >server. If we could simply restore the DB onto the new server, that > >new server could inherit the same hostname and port numbers as the > >old server, making the whole server migration transparent to our > >hundreds of end users. > > > >At 03:46 AM 9/17/2006, Mark Stapleton wrote: > > >You will not be able to move your TSM db from Windows to Linux (or from > > >any OS to any other dissimilar OS). The file structures are too different. > > > > > >Your best bet to have both servers up. Use the new one for backups and use > > >the old one (as necessary) for restored of legacy information. If you're > > >using the origin
Re: migrate 32bit database -> 64bit TSM server?
Thanks Victoria. Ok, so now I know it won't work (in addition to not being supported). Next questions: 1. How hard would it be for IBM to do something to help users do this? 2. How many TSM sites would actually want to do this? I.e., is there reason to submit a requirement for this, or are we just trying to do something that not many folks ever want to do? At 11:32 AM 9/18/2006, Victoria Ortepio wrote: Hi Paul, No, it cannot be done. We've proved it here by taking a TSM data snapshot and attempting to restore it a newly built TSM server on LINUX. This is the result. Unfortunately, the EXPORT / IMPORT option is your only alternative. You may selectively choose what to export out to cut down the conversion time. Tivoli Storage Manager for Linux/i386 Version 5, Release 2, Level 7.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1990, 2003. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR7800I DSMSERV generated at 01:59:13 on Dec 8 2005. ANR7801I Subsystem process ID is 6806. ANR0900I Processing options file /usr/tivoli/tsm/server/bin/dsmserv.opt. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR0200I Recovery log assigned capacity is 5696 megabytes. ANR0201I Database assigned capacity is 15888 megabytes. ANR4621I Database backup device class TSM-DATABASE. ANR4622I Volume 1: /TSM03S/40709557.dbs. ANR4632I Starting point-in-time database restore (no commit). ANR8340I FILE volume /TSM03S/40709557.dbs mounted. ANR1368W Input volume /TSM03S/40709557.dbs contains sequence number 16777216; volume sequence number 1 is required. [EMAIL PROTECTED] bin]# Please refer to this website for info: http://www-1.ibm.com/support/docview.wss?uid=swg21189573 Regards, Vicki Verizon Business Piscataway, NJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Zarnowski Sent: Monday, September 18, 2006 10:39 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] migrate 32bit database -> 64bit TSM server? We are considering moving our server from AIX to another unix OS (probably Linux). I was hoping that we could just restore a backup of our DB to a Linux server and have it point to the same tapes. But the initial feedback I've gotten indicates that this is not supported. No one has told me that it won't work, just that it's not supported. Given how long it would take to export/import all of our (archive) data, this leaves us with some difficult choices. It sure would be nice if TSM had a supported way of doing this more efficiently than export/import. The other problem with export/import is that all of our clients would then have to change their config files to point to the new server. If we could simply restore the DB onto the new server, that new server could inherit the same hostname and port numbers as the old server, making the whole server migration transparent to our hundreds of end users. At 03:46 AM 9/17/2006, Mark Stapleton wrote: >You will not be able to move your TSM db from Windows to Linux (or from >any OS to any other dissimilar OS). The file structures are too different. > >Your best bet to have both servers up. Use the new one for backups and use >the old one (as necessary) for restored of legacy information. If you're >using the original library for the new server, there are elements of >problems with this. > >After a period of time determined by your business needs, just turn off >the old server. > >Do not consider export/import choices for client data. Exports and imports >TAKE TOO #%^#^&[EMAIL PROTECTED] LONG! (Listening, Tivoli?) -- Paul ZarnowskiPh: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801Em: [EMAIL PROTECTED] -- Paul ZarnowskiPh: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801Em: [EMAIL PROTECTED]
Re: migrate 32bit database -> 64bit TSM server?
- Paul Zarnowski wrote: - >We are considering moving our server from AIX to another unix OS >(probably Linux). I was hoping that we could just restore a backup >of our DB to a Linux server and have it point to the same tapes. >But the initial feedback I've gotten indicates that this is not >supported. No one has told me that it won't work, just that it's >not supported. Given how long it would take to export/import all of >our (archive) data, this leaves us with some difficult choices. It >sure would be nice if TSM had a supported way of doing this more >efficiently than export/import. I don't think such a restore would work. AIX uses big-endian byte ordering, while Linux under Intel uses little-endian ordering. I remember an earlier posting by someone who tried a cross-platform database restore involving systems with opposite byte ordering conventions. The restore failed with a message stating that the first tape loaded had a volume sequence number of 16,777,216 rather than 1. This is exactly the error one would expect if the system writing the database backup used one byte ordering convention for the volume sequence number and the system reading the backup expected theopposite byte ordering.
Re: migrate 32bit database -> 64bit TSM server?
Hi Paul, No, it cannot be done. We've proved it here by taking a TSM data snapshot and attempting to restore it a newly built TSM server on LINUX. This is the result. Unfortunately, the EXPORT / IMPORT option is your only alternative. You may selectively choose what to export out to cut down the conversion time. Tivoli Storage Manager for Linux/i386 Version 5, Release 2, Level 7.0 Licensed Materials - Property of IBM (C) Copyright IBM Corporation 1990, 2003. All rights reserved. U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corporation. ANR7800I DSMSERV generated at 01:59:13 on Dec 8 2005. ANR7801I Subsystem process ID is 6806. ANR0900I Processing options file /usr/tivoli/tsm/server/bin/dsmserv.opt. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR0200I Recovery log assigned capacity is 5696 megabytes. ANR0201I Database assigned capacity is 15888 megabytes. ANR4621I Database backup device class TSM-DATABASE. ANR4622I Volume 1: /TSM03S/40709557.dbs. ANR4632I Starting point-in-time database restore (no commit). ANR8340I FILE volume /TSM03S/40709557.dbs mounted. ANR1368W Input volume /TSM03S/40709557.dbs contains sequence number 16777216; volume sequence number 1 is required. [EMAIL PROTECTED] bin]# Please refer to this website for info: http://www-1.ibm.com/support/docview.wss?uid=swg21189573 Regards, Vicki Verizon Business Piscataway, NJ -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Zarnowski Sent: Monday, September 18, 2006 10:39 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] migrate 32bit database -> 64bit TSM server? We are considering moving our server from AIX to another unix OS (probably Linux). I was hoping that we could just restore a backup of our DB to a Linux server and have it point to the same tapes. But the initial feedback I've gotten indicates that this is not supported. No one has told me that it won't work, just that it's not supported. Given how long it would take to export/import all of our (archive) data, this leaves us with some difficult choices. It sure would be nice if TSM had a supported way of doing this more efficiently than export/import. The other problem with export/import is that all of our clients would then have to change their config files to point to the new server. If we could simply restore the DB onto the new server, that new server could inherit the same hostname and port numbers as the old server, making the whole server migration transparent to our hundreds of end users. At 03:46 AM 9/17/2006, Mark Stapleton wrote: >You will not be able to move your TSM db from Windows to Linux (or from >any OS to any other dissimilar OS). The file structures are too different. > >Your best bet to have both servers up. Use the new one for backups and use >the old one (as necessary) for restored of legacy information. If you're >using the original library for the new server, there are elements of >problems with this. > >After a period of time determined by your business needs, just turn off >the old server. > >Do not consider export/import choices for client data. Exports and imports >TAKE TOO #%^#^&[EMAIL PROTECTED] LONG! (Listening, Tivoli?) -- Paul ZarnowskiPh: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801Em: [EMAIL PROTECTED]
Re: migrate 32bit database -> 64bit TSM server?
We are considering moving our server from AIX to another unix OS (probably Linux). I was hoping that we could just restore a backup of our DB to a Linux server and have it point to the same tapes. But the initial feedback I've gotten indicates that this is not supported. No one has told me that it won't work, just that it's not supported. Given how long it would take to export/import all of our (archive) data, this leaves us with some difficult choices. It sure would be nice if TSM had a supported way of doing this more efficiently than export/import. The other problem with export/import is that all of our clients would then have to change their config files to point to the new server. If we could simply restore the DB onto the new server, that new server could inherit the same hostname and port numbers as the old server, making the whole server migration transparent to our hundreds of end users. At 03:46 AM 9/17/2006, Mark Stapleton wrote: You will not be able to move your TSM db from Windows to Linux (or from any OS to any other dissimilar OS). The file structures are too different. Your best bet to have both servers up. Use the new one for backups and use the old one (as necessary) for restored of legacy information. If you're using the original library for the new server, there are elements of problems with this. After a period of time determined by your business needs, just turn off the old server. Do not consider export/import choices for client data. Exports and imports TAKE TOO #%^#^&[EMAIL PROTECTED] LONG! (Listening, Tivoli?) -- Paul ZarnowskiPh: 607-255-4757 Manager, Storage Services Fx: 607-255-8521 719 Rhodes Hall, Ithaca, NY 14853-3801Em: [EMAIL PROTECTED]
Re: migrate 32bit database -> 64bit TSM server?
"ADSM: Dist Stor Manager" wrote on 09/15/2006 04:16:56 PM: > We run TSM 5.3.1 32bit on windows 2000 32bit Server. We are considering > moving to TSM 5.3.3 64bit on RedHat Enterprise Linux v4 AS x64. > > Is it possible to migrate the database from 32bit server to 64bit server? > Anyone done it before and had it work? You will not be able to move your TSM db from Windows to Linux (or from any OS to any other dissimilar OS). The file structures are too different. Your best bet to have both servers up. Use the new one for backups and use the old one (as necessary) for restored of legacy information. If you're using the original library for the new server, there are elements of problems with this. After a period of time determined by your business needs, just turn off the old server. Do not consider export/import choices for client data. Exports and imports TAKE TOO #%^#^&[EMAIL PROTECTED] LONG! (Listening, Tivoli?) -- Mark Stapleton ([EMAIL PROTECTED]) US Bank MR Backup and Recovery Management (but not for much longer) -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. ==
Re: migrate 32bit database -> 64bit TSM server?
Hi, The difficulty are not to change from 32- to 64bit OS. I found it hard to belive that some more bits would affect TSM DB in some redical or any way, (excluding performance..). The problem is in changing OS type, Windows to Linux. The list have plenty of documentation on this procedure with export/import. //Henrik -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alexander Lazarevich Sent: 15. september 2006 23:17 To: ADSM-L@VM.MARIST.EDU Subject: migrate 32bit database -> 64bit TSM server? We run TSM 5.3.1 32bit on windows 2000 32bit Server. We are considering moving to TSM 5.3.3 64bit on RedHat Enterprise Linux v4 AS x64. Is it possible to migrate the database from 32bit server to 64bit server? Anyone done it before and had it work? Thanks, Alex --- The information contained in this message may be CONFIDENTIAL and is intended for the addressee only. Any unauthorised use, dissemination of the information or copying of this message is prohibited. If you are not the addressee, please notify the sender immediately by return e-mail and delete this message. Thank you.
migrate 32bit database -> 64bit TSM server?
We run TSM 5.3.1 32bit on windows 2000 32bit Server. We are considering moving to TSM 5.3.3 64bit on RedHat Enterprise Linux v4 AS x64. Is it possible to migrate the database from 32bit server to 64bit server? Anyone done it before and had it work? Thanks, Alex
