How to get the best use from TSM with a large disk?
Dear All, My TSM backup server holds approx 15Tb of data collected from some 80 servers. The twin 4560 library holds 56 tapes. Approx. 150 tapes are offline. The primary disk storage is 120Gb. As you can imagine reclamation takes quite a lot of time as the system become overloaded since it was put in action almost 2 years ago. The greatest complaint is that restore, unlike backup, is not instant. To fix the problem my management is about to purchase 5Tb of disks. We only had small disks up to now and it seems that a large disk is an entirely different game. It does not seem to be very obvious how to get the best value out of it. Had I had enough disks to put all data on disk could simply move tape system to the disk. Had I had larger library I would simply put all tapes online. But in my case I face a mixed disk tape system. As I am not so keen on reinventing the wheel, I would like to ask few quiestions, like: Where can I find materials about TSM configuration for a large disk/ large disk + tape ? I am sure that somebody from ASDM-L may have a suitable experience. Would you be so kind to share it with me and provide me with some pointers? There are special mechanism to regroup data - like backup sets and co-location (and maybe something I missed) Would they be of any use in my future setup ? With regards, -- Mr Krzysztof Wozniak,-_|\ E-mail: [EMAIL PROTECTED] Edith Cowan University / \ Phone: 61-8-9273 8026 Churchlands WA, 6018 $_,-._/Fax: 61-8-9273 8000 Australia o
Tivoli/RMAN Issue
Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/04/2005 22:32:56 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-02041: unable to duplicate a string O/S-Error: (OS 7011) The modem did not accept the command sent to it. Verify that the configured modem name matches the attached modem. ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 2041, sbtopen: system error We reinstalled the TDP client and rebooted the server. We know receive the following error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/06/2005 07:40:50 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-00610: Message 610 not found; product=RDBMS; facility=SOSD Can anyone help? ** http://www.barking-dagenham.gov.uk E-mail confidentiality notice. This message is intended for the addressee(s) only. It may be private, confidential and may be covered by legal professional privilege or other confidentiality requirements. If you are not one of the intended recipients, please notify the sender immediately on +44(0)20-8592-4500 and delete the message from all locations in your computer network. Do not copy this e-mail or use it for any purpose or disclose its contents to any person: to do so may be unlawful **
hi tsm'ers ! UPGRADE question
hi all, i'll first explain the situation and then tell you what we want do , i appreciate every reply and help you offer TSM 5.2.4.0 on pSeries 640 2x8 port switch LTO library L32 with 12 LTO1 drives (and the same configuration on DR site) as we approached the capacity of this one LTO library we have now choice to upgrade the whole thing option 1. the simplest - add D52 (driveless) frame filled with 400 LTO1 tapes option 2. my proposition - replace 9 LTO1 drives with 9 LTO3 drives + additional D52 frame filled with LTO3 cartridges why 9 ? well i thought because we have a lot of archive data on LTO1 tapes and considering the long expiration policies i think some day the LTO1 tapes will get used to delete the stuff i'm not sure but think that LTO3 drive cannot write LTO1 tapes am i right ? i cant find on ibm site the interoperability matrix for LTO(drives/tapes) ,can someone point ? thanks so if LTO3 drive can read from LTO1 tape , can LTO1 drive read LTO3 tape ? (of course with LTO1 drive native speed) (this is acceptable) furthermore , one idea (not mine) was to install LTO3 drives and tapes and migrate the whole thing to LTO3 tapes, but what then with all the empty LTO1 tapes and 3 LTO1 drives ? :-) boy ! i'm really confused and my chiefs want some solution proposition one of them wants to stay in-line with new technologies and one is for the simplest solution ... me ? i'm for new technology but i really in this moment don't know how it will look like and how the whole thing should be done, and what and how is the smartest way to do this thing. thats's pretty much it, i will surely find some other question as time goes by and i'll ask them here coz this community is my only reference for questions like this, coz i know from experience ibm sales personel is really confused when we talk to them about our needs, and for tech guys from ibm they got itchy all over when i call them on the phone ;-) LOL nevermind ... thanks for every letter you will write in reply goran konjich senior unix administrator vipnet
Re: Tivoli/RMAN Issue
Hi Brendan! Look for the sbtio.log file, it probably contains more useful information about the error. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:44 To: ADSM-L@VM.MARIST.EDU Subject: Tivoli/RMAN Issue Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/04/2005 22:32:56 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-02041: unable to duplicate a string O/S-Error: (OS 7011) The modem did not accept the command sent to it. Verify that the configured modem name matches the attached modem. ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 2041, sbtopen: system error We reinstalled the TDP client and rebooted the server. We know receive the following error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/06/2005 07:40:50 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-00610: Message 610 not found; product=RDBMS; facility=SOSD Can anyone help? ** http://www.barking-dagenham.gov.uk E-mail confidentiality notice. This message is intended for the addressee(s) only. It may be private, confidential and may be covered by legal professional privilege or other confidentiality requirements. If you are not one of the intended recipients, please notify the sender immediately on +44(0)20-8592-4500 and delete the message from all locations in your computer network. Do not copy this e-mail or use it for any purpose or disclose its contents to any person: to do so may be unlawful ** ** 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: Tivoli/RMAN Issue
Hi Eric, Thank you for the reply. I'm a DBA with not much experience of Tivoli. Where should this log file be located? Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 10:10 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Tivoli/RMAN Issue Hi Brendan! Look for the sbtio.log file, it probably contains more useful information about the error. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:44 To: ADSM-L@VM.MARIST.EDU Subject: Tivoli/RMAN Issue Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/04/2005 22:32:56 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-02041: unable to duplicate a string O/S-Error: (OS 7011) The modem did not accept the command sent to it. Verify that the configured modem name matches the attached modem. ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 2041, sbtopen: system error We reinstalled the TDP client and rebooted the server. We know receive the following error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/06/2005 07:40:50 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-00610: Message 610 not found; product=RDBMS; facility=SOSD Can anyone help? ** http://www.barking-dagenham.gov.uk E-mail confidentiality notice. This message is intended for the addressee(s) only. It may be private, confidential and may be covered by legal professional privilege or other confidentiality requirements. If you are not one of the intended recipients, please notify the sender immediately on +44(0)20-8592-4500 and delete the message from all locations in your computer network. Do not copy this e-mail or use it for any purpose or disclose its contents to any person: to do so may be unlawful ** ** 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: Tivoli/RMAN Issue
Hi Brendan! The location of sbtio.log is controlled by the user_dump_dest option in your Oracle initialization file. The default is directory is $ORACLE_HOME/admin/hostname/udump You could also use the find command... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 11:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: Tivoli/RMAN Issue Hi Eric, Thank you for the reply. I'm a DBA with not much experience of Tivoli. Where should this log file be located? Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 10:10 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Tivoli/RMAN Issue Hi Brendan! Look for the sbtio.log file, it probably contains more useful information about the error. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:44 To: ADSM-L@VM.MARIST.EDU Subject: Tivoli/RMAN Issue Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/04/2005 22:32:56 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-02041: unable to duplicate a string O/S-Error: (OS 7011) The modem did not accept the command sent to it. Verify that the configured modem name matches the attached modem. ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 2041, sbtopen: system error We reinstalled the TDP client and rebooted the server. We know receive the following error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/06/2005 07:40:50 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-00610: Message 610 not found; product=RDBMS; facility=SOSD Can anyone help? ** http://www.barking-dagenham.gov.uk E-mail confidentiality notice. This message is intended for the addressee(s) only. It may be private, confidential and may be covered by legal professional privilege or other confidentiality requirements. If you are not one of the intended recipients, please notify the sender immediately on +44(0)20-8592-4500 and delete the message from all locations in your computer network. Do not copy this e-mail or use it for any purpose or disclose its contents to any person: to do so may be unlawful ** ** 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: Tivoli/RMAN Issue
Hi Eric, I have checked the sbtio.log file in the udump directories for both RMAN and PROD database. RMAN stbio.log is empty and PROD stbio.log has a last modified date of 18/04/05. Our issue started on 04/05/05. Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 10:56 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Tivoli/RMAN Issue Hi Brendan! The location of sbtio.log is controlled by the user_dump_dest option in your Oracle initialization file. The default is directory is $ORACLE_HOME/admin/hostname/udump You could also use the find command... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 11:29 To: ADSM-L@VM.MARIST.EDU Subject: Re: Tivoli/RMAN Issue Hi Eric, Thank you for the reply. I'm a DBA with not much experience of Tivoli. Where should this log file be located? Regards, Brendan -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 10:10 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Tivoli/RMAN Issue Hi Brendan! Look for the sbtio.log file, it probably contains more useful information about the error. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Baker Brendan [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:44 To: ADSM-L@VM.MARIST.EDU Subject: Tivoli/RMAN Issue Hi, Yesterday all our RMAN scripts failed with the follow error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/04/2005 22:32:56 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-02041: unable to duplicate a string O/S-Error: (OS 7011) The modem did not accept the command sent to it. Verify that the configured modem name matches the attached modem. ORA-19511: Error received from media manager layer, error text: SBT error = 7011, errno = 2041, sbtopen: system error We reinstalled the TDP client and rebooted the server. We know receive the following error message: RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03009: failure of allocate command on tape1 channel at 05/06/2005 07:40:50 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer OSD-00610: Message 610 not found; product=RDBMS; facility=SOSD Can anyone help? ** http://www.barking-dagenham.gov.uk E-mail confidentiality notice. This message is intended for the addressee(s) only. It may be private, confidential and may be covered by legal professional privilege or other confidentiality requirements. If you are not one of the intended recipients, please notify the sender immediately on +44(0)20-8592-4500 and delete the message from all locations in your computer network. Do not copy this e-mail or use it for any purpose or disclose its contents to any person: to do so may be unlawful ** ** 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: TSM/Veritas
Yes, is possible, we have a couple installations running where the same library supports both backup products, with IBM3584, and with L700. I am pretty sure you can do it with all the large scale libraries provided that the library supports true sharing and zoning. Brgds, Othonas Xixis IBM Global Services/Strategic Outsourcing Gill, Geoffrey L. GEOFFREY.L.GILL@ To SAIC.COM ADSM-L@VM.MARIST.EDU Sent by: ADSM:cc Dist Stor Manager Subject [EMAIL PROTECTED] TSM/Veritas .EDU 05/05/2005 05:11 PM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU I was wondering if anyone out there is, or has dealt with this. We know that it is physically possible to attach 2 TSM servers to a library and run each independently of the other. The question I have is, is it possible to run 2 systems to the same library, knowing each will have their own dedicated drives, when one is running TSM and the other Veritas? Thanks for any info you can provide, Geoff
Empty volume cannot be deleted or reclaimed
Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? TIA Pat Doyle TSM Server Version 5.1.6.2 tsm: EAGLESTAR_TSMq drm 75l1 Volume Name State Last Update Automated Date/Time LibName - --- 75L1 Vault 2005-04-08 11:25:52 tsm: EAGLESTAR_TSMQ VOL 75L1 Session established with server EAGLESTAR_TSM: Windows Server Version 5, Release 1, Level 6.2 Server date/time: 2005-05-06 13:18:07 Last access: 2005-05-06 13:15:05 Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status (MB) --- -- - - 75L1 COLO1_COPY- LTODEVC184,320.0 0.0 Filling _POOL tsm: EAGLESTAR_TSMQ CON 75L1 ANR2034E QUERY CONTENT: No match found using this criteria. ANS8001I Return code 11. tsm: EAGLESTAR_TSMDELETE VOL 75L1 WAIT=YES ANR2220W This command will delete volume 75L1 from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSMDELETE VOL 75L1 DISCARDDATA=YES WAIT=YES ANR2221W This command will result in the deletion of all inventory references to the data on volume 75L1, thereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSM ** The contents of this e-mail and possible associated attachments are for the addressee only. The integrity of this non-encrypted message cannot be guaranteed on the internet. Eagle Star Insurance Company (Ireland) Limited is therefore not responsible for the contents. If you are not the intended recipient, please delete this e-mail and notify the sender Eagle Star Insurance Company (Ireland) Limited is regulated by the Irish Financial Services Regulatory Authority **
Re: Incremental skipping filesystems?
Hallo, And thanks for the suggestions, they prompted us to investigate a few avenues. We tracked it down to an issue with the 5.2.0.0 client on Solaris. Upgrading to 5.2.2.0 has fixed the problem - although I am still trying to find a page on ibm.com describing the fault. Thanks, Matt. Computer says 'No'.. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben Bullock Sent: Thursday, May 05, 2005 4:46 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Incremental skipping filesystems? Hmm, then indeed that does seem to be strange. The fact that the filespaces don't even show up in a q fi is really strange. By the looks of your filesystem /home is not an NFS mount, so they really should be backed up. /home is not a link out to somewhere else it is? It doesn't looks like it is, as it shows up in a 'df' command. Strange What about if for grins and giggles if you put a DOMAIN all-local statement in your dsm.opt file and try it... Heck, perhaps even putting that line in after each SERVERNAME statement and trying it... It's a long shot, but perhaps it might behave differently Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Thursday, May 05, 2005 9:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Incremental skipping filesystems? We aren't using client option sets, but good idea I hadn't thought of them. The dsm.sys and dsm.opt are linked as follows; lrwxrwxrwx 1 root other 50 May 4 21:00 dsm.sys - /app/scripts/config_files/tsm/rhine-e.PROD_dsm.sys lrwxrwxrwx 1 root other 50 May 4 21:00 dsm.opt - /app/scripts/config_files/tsm/rhine-e.PROD_dsm.opt These files exist, and are the ones I have posted. Hmm.. I vaguely remember there was a known issue that could cause this behaviour, and I think specifically on Sun machines, but I havent turned up anything searching ibm.com yet... Computer says 'No'.. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ben Bullock Sent: Thursday, May 05, 2005 4:28 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Incremental skipping filesystems? Perhaps you are hitting a client options set on the TSM server? QUERY CLOPTS On Solaris clients, you might also check to make sure that the TSM config files in /opt/tivoli/tsm/client/ba/bin directory are properly linked to the files out in /usr/bin. If they are unique files in each location, you can get some strange things. This is how they should look: lrwxrwxrwx 1 root other 16 Aug 25 2004 dsm.sys - /usr/bin/dsm.sys lrwxrwxrwx 1 root other 16 Aug 25 2004 dsm.opt - /usr/bin/dsm.opt If not, perhaps a copy of your dsm.sys, the dsm.opt and the inclexcl file might help. Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Thursday, May 05, 2005 9:09 AM To: ADSM-L@VM.MARIST.EDU Subject: Incremental skipping filesystems? Hallo *SM'ers Client o/s, SOLARIS SunOS 5.9 Dsmc 5.2.0.0 Dsmserv 5.2.2.3 on AIX 5.2.0.0 It appears incremental backup is missing/skipping filesystems Firstly, I am assured there were definitley many directories and files under /home/ last night when the backups ran... The dsmc log for the backups say's this; IBM Tivoli Storage Manager Command Line Backup/Archive Client Interface - Version 5, Release 2, Level 0.0 (c) Copyright by IBM Corporation and other(s) 1990, 2003. All Rights Reserved. Node Name: RHINE-E Session established with server RUTLAND: AIX-RS/6000 Server Version 5, Release 2, Level 2.3 Server date/time: 05/04/05 20:01:24 Last access: 05/04/05 20:01:22 Incremental backup of volume '/' Incremental backup of volume '/etc/mnttab' Incremental backup of volume '/var' Incremental backup of volume '/var/run' Incremental backup of volume '/home' Incremental backup of volume '/app/genrat' Incremental backup of volume '/app/mine1' ... etc /home is definitley listed. There are no further mentions of /home in the logfile. Approx 130,000 files inspected, 2,500 backed up. So very possible nothing had changed in home, hence no further mention in the log. (or, /home was totally empty? But I am asssured this is not the case) Now, firstly, firing up the web client and browsing the files available for restore, all files are listed under the single filesystem name '/' so I assume /home is a dir of /, rather than a separate mountpoint, but then, why would TSM list it as a domain for backup at the beginning of the incremental? Secondly, in the GUI, there is not an entry for /home Query backup from the command-line shows exactly the same thing - nothing. The following select statement on the TSM server produces the output that follows; tsm: RUTLANDselect * from backups where node_name='RHINE-E' and hl_name like '%home%' ANR2963W
Re: Tivoli/RMAN Issue
On May 6, 2005, at 4:44 AM, Baker Brendan wrote: OSD-02041: unable to duplicate a string Cause: There is not enough contiguous memory available to perform the task. Action: Wait a few minutes and try the operation again-memory may have been freed by other processes. If this happens often, reduce the size of the System Global Area (SGA) by decreasing the DB_BLOCK_BUFFERS parameter in the INIT%SID%.ORA file. Alternatively, unload any unnecessary NLMs to free more memory or consider adding more memory to your system.
Re: Migration - Primary and Copy Pool
Bruno, From the TSM Help for the Define stgpool command: The server can perform simultaneous write to copy storage pools for the following operations: o Backup and archive operations by Tivoli Storage Manager backup-archive clients or application clients using the Tivoli Storage Manager API. o HSM migration operations by Tivoli Storage Manager for Space Management (HSM) clients. o Import operations that involve copying exported file data from external media to a primary storage pool associated with a copy storage pool list. Simultaneous writing is NOT supported when migrating data between storage pools. You will have to rely on the Backup Stgpool command. Regards, Paul van Dongen MCSE IBM Certified Deployment Professional - ITWS 8.2 e ITSM 5.2 Vanguard http://www.vanguard-it.com.br -Original Message- From: Bruno Melo - Suporte Informtica [mailto:[EMAIL PROTECTED] Sent: Thu 5/5/05 16:24 To: ADSM-L@VM.MARIST.EDU Cc: Subject: Migration - Primary and Copy Pool Hi Fellows, The environment: TSM Server 5.1.9.5, AIX 4.3.3 ML 9 Two 3580 LTO1 SCSI tape drives (manual) Both drives defined on the same library. A small costumer used to backup their data directly to tape storage pools, primary and copy, simultaneously coping the data to both storage pools. Until that point nothing weird, just define the copystg option on the primary and everything works like a charm. The strange bahavior appeared when, for performance reasons, they decided to backup their data to disk and than migrate it to tape, the migration to tape works fine, but only goes to one of the storage pools (the primary). Since, nothing has changed on the tape storage pools what the hell is going on? It seems like some limitation for the migration process, but it should work. At least this is what the manuals show. I've checked the migprocess option to ensure that there was only one process, but nothing changed. The backup stg command works fine. Am I missing something? Atenciosamente, . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . BRUNO MELO Suporte Informtica Ltda. e-mail: [EMAIL PROTECTED]
Re: Empty volume cannot be deleted or reclaimed
I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? Do a audit vol XX fix=yes
Re: Empty volume cannot be deleted or reclaimed
Hi Patrick! Try an audit volume for this tape. If you see that it has repaired files, you will have to do a move data for the tape. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 14:25 To: ADSM-L@VM.MARIST.EDU Subject: Empty volume cannot be deleted or reclaimed Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? TIA Pat Doyle TSM Server Version 5.1.6.2 tsm: EAGLESTAR_TSMq drm 75l1 Volume Name State Last Update Automated Date/Time LibName - --- 75L1 Vault 2005-04-08 11:25:52 tsm: EAGLESTAR_TSMQ VOL 75L1 Session established with server EAGLESTAR_TSM: Windows Server Version 5, Release 1, Level 6.2 Server date/time: 2005-05-06 13:18:07 Last access: 2005-05-06 13:15:05 Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status (MB) --- -- - - 75L1 COLO1_COPY- LTODEVC184,320.0 0.0 Filling _POOL tsm: EAGLESTAR_TSMQ CON 75L1 ANR2034E QUERY CONTENT: No match found using this criteria. ANS8001I Return code 11. tsm: EAGLESTAR_TSMDELETE VOL 75L1 WAIT=YES ANR2220W This command will delete volume 75L1 from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSMDELETE VOL 75L1 DISCARDDATA=YES WAIT=YES ANR2221W This command will result in the deletion of all inventory references to the data on volume 75L1, thereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSM ** The contents of this e-mail and possible associated attachments are for the addressee only. The integrity of this non-encrypted message cannot be guaranteed on the internet. Eagle Star Insurance Company (Ireland) Limited is therefore not responsible for the contents. If you are not the intended recipient, please delete this e-mail and notify the sender Eagle Star Insurance Company (Ireland) Limited is regulated by the Irish Financial Services Regulatory Authority ** ** 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: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed
Unfortunately, any time I Audit a volume my server crashes abruptly! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 13:46 To: ADSM-L@VM.MARIST.EDU Subject: [Possible Spam] Re: Empty volume cannot be deleted or reclaimed Hi Patrick! Try an audit volume for this tape. If you see that it has repaired files, you will have to do a move data for the tape. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 14:25 To: ADSM-L@VM.MARIST.EDU Subject: Empty volume cannot be deleted or reclaimed Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? TIA Pat Doyle TSM Server Version 5.1.6.2 tsm: EAGLESTAR_TSMq drm 75l1 Volume Name State Last Update Automated Date/Time LibName - --- 75L1 Vault 2005-04-08 11:25:52 tsm: EAGLESTAR_TSMQ VOL 75L1 Session established with server EAGLESTAR_TSM: Windows Server Version 5, Release 1, Level 6.2 Server date/time: 2005-05-06 13:18:07 Last access: 2005-05-06 13:15:05 Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status (MB) --- -- - - 75L1 COLO1_COPY- LTODEVC184,320.0 0.0 Filling _POOL tsm: EAGLESTAR_TSMQ CON 75L1 ANR2034E QUERY CONTENT: No match found using this criteria. ANS8001I Return code 11. tsm: EAGLESTAR_TSMDELETE VOL 75L1 WAIT=YES ANR2220W This command will delete volume 75L1 from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSMDELETE VOL 75L1 DISCARDDATA=YES WAIT=YES ANR2221W This command will result in the deletion of all inventory references to the data on volume 75L1, thereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSM ** The contents of this e-mail and possible associated attachments are for the addressee only. The integrity of this non-encrypted message cannot be guaranteed on the internet. Eagle Star Insurance Company (Ireland) Limited is therefore not responsible for the contents. If you are not the intended recipient, please delete this e-mail and notify the sender Eagle Star Insurance Company (Ireland) Limited is regulated by the Irish Financial Services Regulatory Authority ** ** 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. **
3494 at DR Recovery Site
I got to thinking about 3494 category codes in the middle of the night when I should have been sleeping (can you tell my DR test is soon?). If I load the DR 3494 with my copypool tapes and let the 3494 do an audit operation while I am restoring my tsm machine from a sysback tape, will all the tapes be in Insert category? The recovery scripts that DRM prepares do not include any checkin libvol statements. Aren't I going to have to checkin all those tapes before they can be used? The tsm db that I will be restoring won't have any of them in libvol because they are all offsite. David Ehresman University of Louisville
Re: Empty volume cannot be deleted or reclaimed
On May 6, 2005, at 8:25 AM, Doyle, Patrick wrote: Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? A frequent question. Do an Audit Volume. Richard Sims
Re: TSM app in initab
Thanks Richard. Hope these question are not too basic--but guess I gotta start somewhere (who do I see about getting you a raise...) |-+ | | Richard Sims | | | [EMAIL PROTECTED] | | | Sent by: ADSM: | | | Dist Stor| | | Manager | | | [EMAIL PROTECTED]| | | .EDU| | || | || | | 05/05/2005 02:18 | | | PM | | | Please respond to| | | ADSM: Dist Stor | | | Manager | | || |-+ -| | | | To: ADSM-L@VM.MARIST.EDU | | cc: | | Subject: Re: [ADSM-L] TSM app in initab | -| On May 5, 2005, at 4:54 PM, Frank Lozano wrote: 1MT: Shouldn't my dsmserv.err file be recently touched? It has the suspicious date of the last time dsmserv stopped? Ran a find cmd to insure that is the only file That file is created/replaced by the dsmserv process as it is failing, to record what it knows about its plight.
Re: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed
Hi Patrick! This is probably related to APAR IC36609 which has been fixed in 5.1.8.0. Why don't you upgrade to the latest 5.1 level, which is 5.1.10.0? Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 14:46 To: ADSM-L@VM.MARIST.EDU Subject: Re: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed Unfortunately, any time I Audit a volume my server crashes abruptly! -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: 06 May 2005 13:46 To: ADSM-L@VM.MARIST.EDU Subject: [Possible Spam] Re: Empty volume cannot be deleted or reclaimed Hi Patrick! Try an audit volume for this tape. If you see that it has repaired files, you will have to do a move data for the tape. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Doyle, Patrick [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 14:25 To: ADSM-L@VM.MARIST.EDU Subject: Empty volume cannot be deleted or reclaimed Hi, I have a volume that appears to empty, but I can't delete it, or reclaim it. Any ideas? TIA Pat Doyle TSM Server Version 5.1.6.2 tsm: EAGLESTAR_TSMq drm 75l1 Volume Name State Last Update Automated Date/Time LibName - --- 75L1 Vault 2005-04-08 11:25:52 tsm: EAGLESTAR_TSMQ VOL 75L1 Session established with server EAGLESTAR_TSM: Windows Server Version 5, Release 1, Level 6.2 Server date/time: 2005-05-06 13:18:07 Last access: 2005-05-06 13:15:05 Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status (MB) --- -- - - 75L1 COLO1_COPY- LTODEVC184,320.0 0.0 Filling _POOL tsm: EAGLESTAR_TSMQ CON 75L1 ANR2034E QUERY CONTENT: No match found using this criteria. ANS8001I Return code 11. tsm: EAGLESTAR_TSMDELETE VOL 75L1 WAIT=YES ANR2220W This command will delete volume 75L1 from its storage pool after verifying that the volume contains no data. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSMDELETE VOL 75L1 DISCARDDATA=YES WAIT=YES ANR2221W This command will result in the deletion of all inventory references to the data on volume 75L1, thereby rendering the data unrecoverable. Do you wish to proceed? (Yes (Y)/No (N)) Y ANR2406E DELETE VOLUME: Volume 75L1 still contains data. ANS8001I Return code 13. tsm: EAGLESTAR_TSM ** The contents of this e-mail and possible associated attachments are for the addressee only. The integrity of this non-encrypted message cannot be guaranteed on the internet. Eagle Star Insurance Company (Ireland) Limited is therefore not responsible for the contents. If you are not the intended recipient, please delete this e-mail and notify the sender Eagle Star Insurance Company (Ireland) Limited is regulated by the Irish Financial Services Regulatory Authority ** ** 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: [Possible Spam] Re: Empty volume cannot be deleted or reclaim ed
On May 6, 2005, at 8:46 AM, Doyle, Patrick wrote: Unfortunately, any time I Audit a volume my server crashes abruptly! That's what maintenance is for... You can go to a higher level than your 5.1.6.2, where there are fixes for Audit Volume problems, per the server Readme file. Richard Sims
Re: Operational Hourly Monitors
If you go in and look at some of the queries already defined by Tivoli in the default hourly monitor it shows that the SQL WHERE clause compares the date/times BETWEEN '%s and '%s' . I've used this syntax in my own queries and it works fine. I've never found any documentation on it, just a little reverse engineering. Since you can refresh the monitor on either the current time or the scheduled time, I'm going to assume the the %s's are calculated as NOW-1hour and NOW. Bill Boyer Some days you're the bug, some days you're the windshield - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Michael LaFrance Sent: Thursday, May 05, 2005 8:10 PM To: ADSM-L@VM.MARIST.EDU Subject: Operational Hourly Monitors I'm trying to set up an operational monitor that will alert our TSM operators that a tape is required from a shelf location. The shelf is where the archive tapes are stored and they are required from time to time for collocation. The hourly script will check the activity log for ANR8765I. My problem is setting the query to only search the last hour of the activity log. I can make it check the previous day but am stumped by this past hour report. Here is my TSQL script: select msgno, message from actlog where msgno=8765 and date(date_time)=current_date - 1 day I've tried to adjust this script to query just the last hour of the activity log but to no avail. Does anyone have any suggestions? Mike LaFrance Network Analyst Prospera Credit Union Tel 604-864-6638 Fax 604-850-3473 [EMAIL PROTECTED] This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to 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 receive this email in error, please immediately notify the sender. Please note that this financial institution neither accepts nor discloses confidential member account information via email. This includes password related inquiries, financial transaction instructions and address changes.
Out of scratch tapes?
Folks, UNfortunately as a result of miscommunication with our supplier, we will be running out of scratch tapes in the next few days. We should have a new shipment returning on Monday but, in the meantime, it appears that we will run out Sunday evening. Aside from missing backups, what other repercussions can we expect? Thanks so much! DaveZ
Re: Out of scratch tapes?
Well, unhappy management springs to mind. But for the short period you are talking about, can't you do one or more of 1) Add extra disk storage 2) Step up reclamation 3) Look at tape reuse delay 4) Check whether you have any filespaces not accessed for a long time. Are their backups still required? Dave Zarnoch [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu 06/05/2005 14:09 Please respond to ADSM: Dist Stor Manager ADSM-L@vm.marist.edu To ADSM-L@vm.marist.edu cc Subject Out of scratch tapes? Folks, UNfortunately as a result of miscommunication with our supplier, we will be running out of scratch tapes in the next few days. We should have a new shipment returning on Monday but, in the meantime, it appears that we will run out Sunday evening. Aside from missing backups, what other repercussions can we expect? Thanks so much! DaveZ ** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy Group. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Unless specifically stated otherwise, this email (or any attachments to it) is not an offer capable of acceptance or acceptance of an offer and it does not form part of a binding contractual agreement. Scottish Hydro-Electric, Southern Electric, SWALEC, S+S and SSE Power Distribution are trading names of the Scottish and Southern Energy Group. **
Re: 3494 at DR Recovery Site
I got to thinking about 3494 category codes in the middle of the night when I should have been sleeping (can you tell my DR test is soon?). If I load the DR 3494 with my copypool tapes and let the 3494 do an audit operation while I am restoring my tsm machine from a sysback tape, will all the tapes be in Insert category? The recovery scripts that DRM prepares do not include any checkin libvol statements. Aren't I going to have to checkin all those tapes before they can be used? The tsm db that I will be restoring won't have any of them in libvol because they are all offsite. David Ehresman University of Louisville I am also preparing for my first DR test with a 3494, although it is a bit further off than yours. A related question occurs to me: is it necessary to use mtlib to change the categories of the tapes used to restore the TSM database?
Time limit on TSM DB?
Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB?
Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB?
I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB?
Do a q status. That will show the retention period for ACTLOG and SUMMARY. At 12:21 PM 5/6/2005 -0400, you wrote: I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Time limit on TSM DB?
You are searching the activity log, which has a user defined retention period. You can set the retention using the command: set actlogretention ## Where ## is the number of days to retaining records. You can see your current settings by issuing a query status command. Doug Thorneycroft Systems Analyst Computer Technology Section County Sanitation Districts of Los Angeles County (562) 699-7411 Ext. 1058 FAX (562) 699-6756 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 9:21 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Time limit on TSM DB? I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB? SOLVED
Folks, Thanks! That clears up some things.. Activity Log Retention Period: 2 Day(s) Activity Summary Retention Period: 30 Day(s) Thanks again! DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:34 PM Please respond to ADSM: Dist Stor Manager You are searching the activity log, which has a user defined retention period. You can set the retention using the command: set actlogretention ## Where ## is the number of days to retaining records. You can see your current settings by issuing a query status command. Doug Thorneycroft Systems Analyst Computer Technology Section County Sanitation Districts of Los Angeles County (562) 699-7411 Ext. 1058 FAX (562) 699-6756 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 9:21 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Time limit on TSM DB? I'm doing some lookups for amount of data being backed up. Here's the statement: select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between '2005-03-28' and '2005-03-31') and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc '2005-04-04' and '2005-04-06' generates a list '2005-03-28' and '2005-03-31' generates no match DaveZ Thorneycroft, DougTo: ADSM-L@VM.MARIST.EDU [EMAIL PROTECTED]cc: CSD.ORG Subject: Re: [ADSM-L] Time limit on TSM DB? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .EDU 05/06/2005 12:03 PM Please respond to ADSM: Dist Stor Manager Please be more specific, what is it that you are looking for in the database? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Dave Zarnoch Sent: Friday, May 06, 2005 8:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Time limit on TSM DB? Folks, Sorry if this is a FAQ.. I'm trying to generate reports from our TSM database that are older than 1 month old and I am not finding any info. Is this the time retention on the DB? How do I find out? Thanks! DaveZ
Re: Time limit on TSM DB?
Dave The number of days that information is kept in the SQL activity summary table is configurable. Try HELP SET SUMMARYRETENTION for info. Regards Neil Schofield Yorkshire Water Services Ltd. Did you know - in Africa and Asia 1 billion people still don't have access to safe water - 9th - 13th May is water aware week - you can make a big difference by visiting http://www.wateraid.org/wateraware to make an on-line donation. Just a small amount of money can make an impact . Or become a regular donor and give two pounds a month over a year - enough money to give a family safe, clean water for life. YORKSHIRE WATER - WINNER OF THE UTILITY OF THE YEAR AWARD 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: Out of scratch tapes?
Dave I disagree with John's recommendation to step up tape reclamation to get over a short term lack of scratch tapes unless your pending re-use delay will expire before the tapes arrive. My inclination would be to stop all reclamations until the new tapes arrive. Reclamation gives you a benefit in the future (ie after the REUSEDELAY), but in the short term may actually cost you scratch tapes. Rather than allow the backups to fail, have you thought of deleting your oldest pending media and TSM database backups? Regards Neil Did you know - in Africa and Asia 1 billion people still don't have access to safe water - 9th - 13th May is water aware week - you can make a big difference by visiting http://www.wateraid.org/wateraware to make an on-line donation. Just a small amount of money can make an impact . Or become a regular donor and give two pounds a month over a year - enough money to give a family safe, clean water for life. YORKSHIRE WATER - WINNER OF THE UTILITY OF THE YEAR AWARD 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
Result 402
Hi list, After issuing a q event * * begindata=-7 f=d command I have the following (part of the output): Policy Domain Name: Policy_name Schedule Name: BKP_SRV_EXCHANGE_FULL Node Name: EM1-EXCHANGE Scheduled Start: 04/29/2005 01:00:00 Actual Start: 04/29/2005 01:00:08 Completed: 04/29/2005 01:53:39 Status: Failed Result: 402 What4s the meaning of result 402 ? Where can I find documentation about these result codes ? Thanks in advance. Mario Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
Re: Result 402
402 is a general error code, with no associated meaning. You will need to look at the Data Protection for Exchange log to find out what the problem is. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/06/2005 01:28:23 PM: Hi list, After issuing a q event * * begindata=-7 f=d command I have the following (part of the output): Policy Domain Name: Policy_name Schedule Name: BKP_SRV_EXCHANGE_FULL Node Name: EM1-EXCHANGE Scheduled Start: 04/29/2005 01:00:00 Actual Start: 04/29/2005 01:00:08 Completed: 04/29/2005 01:53:39 Status: Failed Result: 402 What4s the meaning of result 402 ? Where can I find documentation about these result codes ? Thanks in advance. Mario
Re: Result 402
should the parameter not be begindate -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 1:55 PM To: ADSM-L@VM.MARIST.EDU Subject:Re: Result 402 402 is a general error code, with no associated meaning. You will need to look at the Data Protection for Exchange log to find out what the problem is. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/06/2005 01:28:23 PM: Hi list, After issuing a q event * * begindata=-7 f=d command I have the following (part of the output): Policy Domain Name: Policy_name Schedule Name: BKP_SRV_EXCHANGE_FULL Node Name: EM1-EXCHANGE Scheduled Start: 04/29/2005 01:00:00 Actual Start: 04/29/2005 01:00:08 Completed: 04/29/2005 01:53:39 Status: Failed Result: 402 What4s the meaning of result 402 ? Where can I find documentation about these result codes ? Thanks in advance. Mario
Setting up Virtual Volumes
I'm trying to set up virtual volumes for DB Backups. I have, in this order, upd server targetserver serverpa=pw nodename=sourceserver def dev dbbackup devt=server servername=targetserver reg no sourceserver pw t=server When I run ba db t=full dev=dbback it fails with ANR0424W - invalid password. What did I miss? This is TSM 5.2.2.5 running on AIX 5.1 Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Out of scratch tapes?
I have to agree for off-site reclamation. With reclamation running you can take up additional tapes that are off-site giving you even less to work with at the present time. Reclamation for your local tapes(on-site tapepool) should help gain back tapes. Eric -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Neil Schofield Sent: Friday, May 06, 2005 12:47 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Out of scratch tapes? Dave I disagree with John's recommendation to step up tape reclamation to get over a short term lack of scratch tapes unless your pending re-use delay will expire before the tapes arrive. My inclination would be to stop all reclamations until the new tapes arrive. Reclamation gives you a benefit in the future (ie after the REUSEDELAY), but in the short term may actually cost you scratch tapes. Rather than allow the backups to fail, have you thought of deleting your oldest pending media and TSM database backups? Regards Neil Did you know - in Africa and Asia 1 billion people still don't have access to safe water - 9th - 13th May is water aware week - you can make a big difference by visiting http://www.wateraid.org/wateraware to make an on-line donation. Just a small amount of money can make an impact . Or become a regular donor and give two pounds a month over a year - enough money to give a family safe, clean water for life. YORKSHIRE WATER - WINNER OF THE UTILITY OF THE YEAR AWARD 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: Out of scratch tapes?
Couple of things comes to my mind. Without knowing what your TSM environment is like it's hard to say.. however, these similar situation might happen. Out of scratch tapes. Disk pools fill up to 100%. Migration from disk to tape pools fail.. tape copies from onsite to offsite fail. TSM database backup fails. Also if you are into faith, praying might help to. If you are out of scratch tapes with all of your tapes utilization at 100%, then you are SOL. If you are out of scratch tapes with some tapes with less than 100% utilization then you have some hope. What can you do.. couple of things 1)select volume_name,stgpool_name,access,pct_reclaim,times_mounted from volumes where stgpool_name='ur onsite tape pool' order by pct_reclaim desc Take highest reclaimable value and perform move data 2) Keep expiration going 3) Stop drm vaulting temporary if you are doing daily DRM. 4) Keep fewer TSM database backups say, you are keeping them onsite for 7 days.. u can try to reduce this # by say keep for 3 days or so. Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/06/2005 09:09:21 AM: Folks, UNfortunately as a result of miscommunication with our supplier, we will be running out of scratch tapes in the next few days. We should have a new shipment returning on Monday but, in the meantime, it appears that we will run out Sunday evening. Aside from missing backups, what other repercussions can we expect? Thanks so much! DaveZ
TSM/Veritas on the same library
Since there was only one response I think I need to give a bit of info to help with why I'm asking the question. We have TSM and Veritas here. Not something I wanted but its here. Currently each reside on their own libraries mainly because one is LTO2(Veritas) and the other a 3494(TSM). I'd like to start moving TSM LTO this year. We are in the midst of standing up a DR site and I'm trying to see how we can bundle this together. So instead of standing up 2 libraries I'd like to stand up one large enough to handle both the Veritas and TSM backups. I'd like to add on to what we have here if they could live together nicely. The 3494 we have is currently shared by the mainframe and 2 TSM servers. We already know we have to bring up a 3494 at the DR site for the mainframe/TSM and another for Veritas. I would like however to send part of the 3494 we have now to handle portions of the TSM backups along with getting hardware for the IBM. If we stood up an LTO library here to start migrating off the 3494 that is doable. I would then need LTO at the DR site for TSM but would like to see if a single large enough unit would suffice. So my original question is still, can a LTO library be shared by both systems provided they each have their own dedicated drives? Has anyone done this or think it can be done? Any information, be it in the form of links to articles or direct knowledge would be greatly appreciated. Thanks, Geoff
Re: TSM/Veritas on the same library
I've gotta ask Geoff, Why, with a 3494 and LTO library would you move TSM to LTO? My first option would be to move veritas to the 3494. 3494 is industrial strength and plays well in multi host and multi application environments. Use 3592 drives and you'll have capacity to burn. Also, second-hand frames to provide additional storage are quite economical. Second-hand is viable here - what can go wrong with a dumb storage rack? and you'll have no trouble getting IBM maintenance coverage for it if that is important to you. Regards Steve. Steve Harris Resting in Brisbane, Australia - Original Message - From: Gill, Geoffrey L. [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU Sent: Saturday, May 07, 2005 11:29 AM Subject: [ADSM-L] TSM/Veritas on the same library Since there was only one response I think I need to give a bit of info to help with why I'm asking the question. We have TSM and Veritas here. Not something I wanted but its here. Currently each reside on their own libraries mainly because one is LTO2(Veritas) and the other a 3494(TSM). I'd like to start moving TSM LTO this year. We are in the midst of standing up a DR site and I'm trying to see how we can bundle this together. So instead of standing up 2 libraries I'd like to stand up one large enough to handle both the Veritas and TSM backups. I'd like to add on to what we have here if they could live together nicely. The 3494 we have is currently shared by the mainframe and 2 TSM servers. We already know we have to bring up a 3494 at the DR site for the mainframe/TSM and another for Veritas. I would like however to send part of the 3494 we have now to handle portions of the TSM backups along with getting hardware for the IBM. If we stood up an LTO library here to start migrating off the 3494 that is doable. I would then need LTO at the DR site for TSM but would like to see if a single large enough unit would suffice. So my original question is still, can a LTO library be shared by both systems provided they each have their own dedicated drives? Has anyone done this or think it can be done? Any information, be it in the form of links to articles or direct knowledge would be greatly appreciated. Thanks, Geoff