Select to find what tape a single file is on
We have an 60 GB Exchange server that we keep 90 versions of. They want me to pull out the tape that has the backup from 7/20 on it and a database backup and send it to another location for restore. Now I know I could run an export with fromdate but that will run for 7 days produce 20 tapes with 3 TB's of data. I see that the backups table has the file_name, backup_date and something called object_ID. I see the contents table has_file name and file_hexname. I know that when I use the TSM GUI to select a single file for restore TSM determines what tape needs to be mounted in seconds. So, where is the table that helps link the file requested for restore to the tape volume it is on. Has anyone had to do this select before. I know that many have discussed at great length the long query you would need to run to determine what tapes you would need to restore an entire server. I'm not asking for all that. I have one specific file name. OK actually 6 but I know each name and I don't mind running a select on each one. - Do you Yahoo!? Shop for Back-to-School deals on Yahoo! Shopping.
Re: How to schedule
Ameerul, How about this? Set up your backup schedule to run *every* Sunday and set its expiry date to a date in the past, say 01/01/2004 Schedule this admin script to run every Sunday, at some time before your backup schedule is to run. (assuming you use prompted mode) === upd schedule mydomain myschedule expiry=01/01/2004 select server_name from status where daysinmonth(current date) - day(current date) < 7 and dayofweek(current date) = 1 if (rc_ok) upd schedule mydomain myschedule expiry=NEVER === Regards Steve Harris AIX and TSM Admin Queensland Health, Brisbane Australia >>> [EMAIL PROTECTED] 09/09/2004 11:28:20 >>> HI All, How do you handle a request to do backup on last Sunday of each month. This backup (or rather archive) is to be kept for a year. How can we accommodate this in TSM (schedule)? One guy is comparing with Veritas which he claims can do it. If TSM schedule can't handle it, anyone has done it anyway thru script or whatever? Please! Maybe i didn't see the solution here but you guys do. The request came from the management for their business policy. Thanks and best regards Ameerul Madzali __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo *** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***
How to schedule
HI All, How do you handle a request to do backup on last Sunday of each month. This backup (or rather archive) is to be kept for a year. How can we accommodate this in TSM (schedule)? One guy is comparing with Veritas which he claims can do it. If TSM schedule can't handle it, anyone has done it anyway thru script or whatever? Please! Maybe i didn't see the solution here but you guys do. The request came from the management for their business policy. Thanks and best regards Ameerul Madzali __ Do you Yahoo!? Take Yahoo! Mail with you! Get it on your mobile phone. http://mobile.yahoo.com/maildemo
Re: Weird tape utilization
Eric Good luck with your PMR. In the meantime, below is a script that I wrote when I realised that we were suffering the "tape leak" that Richard describes. It works on the premise that with collocation turned on, there should only be one filling read-write volume in each storage pool per node/filespace. The select statements list the filling volumes by node for each storage pool collocated by node, and the filling volumes by filespace for each storage pool collocated by filespace. Each node/filespace should be listed only once per storage pool in the output. Scan down the output and if a node/filespace appears more than once it means you are using more tapes than necessary. In this case, pick one of the volumes (ideally the least utilised), update its access-mode to read-only and issue a MOVE DATA on it. You should see one of the other filling volumes listed be mounted as the destination. I usually run the script once a month or so. It may take a while, but is worth it for the tapes you get back. Now if only TSM could take care of this itself ... Regards Neil Schofield Yorkshire Water Services Ltd. select volumeusage.node_name, volumeusage.stgpool_name, volumeusage.volume_name from volumeusage, volumes where volumeusage.volume_name=volumes.volume_name and volumes.status='FILLING' and volumes.access='READWRITE' and volumeusage.stgpool_name in (select stgpool_name from stgpools where collocate='YES') group by volumeusage.node_name, volumeusage.stgpool_name, volumeusage.volume_name order by stgpool_name select volumeusage.node_Name, volumeusage.filespace_name, volumeusage.stgpool_name, volumeusage.volume_name from volumeusage, volumes where volumeusage.volume_name=volumes.volume_name and volumes.status ='FILLING' and volumes.access='READWRITE' and volumeusage.stgpool_name in (select stgpool_name from stgpools where collocate='FILESPACE') group by volumeusage.node_name, volumeusage.filespace_name, volumeusage.stgpool_name, volumeusage.volume_name order by stgpool_name Find out about our new Icytonic drink at http://www.yorkshirewater.com 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: Antwort: Re: q drmedia question [Virus checked]
Arnaud, I just want to point out that the fact that the following fields: Primary Storage Pools: Copy Storage Pools: are empty is not a problem. This is the default state and it means that all primary and copy storage pools will be managed by DRM. As far as his problem I don't think we have enough information to give an answer and your request for the additional information will probably be useful. -- Regards, Mark D. Rodriguez President MDR Consulting, Inc. === MDR Consulting The very best in Technical Training and Consulting. IBM Advanced Business Partner SAIR Linux and GNU Authorized Center for Education IBM Certified Advanced Technical Expert, CATE AIX Support and Performance Tuning, RS6000 SP, TSM/ADSM and Linux Red Hat Certified Engineer, RHCE === PAC Brion Arnaud wrote: Frank, I'm not really sure I understand your problem : why would you remove those volumes from DRM ? What do you mean by "virtual" volumes in the 3583 library. Could you give us an extract of what "q drm" shows, and for some volumes appearing in this list, do a "q vol xxx f=d" and show us the output. I have the feeling that DRM was configured properly 2 years ago (with primary and copy pools associated with DRM), until someone broke those associations, and now DRM still shows those old records that never went updated afterwards. What is sure is that DRM can't work properly without knowing which storage pool to handle ... Give us some clarifications please ... Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 16:42 To: [EMAIL PROTECTED] Subject: Antwort: Re: q drmedia question [Virus checked] Hi, I don't understand this. Isn't it possible to remove this volumes? I see that we have virtuell volumes in the second library with a timestamp from 2002 and they allocate space. Best regards, Frank PAC Brion Arnaud <[EMAIL PROTECTED]An: [EMAIL PROTECTED] ALPINA.COM> Kopie: Gesendet von:Thema:Re: q drmedia question [Virus checked] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 08.09.2004 16:03 Bitte antworten an "ADSM: Dist Stor Manager" Hi Frank, But when I show the options, it shows o.k. Surely not ! If you want the DRM to handle your volumes properly, you should associate all your primary pools with "Primary Storage Pools:" entry, and the same for copy pools ! That time being, your recovery plan will be of no help for rebuilding storage pools in case of a disaster, simply why it does not know them ! Furthermore, "DB Backup series expiration days" value should be the same as "Recovery Plan File Expiration Days", because you'll need the DB backup volume to use the recovery plan. Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 14:58 To: [EMAIL PROTECTED] Subject: q drmedia question [Virus checked] Hi, we have 2 x TSM-Server with TSM Version 5.1.8.0 on AIX 5.2_ML02. The first server has a 3494 library and the second server a 3583 library. When I start the command q drmedia I get a lot of volumes with a very old timestamp (older than 2 years). But when I show the options, it shows o.k.: tsm: ADSM_OERAG01>q drmstatus Recovery Plan Prefix: /mgnt/save_data/adsm_db/config/ Plan Instructions Prefix: /mgnt/save_data/adsm_db/config/ Replacement Volume Postfix: @ Primary Storage Pools: Copy Storage Pools: Not Mountable Location Name: NOTMOUNTABLE Courier Name: COURIER Vault Site Name: VAULT DB Backup Series Expiration Days: 3 Day(s) Recovery Plan File Expiration Days: 5 Day(s) Check Label?: Yes Process FILE Devi
RE : Wider columns in q event command??
I think no. It's an easier way to use dsmadmc with option -DISPLaymode=list -Message d'origine- De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part de Niklas Lundstrom Envoyé : mercredi 8 septembre 2004 10:30 À : [EMAIL PROTECTED] Objet : Wider columns in q event command?? Hello When I issue q event * * exceptipnsonly=yes I get tsm: SPADAB-PROD>q event * * exceptionsonly=yes Scheduled Start Actual Start Schedule Name Node Name Status - - -- 09/08/2004 03:00:00 INCRBACK3 SFFPROD2DBMissed 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD- Missed 001 09/08/2004 05:00:00 09/08/2004 05:00:21 INCRBACK1 STMFSPAS01EX- Failed 002 09/08/2004 05:00:00 09/08/2004 05:33:21 INCRBACK1 STMFSPAS01EX- Failed 005 09/08/2004 05:00:00 09/08/2004 05:00:33 PRIME_POSTSC- PRIMEDB1 Failed HEDULE_CMD 09/08/2004 05:00:00 PRIME_POSTSC- PRIMEDB2 Missed HEDULE_CMD 09/08/2004 07:00:00 09/08/2004 08:33:35 REST_OBTAIN SP7WS210 Failed However some of my schedule and nodenames are too long to fit within the Schedule Name and Node Name row, so I get a line with just a few charachters in the output I want it to look something like: Scheduled Start Actual Start Schedule Name Node NameStatus - - -- 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD001 Missed 09/08/2004 05:00:0009/08/2004 05:00:21INCRBACK1 STMFSPAS01EX002 Failed 09/08/2004 05:00:0009/08/2004 05:33:21INCRBACK1 STMFSPAS01EX005 Failed 09/08/2004 05:00:0009/08/2004 05:00:33PRIME_POSTSCHEDULE_CMD PRIMEDB1 Failed I looked at select * from events but I only see the most recent events there Is there a way to increase the number of charachters in the rows? Regards Niklas Lundström Swedbank --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.751 / Virus Database: 502 - Release Date: 02/09/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.751 / Virus Database: 502 - Release Date: 02/09/2004
Question about backing up a SNAP Appliance NAS device with TSM
I have a NAS from SNAP Appliance that I would like to backup with Tivoli. Has anyone ever tried this? Does anyone have any suggestions on how I should go about backing up this device??? Any help is appreciated, Jason This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courriel est confidentiel et prot+AOk-g+AOk-. L'exp+AOk-diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d+AOk-sign+AOk-(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser imm+AOk-diatement, par retour de courriel ou par un autre moyen.
Re: Windows unattended client upgrade scenario; how to uninstall v3 and v4 clients unattended?
Marcel, The uninstall is quite simple by replacing the -i switch of the msiexec command to -x. Then if you installed each of the different versions with default settings you will need to check the client readme for the silent section. It will have the different options for the ADDLOCAL setting. As the versions changed so did the ADDLOCAL settings. For example, the uninstall for the 5.1x version looked like: msiexec /x "C:\(path to .msi)\IBM Tivoli Storage Manager Client.msi" RebootYesNo="No" REBOOT="Suppress" ALLUSERS=1 INSTALLDIR="C:\program files\tivoli\tsm" ADDLOCAL="BackupArchiveWeb,BackupArchiveGUI,ApiRuntime,AdministrativeCmd,Rea dmes" TRANSFORMS=1033.mst /qn /l*v "c:\log.txt" You may have to create separate scripts for the different versions but it can be applied to any client with that version as long as you installed using default settings. Hope that helps! Brian Brian Scott EDS - GCE-GM Global Client Engineering GM MS 3234 750 Tower Drive Troy, MI 48098 * phone: +01-248-265-4596 (8-365) * mailto:[EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Anthonijsz, Marcel M SITI-ITIBHL Sent: Tuesday, September 07, 2004 12:38 PM To: [EMAIL PROTECTED] Subject: Windows unattended client upgrade scenario; how to uninstall v3 and v4 clients unattended? Hi all, I am currently trying to fix and align our Windows installed TSM Client base, and as we neglected this in the past, we have a variety of TSM Client versions in the field. We have about 200 NT clients that need updating. I want to create an unattended install script to seamlessly install the latest TSM client for Windows NT (5.1.7.3) or Windows 2000. (5.2.3.1). Now the install part (is..) looks easy with MSIEXEC, the difficult part is the uninstall of the v3 and v4 clients. These are the TSM Client versions we have out there: 3.7.2.0 4.1.0.0 4.2.0.0 4.2.1.20 4.2.3.0 4.2.3.4 5.1.1.0 5.1.5.0 Now all Version 5 release notes say that first we need to uninstall the V4 and V3 Client software. But how should that be done unattended All documents say : "Open the Control Panel and double click on the Add/Remove Programs icon" - but that's not what I call unattended :-(. I have searched the list, but could not find a definite answer, nor in any Tivoli documentation. Any more gotcha's I'll need to know for the upgrades? Thanks for all the wisdom, Marcel Anthonijsz Global Data Storage Manager (a.k.a. storman) Shell Information Technology International B.V. PO Box 1027, 2260 BA Leidschendam, The Netherlands T: +31-70 303 4984 F: +31-70 303 4011 E: Marcel.Anthonijsz.atsign.shell.com Internet: http://www.shell.com
Re: HELP, major mess with tapes!
Suggestion In general when reclamation is turned on for an offsite copy pool, it gathers the necessary data from the onsite pool. Provided that you have all the data on onsite the reclamation for offsite should finish, but sometimes this is not the case if you have unavailable or destroyed tapes on onsite. My suggestion is to examine to see if there are any tapes on onsite with Unavailable/Destroyed status and if so find out why. If media is no good for whatever reason then you can try restore the volume from offsite tapes(may need to be brought back from vault) restore volume # preview=yes can tell you if restore of the volume is possible. Restore of onsite volume requires offsite tapes, but offsite tapes reclamation require onsites tapes(unless you bring back offsite tapes to the library ). Move data works, because moving data is simply move from one location to another location. Reclamation for offsite normally takes data from onsite tapes and recreate offsite data so that old offsite tapes can come back to the library to be reused. Sung Y. Lee Joni Moyer <[EMAIL PROTECTED] ARK.COM> To Sent by: "ADSM: [EMAIL PROTECTED] Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> HELP, major mess with tapes! 09/08/2004 12:22 PM Please respond to "ADSM: Dist Stor Manager" Hello all! I was running tape reclamation for an offsite copy pool and I started to receive pages upon pages of messages that look like this: ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage \hmpg1015\e$, fsId NE TECHNICAL MMARY_04060252767- pool TAPEPOOLNT3590: Node HMPG1015, Type Backup, File space \ 3, File name \FSCORPPUB2\HIGHBAR\CLAIMS\BILL ENGINE\BILL ENGI DELIVERABLES\INVOICE_SUMMARY_RTF_FILES\ 0140471001_INVOICE_SU 9.RTF. Then I see the following message: 09/07/2004 02:00:35 ANR1093W Space reclamation terminated for volume 478789 - transaction aborted. And then I see multiple messages like this: ANR1163W Offsite volume 482914 still contains files which could not be moved. I am receiving tons of messages with the ANR1173E and ANR1163W, but I am not quite sure which volume is causing the issue? I mean if it's the reclamation volume, then it is actually pulling the data from the onsite copy and recreating it to be sent back offsite. I am doing a move data on the offsite volume 478789 from which the space reclamation terminated, but I still don't understand why a move data would work and a reclamation would not? Any suggestions would be appreciated Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] <><><>
Re: HELP, major mess with tapes!
Sorry for the repeat post - I hit the send key too early. This APAR is fixed in server levels 5.1.9.2, 5.2.2.5, or 5.2.3.0 At 12:22 PM 9/8/2004 -0400, you wrote: Hello all! I was running tape reclamation for an offsite copy pool and I started to receive pages upon pages of messages that look like this: ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage \hmpg1015\e$, fsId NE TECHNICAL MMARY_04060252767- pool TAPEPOOLNT3590: Node HMPG1015, Type Backup, File space \ 3, File name \FSCORPPUB2\HIGHBAR\CLAIMS\BILL ENGINE\BILL ENGI DELIVERABLES\INVOICE_SUMMARY_RTF_FILES\ 0140471001_INVOICE_SU 9.RTF. Then I see the following message: 09/07/2004 02:00:35 ANR1093W Space reclamation terminated for volume 478789 - transaction aborted. And then I see multiple messages like this: ANR1163W Offsite volume 482914 still contains files which could not be moved. I am receiving tons of messages with the ANR1173E and ANR1163W, but I am not quite sure which volume is causing the issue? I mean if it's the reclamation volume, then it is actually pulling the data from the onsite copy and recreating it to be sent back offsite. I am doing a move data on the offsite volume 478789 from which the space reclamation terminated, but I still don't understand why a move data would work and a reclamation would not? Any suggestions would be appreciated Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED]
Re: HELP, major mess with tapes!
The TSM server is at 5.1.8.3 and is running on the mainframe. Thanks! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] "Dave Canan" <[EMAIL PROTECTED] L.NET> To Sent by: "ADSM: [EMAIL PROTECTED] Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: HELP, major mess with tapes! 09/08/2004 01:21 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> This looks like APAR IC36348. What is your server level? At 12:22 PM 9/8/2004 -0400, you wrote: >Hello all! > >I was running tape reclamation for an offsite copy pool and I started to >receive pages upon pages of messages that look like this: > >ANR1173E Space reclamation for offsite volume(s) cannot copy file in >storage >\hmpg1015\e$, fsId >NE TECHNICAL >MMARY_04060252767- >pool TAPEPOOLNT3590: Node HMPG1015, Type Backup, File space \ >3, File name \FSCORPPUB2\HIGHBAR\CLAIMS\BILL ENGINE\BILL ENGI >DELIVERABLES\INVOICE_SUMMARY_RTF_FILES\ 0140471001_INVOICE_SU >9.RTF. > >Then I see the following message: > >09/07/2004 02:00:35 ANR1093W Space reclamation terminated for volume >478789 - >transaction aborted. > > >And then I see multiple messages like this: > >ANR1163W Offsite volume 482914 still contains files which could not be >moved. I am receiving tons of messages with the ANR1173E and ANR1163W, but >I am not quite sure which volume is causing the issue? I mean if it's the >reclamation volume, then it is actually pulling the data from the onsite >copy and recreating it to be sent back offsite. I am doing a move data on >the offsite volume 478789 from which the space reclamation terminated, but >I still don't understand why a move data would work and a reclamation would >not? > >Any suggestions would be appreciated > > > >Joni Moyer >Highmark >Storage Systems >Work:(717)302-6603 >Fax:(717)302-5974 >[EMAIL PROTECTED] > Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED]
Re: HELP, major mess with tapes!
This looks like APAR IC36348. What is your server level? At 12:22 PM 9/8/2004 -0400, you wrote: Hello all! I was running tape reclamation for an offsite copy pool and I started to receive pages upon pages of messages that look like this: ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage \hmpg1015\e$, fsId NE TECHNICAL MMARY_04060252767- pool TAPEPOOLNT3590: Node HMPG1015, Type Backup, File space \ 3, File name \FSCORPPUB2\HIGHBAR\CLAIMS\BILL ENGINE\BILL ENGI DELIVERABLES\INVOICE_SUMMARY_RTF_FILES\ 0140471001_INVOICE_SU 9.RTF. Then I see the following message: 09/07/2004 02:00:35 ANR1093W Space reclamation terminated for volume 478789 - transaction aborted. And then I see multiple messages like this: ANR1163W Offsite volume 482914 still contains files which could not be moved. I am receiving tons of messages with the ANR1173E and ANR1163W, but I am not quite sure which volume is causing the issue? I mean if it's the reclamation volume, then it is actually pulling the data from the onsite copy and recreating it to be sent back offsite. I am doing a move data on the offsite volume 478789 from which the space reclamation terminated, but I still don't understand why a move data would work and a reclamation would not? Any suggestions would be appreciated Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] Dave Canan TSM Performance IBM Advanced Technical Support [EMAIL PROTECTED]
HELP, major mess with tapes!
Hello all! I was running tape reclamation for an offsite copy pool and I started to receive pages upon pages of messages that look like this: ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage \hmpg1015\e$, fsId NE TECHNICAL MMARY_04060252767- pool TAPEPOOLNT3590: Node HMPG1015, Type Backup, File space \ 3, File name \FSCORPPUB2\HIGHBAR\CLAIMS\BILL ENGINE\BILL ENGI DELIVERABLES\INVOICE_SUMMARY_RTF_FILES\ 0140471001_INVOICE_SU 9.RTF. Then I see the following message: 09/07/2004 02:00:35 ANR1093W Space reclamation terminated for volume 478789 - transaction aborted. And then I see multiple messages like this: ANR1163W Offsite volume 482914 still contains files which could not be moved. I am receiving tons of messages with the ANR1173E and ANR1163W, but I am not quite sure which volume is causing the issue? I mean if it's the reclamation volume, then it is actually pulling the data from the onsite copy and recreating it to be sent back offsite. I am doing a move data on the offsite volume 478789 from which the space reclamation terminated, but I still don't understand why a move data would work and a reclamation would not? Any suggestions would be appreciated Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: Antwort: Re: q drmedia question [Virus checked]
Frank, I'm not really sure I understand your problem : why would you remove those volumes from DRM ? What do you mean by "virtual" volumes in the 3583 library. Could you give us an extract of what "q drm" shows, and for some volumes appearing in this list, do a "q vol xxx f=d" and show us the output. I have the feeling that DRM was configured properly 2 years ago (with primary and copy pools associated with DRM), until someone broke those associations, and now DRM still shows those old records that never went updated afterwards. What is sure is that DRM can't work properly without knowing which storage pool to handle ... Give us some clarifications please ... Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 16:42 To: [EMAIL PROTECTED] Subject: Antwort: Re: q drmedia question [Virus checked] Hi, I don't understand this. Isn't it possible to remove this volumes? I see that we have virtuell volumes in the second library with a timestamp from 2002 and they allocate space. Best regards, Frank PAC Brion Arnaud <[EMAIL PROTECTED]An: [EMAIL PROTECTED] ALPINA.COM> Kopie: Gesendet von:Thema:Re: q drmedia question [Virus checked] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 08.09.2004 16:03 Bitte antworten an "ADSM: Dist Stor Manager" Hi Frank, >But when I show the options, it shows o.k. Surely not ! If you want the DRM to handle your volumes properly, you should associate all your primary pools with "Primary Storage Pools:" entry, and the same for copy pools ! That time being, your recovery plan will be of no help for rebuilding storage pools in case of a disaster, simply why it does not know them ! Furthermore, "DB Backup series expiration days" value should be the same as "Recovery Plan File Expiration Days", because you'll need the DB backup volume to use the recovery plan. Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 14:58 To: [EMAIL PROTECTED] Subject: q drmedia question [Virus checked] Hi, we have 2 x TSM-Server with TSM Version 5.1.8.0 on AIX 5.2_ML02. The first server has a 3494 library and the second server a 3583 library. When I start the command q drmedia I get a lot of volumes with a very old timestamp (older than 2 years). But when I show the options, it shows o.k.: tsm: ADSM_OERAG01>q drmstatus Recovery Plan Prefix: /mgnt/save_data/adsm_db/config/ Plan Instructions Prefix: /mgnt/save_data/adsm_db/config/ Replacement Volume Postfix: @ Primary Storage Pools: Copy Storage Pools: Not Mountable Location Name: NOTMOUNTABLE Courier Name: COURIER Vault Site Name: VAULT DB Backup Series Expiration Days: 3 Day(s) Recovery Plan File Expiration Days: 5 Day(s) Check Label?: Yes Process FILE Device Type?: No Command File Name: /mgnt/save_data/adsm_db/config/recfileplan- cmd What is the reason, that I get a lot of volumes by q drmedia? Best regards, Frank Mueller
Re: Oracle TDPO error SBT 2175
Adrie, In a nutshell, the error that you are seeing from the sbtio.log is a telling sign that the object name that Oracle is giving to the file for that backup already exists on the TSM Server. Usually this is a result of the backup_piece name that Oracle generates is very long and the part of the name that should make the name unique is getting truncated so it looks like a duplicate name to TDP Oracle/TSM. Without seeing your Rman script for this backup I can only venture a guess but I think that you need to take a little more control over how the backup pieces are being named - you can control the naming (to a degree) that Rman/Oracle uses for it's backup_pieces, see the Rman User's guide on this subject. Regards, Neil Rasmussen Software Development Data Protection for Oracle [EMAIL PROTECTED] "Tuyl Adrie, A.C. van" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 09/08/2004 02:44 AM Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject Oracle TDPO error SBT 2175 Dear Oracle and TSM specialists, We are trying to backup an Oracle database with Oracle TDPO for HP-UX. Installation as mentioned in the manual. We created a seperate tdpo node with backdelete yes. rman script works when creating files. When backing up to the TSM server we get the following error from the TDP: SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 The log in TSM server does not show (me) problems, a connection from the TDP is made and data is sent. After that the connection is closed. What can be the problem here? TDPO logs and server logs added. Thanks, Adrie HP UX 11 Oracle 8.1.7.R4 TDPO 2.2.1 TSM server 5.1.8.2 (w2k SP4) Output TDPO $ cat sbtio.log === Tracing started for: --- Application Client : TDP Oracle HP Version : 2.2.1.0 === SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 SBT-2175 08/04/2004 13:45:59 remove2.cpp(237): sbtremove2(): Exit - wrong state, dsmHandle = 1, state = 2 Server log ** 04-08-2004 13:41:43 ANR2017I Administrator 18447 issued command: UPDATE NODE OWCX01 CLOPTSET=HP_SERVER CONTACT="WOZ Centraal" DOMAIN=HPUNIX COMPRESSION=YES AUTOFSRENAME=NO ARCHDELETE=YES BACKDELETE=YES FORCEPWRESET=NO KEEPMP=NO MAXNUMMP=5 URL=http://owcx01:1581 04-08-2004 13:41:43 ANR2063I Node OWCX01 updated. 04-08-2004 13:43:29 ANR0406I Session 25290 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3031)). 04-08-2004 13:47:00 ANE4991I (Session: 25290, Node: OWCX01_ORCL) TDP Oracle HP ANU0599 ANU2535I File /adsmorc//TMWB_8_1_533310141.bck = 204800 bytes sent 04-08-2004 13:47:00 ANR0406I Session 25291 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3026)). 04-08-2004 13:47:00 ANR0403I Session 25291 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:00 ANR0403I Session 25290 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:04 ANR0406I Session 25292 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3025)). 04-08-2004 13:47:05 ANR0403I Session 25292 ended for node OWCX01_ORCL (TDP Oracle HP). This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify [EMAIL PROTECTED] This footnote also confirms that this e-mail message has been checked by McAfee Groupshield for the presence of computer viruses.
Re: Weird tape utilization
Hi Richard! Thank you very much for you reply! I have created a PMR for this behavior and I'm very curious how IBM will convince me that this is a feature, rather than a bug! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Richard Sims [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 14:48 To: [EMAIL PROTECTED] Subject: Re: Weird tape utilization Hi, Eric - For better or worse, this is "historically normal" behavior for the product - I see it a lot. A tape will be busy as output for a client session, or be in the process of dismounting, and the server will revert to a scratch tape for the second session which might otherwise have used that tape. Future sessions may all be singular, and the second tape will simply languish. I have an advisory in ADSM QuickFacts for administrators to periodically query for such orphans, as a cause of "tape leak". It would be nice if the product better dealt with such tapes, but... Richard Sims On Sep 8, 2004, at 5:01 AM, Loon, E.J. van - SPLXM wrote: > Hi *SM-ers! > I have found something very strange in our TSM tape utilization. > I found several primary storage pool tapes which should be used for > data, > but which are not. > For example, one tape has a read/write, filling status with a > utilization of > about 3% and about 23% reclaimable. However, the last written date is > September 15, 2003!!! > I checked all other servers and they all have several tapes in a > filling > state with a last written date several months ago. > I really cannot explain how this is possible. Does anybody know what's > wrong > here? The tapes have no error state, nor did they have in the past. > Thank you very much for any reply in advance! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines ** 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. **
Antwort: Re: q drmedia question [Virus checked]
Hi, I don't understand this. Isn't it possible to remove this volumes? I see that we have virtuell volumes in the second library with a timestamp from 2002 and they allocate space. Best regards, Frank PAC Brion Arnaud <[EMAIL PROTECTED]An: [EMAIL PROTECTED] ALPINA.COM> Kopie: Gesendet von:Thema:Re: q drmedia question [Virus checked] "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 08.09.2004 16:03 Bitte antworten an "ADSM: Dist Stor Manager" Hi Frank, >But when I show the options, it shows o.k. Surely not ! If you want the DRM to handle your volumes properly, you should associate all your primary pools with "Primary Storage Pools:" entry, and the same for copy pools ! That time being, your recovery plan will be of no help for rebuilding storage pools in case of a disaster, simply why it does not know them ! Furthermore, "DB Backup series expiration days" value should be the same as "Recovery Plan File Expiration Days", because you'll need the DB backup volume to use the recovery plan. Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 14:58 To: [EMAIL PROTECTED] Subject: q drmedia question [Virus checked] Hi, we have 2 x TSM-Server with TSM Version 5.1.8.0 on AIX 5.2_ML02. The first server has a 3494 library and the second server a 3583 library. When I start the command q drmedia I get a lot of volumes with a very old timestamp (older than 2 years). But when I show the options, it shows o.k.: tsm: ADSM_OERAG01>q drmstatus Recovery Plan Prefix: /mgnt/save_data/adsm_db/config/ Plan Instructions Prefix: /mgnt/save_data/adsm_db/config/ Replacement Volume Postfix: @ Primary Storage Pools: Copy Storage Pools: Not Mountable Location Name: NOTMOUNTABLE Courier Name: COURIER Vault Site Name: VAULT DB Backup Series Expiration Days: 3 Day(s) Recovery Plan File Expiration Days: 5 Day(s) Check Label?: Yes Process FILE Device Type?: No Command File Name: /mgnt/save_data/adsm_db/config/recfileplan- cmd What is the reason, that I get a lot of volumes by q drmedia? Best regards, Frank Mueller
Re: q drmedia question [Virus checked]
Hi Frank, >But when I show the options, it shows o.k. Surely not ! If you want the DRM to handle your volumes properly, you should associate all your primary pools with "Primary Storage Pools:" entry, and the same for copy pools ! That time being, your recovery plan will be of no help for rebuilding storage pools in case of a disaster, simply why it does not know them ! Furthermore, "DB Backup series expiration days" value should be the same as "Recovery Plan File Expiration Days", because you'll need the DB backup volume to use the recovery plan. Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Frank Mueller Sent: Wednesday, 08 September, 2004 14:58 To: [EMAIL PROTECTED] Subject: q drmedia question [Virus checked] Hi, we have 2 x TSM-Server with TSM Version 5.1.8.0 on AIX 5.2_ML02. The first server has a 3494 library and the second server a 3583 library. When I start the command q drmedia I get a lot of volumes with a very old timestamp (older than 2 years). But when I show the options, it shows o.k.: tsm: ADSM_OERAG01>q drmstatus Recovery Plan Prefix: /mgnt/save_data/adsm_db/config/ Plan Instructions Prefix: /mgnt/save_data/adsm_db/config/ Replacement Volume Postfix: @ Primary Storage Pools: Copy Storage Pools: Not Mountable Location Name: NOTMOUNTABLE Courier Name: COURIER Vault Site Name: VAULT DB Backup Series Expiration Days: 3 Day(s) Recovery Plan File Expiration Days: 5 Day(s) Check Label?: Yes Process FILE Device Type?: No Command File Name: /mgnt/save_data/adsm_db/config/recfileplan- cmd What is the reason, that I get a lot of volumes by q drmedia? Best regards, Frank Mueller
Re: Wider columns in q event command??
Sure there is: Just set your Unix TERM variable *before* you initiate a TSM command line session. An even better way is to use X-Windows, and simply drag your screen wider. --Mark -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of PAC Brion Arnaud Sent: Wednesday, September 08, 2004 5:23 AM To: [EMAIL PROTECTED] Subject: Re: Wider columns in q event command?? Niklas, I don't know exactly what you're trying to achieve, but maybe you could use "dsmadmc -displaymode=table" and then "q ev ... > /tmp/some_file" and some shell scripting to get what you need. To my knowledge, there is no way increasing the length of columns for an internal TSM command ... Hope this helped ! Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Lundstrom Sent: Wednesday, 08 September, 2004 10:30 To: [EMAIL PROTECTED] Subject: Wider columns in q event command?? Hello When I issue q event * * exceptipnsonly=yes I get tsm: SPADAB-PROD>q event * * exceptionsonly=yes Scheduled Start Actual Start Schedule Name Node Name Status - - -- 09/08/2004 03:00:00 INCRBACK3 SFFPROD2DBMissed 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD- Missed 001 09/08/2004 05:00:00 09/08/2004 05:00:21 INCRBACK1 STMFSPAS01EX- Failed 002 09/08/2004 05:00:00 09/08/2004 05:33:21 INCRBACK1 STMFSPAS01EX- Failed 005 09/08/2004 05:00:00 09/08/2004 05:00:33 PRIME_POSTSC- PRIMEDB1 Failed HEDULE_CMD 09/08/2004 05:00:00 PRIME_POSTSC- PRIMEDB2 Missed HEDULE_CMD 09/08/2004 07:00:00 09/08/2004 08:33:35 REST_OBTAIN SP7WS210 Failed However some of my schedule and nodenames are too long to fit within the Schedule Name and Node Name row, so I get a line with just a few charachters in the output I want it to look something like: Scheduled Start Actual Start Schedule Name Node NameStatus - - -- 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD001 Missed 09/08/2004 05:00:0009/08/2004 05:00:21INCRBACK1 STMFSPAS01EX002 Failed 09/08/2004 05:00:0009/08/2004 05:33:21INCRBACK1 STMFSPAS01EX005 Failed 09/08/2004 05:00:0009/08/2004 05:00:33PRIME_POSTSCHEDULE_CMD PRIMEDB1 Failed I looked at select * from events but I only see the most recent events there Is there a way to increase the number of charachters in the rows? Regards Niklas Lundström Swedbank
Re: AIX Command Question
Nancy, The command to disable all client session is DISABLE SESSIONS To disable schedules (both client and administrative) is to set the option DISABLESCHEDS YES in the /usr/tivoli/tsm/server/bin/dsmserv.opt and then restart your TSM Server. Richard. Nancy L Backhaus <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 08-09-2004 15:13 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:AIX Command Question Hello TSMers, What is the command to disable all client schedules from contacting AIX server? I can't seem to find it...arrggghh. Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Phone: (716) 887-7979 Pager: (716) 470-0141 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
Re: AIX Command Question
Disable sessions/enable sessions will disable all client sessions. Kenny Barnes Systems Analyst GmacInsurance 336-770-8280 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Nancy L Backhaus Sent: Wednesday, September 08, 2004 9:14 AM To: [EMAIL PROTECTED] Subject: AIX Command Question Hello TSMers, What is the command to disable all client schedules from contacting AIX server? I can't seem to find it...arrggghh. Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Phone: (716) 887-7979 Pager: (716) 470-0141 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. --
AIX Command Question
Hello TSMers, What is the command to disable all client schedules from contacting AIX server? I can't seem to find it...arrggghh. Nancy Backhaus Enterprise Systems [EMAIL PROTECTED] Phone: (716) 887-7979 Pager: (716) 470-0141 CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole use of the intended recipient(s) and may contain proprietary, confidential, trade secret or privileged information. Any unauthorized review, use, disclosure or distribution is prohibited and may be a violation of law. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please contact the sender by reply email and destroy all copies of the original message.
q drmedia question [Virus checked]
Hi, we have 2 x TSM-Server with TSM Version 5.1.8.0 on AIX 5.2_ML02. The first server has a 3494 library and the second server a 3583 library. When I start the command q drmedia I get a lot of volumes with a very old timestamp (older than 2 years). But when I show the options, it shows o.k.: tsm: ADSM_OERAG01>q drmstatus Recovery Plan Prefix: /mgnt/save_data/adsm_db/config/ Plan Instructions Prefix: /mgnt/save_data/adsm_db/config/ Replacement Volume Postfix: @ Primary Storage Pools: Copy Storage Pools: Not Mountable Location Name: NOTMOUNTABLE Courier Name: COURIER Vault Site Name: VAULT DB Backup Series Expiration Days: 3 Day(s) Recovery Plan File Expiration Days: 5 Day(s) Check Label?: Yes Process FILE Device Type?: No Command File Name: /mgnt/save_data/adsm_db/config/recfileplan- cmd What is the reason, that I get a lot of volumes by q drmedia? Best regards, Frank Mueller
Re: Weird tape utilization
Hi, Eric - For better or worse, this is "historically normal" behavior for the product - I see it a lot. A tape will be busy as output for a client session, or be in the process of dismounting, and the server will revert to a scratch tape for the second session which might otherwise have used that tape. Future sessions may all be singular, and the second tape will simply languish. I have an advisory in ADSM QuickFacts for administrators to periodically query for such orphans, as a cause of "tape leak". It would be nice if the product better dealt with such tapes, but... Richard Sims On Sep 8, 2004, at 5:01 AM, Loon, E.J. van - SPLXM wrote: Hi *SM-ers! I have found something very strange in our TSM tape utilization. I found several primary storage pool tapes which should be used for data, but which are not. For example, one tape has a read/write, filling status with a utilization of about 3% and about 23% reclaimable. However, the last written date is September 15, 2003!!! I checked all other servers and they all have several tapes in a filling state with a last written date several months ago. I really cannot explain how this is possible. Does anybody know what's wrong here? The tapes have no error state, nor did they have in the past. Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
Re: Reducing reuse delay - immediate effect ?
Changing reusedelay has an immediate effect for the stgpool you change it on, including DRM managed pools. Actually it takes about 15-20 minutes in my experience to see the effect. For offsite pool, next time you run list of tapes to come back you will have a larger list. >>> [EMAIL PROTECTED] 09/08/2004 6:44:29 AM >>> Hi List, Due to numerous new client installations, I'm expecting a shortage of scratch volumes in our library, and was thinking of reducing reuse delay values for our storage pools from 7 to 5 days. I was wondering if this will have an immediate effect (tape that would have return to scratch tomorrow and the day after will make it today), or if only new pending tapes will be affected by the new reuse delay. Also is there an impact on DRM, I should take care of ? TIA. Regards. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** ## This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ##
Re: TSM API question
You don't seem to have the API manual, which fully addresses these points (yes, to both questions). Get the TSM manuals at http://publib.boulder.ibm.com/tividd/td/tdprodlist.html Richard Sims http://people.bu.edu/rbs On Sep 8, 2004, at 2:14 AM, Robert Ouzen wrote: Hello I have a customer who want to use the TSM API code to backup his application. The backup needs to run as LANFREE backup (A lot of Video files) . 1.. Can i use the Client API code for Lanfree backup ? 2.. Do i need to code ENABLENALFREE YES at the API dsm.opt file ? Thanks for the quick response . BB [EMAIL PROTECTED] Bercovitch Barouch [EMAIL PROTECTED] Software Support IBM Israel 972-3-9188638
Re: Weird tape utilization
Hi Arnaud!
This could very well be the case here. But if that's true, this really
sounds like a bug to me! And it costs me quite a few tapes!
I will open a PMR for this and I will let you know the results.
Thank you very much!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-Original Message-
From: PAC Brion Arnaud [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 12:02
To: [EMAIL PROTECTED]
Subject: Re: Weird tape utilization
Eric,
I'm seing this phenomenon too, and think I found the explanation for it
(but it's a very specific case) :
Looks like those tapes where written by clients having
resourceutilization set to something higher than 2, that performed their
backup on a stg pool where data should be written first to disk and then
migrated to collocated tapes. At the time where the client backup was
running, the disk pool had reached it's highmig threshold and was being
flushed to tape. Client data that came at this moment has been written
to several tapes (non respectfull to the max mount point value
attributed to this node, but that's another problem), and the data lies
now on those tapes, which never went accessed later, as this specific
case never happened again.
What you could do to check if this happens to you, is to use following
sql (use it in a dsmadmc command, as it takes a long time to be
performed) :
select a1.node_name as "Node ID", a1.volume_name as "Volume ID",
a2.pct_utilized from volumeusage as a1, volumes as a2 where
a1.stgpool_name=upper('$1') and a1.volume_name=a2.volume_name group by
a1.node_name, a1.volume_name, a2.pct_utilized
Basically it will show you which tapes are being used by wich node, and
how many % of tape is used. Use it only on collocated pools, and if you
see that a node has several volumes with few % used, you may be hit by
the problem !
Hope this made sense to you ...
Cheers.
Arnaud
**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Wednesday, 08 September, 2004 11:02
To: [EMAIL PROTECTED]
Subject: Weird tape utilization
Hi *SM-ers!
I have found something very strange in our TSM tape utilization.
I found several primary storage pool tapes which should be used for
data, but which are not.
For example, one tape has a read/write, filling status with a
utilization of about 3% and about 23% reclaimable. However, the last
written date is September 15, 2003!!!
I checked all other servers and they all have several tapes in a filling
state with a last written date several months ago.
I really cannot explain how this is possible. Does anybody know what's
wrong here? The tapes have no error state, nor did they have in the
past.
Thank you very much for any reply in advance!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
**
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.
**
Re: Weird tape utilization
Hi Karel! That would have been too easy. I'm just using one primary tape storage pool. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Bos, Karel [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 11:18 To: [EMAIL PROTECTED] Subject: Re: Weird tape utilization Eric, I would first check to which stg pool these tapes belong. After that I would check if there is any data going in that stg pool. If not, then check why there is a stg pool without have any data going into. If so, check what data from which node is on these tapes (q content count=xx). Maybe collecation on this stg pool is turned on and the client has directed his data to another stg pool. Or maybe the pool has had collection turn on which is now turned of. In that case, just do a move data on these tapes. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: woensdag 8 september 2004 11:02 To: [EMAIL PROTECTED] Subject: Weird tape utilization Hi *SM-ers! I have found something very strange in our TSM tape utilization. I found several primary storage pool tapes which should be used for data, but which are not. For example, one tape has a read/write, filling status with a utilization of about 3% and about 23% reclaimable. However, the last written date is September 15, 2003!!! I checked all other servers and they all have several tapes in a filling state with a last written date several months ago. I really cannot explain how this is possible. Does anybody know what's wrong here? The tapes have no error state, nor did they have in the past. Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** 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. **
Reducing reuse delay - immediate effect ?
Hi List, Due to numerous new client installations, I'm expecting a shortage of scratch volumes in our library, and was thinking of reducing reuse delay values for our storage pools from 7 to 5 days. I was wondering if this will have an immediate effect (tape that would have return to scratch tomorrow and the day after will make it today), or if only new pending tapes will be affected by the new reuse delay. Also is there an impact on DRM, I should take care of ? TIA. Regards. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] **
Re: Weird tape utilization
Eric,
I'm seing this phenomenon too, and think I found the explanation for it
(but it's a very specific case) :
Looks like those tapes where written by clients having
resourceutilization set to something higher than 2, that performed their
backup on a stg pool where data should be written first to disk and then
migrated to collocated tapes. At the time where the client backup was
running, the disk pool had reached it's highmig threshold and was being
flushed to tape. Client data that came at this moment has been written
to several tapes (non respectfull to the max mount point value
attributed to this node, but that's another problem), and the data lies
now on those tapes, which never went accessed later, as this specific
case never happened again.
What you could do to check if this happens to you, is to use following
sql (use it in a dsmadmc command, as it takes a long time to be
performed) :
select a1.node_name as "Node ID", a1.volume_name as "Volume ID",
a2.pct_utilized from volumeusage as a1, volumes as a2 where
a1.stgpool_name=upper('$1') and a1.volume_name=a2.volume_name group by
a1.node_name, a1.volume_name, a2.pct_utilized
Basically it will show you which tapes are being used by wich node, and
how many % of tape is used. Use it only on collocated pools, and if you
see that a node has several volumes with few % used, you may be hit by
the problem !
Hope this made sense to you ...
Cheers.
Arnaud
**
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: [EMAIL PROTECTED]
**
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Loon, E.J. van - SPLXM
Sent: Wednesday, 08 September, 2004 11:02
To: [EMAIL PROTECTED]
Subject: Weird tape utilization
Hi *SM-ers!
I have found something very strange in our TSM tape utilization.
I found several primary storage pool tapes which should be used for
data, but which are not.
For example, one tape has a read/write, filling status with a
utilization of about 3% and about 23% reclaimable. However, the last
written date is September 15, 2003!!!
I checked all other servers and they all have several tapes in a filling
state with a last written date several months ago.
I really cannot explain how this is possible. Does anybody know what's
wrong here? The tapes have no error state, nor did they have in the
past.
Thank you very much for any reply in advance!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
**
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.
**
Re: Weird tape utilization
According to Loon, E.J. van - SPLXM: > Hi *SM-ers! > I have found something very strange in our TSM tape utilization. > I found several primary storage pool tapes which should be used for data, > but which are not. > For example, one tape has a read/write, filling status with a utilization of > about 3% and about 23% reclaimable. However, the last written date is > September 15, 2003!!! > I checked all other servers and they all have several tapes in a filling > state with a last written date several months ago. > I really cannot explain how this is possible. Does anybody know what's wrong > here? The tapes have no error state, nor did they have in the past. > Thank you very much for any reply in advance! Do you use collocation? If yes, check whether the node, using this tape, has more than one tape with status 'filling'. Heinz --- Heinz Flemming [EMAIL PROTECTED] Rechenzentrum, Universitaet Karlsruhe ---
Re: Wider columns in q event command??
Niklas, I don't know exactly what you're trying to achieve, but maybe you could use "dsmadmc -displaymode=table" and then "q ev ... > /tmp/some_file" and some shell scripting to get what you need. To my knowledge, there is no way increasing the length of columns for an internal TSM command ... Hope this helped ! Cheers. Arnaud ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ** -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Lundstrom Sent: Wednesday, 08 September, 2004 10:30 To: [EMAIL PROTECTED] Subject: Wider columns in q event command?? Hello When I issue q event * * exceptipnsonly=yes I get tsm: SPADAB-PROD>q event * * exceptionsonly=yes Scheduled Start Actual Start Schedule Name Node Name Status - - -- 09/08/2004 03:00:00 INCRBACK3 SFFPROD2DBMissed 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD- Missed 001 09/08/2004 05:00:00 09/08/2004 05:00:21 INCRBACK1 STMFSPAS01EX- Failed 002 09/08/2004 05:00:00 09/08/2004 05:33:21 INCRBACK1 STMFSPAS01EX- Failed 005 09/08/2004 05:00:00 09/08/2004 05:00:33 PRIME_POSTSC- PRIMEDB1 Failed HEDULE_CMD 09/08/2004 05:00:00 PRIME_POSTSC- PRIMEDB2 Missed HEDULE_CMD 09/08/2004 07:00:00 09/08/2004 08:33:35 REST_OBTAIN SP7WS210 Failed However some of my schedule and nodenames are too long to fit within the Schedule Name and Node Name row, so I get a line with just a few charachters in the output I want it to look something like: Scheduled Start Actual Start Schedule Name Node NameStatus - - -- 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD001 Missed 09/08/2004 05:00:0009/08/2004 05:00:21INCRBACK1 STMFSPAS01EX002 Failed 09/08/2004 05:00:0009/08/2004 05:33:21INCRBACK1 STMFSPAS01EX005 Failed 09/08/2004 05:00:0009/08/2004 05:00:33PRIME_POSTSCHEDULE_CMD PRIMEDB1 Failed I looked at select * from events but I only see the most recent events there Is there a way to increase the number of charachters in the rows? Regards Niklas Lundström Swedbank
Re: Weird tape utilization
Eric, I would first check to which stg pool these tapes belong. After that I would check if there is any data going in that stg pool. If not, then check why there is a stg pool without have any data going into. If so, check what data from which node is on these tapes (q content count=xx). Maybe collecation on this stg pool is turned on and the client has directed his data to another stg pool. Or maybe the pool has had collection turn on which is now turned of. In that case, just do a move data on these tapes. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: woensdag 8 september 2004 11:02 To: [EMAIL PROTECTED] Subject: Weird tape utilization Hi *SM-ers! I have found something very strange in our TSM tape utilization. I found several primary storage pool tapes which should be used for data, but which are not. For example, one tape has a read/write, filling status with a utilization of about 3% and about 23% reclaimable. However, the last written date is September 15, 2003!!! I checked all other servers and they all have several tapes in a filling state with a last written date several months ago. I really cannot explain how this is possible. Does anybody know what's wrong here? The tapes have no error state, nor did they have in the past. Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** 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. **
Weird tape utilization
Hi *SM-ers! I have found something very strange in our TSM tape utilization. I found several primary storage pool tapes which should be used for data, but which are not. For example, one tape has a read/write, filling status with a utilization of about 3% and about 23% reclaimable. However, the last written date is September 15, 2003!!! I checked all other servers and they all have several tapes in a filling state with a last written date several months ago. I really cannot explain how this is possible. Does anybody know what's wrong here? The tapes have no error state, nor did they have in the past. Thank you very much for any reply in advance! Kindest regards, Eric van Loon KLM Royal Dutch Airlines ** 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. **
Oracle TDPO error SBT 2175
Dear Oracle and TSM specialists, We are trying to backup an Oracle database with Oracle TDPO for HP-UX. Installation as mentioned in the manual. We created a seperate tdpo node with backdelete yes. rman script works when creating files. When backing up to the TSM server we get the following error from the TDP: SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 The log in TSM server does not show (me) problems, a connection from the TDP is made and data is sent. After that the connection is closed. What can be the problem here? TDPO logs and server logs added. Thanks, Adrie HP UX 11 Oracle 8.1.7.R4 TDPO 2.2.1 TSM server 5.1.8.2 (w2k SP4) Output TDPO $ cat sbtio.log === Tracing started for: --- Application Client : TDP Oracle HP Version : 2.2.1.0 === SBT-2175 08/04/2004 13:45:58 send2.cpp(650): sbtbackup(): Exit - tdpoQueryObj() failed. dsmHandle = 1, rc = 8 SBT-2175 08/04/2004 13:45:59 remove2.cpp(237): sbtremove2(): Exit - wrong state, dsmHandle = 1, state = 2 Server log ** 04-08-2004 13:41:43 ANR2017I Administrator 18447 issued command: UPDATE NODE OWCX01 CLOPTSET=HP_SERVER CONTACT="WOZ Centraal" DOMAIN=HPUNIX COMPRESSION=YES AUTOFSRENAME=NO ARCHDELETE=YES BACKDELETE=YES FORCEPWRESET=NO KEEPMP=NO MAXNUMMP=5 URL=http://owcx01:1581 04-08-2004 13:41:43 ANR2063I Node OWCX01 updated. 04-08-2004 13:43:29 ANR0406I Session 25290 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3031)). 04-08-2004 13:47:00 ANE4991I (Session: 25290, Node: OWCX01_ORCL) TDP Oracle HP ANU0599 ANU2535I File /adsmorc//TMWB_8_1_533310141.bck = 204800 bytes sent 04-08-2004 13:47:00 ANR0406I Session 25291 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3026)). 04-08-2004 13:47:00 ANR0403I Session 25291 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:00 ANR0403I Session 25290 ended for node OWCX01_ORCL (TDP Oracle HP). 04-08-2004 13:47:04 ANR0406I Session 25292 started for node OWCX01_ORCL (TDP Oracle HP) (Tcp/Ip 10.10.1.2(-3025)). 04-08-2004 13:47:05 ANR0403I Session 25292 ended for node OWCX01_ORCL (TDP Oracle HP). This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify [EMAIL PROTECTED] This footnote also confirms that this e-mail message has been checked by McAfee Groupshield for the presence of computer viruses.
Wider columns in q event command??
Hello When I issue q event * * exceptipnsonly=yes I get tsm: SPADAB-PROD>q event * * exceptionsonly=yes Scheduled Start Actual Start Schedule Name Node Name Status - - -- 09/08/2004 03:00:00 INCRBACK3 SFFPROD2DBMissed 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD- Missed 001 09/08/2004 05:00:00 09/08/2004 05:00:21 INCRBACK1 STMFSPAS01EX- Failed 002 09/08/2004 05:00:00 09/08/2004 05:33:21 INCRBACK1 STMFSPAS01EX- Failed 005 09/08/2004 05:00:00 09/08/2004 05:00:33 PRIME_POSTSC- PRIMEDB1 Failed HEDULE_CMD 09/08/2004 05:00:00 PRIME_POSTSC- PRIMEDB2 Missed HEDULE_CMD 09/08/2004 07:00:00 09/08/2004 08:33:35 REST_OBTAIN SP7WS210 Failed However some of my schedule and nodenames are too long to fit within the Schedule Name and Node Name row, so I get a line with just a few charachters in the output I want it to look something like: Scheduled Start Actual Start Schedule Name Node NameStatus - - -- 09/08/2004 05:00:00 INCRBACK1 STMFSPAS01AD001 Missed 09/08/2004 05:00:0009/08/2004 05:00:21INCRBACK1 STMFSPAS01EX002 Failed 09/08/2004 05:00:0009/08/2004 05:33:21INCRBACK1 STMFSPAS01EX005 Failed 09/08/2004 05:00:0009/08/2004 05:00:33PRIME_POSTSCHEDULE_CMD PRIMEDB1 Failed I looked at select * from events but I only see the most recent events there Is there a way to increase the number of charachters in the rows? Regards Niklas Lundström Swedbank
