reply to Mark: re : TSM device driver won't start on boot
Hi Mark, Yes the Optical support box is ticked. Regards Chris _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
Re: TDPO backup failing with ANS0236E error
Tim, that was it. I did some tests and forgot to change passwordaccess back to prompt. Thank you for your response. Regards Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 "HEMPSTEAD, Tim" <[EMAIL PROTECTED]To: [EMAIL PROTECTED] A.SLB.COM>cc: Sent by: "ADSM: Dist Stor Subject: Re: TDPO backup failing with ANS0236E error Manager" <[EMAIL PROTECTED]> 22.01.2003 09:57 Please respond to "ADSM: Dist Stor Manager" Jozef, The TDP for Oracle documentation says that the TDP for Oracle will not work with PASSWORDACCESS=generate (see the options section under Part 2 of the chapter on configuring the TDP). Regards Tim -Original Message- From: Jozef Zatko [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 08:18 To: [EMAIL PROTECTED] Subject: TDPO backup failing with ANS0236E error Hello guys, I have a problem with Oracle backup with TDPO 2.2.1. Environment: TSM server 5.1.5.4 on AIX 5.1 Oracle 8.1.7 TDPO 2.2.1 TSM API client 4.2.1 The backup fails with following error (copy from RMAN backup log): ORA-19511: ANS0236E (RC2032) On dsmInit, the owner is not allowed when PASSWORDACCESS=generate. In messages, I found this explanation to this error number: ANS0236E On dsmInit, the owner is not allowed when PASSWORDACCESS=generate. Explanation: PASSWORDACCESS=generate establishes a session with the current login user as the owner. System Action: The system returns to the calling procedure. User Response: When using PASSWORDACCESS=generate, set clientOwnerNameP to NULL. Does somebody know what is the clientOwnerNameP and where I can set it to NULL? Ing. Jozef Zatko Login a.s. Dlha 2, Stupava tel.: (421) (2) 60252618 _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _
Submission of job through the TSM server
Hello guys I am new on Tivoli Storage Manager. We are using TSM V5R1. Does anybody know how can i submit mannually a job through the TSM server. Nicolas Savva Assistant System Specialist Information Services Laiki Group 11 Arch Makarios Ave. CY-1065 Nicosia CYPRUS Tel +357 22812473 Fax +357 22812583 Email: [EMAIL PROTECTED] Web Site: http://www.laiki.com Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message.
Re: TDP for SQL Errors
Maria I have had a number of such problems and found the key to resolving them usually lies in the operating system error number - in your case -2147024888. Check the SQL Server VDI.LOG to confirm, but like Eric says -2147024888 indicates "Not enough storage space is available to process the command". Other possible numbers are -2147467262 (No such interface supported) and -2147221163 (Interface not registered) - in either case refer to Microsoft knowledge base article id Q323602. In any case, the problem usually lies with the SQL Server Virtual Device Interface (VDI) rather than the TDP config. When we experienced "not enough storage space..." errors during TDP backups, it was down to fragmentation of the SQL Server MemToLeave area (see my posting last October - http://msgs.adsm.org/cgi-bin/get/adsm0210/1307.html). By increasing the size of the MemToLeave area using the SQL Server '-g' startup switch, we alleviated all the problems. The -g switch was introduced in SQL Server 7.0 SP2 - see Microsoft knowledge base article id Q254555. Neil Schofield Yorkshire Water Services Ltd. -Original Message- From: Maria Ilieva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 08:21 To: [EMAIL PROTECTED] Subject: TDP for SQL errors Hi, I have some problems with the backup of MSSQL databases and I need your help. TSM 5.1.1.6 Server on AIX 4.3 TSM 5.1.7 Client TDP for MSSQL 5.1.5 Backup fails most of the time for some databases (they are not the same every time) and sometimes completes without errors. I'm receiving the folowing errors: In the Windows event log: 20.1.2003 21:00:25 MSSQLSERVER Error (2) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 18210 : BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device 'TDPSQL-0AF0-'. Operating system error -2147024888(error not found). 20.1.2003 21:00:23 MSSQLSERVER Error (2) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 18210 BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'TDPSQL-0AF0-'. Operating system error 995(error not found). 20.1.2003 21:00:23 MSSQLSERVER Error (6) 17055 NT AUTHORITY\SYSTEM NAUTILUSA 3041 : BACKUP failed to complete the command USE master BACKUP LOG [FEIBank] TO VIRTUAL_DEVICE=N'TDPSQL-0AF0-' WITH BLOCKSIZE=512, MAXTRANSFERSIZE=4194304, NO_TRUNCATE, NAME=N'log', DESCRIPTION=N'TDPSQL-0AF0- (TDP MS SQL V2)' In the TDP schedule log: 01/22/2003 09:00:38 ACO5422E Received the following from the MS SQL server: 01/22/2003 09:00:38 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bc5) 01/22/2003 09:00:39 ACO5436E A failure occurred on stripe number (0), rc = 428 01/22/2003 09:00:39 ACO5407E The SQL server aborted the operation. 01/22/2003 09:00:39 Backup of Virgo failed. 01/22/2003 09:00:39 ACO5422E Received the following from the MS SQL server: 01/22/2003 09:00:39 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bc5) 01/22/2003 09:00:40 ACO5436E A failure occurred on stripe number (0), rc = 428 01/22/2003 09:00:40 ACO5407E The SQL server aborted the operation. 01/22/2003 09:00:41 Backup of WaitImport failed. and so on... Any help is appreciated Maria Ilieva ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** Visit our web site to find out about our award winning Cool Schools community campaign at http://www.yorkshirewater.com/yorkshirewater/schools.html The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available at http://www.keldagroup.com/email.htm Yorkshire Water Services Limited Registered Office Western House Halifax Road Bradford BD6 2SZ Registered in England and Wales No 2366682
Re: Submission of job through the TSM server
Assuming a backup job 'define clientaction 'NodeName' from admin cmdline, (see help def clientact). Which other types of jobs do you refer to? //Henrik Nicolas Savva cc: (bcc: Henrik Wahlstedt) Sent by: Subject: Submission of job through the TSM server "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 2003-01-23 11:11 Please respond to "ADSM: Dist Stor Manager" Hello guys I am new on Tivoli Storage Manager. We are using TSM V5R1. Does anybody know how can i submit mannually a job through the TSM server. Nicolas Savva Assistant System Specialist Information Services Laiki Group 11 Arch Makarios Ave. CY-1065 Nicosia CYPRUS Tel +357 22812473 Fax +357 22812583 Email: [EMAIL PROTECTED] Web Site: http://www.laiki.com Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message. --- 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.
Re: NT exclude problem - Solved
Andy and all Thanks for your help. It was me in the end (as usual). I repeated the experiment and this time it worked as expected. If only I knew what I did to fix it ... Thanks for all suggestions Richard Foster Norsk Hydro -- This e-mail with attached documents is only for the intended recipient and may contain information that is confidential and/or privileged. If you are not the intended recipient, you are hereby notified that any unauthorised reading, copying, disclosure or distribution of the e-mail and/or attached documents is expressly forbidden, and may be a criminal offence, and that Hydro shall not be liable for any action taken by you based on the electronically transmitted information. If you have received this e-mail by mistake, you are kindly requested to immediately inform the sender thereof and delete the e-mail and attached documents.
Some information...
Hi, I need some help for the following: 1. Is TSM capable to perform System Backup on AIX box? 2. Is TSM capable to perform Volume Group Backup? 3. Is TSM capable to perform File System Backup? Nicolas Savva Assistant System Specialist Information Services Laiki Group 11 Arch Makarios Ave. CY-1065 Nicosia CYPRUS Tel +357 22812473 Fax +357 22812583 Email: [EMAIL PROTECTED] Web Site: http://www.laiki.com Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message.
TDP for SQL errors SOLVED
Thanks Del, Correcting registry entries according to the Microsoft Knowledge Base article Q323602 help us. Maria Ilieva - Original Message - From: "Del Hoobler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 22, 2003 3:30 PM Subject: Re: TDP for SQL errors > Maria, (Matt), > > This may be a known Microsoft bug, BUG #: 357231 (SHILOH_BUGS). > Take a look at Microsoft Knowledge Base article Q323602. > > http://support.microsoft.com/default.aspx?scid=kb;en-us;323602 > > Microsoft documents the workaround for this issue in the > knowledge base article. > > Thanks, > > Del > > > > Del Hoobler > IBM Corporation > [EMAIL PROTECTED] > > - Never cut what can be untied. > - Commit yourself to constant improvement. > > === > > . > > 01/22/2003 09:00:38 ACO5422E Received the following from the MS SQL > server: > > 01/22/2003 09:00:38 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP > LOG is terminating abnormally. > > Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bc5) > > 01/22/2003 09:00:39 ACO5436E A failure occurred on stripe number (0), rc > = 428 > > 01/22/2003 09:00:39 ACO5407E The SQL server aborted the operation. > > 01/22/2003 09:00:39 Backup of Virgo failed. > > 01/22/2003 09:00:39 ACO5422E Received the following from the MS SQL > server: > > 01/22/2003 09:00:39 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP > LOG is terminating abnormally. > > Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bc5) > > 01/22/2003 09:00:40 ACO5436E A failure occurred on stripe number (0), rc > = 428 > > 01/22/2003 09:00:40 ACO5407E The SQL server aborted the operation. > > 01/22/2003 09:00:41 Backup of WaitImport failed. > > . >
archiving questions
Hi all, A client of mine requests that 220GB of databases are being "archived" on tape and kept for 3 years. I've been looking for a way on how to do this but the manuals only speak of how the archive client command works. Not really on how things work on the serverside. I assume I'll have to make another managementclaas which defines how long to keep trhe files etc. but I'm not sure how to go about this. below are the specifics on our current mg classes; the domain I'm speaking of is the one called progress. Does anyone have some ideas on how to do this? thnx a lot, michelle ** *** ---> Q DOMAIN ** Policy ActivatedActivated Number ofDescription Domain Policy Default Registered Name Set Mgmt Nodes Class ----- BAKKERLA-BAK_POLI-BAK_MNGM- 4domain voor progress ND CY NTCLASS STANDARD STANDARD STANDARD 34Installed default policy domain. ** *** ---> Q MGMTCLASS ** PolicyPolicyMgmt Default Description DomainSet Name Class Mgmt NameName Class ? - - - - BAKKERLA- ACTIVEBAK_MNGM- Yes progress managementcl- ND NTCLASS ass BAKKERLA- BAK_POLI- BAK_MNGM- Yes progress managementcl- NDCYNTCLASS ass STANDARD ACTIVESTANDARD Yes Installed default management class. STANDARD STANDARD STANDARD Yes Installed default management class. ** *** ---> Q COPYGROUP * * * STANDARD TYPE=BACKUP ** PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly NameName NameExists Deleted Versions Version - - - - --- PROGRESS - ACTIVEBAK_MNGM- STANDARD 51 30 60 NTCLASS PROGRESS- PRO_POLI- BAK_MNGM- STANDARD 51 30 60 CYNTCLASS STANDARD ACTIVESTANDARD STANDARD 51 30 60 STANDARD STANDARD STANDARD STANDARD 51 30 60 ** *** ---> Q COPYGROUP * * * STANDARD TYPE=ARCHIVE ** PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - PROGRESS- ACTIVEBAK_MNGM- STANDARD 365 NTCLASS PROGRESS- BAK_POLI- BAK_MNGM- STANDARD 365 CYNTCLASS STANDARD ACTIVESTANDARD STANDARD 365 STANDARD STANDARD STANDARD STANDARD 365
Re: archiving questions
Hi Michelle, You will need a management class with an archive copy group that retains the data for 3 years. Therefore you will need to: 1) Create a new management class in the desired domain/policy set. (See DEFINE MGMTCLASS in the Administrator's Reference.) 2) Create an archive copygroup in the new management class with the desired retention. (See DEFINE COPYGROUP in the Administrator's Reference.) 3) Activate the policy set. (See ACTIVATE POLICYSET in the Administrator's Reference.) If you are not the TSM server administrator, then you will need to have that person perform these tasks. Once the new management class is available, you can run the archive and bind the files to that new management class. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Michelle Wiedeman <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/23/2003 06:03 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:archiving questions Hi all, A client of mine requests that 220GB of databases are being "archived" on tape and kept for 3 years. I've been looking for a way on how to do this but the manuals only speak of how the archive client command works. Not really on how things work on the serverside. I assume I'll have to make another managementclaas which defines how long to keep trhe files etc. but I'm not sure how to go about this. below are the specifics on our current mg classes; the domain I'm speaking of is the one called progress. Does anyone have some ideas on how to do this? thnx a lot, michelle ** *** ---> Q DOMAIN ** Policy ActivatedActivated Number ofDescription Domain Policy Default Registered Name Set Mgmt Nodes Class ----- BAKKERLA-BAK_POLI-BAK_MNGM- 4domain voor progress ND CY NTCLASS STANDARD STANDARD STANDARD 34Installed default policy domain. ** *** ---> Q MGMTCLASS ** PolicyPolicyMgmt Default Description DomainSet Name Class Mgmt NameName Class ? - - - - BAKKERLA- ACTIVEBAK_MNGM- Yes progress managementcl- ND NTCLASS ass BAKKERLA- BAK_POLI- BAK_MNGM- Yes progress managementcl- NDCYNTCLASS ass STANDARD ACTIVESTANDARD Yes Installed default management class. STANDARD STANDARD STANDARD Yes Installed default management class. ** *** ---> Q COPYGROUP * * * STANDARD TYPE=BACKUP ** PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly NameName NameExists Deleted Versions Version - - - - --- PROGRESS - ACTIVEBAK_MNGM- STANDARD 51 30 60 NTCLASS PROGRESS- PRO_POLI- BAK_MNGM- STANDARD 51 30 60 CYNTCLASS STANDARD ACTIVESTANDARD STANDARD 51 30 60 STANDARD STANDARD STANDARD STANDARD 51 30 60 ** *** ---> Q COPYGROUP * * * STANDARD TYPE=ARCHIVE ** PolicyPolicyMgmt CopyRetain DomainSet Name Class Group Version NameName Name - - - - PROGRESS- ACTIVEBAK_MNGM- STANDARD 365 NTCLASS PROGRESS- BAK_POLI- BAK_MNGM- STANDARD 365 CYNTCLASS STANDARD ACTIVESTANDARD STANDARD 365 STANDARD STANDARD
Re: Win2000 client questions
1. Does anyone have successful restore Active Directory using TSM? 2. Does anyone have experence restore registry ? 3. Can anyone share the procedure with the above? Thanks. Rosa Leung (416)-490-5151
Re: archiving questions
Also, how often will they perform the archives ??? how many files make up the data ??? etc... You want to take such things into consideration because they will have an impact on your environment in general (in the form of tsm server data base growth, tsm db performance issues, tape library capacity issues, etc...). Anymore I look at data that is to be kept for over 1 year as stagnant data (that I don't want in the environments). When long term retention is required, I generally register a node by the name of _exp, have them push any data they require kept to the tsm server using that node name, then I export to two sets of tapes and send to offsite locations. Also, the way you may use relative dates during an import, if they need to extend the retention, all I do is extend the time I keep the tapes. just some food for thought... Dwight -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 7:30 AM To: [EMAIL PROTECTED] Subject: Re: archiving questions Hi Michelle, You will need a management class with an archive copy group that retains the data for 3 years. Therefore you will need to: 1) Create a new management class in the desired domain/policy set. (See DEFINE MGMTCLASS in the Administrator's Reference.) 2) Create an archive copygroup in the new management class with the desired retention. (See DEFINE COPYGROUP in the Administrator's Reference.) 3) Activate the policy set. (See ACTIVATE POLICYSET in the Administrator's Reference.) If you are not the TSM server administrator, then you will need to have that person perform these tasks. Once the new management class is available, you can run the archive and bind the files to that new management class. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Michelle Wiedeman <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/23/2003 06:03 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:archiving questions Hi all, A client of mine requests that 220GB of databases are being "archived" on tape and kept for 3 years. I've been looking for a way on how to do this but the manuals only speak of how the archive client command works. Not really on how things work on the serverside. I assume I'll have to make another managementclaas which defines how long to keep trhe files etc. but I'm not sure how to go about this. below are the specifics on our current mg classes; the domain I'm speaking of is the one called progress. Does anyone have some ideas on how to do this? thnx a lot, michelle ** *** ---> Q DOMAIN ** Policy ActivatedActivated Number ofDescription Domain Policy Default Registered Name Set Mgmt Nodes Class ----- BAKKERLA-BAK_POLI-BAK_MNGM- 4domain voor progress ND CY NTCLASS STANDARD STANDARD STANDARD 34Installed default policy domain. ** *** ---> Q MGMTCLASS ** PolicyPolicyMgmt Default Description DomainSet Name Class Mgmt NameName Class ? - - - - BAKKERLA- ACTIVEBAK_MNGM- Yes progress managementcl- ND NTCLASS ass BAKKERLA- BAK_POLI- BAK_MNGM- Yes progress managementcl- NDCYNTCLASS ass STANDARD ACTIVESTANDARD Yes Installed default management class. STANDARD STANDARD STANDARD Yes Installed default management class. ** *** ---> Q COPYGROUP * * * STANDARD TYPE=BACKUP ** PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly NameName NameExists Deleted Versions Version - - - - --- PROG
Measuring progress of copy stgpool operation
Hi all, Everything is in the title : is there a way (sql query ?) to find out, during a copy stgpool process, how many objects, or even better how many MB remains to be copied for finishing the process. Basically, the goal would be having an idea of remaining duration till the job ceases Thanks in advance ! Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Re: NT restore to different hardware
Looks like there is no easy way to do a restore to different hardware. What happens if there is a disaster and you cannot get your 5 year old server from anywhere. How is TSM going to restore to that server! To me it looks like TSM is very good at taking backups and managing them but in the restore department I have serious doubts. How are other people doing their disaster recovery exercises? Do you keep identical hardware at DR site also? What happens if you need a faster server? There have been references to Redbook SG24-4880, however, this redbook tells you how to do a restore on identical hardware only. All comments are welcome.. Thanks Raminder Braich SAP/Oracle DBA The Davey Tree Expert Company Kent, OH, 44240.
Re: archiving questions
hi dwight, The archive will be performed once and then the tapes will be checked out and put in vault. it is only archived because it contains finacial data which to legal reasons is to be kept for a long period of time. In this manner it will not have a great impact i guess, accept on the amount of tapevolumes. but that is to be overcome by purchasing extra. -Original Message- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: Re: archiving questions Also, how often will they perform the archives ??? how many files make up the data ??? etc... You want to take such things into consideration because they will have an impact on your environment in general (in the form of tsm server data base growth, tsm db performance issues, tape library capacity issues, etc...). Anymore I look at data that is to be kept for over 1 year as stagnant data (that I don't want in the environments). When long term retention is required, I generally register a node by the name of _exp, have them push any data they require kept to the tsm server using that node name, then I export to two sets of tapes and send to offsite locations. Also, the way you may use relative dates during an import, if they need to extend the retention, all I do is extend the time I keep the tapes. just some food for thought... Dwight -Original Message- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 7:30 AM To: [EMAIL PROTECTED] Subject: Re: archiving questions Hi Michelle, You will need a management class with an archive copy group that retains the data for 3 years. Therefore you will need to: 1) Create a new management class in the desired domain/policy set. (See DEFINE MGMTCLASS in the Administrator's Reference.) 2) Create an archive copygroup in the new management class with the desired retention. (See DEFINE COPYGROUP in the Administrator's Reference.) 3) Activate the policy set. (See ACTIVATE POLICYSET in the Administrator's Reference.) If you are not the TSM server administrator, then you will need to have that person perform these tasks. Once the new management class is available, you can run the archive and bind the files to that new management class. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Michelle Wiedeman <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/23/2003 06:03 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:archiving questions Hi all, A client of mine requests that 220GB of databases are being "archived" on tape and kept for 3 years. I've been looking for a way on how to do this but the manuals only speak of how the archive client command works. Not really on how things work on the serverside. I assume I'll have to make another managementclaas which defines how long to keep trhe files etc. but I'm not sure how to go about this. below are the specifics on our current mg classes; the domain I'm speaking of is the one called progress. Does anyone have some ideas on how to do this? thnx a lot, michelle ** *** ---> Q DOMAIN ** Policy ActivatedActivated Number ofDescription Domain Policy Default Registered Name Set Mgmt Nodes Class ----- BAKKERLA-BAK_POLI-BAK_MNGM- 4domain voor progress ND CY NTCLASS STANDARD STANDARD STANDARD 34Installed default policy domain. ** *** ---> Q MGMTCLASS ** PolicyPolicyMgmt Default Description DomainSet Name Class Mgmt NameName Class ? - - - - BAKKERLA- ACTIVEBAK_MNGM- Yes progress managementcl- ND NTCLASS ass BAKKERLA- BAK_POLI- BAK_MNGM- Yes progress managementcl- NDCYNTCLASS ass STANDARD ACTIVESTANDARD Yes Installed default management class. STANDARD STANDARD STANDARD Yes Installed defau
AW: Measuring progress of copy stgpool operation
Hi Arnaud, you could do something like this: Sum up the occupany numbers for the primary storagepool(s) and subtract the occupancy numbers of the copy storagepool. select sum(num_files), sum(physical_mb) from occupancy where stgpool_name='primary storagepoolname' minus select sum(num_files), sum(physical_mb) from occupancy where stgpool_name='copy storagepoolname' or if you have more primary storagepools you should replace "stgpool_name='..'" with "stgpool_name IN 'list of primary storagepools'" or "stgpool_name LIKE 'name%'" Hope this helps Kind regards Thomas Rupp Vorarlberger Illwerke AG -Ursprüngliche Nachricht- Von: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 23. Jänner 2003 14:55 An: [EMAIL PROTECTED] Betreff: Measuring progress of copy stgpool operation Hi all, Everything is in the title : is there a way (sql query ?) to find out, during a copy stgpool process, how many objects, or even better how many MB remains to be copied for finishing the process. Basically, the goal would be having an idea of remaining duration till the job ceases Thanks in advance ! Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SIZE of BACKED UP FILES & TSM activity report
Hi all, I would like to know if there is a command to run for having the total size (and the number) of all the files backed up on each node. This information is available in the activity log, but I prefer a command, if possible, to run for my daily TSM report. I would like also to have a "rather complete" example of a daily or weekly TSM report. Thanks in advance _ Gagne une PS2 ! Envoie un SMS avec le code PS au 61166 (0,35 Hors coût du SMS)
Re: SIZE of BACKED UP FILES & TSM activity report
>I would like to know if there is a command to run for >having the total size (and the number) of all the files >backed up on each node. This information is available in >the activity log, but I prefer a command, if possible, to >run for my daily TSM report. >I would like also to have a "rather complete" example of a >daily or weekly TSM report. For period reports, you should be delving into the TSM accounting log, which is the best information source for such reports. Richard Sims, BU
Antwort: Re: NT restore to different hardware
Hi, just 2 cents worth, wenn you restore a W2k server to different HW you have to install W2k first using the drivers for your HW. -The server is not in a Domain, but has the same name and IP address, -you restore the registry, then you restore the remainder of the files, you reboot. -when the server starts you press F6 and start up in savemode, if that is possible ( SCSI controller). - you add all your driver software for the new HW and boot in normal mode. - if W2k won't boot at all boot to the recovery console and and copy the driver files needed to the system etc directory. Generally speaking it has always worked, when we tested it, but so far, out of a lot of servers we only ever had to restore the data partitions of the servers. For DB servers we won't have that problem because they never last 5 years anyway, everyone always starts to complain that they are too slow, which means new HW in a matter of 2 years. Just a thought Best Regards Markus Veit An: [EMAIL PROTECTED] Kopie: Thema: Re: NT restore to different hardware [EMAIL PROTECTED] Received : 23.01.2003 15:00 Bitte antworten an "ADSM: Dist Stor Manager" Looks like there is no easy way to do a restore to different hardware. What happens if there is a disaster and you cannot get your 5 year old server from anywhere. How is TSM going to restore to that server! To me it looks like TSM is very good at taking backups and managing them but in the restore department I have serious doubts. How are other people doing their disaster recovery exercises? Do you keep identical hardware at DR site also? What happens if you need a faster server? There have been references to Redbook SG24-4880, however, this redbook tells you how to do a restore on identical hardware only. All comments are welcome.. Thanks Raminder Braich SAP/Oracle DBA The Davey Tree Expert Company Kent, OH, 44240.
Re: NT restore to different hardware
Hello Raminder, It is not that simple. Do not get confused with reasons for this problem - this is definitely an operating system related issue, and not one of backup software. Some procedures for disaster recovery on different hardware are described on microsoft web site but are NOT supported. Their limitations are almost independant on backup software. It is even not sure if you will be able to perform installation of today´s operating system on a computer from 2008, so why would you expect it from a backup software? Basically you complain about only one particular dependency among many others: - your data depends now as well as in 5 years on all of:know-how, application, organisational issues (passwords!) - applications depends on know-how and on operating system - operating system depends on know-how and on hardware - not to speak about cross-dependencies with other applications, network, legal regulations.. No backup software will ever be able to backup all of it, you only can create your backup for your particular configuration. maximalistic solution: if this problem is important enough, keep copy of all dependant parts, likedata, manuals, passwords, access lists, SW installation media, SW installation and configuration description, a n d quite naturally a copy of hardware as well. best regards ;) juraj Salak > -Original Message- > From: Braich, Raminder [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 3:00 PM > To: [EMAIL PROTECTED] > Subject: Re: NT restore to different hardware > > > Looks like there is no easy way to do a restore to different > hardware. What > happens if there is a disaster and you cannot get your 5 year > old server > from anywhere. How is TSM going to restore to that server! To > me it looks > like TSM is very good at taking backups and managing them but > in the restore > department I have serious doubts. > How are other people doing their disaster recovery exercises? > Do you keep > identical hardware at DR site also? What happens if you need a faster > server? > There have been references to Redbook SG24-4880, however, > this redbook tells > you how to do a restore on identical hardware only. > > All comments are welcome.. > > Thanks > Raminder Braich > SAP/Oracle DBA > The Davey Tree Expert Company > Kent, OH, 44240. >
Re: SIZE of BACKED UP FILES & TSM activity report
Hi Rachid, You should try "q occ [nodename]" or "q auditocc" (this one has to be preceeded by an "audit lic" to be up-to-date. For correct syntax and optionnal parameters do a "help q occ" using command line. Cheers. arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -Original Message- From: rachida Ouaraini [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 January, 2003 14:36 To: [EMAIL PROTECTED] Subject: SIZE of BACKED UP FILES & TSM activity report Hi all, I would like to know if there is a command to run for having the total size (and the number) of all the files backed up on each node. This information is available in the activity log, but I prefer a command, if possible, to run for my daily TSM report. I would like also to have a "rather complete" example of a daily or weekly TSM report. Thanks in advance _ Gagne une PS2 ! Envoie un SMS avec le code PS au 61166 (0,35 Hors coût du SMS)
Re: Measuring progress of copy stgpool operation
You can run a preview of what data will be backed up to the copy stgpool, & then launch the acutal backup copypool command. The preview will give you the amount of data that needs to be backed up from you primary storage pools to your copystgpool. Monte -Original Message- From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 7:55 AM To: [EMAIL PROTECTED] Subject: Measuring progress of copy stgpool operation Hi all, Everything is in the title : is there a way (sql query ?) to find out, during a copy stgpool process, how many objects, or even better how many MB remains to be copied for finishing the process. Basically, the goal would be having an idea of remaining duration till the job ceases Thanks in advance ! Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as "E-Contract Intended", this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html
Re: archiving questions
> -Original Message- > From: Michelle Wiedeman [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 5:04 AM > To: [EMAIL PROTECTED] > Subject: archiving questions > > Hi all, > > A client of mine requests that 220GB of databases are being > "archived" on tape and kept for 3 years. Michelle, All you have to do is define a management class with the proper retention period, don't forget to activate the policy set. Then from the client run dsmc archive -dirmc=thenameofthatmanagementclass (This binds the archive to that specific management class) This is the key option you need. Use -subdir=yes if you want subdirectories and then specify the folders to archive. You can add -description="Whatevername you want to give" Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: 64-Bit Filesystem
On Tue, 21 Jan 2003 08:40:23 +0100 Sascha Braeuning <[EMAIL PROTECTED]> wrote: > Hello TSMers, > > does anyone know, if TSM Client supports backing up a 64-Bit Filesystem. > Where can I find some hints in the docs? > > > I don't know what you think qualifies as 64bit, but at least jfs2 is supported. -- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl High Performance Computing Tel. +31 20 592 8008Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
Re: Measuring progress of copy stgpool operation
what i do is run the -prev=yes -wait=yes options, capture the total amount of bytes to be backed up, then when the backup is actually running i run a small script to query the backup sessions, capture the total bytes backed up, add them together, then get a percentage and amount remaining. these results will get skewed slightly if you continue running normal backups while the backup stgp is running or if you dont account for the fact that once its the near the end of the backup stg some of the sessions drop out of the list. -Original Message- From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 8:55 AM To: [EMAIL PROTECTED] Subject: Measuring progress of copy stgpool operation Hi all, Everything is in the title : is there a way (sql query ?) to find out, during a copy stgpool process, how many objects, or even better how many MB remains to be copied for finishing the process. Basically, the goal would be having an idea of remaining duration till the job ceases Thanks in advance ! Arnaud =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= | Arnaud Brion, Panalpina Management Ltd., IT Group | | Viaduktstrasse 42, P.O. Box, 4002 Basel - Switzerland | | Phone: +41 61 226 19 78 / Fax: +41 61 226 17 01 | =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Re: Exclude Statements
Hi, Should the exclude statements be in the dsm.sys or in a exclude file separate on a public directory for aix? What is the syntax? exclude/.../unix/../ exclude/.../core/../ exclude/.../.SpaceMan/.../* exclude.fs /.../u01/.../* exclude.fs /.../u02/.../* exclude.fs /.../u03/.../* exclude.fs /.../u04/.../*
Re: Exclude Statements
On NT - they are in one file - on Aix - there is a dsm.opt,dsm.sys (indicating the name of the INCLEXCL file - and the inclexcl file itself. Jane %%% Bassett Healthcare -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:16 AM To: [EMAIL PROTECTED] Subject: Re: Exclude Statements Hi, Should the exclude statements be in the dsm.sys or in a exclude file separate on a public directory for aix? What is the syntax? exclude/.../unix/../ exclude/.../core/../ exclude/.../.SpaceMan/.../* exclude.fs /.../u01/.../* exclude.fs /.../u02/.../* exclude.fs /.../u03/.../* exclude.fs /.../u04/.../*
Re: 64-Bit Filesystem
yes contact [EMAIL PROTECTED] -Original Message- From: Remco Post [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:48 AM To: [EMAIL PROTECTED] Subject: Re: 64-Bit Filesystem On Tue, 21 Jan 2003 08:40:23 +0100 Sascha Braeuning <[EMAIL PROTECTED]> wrote: > Hello TSMers, > > does anyone know, if TSM Client supports backing up a 64-Bit Filesystem. > Where can I find some hints in the docs? > > > I don't know what you think qualifies as 64bit, but at least jfs2 is supported. -- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl High Performance Computing Tel. +31 20 592 8008Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
Re: 64-Bit Filesystem
look through the docs on tivoli.com/support I believe that TSM client supports 64 bit on the AIX platform (TSM client 5.1.0 and 5.1.5). Ted W. Qualls UNIX Enterprise Engineering PepsiCo Business Solutions Group 5080 Spectrum Drive Suite 600W Addison, TX 75001 office: 972.376.7809 pgr:800.946.4645 pin 1090913 cell: 469.682.1773 email: [EMAIL PROTECTED] -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:12 AM To: [EMAIL PROTECTED] Subject: Re: 64-Bit Filesystem yes contact [EMAIL PROTECTED] -Original Message- From: Remco Post [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:48 AM To: [EMAIL PROTECTED] Subject: Re: 64-Bit Filesystem On Tue, 21 Jan 2003 08:40:23 +0100 Sascha Braeuning <[EMAIL PROTECTED]> wrote: > Hello TSMers, > > does anyone know, if TSM Client supports backing up a 64-Bit Filesystem. > Where can I find some hints in the docs? > > > I don't know what you think qualifies as 64bit, but at least jfs2 is supported. -- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl High Performance Computing Tel. +31 20 592 8008Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
Re: 64-Bit Filesystem
I would imagine that the 64-bit client would support anything 64-bit? Just
a thought.
--Justin Richard Bleistein
Unix Systems Administrator (Sungard eSourcing)
Desk: (856) 866 - 4017
Cell:(856) 912 - 0861
Email: [EMAIL PROTECTED]
"Qualls, Ted W
{PBSG}" To: [EMAIL PROTECTED]
Subject: Re: 64-Bit Filesystem
Sent by: "ADSM:
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
01/23/2003 11:10
AM
Please respond to
"ADSM: Dist Stor
Manager"
look through the docs on tivoli.com/support
I believe that TSM client supports 64 bit on the AIX platform (TSM client
5.1.0 and 5.1.5).
Ted W. Qualls
UNIX Enterprise Engineering
PepsiCo Business Solutions Group
5080 Spectrum Drive
Suite 600W
Addison, TX 75001
office: 972.376.7809
pgr:800.946.4645 pin 1090913
cell: 469.682.1773
email: [EMAIL PROTECTED]
-Original Message-
From: Andrews, Bert A [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 9:12 AM
To: [EMAIL PROTECTED]
Subject: Re: 64-Bit Filesystem
yes contact [EMAIL PROTECTED]
-Original Message-
From: Remco Post [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 9:48 AM
To: [EMAIL PROTECTED]
Subject: Re: 64-Bit Filesystem
On Tue, 21 Jan 2003 08:40:23 +0100
Sascha Braeuning <[EMAIL PROTECTED]> wrote:
> Hello TSMers,
>
> does anyone know, if TSM Client supports backing up a 64-Bit Filesystem.
> Where can I find some hints in the docs?
>
>
>
I don't know what you think qualifies as 64bit, but at least jfs2 is
supported.
--
Met vriendelijke groeten,
Remco Post
SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl
High Performance Computing Tel. +31 20 592 8008Fax. +31 20 668 3167
"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer
industry
didn't even foresee that the century was going to end." -- Douglas Adams
test
just testing, pleasde ignore
Re: Exclude Statements
does the file information be in both the dsm.opt and need to be in the dsm.sys here is the syntax: INCLExcl/tmp/dsm.backup.exclude exclude /.../core/.../* exclude /.../unix/.../* exclude /.../code/.../* exclude /.../home/.../* exclude /.../usr/.../* exclude /.../var/.../* ~ -Original Message- From: jane.bamberger [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:19 AM To: [EMAIL PROTECTED] Subject: Re: Exclude Statements On NT - they are in one file - on Aix - there is a dsm.opt,dsm.sys (indicating the name of the INCLEXCL file - and the inclexcl file itself. Jane %%% Bassett Healthcare -Original Message- From: Andrews, Bert A [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:16 AM To: [EMAIL PROTECTED] Subject: Re: Exclude Statements Hi, Should the exclude statements be in the dsm.sys or in a exclude file separate on a public directory for aix? What is the syntax? exclude/.../unix/../ exclude/.../core/../ exclude/.../.SpaceMan/.../* exclude.fs /.../u01/.../* exclude.fs /.../u02/.../* exclude.fs /.../u03/.../* exclude.fs /.../u04/.../*
tsm backup question
Now I've noticed sometimes when I backup a file which is considered large compared to others it goes right to tape. Here's my situation. I have a SUN system which has an Oracle database on it. When it backup the normal O/S files it backsup right to disk perfect real quick. Now when it hits a DBF which is only: "12 meg" mind you, it hangs there and says: "waiting for mount of offline media". Now there's plenty of room in the storage pool, migration doesn't need to run, there's like 200 gig in the disk stgpool free and the copy group is set for it to go right to disk. Now it's just not on Oracle DBF files sometimes it's on other application files..etc. It's like if a file is over a certain size regardless of the current disk storage pool utilization percentage it will still mount a tape and backup to tape?. Any ideas?. Is there something I'm missing? It's a problem because I do a backup for this client and I see there's more then enough disk storage pool space freed but not enough tape drives in the time they want it ran. No big deal I figure because I have more then enough disk space. WRONG, I kick the backup off and it still trys to mount a tape?. Any ideas would be appreciated thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: oh great SQL gurus..... statement for validating that all of the NT servers all have valid registry backups
This answer is only for the first points to your question: Instead of running a select statement at all, use the ODBC link and import the backups table into an MS Access DB. You can then run queries to your hearts content without any impact on your production TSM server. I have found a query in access to be quite a bit faster than a select in TSM. Now, before I get slammed, I use selects in TSM all the time but when it comes to complicated long running statements I usually decide to put the data in access. Kyle -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Lisa Cabanas Sent: Tuesday, January 21, 2003 10:31 AM To: [EMAIL PROTECTED] Subject: oh great SQL gurus. statement for validating that all of the NT servers all have valid registry backups Hello again, I was hoping one of you nice SQL gods/goddesses (Paul???) would help me construct a SQL select statement that won't halt my server, won't take days to run, and will help me validate that all of our NT servers all have active and inactive copies of c:\adsm.sys\...\MACHINE\* Now that I get to looking I don't easily see how to get what I am looking for with a select-- is this actually going to be a show bitfile kind-of-thing? (yuk) TIA lisa
Re: NT restore to different hardware
You can restore both NT4.0 and Win2K to different hardware. We have developed the procedures to do both and have done it many times. What made the research hard was the lack of 1 place to go to find the information needed. In the end I had to use rebooks, TSM Manuals and MS knowledge base articles. In addition a lot of testing. If someone was in a critical situation then I would be happy to work with them offline to help them get this done. However, do to the investment made in the procedures I can't post them to the list. Sorry. If you want further information please contact me directly at [EMAIL PROTECTED] Kyle -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Braich, Raminder Sent: Thursday, January 23, 2003 8:00 AM To: [EMAIL PROTECTED] Subject: Re: NT restore to different hardware Looks like there is no easy way to do a restore to different hardware. What happens if there is a disaster and you cannot get your 5 year old server from anywhere. How is TSM going to restore to that server! To me it looks like TSM is very good at taking backups and managing them but in the restore department I have serious doubts. How are other people doing their disaster recovery exercises? Do you keep identical hardware at DR site also? What happens if you need a faster server? There have been references to Redbook SG24-4880, however, this redbook tells you how to do a restore on identical hardware only. All comments are welcome.. Thanks Raminder Braich SAP/Oracle DBA The Davey Tree Expert Company Kent, OH, 44240.
Re: 64-Bit Filesystem
Some more clarity: a JFS2 filesystem is required for a 64-bit AIX 5L installation for the rootvg, but that doesn't make JFS2 a 64-bit filesystem. JFS2 is also referred to as Enhanced JFS. James B. Federline Maryville Technologies 7601 France Avenue S. Suite 140 Edina, MN 55435 Phone (952) 914-3024 Fax (952) 914-3041 [EMAIL PROTECTED] www.maryville.com -Original Message- From: Remco Post [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 8:48 AM To: [EMAIL PROTECTED] Subject: Re: 64-Bit Filesystem On Tue, 21 Jan 2003 08:40:23 +0100 Sascha Braeuning <[EMAIL PROTECTED]> wrote: > Hello TSMers, > > does anyone know, if TSM Client supports backing up a 64-Bit Filesystem. > Where can I find some hints in the docs? > > > I don't know what you think qualifies as 64bit, but at least jfs2 is supported. -- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdamhttp://www.sara.nl High Performance Computing Tel. +31 20 592 8008Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
Re: tsm backup question
On Thu, 2003-01-23 at 10:54, Justin Bleistein wrote: > Now I've noticed sometimes when I backup a file which is considered > large compared to others it goes right to tape. You probably have a maximum file size set for the disk storage pool. -- Mark Stapleton ([EMAIL PROTECTED])
Re: Some information...
Nicolas, Yes, yes, yes - TSM supports backups of all files on an AIX system including all volume groups and file systems. There is also support for logical volume snapshot backups which means that TSM will backup the entire file system as one logical unit. The only probably with this is that you cannot restore individual files out of it. -- Joshua S. Bassi IBM Certified - AIX 4/5L, SAN, Shark Tivoli Certified Consultant -ADSM/TSM eServer Systems Expert -pSeries HACMP AIX, HACMP, Storage, TSM Consultant Cell (831) 595-3962 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Nicolas Savva Sent: Thursday, January 23, 2003 3:54 AM To: [EMAIL PROTECTED] Subject: Some information... Hi, I need some help for the following: 1. Is TSM capable to perform System Backup on AIX box? 2. Is TSM capable to perform Volume Group Backup? 3. Is TSM capable to perform File System Backup? Nicolas Savva Assistant System Specialist Information Services Laiki Group 11 Arch Makarios Ave. CY-1065 Nicosia CYPRUS Tel +357 22812473 Fax +357 22812583 Email: [EMAIL PROTECTED] Web Site: http://www.laiki.com Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message.
Re: tsm backup question
Hi Justin, There is a setting on the disk storage pool called maxsize. This value (which is no limit by default) specifies the maximum size for a physical file in the storage pool. You must specify the scale factor (K,M,G,T) when setting this attribute (i.e. update stg diskpool maxsize=4G) otherwise it defaults to bytes! Laura Buckley STORServer, Inc./SSSI [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Justin Bleistein Sent: Thursday, January 23, 2003 9:54 AM To: [EMAIL PROTECTED] Subject: tsm backup question Now I've noticed sometimes when I backup a file which is considered large compared to others it goes right to tape. Here's my situation. I have a SUN system which has an Oracle database on it. When it backup the normal O/S files it backsup right to disk perfect real quick. Now when it hits a DBF which is only: "12 meg" mind you, it hangs there and says: "waiting for mount of offline media". Now there's plenty of room in the storage pool, migration doesn't need to run, there's like 200 gig in the disk stgpool free and the copy group is set for it to go right to disk. Now it's just not on Oracle DBF files sometimes it's on other application files..etc. It's like if a file is over a certain size regardless of the current disk storage pool utilization percentage it will still mount a tape and backup to tape?. Any ideas?. Is there something I'm missing? It's a problem because I do a backup for this client and I see there's more then enough disk storage pool space freed but not enough tape drives in the time they want it ran. No big deal I figure because I have more then enough disk space. WRONG, I kick the backup off and it still trys to mount a tape?. Any ideas would be appreciated thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: NT restore to different hardware
First of all, TSM is only an application that runs on OS. It is not a super software that can work for all types of machines for all ages of OS. It must work with OS to call file system to read/write files. Therefore, a disaster recovery plan must have a COMPATIBLE machines at DR site. If a production site is running W2K on P4 with UTP 10BaseT Ethernet card and I don't believe DR site will use a 286 machine with BNC card. Not only W2K may not work not a 286, one may not be able to find a network driver for this machine. I believe the basic requirement for a DR is to have COMPATIBLE machine that can boot up with the same OS version, same type of tape drive and sufficient disk space to restore data. I wouldn't expect my Window XP server running on P4 to be able to start up on IBM AT with 640MB, right ? So the planning of DR is to have compatible machines, not identical machines. The way to set up DR for TSM is to have a compatible machine with the same OS version, patch level, same type of tape drive. Install TSM on it. If anything happened on TSM at production site, just restore TSM database and it will be fine. It is not necessary to have identical machine, but you have ensure that you have the same OS version, patch level, same TSM version and already configure the tape drive/library. For example, you can have a RAID disk for TSM server at production site but non-RAID disk as TSM server for DR site. TSM does not carry about RAID because it is OS level, NOT TSM level. So can have different machine in this sense. Thanks & Regards William |-+> | | Salak Juraj | | | <[EMAIL PROTECTED]| | | T> | | | Sent by: "ADSM: | | | Dist Stor| | | Manager" | | | <[EMAIL PROTECTED]| | | .EDU>| | || | || | | 23/01/2003 22:34 | | | Please respond to| | | "ADSM: Dist Stor | | | Manager" | | || |-+> >| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: NT restore to different hardware | | | | | >| Hello Raminder, It is not that simple. Do not get confused with reasons for this problem - this is definitely an operating system related issue, and not one of backup software. Some procedures for disaster recovery on different hardware are described on microsoft web site but are NOT supported. Their limitations are almost independant on backup software. It is even not sure if you will be able to perform installation of today´s operating system on a computer from 2008, so why would you expect it from a backup software? Basically you complain about only one particular dependency among many others: - your data depends now as well as in 5 years on all of:know-how, application, organisational issues (passwords!) - applications depends on know-how and on operating system - operating system depends on know-how and on hardware - not to speak about cross-dependencies with other applications, network, legal regulations.. No backup software will ever be able to backup all of it, you only can create your backup for your particular configuration. maximalistic solution: if this problem is important enough, keep copy of all dependant parts, likedata, manuals, passwords, access lists, SW installation media, SW installation and configuration description, a n d quite naturally a copy of hardware as well. best regards ;) juraj Salak > -Original Message- > From: Braich, Raminder [mailto:[EMAIL PROTECTED]] > Sent: Thursday, Januar
Re: Netware NDS question for TSM
I have sometimes had a problem where the password file has become corrupt. You can delete the tsm.pwd and then query tsa again. This will create a new tsm.pwd file. The path is; SYS:TIVOLI\TSM\CLIENT\BA\TSM.PWD -Original Message- From: Flemming Hougaard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 12:51 PM To: [EMAIL PROTECTED] Subject: SV: Netware NDS question for TSM Have u used the "DSMC QUERY TSA NDS"? and the "NWPWFILE YES" in the DSM.OPT? Sometimes it still fails, and then u can use the following "NWUSer treename:.username.context:password" eg.nwuser treea:.admin.ibm:secret Regards Flemming -Oprindelig meddelelse- Fra: Ron Lochhead [mailto:[EMAIL PROTECTED]] Sendt: 14. januar 2003 19:29 Til: [EMAIL PROTECTED] Emne: Netware NDS question for TSM OS= Netware 4.11 TSM = 3.1.0.6 NDS = 6.13 We are backing up multiple Netware servers using a older ver of the TSM client because the Netware client back in June 2002 would not work on those servers. We recently setup NDS to be backed up via the scheduler and now when the scheduler attempts to kick off the backup it prompts for a Netware user id and pw? So does anyone know how we can insert the Netware user id and pw to prevent this from taking place? Thanks in advance. Ron Lochhead
Re: How to Run a Schedule on the first Saturday of each month.
Define the schedule with perunits=onetime. Define a script and invoke it *each* Saturday through (another - administrative) schedule: "select 1 from db where day(current_date)<=7 if (rc_ok) goto is_first done: exit is_first: upd sch startd=today" The client schedule will fire only once. The administrative schedule will fire each Saturday. If the day is first Saturday of the month it will update the client schedule to start again in that day. Parameters of the client schedule will mandate when exactly and what action will take place. Appropriate duration options mandate startup window. Zlatko Krastev IT Consultant "Fought,Tom" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 21.01.2003 15:09 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:How to Run a Schedule on the first Saturday of each month. Please instruct me on how to setup a schedule which runs only on the first Saturday of each month. I find the schedule options somewhat unclear. Thanks Tom
Re: tsm backup question
If the problem is not maxsize, check all the copy groups in the domain and see if ANY of them are pointing direct to tape. (You can check what management class a file is bound to by opening the GUI and clicking RESTORE as though you want to restore the file. Scroll to the far right, it shows the management class. ) Directories get bound to the management class with the longest retention period (RETONLY), and you can hose yourself that way. Fix it by creating a dummy management class with a copy group that points direct to disk, but has a RETONLY 1 day longer. -Original Message- From: Mark Stapleton [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:14 PM To: [EMAIL PROTECTED] Subject: Re: tsm backup question On Thu, 2003-01-23 at 10:54, Justin Bleistein wrote: > Now I've noticed sometimes when I backup a file which is considered > large compared to others it goes right to tape. You probably have a maximum file size set for the disk storage pool. -- Mark Stapleton ([EMAIL PROTECTED])
Re: tsm backup question
Hi, You have set an option called MAXFILE=some MB in disk storage. pool, so when the individual file size is greater that that it will automatically move to the primary tape pool. You can increase the size of this option if you want all files to go to disk storage pool Ragrds N.Suresh -Original Message- From: Justin Bleistein [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 5:54 PM To: [EMAIL PROTECTED] Subject: tsm backup question Now I've noticed sometimes when I backup a file which is considered large compared to others it goes right to tape. Here's my situation. I have a SUN system which has an Oracle database on it. When it backup the normal O/S files it backsup right to disk perfect real quick. Now when it hits a DBF which is only: "12 meg" mind you, it hangs there and says: "waiting for mount of offline media". Now there's plenty of room in the storage pool, migration doesn't need to run, there's like 200 gig in the disk stgpool free and the copy group is set for it to go right to disk. Now it's just not on Oracle DBF files sometimes it's on other application files..etc. It's like if a file is over a certain size regardless of the current disk storage pool utilization percentage it will still mount a tape and backup to tape?. Any ideas?. Is there something I'm missing? It's a problem because I do a backup for this client and I see there's more then enough disk storage pool space freed but not enough tape drives in the time they want it ran. No big deal I figure because I have more then enough disk space. WRONG, I kick the backup off and it still trys to mount a tape?. Any ideas would be appreciated thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: tsm backup question
I see that now with a: "q stgpool pool_name f=d". Thanks man that's explains it. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED] Laura Buckley cc: Sent by: "ADSM: Subject: Re: tsm backup question Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 01/23/2003 12:16 PM Please respond to buckley Hi Justin, There is a setting on the disk storage pool called maxsize. This value (which is no limit by default) specifies the maximum size for a physical file in the storage pool. You must specify the scale factor (K,M,G,T) when setting this attribute (i.e. update stg diskpool maxsize=4G) otherwise it defaults to bytes! Laura Buckley STORServer, Inc./SSSI [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]] On Behalf Of Justin Bleistein Sent: Thursday, January 23, 2003 9:54 AM To: [EMAIL PROTECTED] Subject: tsm backup question Now I've noticed sometimes when I backup a file which is considered large compared to others it goes right to tape. Here's my situation. I have a SUN system which has an Oracle database on it. When it backup the normal O/S files it backsup right to disk perfect real quick. Now when it hits a DBF which is only: "12 meg" mind you, it hangs there and says: "waiting for mount of offline media". Now there's plenty of room in the storage pool, migration doesn't need to run, there's like 200 gig in the disk stgpool free and the copy group is set for it to go right to disk. Now it's just not on Oracle DBF files sometimes it's on other application files..etc. It's like if a file is over a certain size regardless of the current disk storage pool utilization percentage it will still mount a tape and backup to tape?. Any ideas?. Is there something I'm missing? It's a problem because I do a backup for this client and I see there's more then enough disk storage pool space freed but not enough tape drives in the time they want it ran. No big deal I figure because I have more then enough disk space. WRONG, I kick the backup off and it still trys to mount a tape?. Any ideas would be appreciated thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Generate Backupset not getting all files?
Greetings TSM'ers, Environment: Server: Win2k-SP3 TSM V5.1.1.0 Client: NT4-SP6 TSM V5.1.5.0 I am trying to generate a backupset for a new node. The generation only takes a few minutes (for a node with 30GB of data writing to a DDS4 drive ?) and returns successfully. However, the only sequential volumes mounted are 2 FILE type volumes used to store the directory info (via DIRMC option). The node file data is in a collocated tape pool (only takes 1 LTO tape) and that tape volume is never mounted. If I do a Q BACKUPSETCONTENTS on this set, I get a listing of the directories from this node, but not all the files. Only a few files show up at the bottom of the list. Yet, the generation completes with a completion state of success. Now, there is a diskpool caching in front of this tape pool, and that pool is used during the process. Essentially it appears to be using only the diskpool cache and not the tape, and skips files that are not in the disk cache. The command I used was: GENERATE BACKUPSET TEST-BKPSET * dev=DDS4 ret=10 Also tried: GENERATE BACKUPSET TEST-BKPSET 1,2,3 dev=DDS4 ret=10 NAMETYPE=FSID Both produce the same result. I have generated many backupsets for other nodes without issue using this same syntax. Ideas? Its probably a PEBKAC (Problem Exists Between Keyboard And Chair) error, but I am not seeing it! Thanx in advance all! Chris Murphy IT Network Analyst Idaho Dept. of Lands Office: (208) 334-0293 [EMAIL PROTECTED]
Re: tsm backup question
thanks for all of the responses to this question. I'm now a bit wiser (well in TSM anyways). Thanks again :o)!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
tsm db question
Is there anyway to find out like through a "select" statement or something which O/S db volume a specific table is located in. When a I do a: "q dbvol" our database is spread across multiple db volumes/files. It would just be nice to see what volume a table is actually physically located in or spread across multiple volumes and which ones? Just a thought. Thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: Exclude filesystem on Solaris
--> "Excl Filespace /mnt/stats" So the filesystem is really excluded. If you run backups through "dsmc incr" or schedule it should not be sent. As far as I understand you are concerned the filesystem still shows up in GUI, right. --> "Here is a bit more info. TSM Server 4.2.2.12 running on Solaris 2.7 TSM Client 3.7.2.0 running on Solaris 2.6" The client is rather old (just after I was born :-) Have you tried with *any* newer version client? Solaris 2.6 is supported even in v5.1 so you have a wide choice of v4.1.x, v4.2.y & v5.1.z I would say this is GUI client bug which you could report in 1999 but not now. Sounds like I worked too much with IBM and started express myself as an IBMer :-) Zlatko Krastev IT Consultant
Re: tsm db question
Unless the "table" is very small it usualy is spread on (nearly) all volumes. Table records are physically located on pages and each page might be on different volume. If later the volume is deleted all pages residing on it are moved to other dbvols. I am writing "table" because what we see in TSM admin interface is more similar to views in RDBMSes - read-only representation of one or more real tables. Zlatko Krastev IT Consultant Justin Bleistein <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 23.01.2003 20:49 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:tsm db question Is there anyway to find out like through a "select" statement or something which O/S db volume a specific table is located in. When a I do a: "q dbvol" our database is spread across multiple db volumes/files. It would just be nice to see what volume a table is actually physically located in or spread across multiple volumes and which ones? Just a thought. Thanks!. --Justin Richard Bleistein Unix Systems Administrator (Sungard eSourcing) Desk: (856) 866 - 4017 Cell:(856) 912 - 0861 Email: [EMAIL PROTECTED]
Re: NT restore to different hardware
-First of all, TSM is only an application that runs on OS. It is not a super software that can work for all types of machines for all ages of OS. It must work with OS to call file system to read/write files. It may not run on all OS's but according to this http://www.tivoli.com/products/index/storage-mgr/platforms.html link it says Win NT 4.0 SP 6a is a supported platform. To me supported means that all the components of the application work for that platform. Now does supported platform mean that TSM works only for backups on NT and not for restores? If that is what supported platform means then I am SOL. -Therefore, a disaster recovery plan must have a COMPATIBLE machines at DR site. If a production site is running W2K on P4 with UTP 10BaseT Ethernet card and I don't believe DR site will use a 286 machine with BNC card. Not only W2K may not work not a 286, one may not be able to find a network driver for this machine. How do you define compatibility? Would a Compaq server be compatible with a dell or an IBM server. All of them can run many versions of windows. Does it mean they are compatible. If they are, how about their network cards and video cards? Every manufacturer uses different cards. Even if you take the same manufacturer IBM 7000 M10 vs. IBM eserver x360 are they compatible? Well, they are not at least to WIN NT. -I believe the basic requirement for a DR is to have COMPATIBLE machine that can boot up with the same OS version, same type of tape drive and sufficient disk space to restore data. I wouldn't expect my Window XP server running on P4 to be able to start up on IBM AT with 640MB, right ? So the planning of DR is to have compatible machines, not identical machines. I highly doubt if you just need compatible hardware. Were it so simple, how come there is no documentation for the restore procedure? As others have said the restore process is not even supported by MS. No you may not be able to start Windows XP server running on P4 on IBM AT but you sure can run it on a pc with 300Mhz with 128MB. The way to set up DR for TSM is to have a compatible machine with the same OS version, patch level, same type of tape drive. Install TSM on it. If anything happened on TSM at production site, just restore TSM database and it will be fine. It is not necessary to have identical machine, but you have ensure that you have the same OS version, patch level, same TSM version and already configure the tape drive/library. For example, you can have a RAID disk for TSM server at production site but non-RAID disk as TSM server for DR site. TSM does not carry about RAID because it is OS level, NOT TSM level. So can have different machine in this sense. Thanks & Regards William |-+> | | Salak Juraj | | | <[EMAIL PROTECTED]| | | T> | | | Sent by: "ADSM: | | | Dist Stor| | | Manager" | | | <[EMAIL PROTECTED]| | | .EDU>| | || | || | | 23/01/2003 22:34 | | | Please respond to| | | "ADSM: Dist Stor | | | Manager" | | || |-+> >--- -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: NT restore to different hardware | | | | | >--- -| Hello Raminder, It is not that simple. Do not get confused with reasons for this problem - this is definitely an operating system related issue, and not one of backup software. Some procedures for disaster recovery on different hardware are described on microsoft web site but are NOT supported. Their limitations are almost independant on backup software. It is even not sure if you will be able to perform installation of today´s operating system on a computer from 2008, so why would you expect it from a backup software? Basically you complain about only one particular dependency among many others: - your data depends now as well as in 5 years on all of:know-how, application, organisational issues (passwords!) - applications depends on know-how and on operating system - operating system depends on know-how and on hardware - not to speak about cross-dependencies with other applications, network, legal regulations.. No backup software will ever be able to backup all of it, you only can create your backup for your particular configuration. maximalistic solution: if this problem is imp
Re: NT restore to different hardware
Sure, it would be best if you had the same or very similar hardware to DR onto. If you do then the DR process is of course much easier. For those of you who want to know if this is a requirement, it simply isn't. Here are the requirements. 1) If NT4.0 enterprise was on the original server then NT4.0 enterprise must be used for the DR. You can't take something that was backed up on Win2K and restore it to a server using Win2K Advanced Server or NT4.0. 2) You must also use the same patch level that means SP and any hotfixes. Ok, some hotfixes may not matter but most do. 3) If you had a Multiprocessor system then you must DR to a multiprocessor system because MS has a different kernel for single -vs.- multiprocessor systems. That's it. If you have a different NIC, HBA, or SCSCI card in the DR system then you will of course have to install new for the new cards. However, those things will not stop a DR/BR. You don't even have to have the same server manufacturer. Some customers need to get some of their servers up and running on machines that are as fast or faster than they were in production, I don't doubt this. However, in some cases that isn't necessary and not economically feasible which is why I am posting this. You CAN DR both NT4.0 and Win2K onto different hardware so long as you follow the requirements I listed above. Kyle Payne [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of William SO Ng Sent: Thursday, January 23, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: Re: NT restore to different hardware First of all, TSM is only an application that runs on OS. It is not a super software that can work for all types of machines for all ages of OS. It must work with OS to call file system to read/write files. Therefore, a disaster recovery plan must have a COMPATIBLE machines at DR site. If a production site is running W2K on P4 with UTP 10BaseT Ethernet card and I don't believe DR site will use a 286 machine with BNC card. Not only W2K may not work not a 286, one may not be able to find a network driver for this machine. I believe the basic requirement for a DR is to have COMPATIBLE machine that can boot up with the same OS version, same type of tape drive and sufficient disk space to restore data. I wouldn't expect my Window XP server running on P4 to be able to start up on IBM AT with 640MB, right ? So the planning of DR is to have compatible machines, not identical machines. The way to set up DR for TSM is to have a compatible machine with the same OS version, patch level, same type of tape drive. Install TSM on it. If anything happened on TSM at production site, just restore TSM database and it will be fine. It is not necessary to have identical machine, but you have ensure that you have the same OS version, patch level, same TSM version and already configure the tape drive/library. For example, you can have a RAID disk for TSM server at production site but non-RAID disk as TSM server for DR site. TSM does not carry about RAID because it is OS level, NOT TSM level. So can have different machine in this sense. Thanks & Regards William |-+> | | Salak Juraj | | | <[EMAIL PROTECTED]| | | T> | | | Sent by: "ADSM: | | | Dist Stor| | | Manager" | | | <[EMAIL PROTECTED]| | | .EDU>| | || | || | | 23/01/2003 22:34 | | | Please respond to| | | "ADSM: Dist Stor | | | Manager" | | || |-+> >--- -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: NT restore to different hardware | | | | | >--- -| Hello Raminder, It is not that simple. Do not get confused with reasons for this problem - this is definitely an operating system related issue, and not one of backup software. Some procedures for disaster recovery on different hardware are described on microsoft web site but are NOT supported. Their limitations are almost independant on backup software. It is even not sure if you will be able to perform installation of today´s operating system on a computer from 2008, so why would you expect it from a backup software? Basically you complain about only one particular dependency among many others: - your data depends now as well as in 5 years on all of:know-how, applic
Re: NT restore to different hardware
Check out: How to Troubleshoot Windows 2000 Hardware Abstraction Layer Issues, Microsoft Knowledge Base article 237556, for a better description of the issues. The biggest issue is the power management of the chip set, in other words, the motherboard. Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] Kyle Payne <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/23/2003 04:18 PM Please respond to payne To: [EMAIL PROTECTED] cc: Subject:Re: NT restore to different hardware Sure, it would be best if you had the same or very similar hardware to DR onto. If you do then the DR process is of course much easier. For those of you who want to know if this is a requirement, it simply isn't. Here are the requirements. 1) If NT4.0 enterprise was on the original server then NT4.0 enterprise must be used for the DR. You can't take something that was backed up on Win2K and restore it to a server using Win2K Advanced Server or NT4.0. 2) You must also use the same patch level that means SP and any hotfixes. Ok, some hotfixes may not matter but most do. 3) If you had a Multiprocessor system then you must DR to a multiprocessor system because MS has a different kernel for single -vs.- multiprocessor systems. That's it. If you have a different NIC, HBA, or SCSCI card in the DR system then you will of course have to install new for the new cards. However, those things will not stop a DR/BR. You don't even have to have the same server manufacturer. Some customers need to get some of their servers up and running on machines that are as fast or faster than they were in production, I don't doubt this. However, in some cases that isn't necessary and not economically feasible which is why I am posting this. You CAN DR both NT4.0 and Win2K onto different hardware so long as you follow the requirements I listed above. Kyle Payne [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of William SO Ng Sent: Thursday, January 23, 2003 11:30 AM To: [EMAIL PROTECTED] Subject: Re: NT restore to different hardware First of all, TSM is only an application that runs on OS. It is not a super software that can work for all types of machines for all ages of OS. It must work with OS to call file system to read/write files. Therefore, a disaster recovery plan must have a COMPATIBLE machines at DR site. If a production site is running W2K on P4 with UTP 10BaseT Ethernet card and I don't believe DR site will use a 286 machine with BNC card. Not only W2K may not work not a 286, one may not be able to find a network driver for this machine. I believe the basic requirement for a DR is to have COMPATIBLE machine that can boot up with the same OS version, same type of tape drive and sufficient disk space to restore data. I wouldn't expect my Window XP server running on P4 to be able to start up on IBM AT with 640MB, right ? So the planning of DR is to have compatible machines, not identical machines. The way to set up DR for TSM is to have a compatible machine with the same OS version, patch level, same type of tape drive. Install TSM on it. If anything happened on TSM at production site, just restore TSM database and it will be fine. It is not necessary to have identical machine, but you have ensure that you have the same OS version, patch level, same TSM version and already configure the tape drive/library. For example, you can have a RAID disk for TSM server at production site but non-RAID disk as TSM server for DR site. TSM does not carry about RAID because it is OS level, NOT TSM level. So can have different machine in this sense. Thanks & Regards William |-+> | | Salak Juraj | | | <[EMAIL PROTECTED]| | | T> | | | Sent by: "ADSM: | | | Dist Stor| | | Manager" | | | <[EMAIL PROTECTED]| | | .EDU>| | || | || | | 23/01/2003 22:34 | | | Please respond to| | | "ADSM: Dist Stor | | | Manager" | | || |-+> >--- -| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: NT restore to different hardware | | | | | >--- -
trying to restore SQL master DB
Hi, We are running TSM 5.1.0 on Win 2000. I am doing testing at the DR site and am having some trouble. I was able to restore the TSM DB OK. Then I started restoring the SQL master DB using TDP SQL (v.2.2). I stopped SQL, restarted it in single user mode and then restored from TDP SQL. Tivoli asks for tape , mounts the tape, tries to read from tape then SQL comes up with error message and SQL stops itself, Tivoli breaks connection and restore fails. Here is the SQL log. There are no error messages in Tivoli logs. Does anyone have any suggestions? Any help will be appreciated. Thanks regards, Sona SQL Error Log: 2003-01-23 16:33:22.53 serverCopyright (C) 1988-2000 Microsoft Corporation. 2003-01-23 16:33:22.54 serverAll rights reserved. 2003-01-23 16:33:22.54 serverServer Process ID is 1360. 2003-01-23 16:33:22.56 serverLogging SQL Server messages in file 'g:\Microsoft SQL Server\MSSQL\log\ERRORLOG'. 2003-01-23 16:33:22.57 serverSQL Server is starting at priority class 'normal'(4 CPUs detected). 2003-01-23 16:33:22.90 serverSQL Server configured for thread mode processing. 2003-01-23 16:33:22.92 serverUsing dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2003-01-23 16:33:22.95 serverAttempting to initialize Distributed Transaction Coordinator. 2003-01-23 16:33:24.10 spid3 Warning ** 2003-01-23 16:33:24.12 spid3 SQL Server started in single user mode. Updates allowed to system catalogs. 2003-01-23 16:33:24.12 spid3 Starting up database 'master'. 2003-01-23 16:33:24.18 spid3 0 transactions rolled back in database 'master' (1). 2003-01-23 16:33:24.18 spid3 Recovery is checkpointing database 'master' (1) 2003-01-23 16:33:24.25 spid3 Server name is 'xxx'. 2003-01-23 16:33:24.25 serverUsing 'SSNETLIB.DLL' version '8.0.534'. 2003-01-23 16:33:24.25 spid5 Starting up database 'model'. 2003-01-23 16:33:24.26 spid7 Starting up database 'msdb'. 2003-01-23 16:33:24.26 spid8 Starting up database 'pubs'. 2003-01-23 16:33:24.28 spid9 Starting up database 'Northwind'. 2003-01-23 16:33:24.32 spid5 Clearing tempdb database. 2003-01-23 16:33:24.35 serverSQL server listening on xx.x.x.x: . 2003-01-23 16:33:24.35 serverSQL server listening on xxx.x.x.x: . 2003-01-23 16:33:24.46 serverSQL server listening on TCP, Shared Memory, Named Pipes. 2003-01-23 16:33:24.46 serverSQL Server is ready for client connections 2003-01-23 16:33:24.90 spid5 Starting up database 'tempdb'. 2003-01-23 16:33:24.95 spid3 Recovery complete. 2003-01-23 16:33:24.95 spid3 SQL global counter collection task is created. 2003-01-23 16:34:26.48 spid51Using 'xpstar.dll' version '2000.80.534' to execute extended stored procedure 'xp_servicecontrol'. 2003-01-23 16:39:08.42 spid51Unnamed tape (Family ID: 0x10371d6a, sequence 1) mounted on tape drive 'TDPSQL-0B14-'. 2003-01-23 16:39:08.62 spid51Error: 9001, Severity: 21, State: 1. 2003-01-23 16:39:08.64 spid51Error: 3151, Severity: 21, State: 0. This e-mail is confidential and is intended solely for the use of the individual or entity to whom it is addressed. If you are not an intended recipient then you have received this e-mail in error and any use, dissemination, forwarding, printing or copying is strictly prohibited. You should contact the sender by return then delete all the material from your system.
Re: Some information...
NO NO YES Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -Original Message- From: Nicolas Savva [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:54 AM To: [EMAIL PROTECTED] Subject: Some information... Hi, I need some help for the following: 1. Is TSM capable to perform System Backup on AIX box? 2. Is TSM capable to perform Volume Group Backup? 3. Is TSM capable to perform File System Backup? Nicolas Savva Assistant System Specialist Information Services Laiki Group 11 Arch Makarios Ave. CY-1065 Nicosia CYPRUS Tel +357 22812473 Fax +357 22812583 Email: [EMAIL PROTECTED] Web Site: http://www.laiki.com Privileged/Confidential information may be contained in this message and may be subject to legal privilege. Access to this e-mail by anyone other than the intended recipient is unauthorised. If you are not the intended recipient (or responsible for delivery of the message to such person), you may not use, copy, distribute or deliver to anyone this message (or any part of its contents) or take any action in reliance on it. In such case, you should destroy this message, and notify us immediately. If you have received this email in error, please notify us immediately by e-mail or telephone and delete the e-mail from any computer. If you or your employer does not consent to internet e-mail messages of this kind, please notify us immediately. All reasonable precautions have been taken to ensure no viruses are present in this e-mail. As we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments we recommend that you subject these to your virus checking procedures prior to use. The views, opinions, conclusions and other information expressed in this electronic mail are not given or endorsed by Laiki Group unless otherwise indicated by an authorised representative independent of this message.
Q: Reread the Discpool-Cache files
Good morning, we have a problem with our data in a primary storage pool. Our worm are corrupted about the apar IC35442 We have aix 4.3.3 and tsm-server 5.1.5.3 . All data cached in a diskpool for 1 year. I have migrate the data to the worm but the worm are damaged. We have defined a copypool but about the apar IC35442 the data also damaged. All data stay in the discpool as cached file. Is there any solution in tsm to reread this cached file to produced a new storagepool ?? What about a new primary storagepool as nextstoragepool when i mark the worm "unav or damaged" ?? thanks Michael Garnebode
Re: Q: Reread the Discpool-Cache files
Just a suggestion here - maybe some of the other members of the listserv can comment as to whether or not this would work: 1. update the stgp you have defined so that cache=NO. This does not clear the cache out. 2. Stop all backup processing. 3. Migrate down to 0 - this leaves only your cached files. 4. Do Move Data commands on all the disk volumes to a new storage pool. This picks up all the cached data. 5. Define a new copy storagepool, and do a backup stgp of the new primary disk storagepool to the new copypool. At 07:04 AM 1/24/2003 +0100, you wrote: Good morning, we have a problem with our data in a primary storage pool. Our worm are corrupted about the apar IC35442 We have aix 4.3.3 and tsm-server 5.1.5.3 . All data cached in a diskpool for 1 year. I have migrate the data to the worm but the worm are damaged. We have defined a copypool but about the apar IC35442 the data also damaged. All data stay in the discpool as cached file. Is there any solution in tsm to reread this cached file to produced a new storagepool ?? What about a new primary storagepool as nextstoragepool when i mark the worm "unav or damaged" ?? thanks Michael Garnebode Money is not the root of all evil - full backups are.
Re: archiving questions
Hello Michelle, if you did the tasks, Andrew expected in the mail before, you can perform an archive operation with the option archmc=. For example you can use the following command to archive files in your diectory d:\archive: archive archmc=archclass d:\archive\* If you use the option -deletefiles, files archived will be deleted on the client! I think, it's very comfortable to use. Also see your document how to use your Backup/Archive Client. There you can get more information about special options. MfG/regards Sascha Bräuning Sparkassen Informatik, Fellbach OrgEinheit: 6322 Wilhelm-Pfitzer Str. 1 70736 Fellbach Telefon: (0711) 5722-2144 Telefax: (0711) 5722-1634 Mailadr.: [EMAIL PROTECTED] -- Weitergeleitet von Sascha Bräuning/6322/FE/SI/DE on 24.01.2003 08:45 --- Andrew Raibeck <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 23.01.2003 14:30:21 Bitte antworten an "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> An: [EMAIL PROTECTED] Kopie: Thema: Re: archiving questions Hi Michelle, You will need a management class with an archive copy group that retains the data for 3 years. Therefore you will need to: 1) Create a new management class in the desired domain/policy set. (See DEFINE MGMTCLASS in the Administrator's Reference.) 2) Create an archive copygroup in the new management class with the desired retention. (See DEFINE COPYGROUP in the Administrator's Reference.) 3) Activate the policy set. (See ACTIVATE POLICYSET in the Administrator's Reference.) If you are not the TSM server administrator, then you will need to have that person perform these tasks. Once the new management class is available, you can run the archive and bind the files to that new management class. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. Michelle Wiedeman <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/23/2003 06:03 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:archiving questions Hi all, A client of mine requests that 220GB of databases are being "archived" on tape and kept for 3 years. I've been looking for a way on how to do this but the manuals only speak of how the archive client command works. Not really on how things work on the serverside. I assume I'll have to make another managementclaas which defines how long to keep trhe files etc. but I'm not sure how to go about this. below are the specifics on our current mg classes; the domain I'm speaking of is the one called progress. Does anyone have some ideas on how to do this? thnx a lot, michelle ** *** ---> Q DOMAIN ** Policy ActivatedActivated Number ofDescription Domain Policy Default Registered Name Set Mgmt Nodes Class ----- BAKKERLA-BAK_POLI-BAK_MNGM- 4domain voor progress ND CY NTCLASS STANDARD STANDARD STANDARD 34Installed default policy domain. ** *** ---> Q MGMTCLASS ** PolicyPolicyMgmt Default Description DomainSet Name Class Mgmt NameName Class ? - - - - BAKKERLA- ACTIVEBAK_MNGM- Yes progress managementcl- ND NTCLASS ass BAKKERLA- BAK_POLI- BAK_MNGM- Yes progress managementcl- NDCYNTCLASS ass STANDARD ACTIVESTANDARD Yes Installed default management class. STANDARD STANDARD STANDARD Yes Installed default management class. ** *** ---> Q COPYGROUP * * * STANDARD TYPE=BACKUP ** PolicyPolicyMgmt Copy Versions Versions Retain Retain DomainSet Name Class Group Data DataExtraOnly NameName NameExists Deleted Versions Version
