Re: Collocation anomaly report
You might try this query: select cast(vu.stgpool_name as char(9)) as Pool, - (select access from volumes where volume_name=vu.volume_name) as Access, - cast(vu.volume_name as char(9)) as Volume, - cast(count(distinct nd.collocgroup_name) as decimal(4,0)) as Groups, - cast(count(distinct vu.node_name) as decimal(3,0)) as Nodes, - cast(count(distinct vu.filespace_name) as decimal(5,0)) as FSpaces, - (select pct_utilized from volumes where volume_name=vu.volume_name) as Util, - (select pct_reclaim from volumes where volume_name=vu.volume_name) as Recl - from volumeusage vu, nodes nd - where vu.node_name=nd.node_name - group by vu.stgpool_name, vu.volume_name - order by Groups desc, Nodes desc, FSpaces desc We assign all nodes to collocation groups, even if it is only one node. Good luck. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Colwell, William F. Sent: Wednesday, April 17, 2013 9:44 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Collocation anomaly report Hi Grant, I used to track collocation group spill overs when my servers were version 5 and used tapes. Now I am on v6 and almost all disk, so I don't do that anymore. Anyway, I used a mysql database on my desktop system. I would dump data from the tsm servers and load it into mysql where I could do manipulations not allowed in the tsm servers. Then I would run a report which showed among other things volumes which have data from more than 1 collocation group. The key bit of data from tsm is q nodedata * which provides almost all the same info as a select from volumeusage, but is much faster. I can send you a sample report if you are interested. Bill Colwell Draper Lab -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grant Street Sent: Tuesday, April 16, 2013 7:40 PM To: ADSM-L@VM.MARIST.EDU Subject: Collocation anomaly report Hello We use collocation to segment data into collocation groups and nodes, but recently found that collocation is on a best efforts basis and will use any tape if there is not enough space. I understand the theory behind this but it does not help with compliance requirements. I know that we should make sure that there are always enough free tapes, but without any way to know we have no proof that we are in compliance. I have created an RFE https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfeCR_ID=33537 . Please vote if you agree:-) While I wait a more than two years for this to be implemented, I was wondering if anyone had a way to report on any Collocation anomalies? I created the following but still not complete enough select volume_name, count(volume_name) as Nodes_per_volume from (select Unique volume_name , volumeusage.node_name from volumeusage, nodes where nodes.node_name = volumeusage.node_name and nodes. collocgroup_name is null) group by (volume_name) having count (volume_name) 1 and select unique volume_name, count(volume_name) as Groups_per_volume from (select Unique volume_name , collocgroup_name from volumeusage, nodes where nodes.node_name = volumeusage.node_name ) group by (volume_name) having count(volume_name) 1 Thanks in advance Grant This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: checkin tape to tsm lto libary
Tim, The info given by the library should match what q libvol shows. You maybe should run an audit library to see it clears things up. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Monday, January 14, 2013 11:20 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] checkin tape to tsm lto libary Yes we assigned it to logical library_a which is the only library we have All the other tapes in the library are assigned to library_a Should I see the same list of tapes via the TS3310 web page for data cartridges that I see as a result of q libv tsmlibr Some of the entries in the data cartridges section via the web page don't exist in the q libv tsmlibr command and some that appear in q libv tsmlibr don't exist entries in the data cartridges section via the web page Thanks, Tim -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Richard van Denzel Sent: Monday, 14 January, 2013 11:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: checkin tape to tsm lto libary Did you phiscally assign it to the library on the library? Met vriendelijke groet, Richard van Denzel +31 (0)6 15 83 82 48 -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] Namens Ballenger, Craig Verzonden: maandag 14 januari 2013 17:24 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: Re: [ADSM-L] checkin tape to tsm lto libary Did you check the tape in to the library and assign it to the correct pool? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Monday, January 14, 2013 11:06 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] checkin tape to tsm lto libary Have a LTO tape that was previously written to. It was outside the library so we inserted it to do a reclaim process. After it was inserted we attempted a checkin command but the results show no volume found. CHECKIN LIBVOLUME TSMLIBR SEARCH=YES VOLLIST=A00027L5 STATUS=PRIVATE CHECKLABEL=BARCODE ANR8431I CHECKIN LIBVOLUME process completed for library TSMLIBR; 0 volume(s) found. Status of tape to TSM tsm: TSMPOK_SERVER1q vol a00027l5 f=d Volume Name: A00027L5 Storage Pool Name: ORACLE_COPY Device Class Name: LTO_TAPE Estimated Capacity: 4.4 T Scaled Capacity Applied: Pct Util: 0.8 Volume Status: Full Access: Unavailable Pct. Reclaimable Space: 99.2 Scratch Volume?: Yes In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 159 Write Pass Number: 1 Approx. Date Last Written: 09/25/2012 06:57:42 Approx. Date Last Read: 07/17/2012 16:13:25 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: Volume is MVS Lanfree Capable : No Last Update by (administrator): ADMIN Last Update Date/Time: 10/18/2012 09:55:30 Begin Reclaim Period: End Reclaim Period: Drive Encryption Key Manager: None Logical Block Protected: No Thanks, Tim Brown This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: tsm scripts time of day
Jeannie, Current_date, Current_timestamp, and Current_time are not part of any table, they are SQL variables that can be derived as needed by referencing them in an SQL statement. The STATUS table in TSM is useful as it only contains 1 record, other tables will work, but may return many lines and process more slowly. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Jeannie Bruno Sent: Tuesday, December 18, 2012 11:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] tsm scripts time of day Thanks. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Sims, Richard B Sent: Tuesday, December 18, 2012 12:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] tsm scripts time of day Do SELECT * FROM SYSCAT.TABLES WHERE TABNAME='___' on a given table name to see what columns it has. (Table schema can change over time.) Richard Sims On Dec 18, 2012, at 11:32 AM, Jeannie Bruno jbr...@cenhud.com wrote: Is there a 'current_day' column on the status table? just curious, it's giving me invalid column name, so I thought I had the wrong name. When I do select * from status, I don't even see column current_time.(I'm wearing my glasses too!) This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: tsm scripts time of day
Something like this? I haven't tested it, but it should be close. select current_time from status where time(current_time)'23:00:00.' if (rc_ok) goto today yesterday: query actlog search= ane *** begind=today-1 endd=today begint=18:00 endt=now goto exit today: query actlog search= ane *** begind=today endd=today begint=18:00 endt=now exit: exit -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Monday, December 17, 2012 4:01 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] tsm scripts time of day The reason I wanted to check time is that I want to query the actlog under certain conditions. If its before midnight I want to issue query actlog search= ane *** with begind=today endd=today begint=18:00 endt=now and after midnight with begind=today-1 endd=today today begint=18:00 endt=now Possible? Thanks, Tim -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Prather, Wanda Sent: Thursday, 13 December, 2012 1:36 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: tsm scripts time of day Yep. Select current_date from status select current_timestamp from status (Doesn't have to be from the status table, that's just a convenient one.) -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Thursday, December 13, 2012 11:44 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm scripts time of day Is there a check the time of day within a tsm script ? Thanks, Tim Brown Supervisor Computer Operations Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.commailto:tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: tsm scripts time of day
Tim, I haven't found a direct check, but I kludged this together to accomplish it. select licensecompliance from status where time(current_time)'02:00:00.' if (rc_ok) goto action Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Thursday, December 13, 2012 10:44 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm scripts time of day Is there a check the time of day within a tsm script ? Thanks, Tim Brown Supervisor Computer Operations Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.commailto:tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: permanent retention
Gary, Since you're using backup for archiving, you can route these backups to your disk/tape archive pools, then you'll avoid having to move the data around much once it's been saved. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ron Delaware Sent: Wednesday, December 12, 2012 2:49 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] permanent retention Gary, The problem you will run into is that the backup data will be mixed in with all of the other backup data, unless you have a management class that sends the data to a separate storage pool and tape pool. If you need to have this data isolated, archives or a separate storage pool is the only way to go. _ Ronald C. Delaware IBM IT Plus Certified Specialist- Expert IBM Corporation | Tivoli Software IBM Certified Solutions Advisor - Tivoli Storage IBM Certified Deployment Professional 916-458-5726 (Office) 925-457-9221 (cell phone) email: ron.delaw...@us.ibm.com Storage Services Offerings From: Lee, Gary g...@bsu.edu To: ADSM-L@vm.marist.edu Date: 12/12/2012 01:53 PM Subject:Re: [ADSM-L] permanent retention Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Ron: I understand that archive is preferable, but there is sufficient data there as to interfere with daily backups. Therefore, I want to do it with backups so as not to re-move data. I have a management class permanent-retain with a backup copygroup defined as follows: Copy Group Type: Backup Versions Data Exists: 1 Versions Data Deleted: 1 Retain Extra Versions: No Limit Retain Only Version: No Limit in dsm.opt I have: INCLUDE.BACKUP *:\Keep\...\* permanent-retain INCLUDE.BACKUP *:\Keep\...\*.* permanent-retain Will this do the job and not retain too much data? Thanks for the help. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ron Delaware Sent: Wednesday, December 12, 2012 12:08 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] permanent retention Gary, You really don't want to use backup's for long term retention, that is an archive function. But if you must, you set everything to NOLIMIT NOLIMIT NOLIMIT NOLIMIT that way the data will hang around forever, but as I stated, Archives are the way to go _ Ronald C. Delaware IBM IT Plus Certified Specialist- Expert IBM Corporation | Tivoli Software IBM Certified Solutions Advisor - Tivoli Storage IBM Certified Deployment Professional 916-458-5726 (Office) 925-457-9221 (cell phone) email: ron.delaw...@us.ibm.com Storage Services Offerings From: Lee, Gary g...@bsu.edu To: ADSM-L@vm.marist.edu Date: 12/12/2012 10:46 AM Subject:[ADSM-L] permanent retention Sent by:ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Just received a request to have a few files stored in tsm essentially forever. I am trying to figure out the best way to accomplish this with minimal administrative overhead. So far, 1. create a management class with an archive group set for days, then archive the files. 2. create a management class and use backup, but I am unclear how to accomplish permanent retention there? Any ideas well be appreciated. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: TSM cmd after library has been defined again..
Jerome, If your cleaning tapes are known to TSM, you'll need to check them back in also with the number of cleanings remaining. Q libv lib CL* f=d should show number of cleanings remaining before you drop the library. checkin libv lib search=y stat=clean checkl=bar clean=# remaining will check in your media. You may want to eject and insert them individually if they have a different number of cleanings remaining on each. It's usually best to let the library handle the cleanings if you can keep TSM out of it. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Ribeiro, Ricardo Sent: Tuesday, November 27, 2012 1:15 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM cmd after library has been defined again.. Here is an easier one... Syntax for a SCSI library -LABEl LIBVolume--library_name more... (ENTER to continue, 'C' to cancel) +-volume_name+ '-SEARCH--=--+-Yes--| A |--+--LABELSource--=--+-Barcode+-' '-Bulk--| A |-' +-Prompt-+ '-Vollist--| B |-' .-OVERWRITE--=--No--. --+-+--+---+--- '-CHECKIN--=--+-SCRatch-+-' '-OVERWRITE--=--+-No--+-' '-PRIvate-''-Yes-' -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@vm.marist.edu] On Behalf Of Remco Post Sent: Tuesday, November 27, 2012 11:55 AM To: ADSM-L@vm.marist.edu Subject: Re: [ADSM-L] TSM cmd after library has been defined again.. checkin libv lib search=y stat=scr checkl=[bar|yes] checkin libv lib search=y stat=priv checkl=[bar|yes] in that order On 27 nov. 2012, at 19:37, Swartz, Jerome jerome.swa...@computacenter.com wrote: Hi All, Haven't touched TSM in a while. Needed to delete the paths, drives and library. I just defined those again and there is a command that I need to run so that TSM can see the tapes in the library. Just can't get to it! Q libv doesn't return any results.. Thanks in advance! Jerome ** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (Mid-Market) Limited is registered in England and Wales with the registered number 3434654. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (FMS) Limited is registered in England and Wales with the registered number 3798091. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ** -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: rename nodes fi for systemstate
Check your spelling Sytem State -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Monday, November 26, 2012 12:14 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] rename nodes fi for systemstate I can rename a servers systemstate FI but cant rename it back. Is this inherent or an error with the rename command. I know that it can be recreated but just curious why the second rename fails. Works: rename FILESPACE servera servera\SystemState\NULL\System State\SystemState serveraDR\SystemState\NULL\Sytem State\SystemState namet=UNI NEWNAMET=UNI Fails: rename FILESPACE servera serveraDR\SystemState\NULL\System State\SystemState servera\SystemState\NULL\Sytem State\SystemState namet=UNI NEWNAMET=UNI ANR0852E RENAME FILESPACE: No matching file spaces found for node SERVERA Thanks, Tim Brown Supervisor Computer Operations Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.commailto:tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
TSM Remote volume audit process
Greetings! We are running remote volumes as backups for our TSM backstore of Tivoli Enterprise Content Manager. We had a damaged volume on the backup system and audited the volume, which deleted the remote volume containing eCM info from the tape. I don't see any evidence that the eCM backstore TSM machine is aware that the backup was deleted. Is this relayed back to that TSM so that the data is backed up again? Thanks, Bob. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: unaccounted for volumes
The most obvious reasons would be a tape operator running a check-in script instead of a label script or checking in with a status=private instead of status=scratch. TSM will not initialized a tape with data it knows about, so checking them out and labeling or checking back in as scratch (whichever is appropriate) will work. If you check everything out with remove=no, and checkin scratch first and then private, you should get back all the volumes that have been initialized. If you are still missing some, they probably haven't been initialized. As for the volhist, a volume isn't listed there until it is actually used for data of some kind. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Friday, October 05, 2012 1:36 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] unaccounted for volumes Tsm server 6.2.2 running on RHEL v6 with a 3494 library and 8 ts1120 drives. Was doing some checking on tape inventory and usage for one of our tsm servers. A Select count(*) from libvolumes Shows 298 volumes in the library. Checking volhistory for database backup volumes shows 3 tapes in that capacity. Check of pending volumes shows 1 And summing up all tape pool volumes gives 118. A Select count(*) from libvolumes where status='Private' Shows 160 And Select for scratch volumes gives 137. The upshot is that I have around 40 volumes in the libvolumes table listed as private, but not accounted for in the volumes or volhistory? Audit library ields no errors. Can I just check these out and re check them in as scratch? What would account for this. p.s. I have the volhist file from the moment the server was placed online. The lost volumes do not appear there anywhere. Thanks for any help. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Neutering a test server
If you really want to isolate it, change the IP address to one in an unused/isolated subnet/vlan and don't give it a route statement. Make sure DHCP is not enabled on any of your other NICs. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Zoltan Forray/AC/VCU Sent: Monday, May 14, 2012 8:46 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Neutering a test server Recently, for migration/testing purposes, I did a full conversion of a 5.5 server to 6.2 on my test TSM server. I would like to continue using this server to test additional upgrades without having to wipe and rebuild. Unfortunately, since it is a copy of a real server, whenever I fire it up, it keeps trying to reach out and touch other TSM servers that it has definitions to (library manager, etc), thus producing constant error messages due to invalid passwords, etc. I am concerned if I play with it to do like things mass-deletes, etc, it will try to do things like purge/release tapes, etc. Besides adding to DSMSERV.OPT: DISABLESCHEDS YES NOMIGRRECL What else can I do to neuter it to avoid possible problems? In this same vein, is there a simple way to remove the current instance and install/configure another one? Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Size of actice data pool ?
Another option that may quickly give you some rough information is query filespace. A spreadsheet with filespace size times percentage full for the pertinent filespaces will give you an estimate of the data involved. This depends also on backup excludes that may be involved. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Shawn Drew Sent: Friday, April 27, 2012 11:10 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Size of actice data pool ? You can run a preview on the copy activedata command.(i.e. copy active data xxx preview=yes) This should tell you what you want to know. Regards, Shawn Shawn Drew Internet guenther_bergm...@gbergmann.de Sent by: ADSM-L@VM.MARIST.EDU 04/27/2012 11:35 AM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] Size of actice data pool ? Hi all, given the following setup: TSM 5.5 Primary storage pool of device class FILE Copy ool on LTO -tapes, managed by DRM Primary pool ist copied daily to the copy pool Since the Copy pool is reaching some limitations ( # of tapes, vault capacity) we are thinking about setting up an active data pool and copying the active data pool to the copy pool. The question: How to estimate the size of the active data pool in compared to the primary pool? Is there something like: QUERY OCCUPANCY ACTIVEDATAONLY=YES ? Can it be done with some SQL query? I can geht the numbers (active/inactive) from the backups table, but it does not give the size of the backed up objects. Any hints on this? regards Günther -- Guenther Bergmann, Am Kreuzacker 10, 63150 Heusenstamm, Germany Guenther_Bergmann at gbergmann dot de This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Move NodeData
George, I'm still at 5.5, but I don't believe the requirement that the copypool volumes needed for a move nodedata job be mountable has changed in newer releases. If you run it without the volumes onsite, you will get a message for each needed volume: MOVE NODEDATA nodename FROMSTGPOOL=offsitepoolname 04/02/2012 09:44:06 ANR1258W Files on volume xx needed for move data cannot be accessed - access mode is unavailable, offsite, or destroyed. (SESSION: 17678) Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of George Huebschman Sent: Monday, April 02, 2012 9:33 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Move NodeData Gene, I know what they do, how they are similar and different. Move Data moves data from a tape. Move Node Data moves the data for a node on whatever tape it resides on to another tape in another (or the same) storage pool. (Achieving something similar to a node collocation.) - My question is, does the mechanism of moving the objects work the same as reclamation and move data (or not, as the documentation hints at). - Do the source volumes have to be onsite? - Does it work more like Restore Volume run for a primary pool volume, where TSM generates a listing of CopyPool media that is required to perform the restore? On Mon, Apr 2, 2012 at 10:03 AM, Shaffer, Gene gene.shaf...@aurora.orgwrote: Hi George; The short story - 'move data' to get files off a specific tape volume 'move nodedata' to consolidate files for a node to fewer volumes -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of George Huebschman Sent: Friday, March 30, 2012 1:30 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Move NodeData I think I have misunderstood how the command move nodedata works in regard to offsite media. I had believed that it functioned in the same way that reclamation and move data operations worked, utilizing onsite media to write new offsite media. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: delete node data from copy stg pool
Yes, but it isn't necessarily a straight forward process. The tool we use is DELETE VOLUME (volume_name) DISCARDDATA=YES, BUT, and that can be a big obstacle, we only want to delete data that belongs to the pertinent node on the volumes. To accomplish this, we have set up our copy pools and nodes in collocation groups and, when we want to segregate a node, we set them up in a separate group. Then we can do a move data on the volumes that contain the pertinent node information so that we can do a DELETE VOLUME on the new volumes created for that node. If anyone has a favorite way of doing this, or if TSM would like to create a DELETE NODEDATA with a COPYPOOL option command, or update the DELETE FILESPACE command to allow specifying a copy pool, it would be a LOT easier to accomplish this. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tim Brown Sent: Wednesday, March 28, 2012 1:19 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] delete node data from copy stg pool Can one delete node data from a copy pool, I have 2 copy pools with node A in 2 of them and only want it in one. Thanks, Tim Brown Supervisor Computer Operations Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: mailto:tbr...@cenhud.com tbr...@cenhud.com mailto:tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: delete node data from copy stg pool
This works for copy pools, but requires that you bring the tapes onsite...not always an option if you need your DR media offsite. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of George Huebschman Sent: Wednesday, March 28, 2012 2:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] delete node data from copy stg pool The command move nodedata fromstgpool=tape_pool1 tostgpool=tape_pool2 might be what you want. Syntax .-,-. V | -MOVe NODEdata--+---node_name-+--+ '-COLLOCGroup--=--group_name-' --FROMstgpool--=--source_pool_name- --+-+-- '-TOstgpool--=--destination_pool_name-' -- George Huebschman Cell 410 522-8581 When you have a choice, spend money where you would prefer to work if you had NO choice. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Small TSM environment with removable file volumes for offsite
Greetings! I'm looking at building a very small TSM environment to support a remote site. Since there are only a couple of terabytes of data and the change rate should be only a few hundred gig per day, what I'm thinking of is a TSM server with about 5TB of internal storage for onsite deduped file pools. For offsite, I want to use bare SATA drives as removable file volumes (not deduped). For the initial proof of concept, I'd use an inexpensive SATA dock with 3.5 inch 1TB or 2TB drives for the offsite copy volume and small (100GB or so) 2.5 inch drives for the data base backups. These drives would go offsite in plastic drive sleeves daily and reclaims would run from the onsite pools. I've found a little about using removable file pool volumes, but I wanted to run this by the experts to see what others may have tried. For disaster recovery, it might be nice if all the drives could be mounted in an enclosure (I don't think there will be over about a dozen offsite volumes) -- Maybe a Promise SAN in JBOD mode or something that can be used with bare drives. Bob This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Small TSM environment with removable file volumes for offsite
Steve, We are considering that as well, but the remote office is fairly autonomous and several states away. With limited bandwidth, replication of DR info to us is probably reasonable, but recovery would involve transporting data back to the remote office. They already do backups to disks that are transported offsite, but we haven't brought them into the TSM fold as yet, which should greatly improve the process. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Steven Langdale Sent: Thursday, March 22, 2012 1:25 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Small TSM environment with removable file volumes for offsite Not really answering your question (sorry), but have you thought about client side de-dupe and backing up to a TSM instance in your main DC? For something that small, I'd look to a local TSM server as a last resort. Steven On 22 March 2012 16:29, Bob Levad ble...@winnebagoind.com wrote: Greetings! I'm looking at building a very small TSM environment to support a remote site. Since there are only a couple of terabytes of data and the change rate should be only a few hundred gig per day, what I'm thinking of is a TSM server with about 5TB of internal storage for onsite deduped file pools. For offsite, I want to use bare SATA drives as removable file volumes (not deduped). For the initial proof of concept, I'd use an inexpensive SATA dock with 3.5 inch 1TB or 2TB drives for the offsite copy volume and small (100GB or so) 2.5 inch drives for the data base backups. These drives would go offsite in plastic drive sleeves daily and reclaims would run from the onsite pools. I've found a little about using removable file pool volumes, but I wanted to run this by the experts to see what others may have tried. For disaster recovery, it might be nice if all the drives could be mounted in an enclosure (I don't think there will be over about a dozen offsite volumes) -- Maybe a Promise SAN in JBOD mode or something that can be used with bare drives. Bob This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: reclaim of file storage pool
Check out this deduperequiresbackup information http://publib.boulder.ibm.com/infocenter/tsminfo/v6/index.jsp?topic=%2Fcom.ibm.itsm.srv.ref.doc%2Fr_opt_server_deduprequiresbackup.html I think you'll have to run backups of your devt_file before you can reclaim. Backup stgpool devt_file lto_copy If your diskpool backups are working right, you shouldn't have anything to back up from devt_file. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Andrew Carlson Sent: Monday, March 05, 2012 3:18 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclaim of file storage pool The first thing I would check, is that you have full volumes that are 10% full (90% reclaimable), which is what the 90 in your command specifies. On Mon, Mar 5, 2012 at 14:30, Tim Brown tbr...@cenhud.com wrote: TSM 6.3 Our first drop stgpool uses devclass of disk, our next stgpool coded is on disk with a devclass of file, so the data is stored as .bfs files and their file sizes are 2048mb. This stgpool DEVT_PRIM is defined with dedup=yes. Over time the pct utilization of these bfs files drops as expiration runs and files get marked inactive and eventually removed. We attempted to reclaim these just like we had done for years with tapes but the reclaim fails with msg: TSMPOK_SERVER1RECLAIM STGPOOL DEVT_PRIM THRESHOLD=90 ANR2111W RECLAIM STGPOOL: There is no data to process for DEVT_PRIM. ANS8001I Return code 11. We also have an LTO copy pool in place that is used before we migrate from devt_disk to devt_prim Clients devt_disk Backup stgpool devt_disk lto_copy Migrate stgpool devt_disk lowmig=0 This all results in the 2gb files in devt_prim that will eventually need reclamation which is the process that is failing. Any thoughts on why reclaim fails with our config ? Thanks, Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. -- Andy Carlson --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Select Statement
James, set summaryretention xx Merry Christmas Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lepre, James Sent: Thursday, December 22, 2011 10:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Select Statement Does anyone know how to take this select command which produces only one month of data and allow it to go back say 1 year if possible. I have tried to figure it out but nothing works select date(start_time) as Start Date,time(start_time) as Start Time,date(end_time) as End Date,time(end_time) as End Time,number as Process #,activity,schedule_name,entity,bytes,successful from summary where schedule_name='SchedNAME' Thanks Everyone and Happy Holidays --- Confidentiality Notice: The information in this e-mail and any attachments thereto is intended for the named recipient(s) only. This e-mail, including any attachments, may contain information that is privileged and confidential and subject to legal restrictions and penalties regarding its unauthorized disclosure or other use. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action or inaction in reliance on the contents of this e-mail and any of its attachments is STRICTLY PROHIBITED. If you have received this e-mail in error, please immediately notify the sender via return e-mail; delete this e-mail and all attachments from your e-mail system and your computer system and network; and destroy any paper copies you may have in your possession. Thank you for your cooperation. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: disabe/enable a sched via command line
If you change the period units to onetime, the start date will have been passed and the schedule will not start until you change it back to a recurring unit. The Period will also change to 0 when onetime is selected, so the reversal will have to set both back to their original values. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Jeannie Bruno Sent: Wednesday, December 14, 2011 1:22 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] disabe/enable a sched via command line Can you change the Start Date/time to a future date on the schedules you don't want to run. - Original Message - From: Tyree, David david.ty...@sgmc.org To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, December 14, 2011 2:05 PM Subject: Re: [ADSM-L] disabe/enable a sched via command line I have about a dozen schedules but I would like to be able deactivate a couple of them and not affect the others. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Vandeventer, Harold [BS] Sent: Wednesday, December 14, 2011 1:29 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] disabe/enable a sched via command line How about DISABLE SESSIONS? That would not stop schedules, but would disallow the node connection. Still allows mgmt access, doesn't require an edit to opt nor a restart. Harold Vandeventer Systems Programmer State of Kansas - Department of Administration/COMPACT harold.vandeven...@da.ks.gov (785) 296-0631 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary D. Sent: Wednesday, December 14, 2011 12:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] disabe/enable a sched via command line The closest thing I can come up with is Disable server But this prevents all client connections. To disable schedules, add the line Disablescheds yes To the dsmserv.opt file, then restart the server. When you want to restart schedules, comment out the line, and restart the tsm server again. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Tyree, David Sent: Wednesday, December 14, 2011 1:05 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] disabe/enable a sched via command line I'm trying to figure out to enable and disable client schedules from the command line. I've looked over the online help and elsewhere but no luck. If the command was for an admin sched I would do update sched something type=admin active=yes/no . But I don't see a similar command for client schedules. thanks David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
TSM 6.2.3 deduped storage for Content Manager for mulpiplatforms.
Greetings, I am looking for a recommendation and/or information on using a TSM 6.2.3 deduped file pool as storage for Content Manager for Multiplatforms. We stored 12GB of PDF data from our old CM server into the new CM server which uses TSM for storage. Once the data hit my file pool, dedupe only found 700MB of duplicated blocks. I don't have access to the Content Manager settings and haven't found any obvious hits on google or IBM. My question is whether the CM server compresses before sending to TSM and whether I might get a better dedupe ratio if it didn't compress, so, my question: what setting on Content Manager might adjust whether data is compressed prior to sending to TSM, Is it the standard client setting in the dsm.opt file? Should it be set to never? Finally, is this server a good or a bad candidate for client-side dedupe? Thanks, Bob. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Volumes not managed by DRM, but should be
Do a Q DRMSTATUS to ensure the correct pools are listed for primary and copy pool. Update if it is not correct: SET DRMPRIMSTGPOOL And SET DRMCOPYSTGPOOL Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Moyer, Joni M Sent: Tuesday, August 02, 2011 10:47 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Volumes not managed by DRM, but should be Hi Everyone, I have a TSM 5.5.5.0 AIX server and I have found 11 tapes that are copy pool tapes that should be managed by DRM but do not appear to be. For example, T02659 is as follows: Volume Name: T02659 Storage Pool Name: COPY_SHAREPOINT Device Class Name: LTO2_OFFSITE Estimated Capacity: 276.4 G Scaled Capacity Applied: Pct Util: 17.8 Volume Status: Full Access: Read/Write Pct. Reclaimable Space: 82.2 Scratch Volume?: Yes In Error State?: No Number of Writable Sides: 1 Number of Times Mounted: 130 Write Pass Number: 1 Approx. Date Last Written: 01/03/11 04:34:48 Approx. Date Last Read: 09/12/10 02:04:41 Date Became Pending: Number of Write Errors: 0 Number of Read Errors: 0 Volume Location: Volume is MVS Lanfree Capable : No Last Update by (administrator): Last Update Date/Time: 09/12/10 02:03:30 When I do a q drm T02659 I get the following results: ANR2034E QUERY DRMEDIA: No match found using this criteria. Does anyone know how I can resolve this issue? Thanks in advance! This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: TSM multi libraries in a single stgpool
There is no reason a single library can't have multiple device classes. If I thought I would ever need to run multiple libraries, I'd be tempted to create multiple device classes, one per tape storage pool. Then if it ever became necessary to move a pool to another library, it would be a simple matter to update the device class to point to the new library and move the corresponding tapes. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Remco Post Sent: Wednesday, July 06, 2011 12:26 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM multi libraries in a single stgpool On 6 jul 2011, at 14:09, Steven Langdale wrote: Can TSM support having two libraries in a single stgpool? Looking to add another library but would to make sure it is used in tandem with our current library and not just sit there. Thank you, Vince Vince No you can't, it's one devclass in a stgpool and a devclass can only point to one library. Theres obviously nothing stopping you creating a new devclass and stgpool for this new library and pointing some servers at it to spread the workload. or, use one library for the primary pools and another for the copy pools, or define one stgpool in the new library as the next for an existing pool in the existing lib. Steven -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Restore trouble on Virtuel W2K3 server.
Here is a how-to on restoring a complete system. Good luck! Modified Instructions for Complete Restores of Windows Systems with the TSM Client: Bare Metal Restore (BMR), System State Restore, Windows System Object Restore https://www-304.ibm.com/support/docview.wss?uid=swg21164812wv=1 -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Grigori Solonovitch Sent: Thursday, June 16, 2011 7:06 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restore trouble on Virtuel W2K3 server. I do not think it is possible to do restore like this - you need to use some Bare Machine Recovery software like TBMR (Bare Machine Recovery for TSM). In addition, you can just clone VM instead of using TSM, if source and target servers are VMs. Grigori G. Solonovitch -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Bo Carsten Krogholm Nielsen Sent: Thursday, June 16, 2011 2:52 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore trouble on Virtuel W2K3 server. Hi all, I have restored a W2K3 server in a VM environment, but now it will not back up. It is a new server, where I restored the backup from another server. 1. Restored C-drive 2. SystemState restored. Then boot the server, which then stops during boot. What went wrong? Have fun Bo Nielsen Senior Technology Consultant DONG Energy A/S Klædemålet 9 2100 København Ø Denmark Tlf.: +45 9955 Mobile +45 9955 5434 bo...@dongenergy.dkmailto:bo...@dongenergy.dk www.dongenergy.dk Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Questions about vtl useage
All good advice. I would add a couple of points: When checking performance on a VTL (especially deduped) be sure to check both write and read speeds. Some VTLs will ingest very well, but when you are running reclamation or large restores (especially multiples), you may be limited by the re-hydration (recombobulation?) capabilities of the device. In the same light, when you are running reclamation on deduped storage, the same recombobulation must occur to feed the data back to TSM before it can be re-written and deduped again. Since TSM controls the filepool dedup and knows where all the blocks are, this process of rebuilding the data and re-writing and re-de-duping is mostly done with pointers. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Prather, Wanda Sent: Wednesday, June 16, 2010 10:42 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Questions about vtl useage Pick Carefully is indeed, the best advice. If all you need is additional storage, there are many configurations of either VTL or disk/filepool that you can choose. Filepools are very easy to manage in TSM. VTL's are more trouble to manage in some ways (you'll likely be defining managing dozens of paths), and there are more parts that can break. The 1 thing that would force you to choose a VTL, is a requirement for LAN-FREE support, which can only be done to a tape or tape-emulating device. There are 2 things that would force you to choose filepool: either wanting to run your TSM server as a VM (and I'm not saying that is a good idea anyway), or wanting to use client-side dedup. If none of those issues apply to your situation, there are lots of combinations you can use. A VTL that dedups; a disk filepool with or without TSM software deduplication: you can use disk of your own with a VTL gateway that dedups; there are companies that will sell you a VTL that dedups but behaves like plain disk so you can still use TSM with a filepool for client-side dedup, and you can use a NAS device that dedups but looks like plain disk to TSM so you can still use TSM with a filepool. SO, now that Ive added to the confusion: Here are the big MISTAKES I've seen people make over the last 4 years buying VTLs (or some combination of the above stuff): 1) Buying a solution that only solves today's problem. You need a solution that will solve your current problem, and will adapt to the problem you will hit 2 years from now, whatever that is most likely to be. For instance, if there is ANY likelihood that you would face a big bump in storage requirements in 2 years, for heaven's sake don't buy a VTL that can't expand to fit that need. Make sure you understand how you would adapt what you plan to buy, in case of a) needing more storage in the future, b) needing more throughput in the future, c) adding to the number of TSM servers you plan to run in the future, etc. There isn't really a good way to repurpose a VTL if you outgrow it. 2) Not figuring out what your throughput requirements are. Some VTL's are quite limited in throughput. Don't assume that because it's disk, it will be fast. Figure out your throughput needs as well as your space needs, and make the vendor configure to meet both requirements. 3) Not figuring on software or expansion costs. Make sure you get bids for at LEAST 3 years of your support costs, including the software costs. Also find out what it would cost if you have to expand the puppy later by xx terabytes. Some of the VTL's are licensed by TB, some are not. 4) Buying something you don't thoroughly understand. VTL's are not magic. If you buy disk instead of a VTL, you have to deal with spindles and buses and controllers and HBA's and firmware. If you buy a VTL, you have to deal with spindles and buses and controllers and HBA's and firmware at the back end, plus servers and HBA's and firmware and software on the front end. If someone offers you a VTL, LOOK at the hardware that makes it up. If someone offered you the same package as a straight disk array, would you be happy to buy it? If not, why would you want it as part of a VTL? If after you consider all these issues you aren't comfortable that a VTL is the right choice, or you just can't decide, buy disk. It's more flexible and you can always reconfigure it, repurpose it, move things around in your disk farm as you want. If you decide you need a VTL later, you can add a VTL gateway in front of your own disk. Wanda -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebner,Andy,FORT WORTH,IT Sent: Monday, June 14, 2010 9:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Questions about vtl useage We currently use an older VTL for the primary pools and you might find it hard to tell the difference between it and disks. With the deduping VTLs out there the amount of storage needed will be reduced. Pick carefully if you go the dedup route. There
Re: synchronize a windows drive with a USB removable disk using TSM
This would possibly be a good thing to do for an offsite recovery server with access to replicated TSM data. One problem with using TSM for this is files that have been deleted from the original server. You'd need to determine which files have been deleted from the source server so you could do the same on your backup file system. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Steven Langdale Sent: Sunday, April 25, 2010 2:00 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] synchronize a windows drive with a USB removable disk using TSM You probably can, but I'd be inclined to use something like robocopy (http://en.wikipedia.org/wiki/Robocopy) to achieve what your after Steven Langdale Global Information Services EAME SAN/Storage Planning and Implementation ( Phone : +44 (0)1733 584175 ( Mob: +44 (0)7876 216782 ü Conference: +44 (0)208 609 7400 Code: 331817 + Email: steven.langd...@cat.com Mehdi Salehi ezzo...@googlemail.com Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 25/04/2010 07:52 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] synchronize a windows drive with a USB removable disk using TSM Caterpillar: Confidential Green Retain Until: 25/05/2010 Hi, Before making a full backup of drive D:\ in a Windows XP client, I have copied all D:\* to a removable USB disk (300GB). Drive D:\ is changing everyday and sends the incremental backup to TSM. Can I sync D:\ with above USB disk using TSM restore? Initially, d:\ and USB disk have identical contents, I need to sync them occasionally. Thanks. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Backupset removal from Volhistory
DELETE VOLHISTORY type=backupset volume=xx force=yes todate=today -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Friday, April 16, 2010 10:03 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Backupset removal from Volhistory Hi list, I have a backupset entry in VOLHISTORY that I want to delete. The QUERY BACKUPSET command does not show this volume, so I cannot use the DEL BACKUPSET command. How can I remove this particular backupset entry from VOLHISTORY? Mario This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: SV: two libraries in a storage pool?
You could look into a virtual library manager. Gresham (www.greshamstorage.com) I believe has a product that will present multiple libraries to your system as if they were one. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Christian Svensson Sent: Wednesday, April 07, 2010 7:11 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SV: two libraries in a storage pool? Answer to you question is no. Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms Från: Mehdi Salehi [ezzo...@googlemail.com] Skickat: den 7 april 2010 11:22 Till: ADSM-L@VM.MARIST.EDU Ämne: two libraries in a storage pool? Hi all, Is there any way to assign tape drives in two separate LTO libraries in a single storage pool? I see in TSM reference that each storage pool has one device class and to each device class only one library can be assigned. My answer to above question is no. Am I mistaken? Thanks. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: issue with sql syntax in TSM database
We do multiple queries, activity for today, today-1, today-2, etc.
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
yoda woya
Sent: Tuesday, March 16, 2010 2:41 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] issue with sql syntax in TSM database
any workarounds if need to group them by the date only portion of the
timestamp.
On Tue, Mar 16, 2010 at 2:02 PM, Grigori Solonovitch g.solonovi...@bkme.com
wrote:
You should not use function date in group by. So try:
select start_time, sum(bytes)
from
summary
where
ACTIVITY in ('BACKUP','RESTORE')
group by start_time
From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of yoda
woya [yodaw...@gmail.com]
Sent: Tuesday, March 16, 2010 8:15 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] issue with sql syntax in TSM database
I am trying to run this sql and cannot get a result
select date(start_time), sum(bytes)
from
summary
where
ACTIVITY = 'BACKUP'
or ACTIVITY = 'RESTORE'
group by date(start_time)
any reasons why??
Please consider the environment before printing this Email.
This email message and any attachments transmitted with it may
contain confidential and proprietary information, intended only for
the named recipient(s). If you have received this message in error, or
if you are not the named recipient(s), please delete this email after
notifying the sender immediately. BKME cannot guarantee the integrity
of this communication and accepts no liability for any damage caused
by this email or its attachments due to viruses, any other defects,
interception or unauthorized modification. The information, views,
opinions and comments of this message are those of the individual and not
necessarily endorsed by BKME.
This electronic transmission and any documents accompanying this electronic
transmission contain confidential information belonging to the sender. This
information may be legally privileged. The information is intended only for
the use of the individual or entity named above. If you are not the intended
recipient, you are hereby notified that any disclosure, copying, distribution,
or the taking of any action in reliance on or regarding the contents of this
electronically transmitted information is strictly prohibited.
Re: Reclamation for offsite storage pools
Hi George, When you get behind with reclamation, you end up with many volumes with low util/high reclaim values. TSM trys to minimize tape mounts by reclaiming offsite data from your onsite tapes without too many remounts, which can pull data related to several/(or many) offsite volumes. You can force a more expeditious reclaim by specifying a high reclaim percent (95% or so) and setting OFFSITERECLAIMLIMIT to a small number (1 or 2). This will optimize getting volumes back at the expense of (probably) more local tape mounts. If you want to get a specific tape cleared, do a MOVE DATA. If you have the media, you could create a new pool and delete the old copy pool once the new one has been populated. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Wednesday, January 27, 2010 8:08 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Reclamation for offsite storage pools Hi George, Doesn't reclamation for offsite copy storage pool volumes write the data to new copy storage pool volumes from the primary copy? I guess I'm trying to come up with a more efficient method of getting caught up as reclamation just isn't accomplishing what I hope it would. Thanks again! -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebschman, George J. Sent: Wednesday, January 27, 2010 9:05 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Reclamation for offsite storage pools This is not true,Can I do a move data from 1 copy storage pool volume to the another volume within the same copy storage pool? That is what reclamation does for you without you specifying individual volumes. You use a reclamation threshold in a command or a storage pool threshold and TSM picks the volumes. With a MOVE DATA on a copy pool volume, TSM just grabs the data from the primary pool. You can let reclamations/move data/move nodedata run through housekeeping if needed. Ordinarily it isn't the best thing to do, but it shouldn't break anything. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Moyer, Joni M Sent: Wednesday, January 27, 2010 8:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Reclamation for offsite storage pools Hello everyone, For several years I had not been able to run reclamation on one of my tsm servers due to the lack of physical tape drives to accomplish the task. I am in the process of trying to get caught up, but it seems that I just never do. Most of my issue is with the copy storage pool volumes which are very under-utilized. It seems like reclamation, even if I start multiple reclamation threads, is taking quite a long time. Is there some other way for me to get the data onto new media without doing reclamation? Can I do a move data from 1 copy storage pool volume to the another volume within the same copy storage pool? I know that this would mean bringing the tapes back from the vault, but it is just not progressing as I would like with the reclamation processes. Any suggestions are greatly appreciated as I would like to get this back under control. Thank you in advance! Joni Moyer Storage Administrator III (717)302-9966 joni.mo...@highmark.com This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates. IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you
[no subject]
yahoo.com 1c63ffb4e7581f4e9cb6476a096367f788b0848...@a2xmxs1v1.a2x.lan.at 2266722b-923f-40bb-a65e-ac6be2747...@bu.edu X-ASG-Orig-Subj: RE: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Deleting EXPORT tape Subject: RE: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Deleting EXPORT tape Date: Thu, 7 Jan 2010 10:07:40 -0600 Message-ID: 375a530911ce4d8580a582cf23fd8...@wgo.local MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: 2266722b-923f-40bb-a65e-ac6be2747...@bu.edu Thread-Index: AcqPp28dRYew7QOGRua/biAkpn6h1QAC90Sw x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: by amavisd-new on lnxsrvu at winnebagoind.com X-Copyrighted-Material: Please visit http://www.company.com/privacy.htm X-Barracuda-Connect: lnxsrvu.winnebagoind.com[69.66.77.165] X-Barracuda-Start-Time: 1262880490 X-Barracuda-Bayes: INNOCENT GLOBAL 0. 1. -2.0210 X-Barracuda-Virus-Scanned: by Barracuda Spam Virus Firewall at marist.edu X-Barracuda-Spam-Score: -2.02 X-Barracuda-Spam-Status: No, SCORE=-2.02 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.5 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.19196 Rule breakdown below pts rule name description -- -- You might try this. DELETE VOLHISTORY typ=export volume=## force=yes todate=today It has worked for me to delete a backupset. I haven't tried it on an export. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Thursday, January 07, 2010 8:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] AW: [ADSM-L] AW: [ADSM-L] Deleting EXPORT tape On Jan 7, 2010, at 9:33 AM, VOJTA Othmar wrote: I have tried it now. FORCE=YES supports TYPE=DBB, but not TYPE=EXPORT. Sorry, no ideas any longer. If you perform one more, trivial Export, the bad one would be old and so could then be deleted. The prevailing problem with Delete Volhistory, of course, is that the most selectivity it offers is everything before this date/time. Richard Sims This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Client file active data pool selection for restores
TSM Version 5.5.2 on Windows I have set up two active data pools (one physical-LTO4 and one virtual-LTO2) for a group of nodes. When a restore is requested by the client, the active data on the physical tape is usually mounted. Since I have set up collocation of the virtual tape by node and I have more virtual drives than physical, I would prefer that the restore call for the virtual volumes. Is there any way short of marking the physical tape unavailable to force to restore to come from a particular pool or to skew the choices TSM makes to favor the more granularly collocated media? Bob. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Migration for Windows-based installation
When we migrated to a new server and LTO4 from LTO1, we installed all of the new stuff and tested the hardware with the TSM version we were running. When that was working well, we drained all of the disk pools, backed up the database from the existing server, shut it down, attached the old tape drives to the new server, restored the database, brought it up, deleted all of the old disk pools, defined new disk pools for the new hardware, defined the new tape drives, set up new devclasses and storage pools, changed the domains to point to the new devices and migration hierarchy, tested backups and restores, and set up move data jobs to move data from the LTO1's back to disk pools where it would then migrate to the new LTO4s. Once the LTO1's were empty, we detached the library and recycled the old tapes. The upgrade to a newer TSM could occur on the old server or the new, but best probably not at the same time as the hardware cutover. Starting from scratch was not an option for us as we have files with multi-year retentions. Bob. PS - If you have references to tapes that no longer exist, there are methods (google is your friend) to delete references to them. The method of deletion may depend on how the data was stored (primary/copypool/backupset/db backup/other). Once the references are gone, you should delete the storage pools and device classes that are obsolete. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Kurt Buff Sent: Monday, October 12, 2009 3:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Migration for Windows-based installation So, what happens to all the tapes I have offsite at Iron Mountain, and the archives I have stored in my basement vault, etc. I'll be perusing the archives as you suggest, but this isn't exactly crystalline to me just yet. A complicating factor that I hadn't realized until I did a bit of digging just now is that the current database holds references to a *really* old set of 8mm (AIT2) tapes from a Spectralogic Treefrog that we migrated from some years ago. Would the procedure you're suggesting clean that up? Kurt On Mon, Oct 12, 2009 at 12:10, Kelly Lipp l...@storserver.com wrote: Start from scratch. Install TSM at the level you would like, move and configure the library. Point the clients at the new server and go. That first backup will necessarily be a full. Will take longer than usual, but easy. This method allows you go clean up your database. Keep the old server around until the data expires. Clearly, there are more details, especially since you are going to re-use the library on the new STORServer (oops, I mean TSM Server). The overall concept is sound. For sites of your size I like this method as it is simple and gets me a brand new, pristine database. This will become important next year when you migrate to TSM 6.2. Besides, a clean start is always a good thing. This topic has been covered earlier and in much more detail. You might peruse the archives to see what you can find. My name will show up along with others like Wanda who have been through this many times. Thanks, Kelly Lipp Chief Technical Officer www.storserver.com 719-266-8777 x7105 STORServer solves your data backup challenges. Once and for all. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Kurt Buff Sent: Monday, October 12, 2009 1:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Migration for Windows-based installation I'd prefer to be able to migrate server data as much as possible, including the diskpool, but if it it would be an incredibly difficult maneuver (or take inordinate amounts of time, say on the order of more than a 4-day weekend) and/or the downside of losing the diskpool is relatively minor, I could potentially live without it. I would also contemplate keeping the current TSM server version on the new machine and upgrading immediately after implementation if that would be of benefit. We back up fewer than 10 servers, but one is our Exchange 2003 server at roughly 200gb and is a full backup every night, and the other is our file server at over 2tb, though on a nightly basis it normally does around 25-50gb. Does that answer your question? Kurt On Mon, Oct 12, 2009 at 11:18, David McClelland t...@networkc.co.uk wrote: Are you looking purely at a lift and shift hardware change here, or at a clean installation of TSM Server (at 5.5.3 for example) and migrating clients into the new instance? Cheers, /David Mc London, UK -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Kurt Buff Sent: 12 October 2009 18:54 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Migration for Windows-based installation All, We have a TSM server that's running out of steam, and nearing the end of its expected reliable life. We have Version 5, Release 3, Level
Re: Backup Stgpool using 2 drives taking too long
Mario, Based on your server level (5.5) you may be experiencing the following: IC57855: TSM SERVER DELAYS TRANSACTIONS BY 1 SECOND WHEN RECOVERY LOG UTILIZATION EXCEEDS 80% RESULTING IN PERFORMANCE DEGRADATION Please check your recovery log utilization to see if this may be the issue. With only two tape drives, you may be blocking the system's attempts to run an incremental DB backup. If this is the issue, you may want to direct incrementals to a disk or file devclass. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of John D. Schneider Sent: Monday, August 03, 2009 3:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Backup Stgpool using 2 drives taking too long Mario, So, if I understand this correctly, the primary storage pool is LTO4, and the copy storage pool is LTO4, and so the whole backup stgpool is straight tape to tape. Is that correct? When you say the process becomes idle for 20 minutes, how can you tell it is idle? Do you mean the number of bytes copied doesn't get any bigger? The total byte count only gets updated at the end of each aggregated file. That is, if the copy stream hits a 300GB single file, then the copy will proceed to copy that file as fast as tape performance permits, but the total byte count won't increase until that huge file completes. And a multi-hundred GB file could easily take 20 minutes or more. Next time you catch it in this state, look at the size of the current file, and do the arithmetic. Is it possible that is what you are seeing? If you can look at the tape drives themselves, you can tell if the tape drives themselves are reading and writing, or sitting idle, can't you? I suspect that the tape drives will be buzzing away, even though it seems like you aren't making progress. If I have misunderstood, and you can tell that the drives are really idle, then I would look at drive firmware next, then at IBMtape drivers. Make sure you are up-to-date We have 6 TSM Windows servers with IBM libraries and drives, and we are not seeing the symptom you describe, that is, periods of actual stalled backup stgpools. Feel free to contact me offline if you have not done the firmware and driver updates before, and need any assistance. Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 Original Message Subject: [ADSM-L] Backup Stgpool using 2 drives taking too long From: Mario Behring mariobehr...@yahoo.com Date: Mon, August 03, 2009 1:34 pm To: ADSM-L@VM.MARIST.EDU Hi list, The environment is TSM Server 5.5 running on a Windows 2003 box with a IBM ULT3580-TD4 SCSI (2 drives) connected. There is a backup stgpool process running on background for more than 12 hours (several schedules were missed during this time). The process is using both drives, one reading the data and the other writing, as expected. The problem is that, at some point, both drives stay IDLE for more than 20 minutes...then start reading/writing again (for a short time I might add). The process would be long over by now if this was not happening...what could be wrong and how can I put the drives to work non-stop, if possible...?? Any process that uses both drives in this fashion, like an EXPORT for example, is behaving the same way... Thanks Mario This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Summarizing Tape Utilization
I think you'll need a separate query for each utilization range. At least, I haven't thought of a good way to iterate. select stgpool_name, count(*) as 60% utilized 70% - from volumes - where devclass_name='LTOCLASS4' - and pct_utilized=60 - and pct_utilized70 - group by stgpool_name - order by stgpool_name Etc... You could maybe nest several of these selects inside another select, but that can be pretty cumbersome. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebschman, George J. Sent: Wednesday, July 29, 2009 10:59 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Summarizing Tape Utilization Greetings everyone, I have a/an SQL Select question. Most of my TSM Servers are at 5.5.1.0, one is at 5.5.2.0 I am trying to count the number of tapes with a percentage utilization in brackets of 10 percent. In other words, how many tapes with utilization between 100 and 90, 90 and 80, and so forth. I first tried: select count(volume_name), pct_utilized, stgpool_name from volumes - where (pct_utilized between 100 and 90) or (pct_utilized between 90 and 80) or (pct_utilized between 70 and 60) or (pct_utilized between 60 and 50) or (pct_utilized50)- group by stgpool_name, pct_utilized Although the statement functions and returns valid data, it is not what I expected. I mistakenly expected it to count all the tapes within each given range. What it really does is count tapes with distinct pct_util. I might as well not have specified the ranges. The only tapes it counted cumulatively were of the exact same pct_util. Unnamed[1] PCT_UTILIZED STGPOOL_NAME --- -- 1 59.4 C_TSMSERVER_TAPE 1 68.7 C_TSMSERVER_TAPE 1 78.2 C_TSMSERVER_TAPE 1 79.5 C_TSMSERVER_TAPE 1 99.9 C_TSMSERVER_TAPE 1100.0 C_TSMSERVER_TAPE 1 66.0 NASPOOL If I select for a count for greater than or less than a particular value, I get the kind of count I expect. I had expected between to do similar work but be less klunky. select count(volume_name) from volumes where pct_utilized100 and pct_utilized89 The other option I tried was CASE, WHEN, THEN: select count(case when pct_utilized between 100 and 91 then 1 else 0) from volumes and, select count(case when (pct_utilized between 100 and 91) then 1 else 0) from volumes Those failed for syntax errors. Is there a clean way to do this? George Huebschman IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Replacing tape drives (or there has to be a better way)
That is right, of course, you don't NEED to work with anything except the problem drive. The only reason we drop the whole library and re-define it is that it is easy once the script is written and you don't need to be concerned with what was changed. Everything will re-detect just fine if all is well with the hardware and drivers. The only caveat is that the library needs to be quiet, which will probably be an issue for busier shops. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tchuise, Bertaut Sent: Monday, July 13, 2009 8:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Zoltan, You don't need to delete and redefine all connections to the drive being replaced. All you need to do before a drive change is to make sure that the drive is not used and that you take the path to the drive offline. Once IBM replaces the drive (using the same S/N as the replaced drive), you should take the path to the drive back online - that's all I ever needed to do during our drive replacements - btw our drives are defined with the element=autodetect parameter. I hope all works out. BERTAUT TCHUISE Storage Support Administrator Legg Mason Technology Services *410-580-7032 btchu...@leggmason.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: Monday, July 13, 2009 9:13 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) So, are you saying that I always need to delete and redefine all connections to the drive being replaced? I have just tried this and will see if it works. From: Bob Levad ble...@winnebagoind.com To: ADSM-L@VM.MARIST.EDU Date: 07/10/2009 04:56 PM Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Zoltan, In playing with various DR scenarios and working through occasional hardware problems, I found it difficult to get all the right commands entered correctly and in the correct sequence and with the library/drives in the correct states so I created scripts that delete and re-define everything. If things are healthy as far as the hardware is concerned, they work flawlessly and everything gets redefined and if there is a problem, looking for the first failure usually tells me where the problem lies. Bob. /* define ltolib2 */ del_path: delete path tsmsrvb mt0.0.0.1 srctype=server desttype=drive library=ltolib2 etc... del_drive: delete drive ltolib2 mt0.0.0.1 Etc... drop_library_path: delete path tsmsrvb ltolib2 srctype=server desttype=library drop_library: delete library ltolib2 create_library: define library ltolib2 libtype=scsi create_library_path: define path tsmsrvb ltolib2 srctype=server desttype=library device=lb0.1.0.1 online=yes def_drive: define drive ltolib2 mt0.0.0.1 element=autodetect serial=autodetect online=yes Etc... def_path: define path tsmsrvb mt0.0.0.1 srctype=server desttype=drive library=ltolib2 device=mt0.0.0.1 online=yes Etc... Checkin_scratch: checkin libv ltolib2 search=yes checklabel=barcode status=scratchCheckin_scratch: Checkin_private: checkin libv ltolib2 search=yes checklabel=barcode status=private -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: Friday, July 10, 2009 1:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Well the consensus is to change the serial number of the replaced drive, which I did. However, since I had already rebooted the library owning server, to discover the new serial number, I rebooted it again and it seems to access the replaced drive, just fine. However (isn't there always a however or but), none of the library client servers can mount a tape on this drive!. They all fail with a Unable to open drive error. I have tried updating the paths to this drive, on the library manager server, telling it to autodetect, which it does just fine. Even tried deleting and redefining all the paths to the library client servers.nada.zip...all library client servers still fail trying to get to this drive. More thoughts on how to resolve this? Do I need to bounce each of the TSM servers (not the whole machine..just the server)? From: Costa, Justino justino.co...@logica.com To: ADSM-L@VM.MARIST.EDU Date: 07/09/2009 07:38 PM Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU There must be a reason why sandiscovery defaults to off on non-windows platforms. Anyway, I think you're right and that *should* be the correct behavior of SANDISCOVERY=ON. However, I prefer to stick with persistent binding and tight control on SAN changes. This way, I can at least
Re: SV: Desperation, DR, and four TS3100 libraries...
Wanda, We actually tried 2 TS3100s in a test recovery. It didn't go very well. If you attempt it. The Gresham product should be able to present 1 library image to TSM. I don't know at what cost. Without Gresham: Make sure your incremental DB backups are directed to disk or someplace other than the already overloaded libraries. If you have a few months to prepare, break the copypool down to several that will individually fit in a 3100 and give each copypool it's own devclass. Even though the devclass breakdown is not needed at the home site, it will allow you to re-design as needed in a recovery scenario. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wanda Prather Sent: Friday, July 10, 2009 10:31 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SV: Desperation, DR, and four TS3100 libraries... Thanks Christian, and everyone, for the suggestions. Even if I can convince TSM to work with the tapes spread across the 4 libraries, I think I still lose too much throughput. If I want to restore multiple clients/filespaces in parallel, I think we could easily get into the situation that client 1 is using the drive in library 1, and the restore for client 2 needs a tape that is also in library 1. The only way I can see to keep all 4 drives busy is to use them in manual mode. (Short of doing MOVE NODEDATA to guarantee that every client is on its own tape, which is highly unrealistic for a copy pool. Not that this scenario is realistic to begin with!) Thanks everyone! Wanda (maybe another margarita will bring more enlightenment..) On Fri, Jul 10, 2009 at 5:58 AM, Christian Svensson christian.svens...@cristie.se wrote: Hi Wanda, On my way to work this morning I have been thinking about your situation and I think I have an idea how you can get it to work. But only for restore not for backup... :) I haven't try this yet and probably don't have time to test it for you. But I think this will work. Define 4 SCSI Libraries Define 4 Drives. 1 to each Library Create 3 NEW Copypool Device Class that is pointing to Library 2,3 and 4 (CopyClass2, CopyClass3, CopyClass4) And Update one Device Class to point to the 1st Library. Now do a Audit of the library with Owner=YOUR TSM SERVER In this stage does TSM know that ALL Tape are available but in different libraries. Technically it should work. The database knows what tape TSM need and only change the data entry-path for the tape in the same way it does with the primary (1st) Library you have. This is still just an crazy idea like always that I normally have. Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Från: ADSM: Dist Stor Manager [ads...@vm.marist.edu] f#246;r Wanda Prather [wprat...@jasi.com] Skickat: den 10 juli 2009 03:33 Till: ADSM-L@VM.MARIST.EDU Ämne: Desperation, DR, and four TS3100 libraries... I'm drawing a blank here, any suggestions welcomed. I have a TSM customer who makes their copypool tapes using a TS3200 with LTO4 drives. The TS3200 is a rack-mounted, 2 drive, 40-mumble slot standard ASCII library. No issues. One copy pool, tapes vaulted and sent offsite. They want to go to a commercial DR vendor site and do a DR test next week. The commercial DR vendor, unbelievably, has no multi-drive LTO4-capable libraries. Instead, they want us to use 4 (count 'em, four) TS3100 libraries. The TS3100 is a rack-mounted, 1 drive, 20-mumble slot standard ASCII library. There's only 1 copy pool, so all tapes were created on the same device class. Ignoring the which-carts-would-go-in-which-library issue, I can't have a device class pointing to 4 libraries. And, the TS3100 is built in such a way that unlike a TS3500, you can't open the doors and access the drives for manual mounting. (I'd be happy to pull the covers off and try it, ignoring any warranties I might void, but I doubt the vendor will let me attack the thing with a screwdriver/wrench/hacksaw.) If I put all the carts in one TS3100 that will work, but that leaves me only 1 drive to restore all the clients, and they won't likely get done in the desired time window. The only thing I can think of to use all 4 drives, is to define those four TS3100's as 1 manual library with 4 manual drives, and use the front panel of each TS3100 to move tapes from the I/O slot to the drive when TSM requests a mount. (Actually the FIRST thing I thought of, was cancel the DR contract, this is nonsense. But my customer isn't convinced yet...) Anybody got a better solution? I've already tried a margarita, it didn't help W This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The
Re: Replacing tape drives (or there has to be a better way)
Zoltan, In playing with various DR scenarios and working through occasional hardware problems, I found it difficult to get all the right commands entered correctly and in the correct sequence and with the library/drives in the correct states so I created scripts that delete and re-define everything. If things are healthy as far as the hardware is concerned, they work flawlessly and everything gets redefined and if there is a problem, looking for the first failure usually tells me where the problem lies. Bob. /* define ltolib2 */ del_path: delete path tsmsrvb mt0.0.0.1 srctype=server desttype=drive library=ltolib2 etc... del_drive: delete drive ltolib2 mt0.0.0.1 Etc... drop_library_path: delete path tsmsrvb ltolib2 srctype=server desttype=library drop_library: delete library ltolib2 create_library: define library ltolib2 libtype=scsi create_library_path: define path tsmsrvb ltolib2 srctype=server desttype=library device=lb0.1.0.1 online=yes def_drive: define drive ltolib2 mt0.0.0.1 element=autodetect serial=autodetect online=yes Etc... def_path: define path tsmsrvb mt0.0.0.1 srctype=server desttype=drive library=ltolib2 device=mt0.0.0.1 online=yes Etc... Checkin_scratch: checkin libv ltolib2 search=yes checklabel=barcode status=scratchCheckin_scratch: Checkin_private: checkin libv ltolib2 search=yes checklabel=barcode status=private -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: Friday, July 10, 2009 1:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Well the consensus is to change the serial number of the replaced drive, which I did. However, since I had already rebooted the library owning server, to discover the new serial number, I rebooted it again and it seems to access the replaced drive, just fine. However (isn't there always a however or but), none of the library client servers can mount a tape on this drive!. They all fail with a Unable to open drive error. I have tried updating the paths to this drive, on the library manager server, telling it to autodetect, which it does just fine. Even tried deleting and redefining all the paths to the library client servers.nada.zip...all library client servers still fail trying to get to this drive. More thoughts on how to resolve this? Do I need to bounce each of the TSM servers (not the whole machine..just the server)? From: Costa, Justino justino.co...@logica.com To: ADSM-L@VM.MARIST.EDU Date: 07/09/2009 07:38 PM Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU There must be a reason why sandiscovery defaults to off on non-windows platforms. Anyway, I think you're right and that *should* be the correct behavior of SANDISCOVERY=ON. However, I prefer to stick with persistent binding and tight control on SAN changes. This way, I can at least avoid spending time on false positives like this one described here http://www-01.ibm.com/support/docview.wss?uid=swg1IC59807, even for the latest 5.5.x and 6.1.x versions. jmC -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wanda Prather Sent: quinta-feira, 9 de Julho de 2009 18:11 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Replacing tape drives (or there has to be a better way) I've been following this thread and have a question about AUTODETECT: I've seen this message: ANR8955I Drive drive name in library library name with serial number serial number is updated with the newly discovered serial number serial number . as a result of having the drives defined with AUTODETECT=YES and also SANDISCOVERY ON with the appropriate HBA library installed. Can anyone expand on why this does or doesn't always work when changing a drive serial #? Or does it only work when the device number changes? W Subject [ADSM-L] Replacing tape drives (or there has to be a better way) I need thoughts/suggestions/help on how to deal with SAN attached tape drive replacements when a library is shared amongst 5-servers. We just has a drive replaced, therefore giving us a new serial number (3494ATL - TS1130). All servers that use these drives/libraries are RedHat Linux and use very current lin_tape drivers. Currently, the method we use is to bounce each server so the system rescans the SAN and gets the new serial number. In the past, just stopping the TSM server and then restarting the lin_tape driver would often be enough. Now with the latest lin_tape drivers, I don't see the lin_taped daemon running any more. Yes, I have tried updating the paths on the library manager server and telling it to autodetect but that didn't help. There has to be a better way! If you have a similar configuration, how do you handle this scenario? This electronic transmission and any
Re: deleted tapes with discard data
Use caution when restoring the DB!! Any other changes since the DB Backup will be lost if you restore the database. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Anderson Douglas da Silva Sent: Wednesday, May 27, 2009 3:58 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] deleted tapes with discard data Rodney I think you'll need restore you last database backup. When you delete a volume from primary pool, automatically you lost the copy pool data too. --- Anderson Douglas da Silva -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rodney Luk Sent: quarta-feira, 27 de maio de 2009 17:15 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] deleted tapes with discard data Hi Forum, I am new to TSM. I had inherited TSM and the TSM admin had left the company. My co-worker accidentally deleted several tapes with discard the data. I knew I can issue the backup command to backup the data from the primary tape pool back to the copy tape pool. However, how do I recover the data on the primary tapes since I don't know which copy pool tapes need to recall from offsite. Thanks Rodney Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Percent complete
select DISTINCT (100.0*(Select count(*) from events where scheduled_start current_timestamp - 1 day)/(Select count(*) from events where status not like '%Completed%' and scheduled_start current_timestamp - 1 day)) AS Percent FROM events -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Ian Smith Sent: Friday, April 17, 2009 7:34 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Percent complete Hi I need a little reminder on how to do a calculation in a SQL statement: I want to divide: Select count(*) from events where scheduled_start current_timestamp - 1 day BY Select count(*) from events where status not like '%Completed%' and scheduled_start current_timestamp - 1 day THEN * 100 I have done this before by putting each statement in brackets but can't quite remember!!! Thanks Ian Dell Corporation Limited is registered in England and Wales. Company Registration Number: 2081369 Registered address: Dell House, The Boulevard, Cain Road, Bracknell, Berkshire, RG12 1LF, UK. Company details for other Dell UK entities can be found on www.dell.co.uk. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: volumes in a collocation group?
NOTES: These may run for a while. Watch for wrapped lines to fix. In the first query, watch for Number of Groups greater than 1 when the storage pool is supposed to be collocated by group. In the second query, you will see a line item for each group on each tape. All of our nodes belong to a group, even if there is only one node in it. * The following query will show: Pool name, Access, Volume name, # Groups, # Nodes, # FSpaces, % Util, % Recl select - cast(vu.stgpool_name as char(9)) as Pool, - (select access from volumes where volume_name=vu.volume_name) as Access, - cast(vu.volume_name as char(9)) as Volume, - cast(count(distinct nd.collocgroup_name) as decimal(4,0)) as Groups, - cast(count(distinct vu.node_name) as decimal(3,0)) as Nodes, - cast(count(distinct vu.filespace_name) as decimal(5,0)) as FSpaces, - (select pct_utilized from volumes where volume_name=vu.volume_name) as Util, - (select pct_reclaim from volumes where volume_name=vu.volume_name) as Recl - from - volumeusage vu, nodes nd - where - vu.node_name=nd.node_name - group by - vu.stgpool_name, vu.volume_name - order by - Groups desc, Nodes desc, FSpaces desc This query will show: Pool, Access, Volume name, Group name, # Nodes, # FSpaces, % Util, % Recl select - cast(vu.stgpool_name as char(9)) as Pool, - (select access from volumes where volume_name=vu.volume_name) as Access, - cast(vu.volume_name as char(9)) as Volume, - cast(nd.collocgroup_name as char(7)) as Groups, - cast(count(distinct vu.node_name) as decimal(3,0)) as Nodes, - cast(count(distinct vu.filespace_name) as decimal(5,0)) as FSpaces, - (select pct_utilized from volumes where volume_name=vu.volume_name) as Util, - (select pct_reclaim from volumes where volume_name=vu.volume_name) as Recl - from - volumeusage vu, nodes nd - where - vu.node_name=nd.node_name - group by - vu.stgpool_name, vu.volume_name, nd.collocgroup_name - order by - Access, Pool, Volume, Groups, Nodes desc, FSpaces desc *** Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, March 18, 2009 12:28 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group? Thanks Fred. That was mentioned previously, but it does not show if other servers not in the colloc group are stored on those volumes. Larry Clark (518) 712-5138 Home Office - Original Message - From: Fred Johanson f...@uchicago.edu To: ADSM-L@VM.MARIST.EDU Sent: Wednesday, March 18, 2009 12:34 PM Subject: Re: [ADSM-L] volumes in a collocation group? Q noded col=name-of-collocpool stg=name-of-stgpool Fred Johanson TSM Administrator University of Chicago 773-702-8464 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Botelho, Tiago (External) Sent: Wednesday, March 18, 2009 11:27 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group? Hi Larry, I thing that my TSM Server do not have this DB record (version 5.2) , but I will try to help you or give you some ideas. Try sommething similarlike this: select volume_name from volumeusage where stgpool_name='STORAGEPOOL' group by volume_name try to find where COLLOCG record are (maybe in nodedata table) See on TSM Server commnd line all the tables from db: h select select * from tables select * from columns ... Useful scripts can be made with TSm DB Best regards Tiago -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: sábado, 14 de Março de 2009 22:13 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] volumes in a collocation group? Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)? This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Can mixed incremental/selective backups be used to consolidate offsite data?
Adrian, We mostly use collocation by group for this issue, but we have upon occasion done as you suggest and have run a selective to consolidate a particular client's data. We have also renamed filespaces which forces a full incremental. When we do this, we include the date (as in \\mynode\c$_20090205) so we can look back after a couple of months and discard the old filespace. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Davis, Adrian Sent: Thursday, February 05, 2009 2:58 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Can mixed incremental/selective backups be used to consolidate offsite data? Richard, I'm mainly concerned about the Offsite volumes. We have a small library (IBM 3583) and a limited budget, so I was hoping for a simple work-around to this issue. Never mind - I guess we'll just have to live with it. Best Regards, =Adrian= -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: 04 February 2009 13:05 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Can mixed incremental/selective backups be used to consolidate offsite data? Adrian - The key word collocation does not appear in your question. That's the architectural solution to keeping related data together. Collocation is conventionally used for onsite volumes, but not for offsite volumes, given the substantial tape management complications that would occur with partially filled volumes: offsite volumes are usually not collocated, for that reason - but could be. Richard Sims DISCLAIMER This message is confidential and intended solely for the use of the individual or entity it is addressed to. If you have received it in error, please contact the sender and delete the e-mail. To see the full version of this disclaimer please visit the following address: http://www.lewisham.gov.uk/AboutThisSite/EmailDisclaimer.htm For advice and assistance about online security and protection from internet threats visit the Get Safe Online website at http://www.getsafeonline.org This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: How to figure collocation overhead
Don't forget collocation by group. All of our nodes belong to one group or another and we can then be pretty sure that collocation will do what we need. Mostly, our tape pools are collocated by group. Some nodes are in a group all by themselves and some (e.g. workstations) have many nodes in their group. We only use collocation by filespace if it is really needed for the largest nodes. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Sam Rawlins Sent: Thursday, January 15, 2009 2:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to figure collocation overhead Hi Bill, I like Wanda's point. MAXSCRatch is the best way to control tape usage. You can probably write a fun select to see how many nodes have data on the average tape. In Wanda's example, there are about 2 nodes per tape. If you see that that number gets too high, you can increase MAXSCRatch. On Thu, Jan 15, 2009 at 11:53 AM, Wanda Prather wanda.prat...@jasi.comwrote: Collocation consumes as much of the library as you tell it to. When you set MAXSCRATCH on a storage pool, TSM will confine the pool to that number of tapes. If you have less tapes available than you have clients, you get a do the best you can collocation. There are plenty of sites who have more clients than slots in their library. If you have 100 clients and set MAXSCRATCH for the pool to 50 tapes, TSM will put each client on a different tape until it hits 50, then it will double up. You still get a decent amount of collocation; it's a lot faster for a restore to skip over another clients data on the same tape, than it is to rewind, dismount, mount, and reposition to a different tape. What you have to remember if you are collocating, is that you have to check your pools periodically and reevaluate maxscratch for the pool. If your total amount of data is growing, you will need to up the maxscratch periodically so that you maintain enough available free tapes in the pool to provide a reasonable level of collocation. W On Thu, Jan 15, 2009 at 1:34 PM, Evans, Bill bev...@fhcrc.org wrote: Is there a guide or rule of thumb for determining what collocation will do to library space? It is being considered for improving restore speeds. I'm backing up 80TB in 30 volumes(filespaces) on a solaris server. Currently there is no collocation set, all data goes to a long-term management class, single onsite and off-site tape pools, data churn averages 1TB/night. Using a 650 slot L700 library, LTO3, TSM 5.5, AIX 5.3. The library is 80% full, so, I'm concerned that starting collocation for the volumes will consume the rest of the library. Each filespace collocation may end up with one tape not full (or 30 in this case). Thanks, Bill Evans Research Computing Support FRED HUTCHINSON CANCER RESEARCH CENTER -- Sam Rawlins This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: How to delete Volhistory...
I am not sure which parms are absolutely required, but this is the command I used to get rid of an old entry. DELETE VOLHISTORY type=backupset volume=D:\88894302.OST force=yes todate=today Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of KIRAN-SYSTEMS Sent: Friday, January 16, 2009 12:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to delete Volhistory... I am using the below command to delete volhis of a library client server from library manager server Del volhis vol=volume name force=yes -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Steven Harris Sent: Friday, January 16, 2009 11:24 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to delete Volhistory... We need detail Kiran, if we are to help. Please post the command you are using and the output when it doesn't work. also the output of a select * from volhistory where volume_name='XYZ000L3' - with your volume of interest substituted Thanks Steve Steven Harris TSM Administrator, Sydney Australia KIRAN-SYSTEMS ki...@dqentertai NMENT.COM To Sent by: ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager ads...@vm.marist Subject .EDU Re: [ADSM-L] How to delete Volhistory... 16/01/2009 04:12 PM Please respond to ADSM: Dist Stor Manager ads...@vm.marist .EDU The below command is not working for me.Iam using TSM Server 5.5.0 -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Robben Leaf Sent: Friday, January 09, 2009 1:02 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] How to delete Volhistory... Not entirely true. The product doesn't provide a DOCUMENTED way to do this. There are some undocumented parameters for the DELETE VOLHIST command. Specifically, you can add vol=VOLNAME force=yes to the command to remove the volume forcibly from the volhistory. We have found this command necessary when our library manager thinks another TSM server instance still owns a tape, when that instance has forgotten all about it. Robben Leaf From: Richard Sims r...@bu.edu To: ADSM-L@VM.MARIST.EDU Date: 01/08/2009 06:14 AM Subject: Re: [ADSM-L] How to delete Volhistory... Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU On Jan 8, 2009, at 12:27 AM, KIRAN-SYSTEMS wrote: Please let me know how to delete volume history of a particular Volume. The product does not provide a way to do this. Richard Sims U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - Disclaimer: This email message (including attachments if any) may contain privileged, proprietary, confidential information, which may be exempt from any kind of disclosure whatsoever and is intended solely for the use of addressee (s). If you are not the intended recipient, kindly inform us by return e-mail and also kindly disregard the contents of the e-mail, delete the original message and destroy any copies thereof immediately. You are notified that any dissemination, distribution or copying of this communication is strictly prohibited unless approved by the sender. DQ Entertainment (DQE) has taken every reasonable precaution to minimize the risk of transmission of computer viruses with this e-mail; DQE is not liable for any damage you may sustain as a result of any virus in this e-mail. DQE shall not be liable for the views expressed in the e-mail. DQE reserves the right to monitor and review the content of all messages sent to or from this e-mail address Disclaimer: This email message (including attachments if any) may contain privileged, proprietary, confidential information, which may be exempt from any kind of disclosure whatsoever and is intended solely for the use of addressee (s). If you are not the intended recipient, kindly inform us by return e-mail and also kindly disregard the contents of the e-mail,
Re: Question on automated data move for tapes not accessed for a certain time: conclusion
If you are only occasionally moving old volumes, you could just run a script that builds the command and manually paste it to the command line. select volume_name, date(last_write_date) as Oldest Volume from volumes where last_write_date=(select min(last_write_date) from volumes) select 'MOVE DATA ' as Run This Command, volume_name from volumes where last_write_date=(select min(last_write_date) from volumes) Output: VOLUME_NAMEOldest Volume -- - WG10122008-03-26 Run This Command VOLUME_NAME -- MOVE DATAWG1012 Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Bjørn Nachtwey Sent: Friday, January 09, 2009 2:35 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Question on automated data move for tapes not accessed for a certain time: conclusion dear all, thanks for your answers, so i think i'll only touch the 3590-tapes used for archive, because the tapes are 9 years old :-) David E Ehresman wrote: I have a simplistic korn shell script that does this that I could share with you if you are interested. David Ehresman sure, i'll compare it with mine and may improve it. thanks, Bjørn -- Dipl.-Ing. Bjørn Nachtwey Technische Universität Carolo-Wilhelmina zu Braunschweig Gauss-IT-Zentrum (GITZ) -- Abteilung Server Hans-Sommerstraße 56, 38106 Braunschweig Telephon: +49 (0)531 / 391 - 5535 TeleFax: +49 (0)531 / 391 - 5549 Mobil:+49 (0)163 / 639 4804 http://www.tu-braunschweig.de/it mailto: b.nacht...@tu-bs.de mailto: c0034...@tu-bs.de PGP-Schluessel: http://www-public.tu-bs.de:8080/~nachtwey/bjoern_nachtwey.asc PGP-Fingerprint: B472 526A A903 4AEB 9269 EC0B 9CDE 7465 CE87 This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Request for some TSM queries to use
Drop the not and it will work fine. You might want to order by node_name. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, January 07, 2009 5:57 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Request for some TSM queries to use How About this? Would it provide a list of volumes used by each node is a storage pool?: select distinct volume_name,node_name,stgpool_name from volumeusage where not stgpool_name='my_store_pool_name' This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: How to delete Volhistory...
Kiran, This worked for me for a backupset. I don't know if it will work for your particular case. The volume was a FILE type volume that no longer existed. DELETE VOLHISTORY type=backupset volume=D:\88894302.OST force=yes todate=today Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of KIRAN-SYSTEMS Sent: Wednesday, January 07, 2009 11:28 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] How to delete Volhistory... Hi, Please let me know how to delete volume history of a particular Volume. Regards, Kiran. Disclaimer: This email message (including attachments if any) may contain privileged, proprietary, confidential information, which may be exempt from any kind of disclosure whatsoever and is intended solely for the use of addressee (s). If you are not the intended recipient, kindly inform us by return e-mail and also kindly disregard the contents of the e-mail, delete the original message and destroy any copies thereof immediately. You are notified that any dissemination, distribution or copying of this communication is strictly prohibited unless approved by the sender. DQ Entertainment (DQE) has taken every reasonable precaution to minimize the risk of transmission of computer viruses with this e-mail; DQE is not liable for any damage you may sustain as a result of any virus in this e-mail. DQE shall not be liable for the views expressed in the e-mail. DQE reserves the right to monitor and review the content of all messages sent to or from this e-mail address This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Request for some TSM queries to use
Larry, Your query works fine if you switch the double quotes to single quotes. This query will tell you where every node resides. select distinct vu.stgpool_name, - vu.node_name, - vu.volume_name, - v.pct_utilized - from volumeusage vu, - volumes v - where v.volume_name=vu.volume_name - order by vu.stgpool_name, - vu.node_name, - v.pct_utilized As multiple nodes can and probably do exist on each tape, this can be a very long list unless further qualified. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Larry Clark Sent: Wednesday, January 07, 2009 3:16 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Request for some TSM queries to use Hi, My TSM query usage is a bit rusty. These days it's VIO builds but I need to participate in a customer DR exercise and will be restoring files to AIX servers by fs (mount point). To avoid resource conflicts I'd like to be able to determine what filespaces are on what volumes by node. Would this do it from the TSN command line? Since I normally do not have access to the TSM server I will not be able to test it until the DR exercise: SELECT VOLUMEUSAGE.NODE_NAME, VOLUMEUSAGE.COPY_TYPE, VOLUMEUSAGE.FILESPACE_NAME, VOLUMEUSAGE.STGPOOL_NAME, VOLUMEUSAGE.VOLUME_NAME FROM VOLUMEUSAGE WHERE (((VOLUMEUSAGE.NODE_NAME)=MY_NODE_NAME) AND ((VOLUMEUSAGE.STGPOOL_NAME)=MY_STG_POOL)); Also, does anyone have a query that would produce a list of what nodes occupy what volumes? We may have time to produce an overall usage list while the mksysbs are being restored prior to the restore of the mount points. Thank you This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Restore Testing stories
Our biggest restore failure was for a small windows domain controller. It was not replicated and we were slightly backleveled on the client. When the vmware disk became corrupted, we had to rebuild the client list as we were not able to correctly restore the active directory. The moral is to keep your TSM clients up to date and read the release notes on what the product will NOT do. Another good practice is to back things up in more than one way. Then, when your primary restore method fails, you will have another option. Don't forget to test! Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, December 15, 2008 8:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restore Testing stories Wow, good point, Andy: gotta have the same Service Pack level before trying a bare metal restore. But our whitepaper doesn't address that, because we don't (yet) help with full, bare-metal DR tests. We help with the 99% of systems you DON'T have time to do a DR test on, by random-sampling the backed-up files and restoring one or two of them. Glad you found it intriguing. I don't think anybody has ever tried to do this before. So I continue to ask for horror stories about restores that failed, and why. (Keep the customer anonymous, please - some stories could be embarassing!) Come on, folks: got more? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 12, 2008, at Dec 12, 5:53 PM, Huebner,Andy,FORT WORTH,IT wrote: The product looks intriguing. The paper did not address my biggest problem, restoring the Windows OS. Our issue is verifying the SP level of the server prior to restore. We have had very little success restoring the OS if the target OS is a different SP level than the backup. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lmorris99 Sent: Friday, December 12, 2008 3:17 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore Testing stories Would you be so kind as to share your stories about why restores fail, when they do? We are working on a way to prevent such failures. (Our whitepaper is at http://www.tsmworks.com/downloads/art-whitepaper.pdf , if you're curious.) Your real-world anecdotes are helpful! Stories like: * we found that the node had not been backed up in 3 months * the user's exclude list had excluded the file he needed * the tape volume TSM needed was missing / damaged / etc. are what we're looking for. Got some? Respond here, mail me, call me - all good. Thanks! --- Lindsay Morris Principal TSMworks, Inc. lind...@tsmworks.com 919-403-8260 + -- |This was sent by lindsay.mor...@tsmworks.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. + -- This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Restore Testing stories
I don't remember all of the details (it was in 2005). I think our client was probably 5.1.x or so and the domain controller was Windows 2003 Server. I believe the issue was that the tech upgraded from 2k to 2k3 and didn't update to a client with AD support. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, December 15, 2008 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restore Testing stories So, Bob, are you saying that your back-level TSM client failed to restore your Active Directory? Even though it backed it up OK? And was this a known problem with the TSM client? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 15, 2008, at Dec 15, 10:49 AM, Bob Levad wrote: Our biggest restore failure was for a small windows domain controller. It was not replicated and we were slightly backleveled on the client. When the vmware disk became corrupted, we had to rebuild the client list as we were not able to correctly restore the active directory. The moral is to keep your TSM clients up to date and read the release notes on what the product will NOT do. Another good practice is to back things up in more than one way. Then, when your primary restore method fails, you will have another option. Don't forget to test! Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, December 15, 2008 8:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restore Testing stories Wow, good point, Andy: gotta have the same Service Pack level before trying a bare metal restore. But our whitepaper doesn't address that, because we don't (yet) help with full, bare-metal DR tests. We help with the 99% of systems you DON'T have time to do a DR test on, by random-sampling the backed-up files and restoring one or two of them. Glad you found it intriguing. I don't think anybody has ever tried to do this before. So I continue to ask for horror stories about restores that failed, and why. (Keep the customer anonymous, please - some stories could be embarassing!) Come on, folks: got more? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 12, 2008, at Dec 12, 5:53 PM, Huebner,Andy,FORT WORTH,IT wrote: The product looks intriguing. The paper did not address my biggest problem, restoring the Windows OS. Our issue is verifying the SP level of the server prior to restore. We have had very little success restoring the OS if the target OS is a different SP level than the backup. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lmorris99 Sent: Friday, December 12, 2008 3:17 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore Testing stories Would you be so kind as to share your stories about why restores fail, when they do? We are working on a way to prevent such failures. (Our whitepaper is at http://www.tsmworks.com/downloads/art-whitepaper.pdf , if you're curious.) Your real-world anecdotes are helpful! Stories like: * we found that the node had not been backed up in 3 months * the user's exclude list had excluded the file he needed * the tape volume TSM needed was missing / damaged / etc. are what we're looking for. Got some? Respond here, mail me, call me - all good. Thanks! --- Lindsay Morris Principal TSMworks, Inc. lind...@tsmworks.com 919-403-8260 + - - |This was sent by lindsay.mor...@tsmworks.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. + - - This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited. This electronic transmission and any documents accompanying this electronic transmission contain confidential information
[no subject]
HI-MB.w i le! [EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED]A[EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED] X-ASG-Orig-Subj: RE: [ADSM-L] Question about group collocation Subject: RE: [ADSM-L] Question about group collocation Date: Tue, 25 Nov 2008 07:22:40 -0600 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350 Thread-Index: AclLCPutulWfoZefRTeCteX968Jr/wAC2v/rAPXuQQAABPCFgA== In-Reply-To: [EMAIL PROTECTED] X-Virus-Scanned: by amavisd-new on lnxsrvu at winnebagoind.com X-Copyrighted-Material: Please visit http://www.company.com/privacy.htm X-Barracuda-Connect: lnxsrvu.winnebagoind.com[69.66.77.165] X-Barracuda-Start-Time: 1227619391 X-Barracuda-Bayes: INNOCENT GLOBAL 0. 1. -2.0210 X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at marist.edu X-Barracuda-Spam-Score: -2.02 X-Barracuda-Spam-Status: No, SCORE=-2.02 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.1.9 Rule breakdown below pts rule name description -- -- That's how it works. All of our nodes belong to a group, even if there is only one node in the group. This makes it easy to catch a node added where the group assignment was missed. We also do some collocation local by filespace or node and offsite by group. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Minns, Farren - Chichester Sent: Tuesday, November 25, 2008 4:57 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Question about group collocation Hi all I currently have a tapepool collocated by node. I have created my first collocation group and added three client nodes to it. So, if I now update the tapepool to collocate by 'group', am I right in thinking it will still collocate all nodes NOT in the collocation group by node? Thanks Farren Minns This email (and any attachment) is confidential, may be legally privileged and is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient please do not disclose, copy or take any action in reliance on it. If you have received this message in error please tell us by reply and delete all copies on your system. Although this email has been scanned for viruses you should rely on your own virus check as the sender accepts no liability for any damage arising out of any bug or virus infection. Please note that email traffic data may be monitored and that emails may be viewed for security reasons. John Wiley Sons Limited is a private limited company registered in England with registered number 641132. Registered office address: The Atrium, Southern Gate, Chichester, West Sussex, PO19 8SQ. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
[no subject]
HI-MB.w i le! [EMAIL PROTECTED][EMAIL PROTECTED] D4B07980AD4F! [EMAIL PROTECTED] X-ASG-Orig-Subj: RE: [ADSM-L] Collocation question Subject: RE: [ADSM-L] Collocation question Date: Fri, 21 Nov 2008 08:33:30 -0600 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: [EMAIL PROTECTED] X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350 Thread-Index: AclL2OtUeB88DCAQT0Gxau3IffSyKwACVIoA X-Virus-Scanned: by amavisd-new on lnxsrvu at winnebagoind.com X-Copyrighted-Material: Please visit http://www.company.com/privacy.htm X-Barracuda-Connect: lnxsrvu.winnebagoind.com[69.66.77.165] X-Barracuda-Start-Time: 1227278040 X-Barracuda-Bayes: INNOCENT GLOBAL 0.0035 1. -1.9983 X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at marist.edu X-Barracuda-Spam-Score: -2.00 X-Barracuda-Spam-Status: No, SCORE=-2.00 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=5.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.1.10780 Rule breakdown below pts rule name description -- -- We do collocation by groups, nodes, filespaces, or none depending on the storage pool. Here is our query to see if we've got any volumes that are out of spec as far as our collocation strategy is concerned. select - cast(vu.stgpool_name as char(9)) as Pool, - (select access from volumes where volume_name=vu.volume_name) as Access, - cast(vu.volume_name as char(9)) as Volume, - cast(count(distinct nd.collocgroup_name) as decimal(4,0)) as Groups, - cast(count(distinct vu.node_name) as decimal(3,0)) as Nodes, - cast(count(distinct vu.filespace_name) as decimal(5,0)) as FSpaces, - (select pct_utilized from volumes where volume_name=vu.volume_name) as Util, - (select pct_reclaim from volumes where volume_name=vu.volume_name) as Recl - from - volumeusage vu, nodes nd - where - vu.node_name=nd.node_name - group by - vu.stgpool_name, vu.volume_name - order by - Groups desc, Nodes desc, FSpaces desc In this query, we should see a 1 in the column corresponding to the collocation type for a storage pool. For example, the 2 in the groups column for tcopy2b shows me that this volume has information from 2 groups. This should be remedied for fastest recovery in a DR situation. TARCH1 is not collocated, so WG1016 is fine with 4 groups and 5 nodes. TPOOL2 is collocated by node, so the 3rd volume is fine, since it shows just 1 node on the volume. TCOPY3B has directory information on it and is collocated none, so it also is fine with 131 filespaces and 84 nodes. Pool Access Volume Groups Nodes FSpacesUtil Recl - -- - -- - --- -- -- TCOPY2BOFFSITE WG1095 2 6885.4 14.6 TARCH1 READWRITE WG1016 4 5697.1 2.8 TPOOL2 READWRITE WG1002 1 15 0.6 0.0 TCOPY3BREADWRITE WG1062 6 84 131 1.4 0.0 Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Friday, November 21, 2008 6:58 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Collocation question -- -- On Nov 21, 2008, at 6:20 AM, Minns, Farren - Chichester wrote: Hi all Quick question. Am I right in thinking that if I have collocation set for a primary storage pool and I run out of scratch volumes that TSM will just try to put data on any other volumes with free space? The Administration Guide manual is must-reading for understanding how the product works. See How the Server Selects Volumes with Collocation Enabled therein for the rules table. Richard Sims This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Offsite reclamation problem
Robert, As far as letting IBM handle the spare, that depends on how many hours you are from the depot. The odd drive (preferably in the local library if you have a remote also) will still get used a lot, whenever a job needs a tape, the mount can proceed and you may not have to wait for the dismount of the previous tape. Also, it will be used for DataBase backups, restores and other ad-hoc jobs. But you are right, YMMV. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Clark, Robert A Sent: Wednesday, November 05, 2008 4:11 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Offsite reclamation problem That works if the primary and copy tape pools are in the same library. With people using multiple logical libraries (with encrypted tape drives for the offsite pool) it isn't necessarily an easy win. I'd rather have IBM keep a spare at the depot, instead of paying ongoing maintenance on one more drive. YMMV. [RC] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bob Levad (641-585-6770) Sent: Tuesday, November 04, 2008 10:28 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Offsite reclamation problem I've always liked running with an odd number of tape drives to make it more difficult to busy them all at once. Plus you have a spare for when one is ACTUALLY down. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of lindsay morris Sent: Tuesday, November 04, 2008 11:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Offsite reclamation problem Lots of people have a best-practice of always keeping at least one drive free for user restores. That minimizes the problem. It makes users happy too, because even though a restore does pre-empt another task, it may take TSM 40 minutes to finish the reclamation it was working on and give up the drive. So the user has to sit waiting for far too long (in some cases). -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Nov 4, 2008, at Nov 4, 12:21 PM, Bos, Karel wrote: No :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: dinsdag 4 november 2008 18:14 To: ADSM-L@VM.MARIST.EDU Subject: Offsite reclamation problem We have a 5.4.2.0 TSM server running under mainframe Linux. We have five tape drives available for our primary tape storage pool and five tape drives available for our copy storage pool. We run offsite tape reclaimation with 'maxproc=5'. If a client runs a restore while off reclamation is going on, TSM will take a tape drive away from reclamation. This is done by cancelling a reclamation process, rather than having a process go into mount point wait. TSM does not start a replacement process when this happens. A restore that runs for a couple of minutes can leave a pair of tape drives sitting idle for hours. Is there any configuration setting or release level upgrade that will cause TSM to handle this situation more intelligently? disclaimer.txt This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited. DISCLAIMER: This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Offsite reclamation problem
I've always liked running with an odd number of tape drives to make it more difficult to busy them all at once. Plus you have a spare for when one is ACTUALLY down. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of lindsay morris Sent: Tuesday, November 04, 2008 11:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Offsite reclamation problem Lots of people have a best-practice of always keeping at least one drive free for user restores. That minimizes the problem. It makes users happy too, because even though a restore does pre-empt another task, it may take TSM 40 minutes to finish the reclamation it was working on and give up the drive. So the user has to sit waiting for far too long (in some cases). -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Nov 4, 2008, at Nov 4, 12:21 PM, Bos, Karel wrote: No :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: dinsdag 4 november 2008 18:14 To: ADSM-L@VM.MARIST.EDU Subject: Offsite reclamation problem We have a 5.4.2.0 TSM server running under mainframe Linux. We have five tape drives available for our primary tape storage pool and five tape drives available for our copy storage pool. We run offsite tape reclaimation with 'maxproc=5'. If a client runs a restore while off reclamation is going on, TSM will take a tape drive away from reclamation. This is done by cancelling a reclamation process, rather than having a process go into mount point wait. TSM does not start a replacement process when this happens. A restore that runs for a couple of minutes can leave a pair of tape drives sitting idle for hours. Is there any configuration setting or release level upgrade that will cause TSM to handle this situation more intelligently? disclaimer.txt This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Reclamation
James, This may not address your specific need, but here is how we handle reclaims. We are running reclamations about 12 to 20 hours a day. We check every 15 minutes to see if a any other job is accessing a each storage pool, then check if an admin schedule called STOP_PROCESSING (which does nothing) is ACTIVE. If this is ACTIVE (set automatically at certain times or manually by us) the reclaim script just exits. Otherwise, storage pools needing reclamation and not currently busy have a reclaim started. Reclamations are all set to run for a duration of 115 minutes. If the STOP_PROCESSING flag is set, the next reclaim window will just exit and other processing occurs. Most of the time it is set to NO, so the reclamation starts again and has a good chance of needing the same tapes that are possibly still mounted (MOUNT RETENTION is set to 10 minutes). Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lepre, James Sent: Monday, October 27, 2008 10:54 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Reclamation Hello Everyone, Has anyone written a script to stop reclamation at a certain point or know of a way to stop it instantly without canceling the process manually from the command line. I know you can use the duration parameter; however this stops the reclamation after it is done with the current volume. I am looking to control the process more because of other VTL processes need more precedent. I am currently running TSM v 5.5.1 on a windows 2003 server. Any help is always appreciated Thank you James Lepre Senior Server Specialist Solix, Inc. 100 S. Jefferson Road Whippany, NJ 07981 Phone: 973-581-5362 Cell: 973-223-1921 --- Confidentiality Notice: The information in this e-mail and any attachments thereto is intended for the named recipient(s) only. This e-mail, including any attachments, may contain information that is privileged and confidential and subject to legal restrictions and penalties regarding its unauthorized disclosure or other use. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action or inaction in reliance on the contents of this e-mail and any of its attachments is STRICTLY PROHIBITED. If you have received this e-mail in error, please immediately notify the sender via return e-mail; delete this e-mail and all attachments from your e-mail system and your computer system and network; and destroy any paper copies you may have in your possession. Thank you for your cooperation. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Incorrect volume being mounted for reclamation
checkout libv ltolib2 100562 checklabel=no remove=bulk -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Thursday, September 04, 2008 7:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Incorrect volume being mounted for reclamation Thanks Howard and Kelly!. Before I try the Audit Library is there any other option that I could try? Are there any command (s) to specifically check the label of volume 100562 and if it is incorrect then correct that tape with a command? Thanks again I appreciate your responses! Tim Howard Coles wrote: Thanks Kelly, Not sure about anyone else's Outlook client but mine thoroughly hosed up those three commands to look like: audit library libname checklabel=barcode checkin libvol libname search=yes checklabel=barcode status=scratch checkin libvol libname search=yes checklabel=barcode status=private So here they are spread out: audit library libname checklabel=barcode checkin libvol libname search=yes checklabel=barcode status=scratch checkin libvol libname search=yes checklabel=barcode status=private See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Lipp Sent: Wednesday, September 03, 2008 4:00 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Incorrect volume being mounted for reclamation Howard is right on. I'd add a couple more commands to his audit to synchronize the library completely: Tsm audit library libname checklabel=barcode checkin libvol libname Tsm search=yes checklabel=barcode status=scratch Tsm checkin libvol libname search=yes checklabel=barcode status=private These three command will ensure that your library inventory is accurate and that all tapes in the library are checked in properly. The audit library command will check tapes out that are not found. For instance, if TSM thinks that tape 100087 is in the library, but the audit determines that it isn't, it will be removed from the TSM library inventory. However, if the audit finds tape 100088 that TSM doesn't think is in the library, it won't automatically check it in. The two checkin libvol commands fix that up as well. Note the order: you want to do the scratch tapes first. Thanks, Kelly Lipp CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Howard Coles Sent: Wednesday, September 03, 2008 2:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Incorrect volume being mounted for reclaimation Stop all processes, unmount all tapes and audit the library. It looks like TSM thinks tape 100562 is in the slot currently occupied by 100617 instead. Either the paths are wrong for the drives, (which I doubt) or the library's inventory is a little off. To verify, do a q libv, determine which slot TSM thinks the tape is in, and then open up your library and see if they match. You may have to actually take the tape out, and then back in again. I would try the audit first, then check TSM's list-o-tapes. IF the tape your needing doesn't show up there may be other problems. Such as tape stuck in picker, not in library at all (mistakenly sent offsite), etc. See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Hughes Sent: Wednesday, September 03, 2008 3:48 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Incorrect volume being mounted for reclaimation Hello all, I'm reaching at for any help on this. We have a tape that needs to be reclaimed but it keeps being set to unavailable during reclamation. When I update the tape by doing the following using the GUI ANR2017I Administrator x issued command: UPDATE VOLUME 100562 ACCESS=READWRITE WHERESTGPOOL=LTOPOOL WHEREDEVCLASS=LTOCLASS (SESSION: 138535) It changes back to available, however as soon as reclamation calls for the tape it changes back to unavailable The TSM Server log with messages are below can anyone give me suggestions/help on the best way to correct the issue? Thanks for any help in advance! ANR2017I Administrator x issued command: UPDATE VOLUME 100562 ACCESS=READWRITE WHERESTGPOOL=LTOPOOL WHEREDEVCLASS=LTOCLASS (SESSION: 138535) 09/03/08 07:37:40 ANR2207I Volume 100562 updated. (SESSION: 138535) 09/03/08 09:00:00 ANR1044I Removable volume 100562 is required for space reclamation. (PROCESS: 946) 09/03/08 09:00:36 ANR8356E Incorrect volume 100617 was mounted instead of volume 100562 in library LTO_LIB. (PROCESS: 947) 09/03/08 09:01:01 ANR8381E LTO volume 100562 could not be mounted in drive RMT3 (/dev/rmt3). (PROCESS: 947) 09/03/08
Re: select and script
It's a big hammer, but this is the only thing I've found for this type of thing. It could be made into a separate macro and a series of calls could be made for each percentage level to test. /* Display message for DB utilization */ 90: select pct_utilized from db where pct_utilized 90 if (rc_notfound) goto 80 issue message I REMCO001 datbase for server is 90 percent full goto exit 80: select pct_utilized from db where pct_utilized 80 if (rc_notfound) goto 70 issue message I REMCO001 datbase for server is 80 percent full goto exit 70: select pct_utilized from db where pct_utilized 70 if (rc_notfound) goto ok issue message I REMCO001 datbase for server is 70 percent full goto exit ok: issue message I REMCO001 datbase for server is less than 70 percent full exit: Exit Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Tuesday, August 26, 2008 11:18 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select and script On Aug 26, 2008, at 17:17 , Kauffman, Tom wrote: It would be nice -- maybe after the DB2 conversion we'll get a genuine TSM server-side command language and scripting facility. Until then I do a lot of admin work from the outside with a mix of perl and shell scripts. Unfortunately, for most TSM admins it's much easier to distribute a server script to all TSM servers than to run a set of scripts against all server instances on all servers (or even get the scripts there and be able run them in cron). As for TSM 6.1, I'd expect nothing more than current 5.5 functionality WRT the scripting engine. TK -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Tuesday, August 26, 2008 11:14 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: select and script On 26 aug 2008, at 17:04, Kauffman, Tom wrote: You mean something like this? Yes, something like that, but entirely within TSM, so a real TSM server script ;-) #!/bin/sh DBUTIL=`dsm_cmd.pl select pct_utilized from db | tail -2` echo Database is $DBUTIL% full\n exit 0 columbia:-:/home/kauffmant ./dbutil.sh Database is 67.0% full Just a two-minute hack, could use a bit of cleanup. Dsm_cmd.pl is part off the adsm.pm perl interface to adsm found here: http://www.io.com/~ocrow/ADSM/Adsm.html Tom Kauffman -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Remco Post Sent: Tuesday, August 26, 2008 9:45 AM To: ADSM-L@VM.MARIST.EDU Subject: select and script Hi all, I'm convinced that it should be possible in TSM to do something like the following in a TSM server script: select into %1 pct_utilized from db issue message I REMCO001 datbase for server is %1 percent full But I can't anything anywhere on the web or the TSM manuals to point me in the right direction. Am I mistaking, can't this be done? Or am I not looking in the right places? -- Met vriendelijke groeten/Kind regards, Remco Post, PLCS +31624821622 -- Met vriendelijke groeten/Kind regards, Remco Post, PLCS +31624821622 -- Met vriendelijke groeten, Remco Post [EMAIL PROTECTED] This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: TSM Administrative Tasks
Analyse collocation status of onsite and offsite media in anticipation of their need. If you have nodes with data scattered on too many offsite tapes, it will greatly impact your ability to recover your environment in a timely manner. Review, test, and document your recovery plan. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Schneider, Jim Sent: Friday, August 22, 2008 11:00 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Administrative Tasks Monitoring space in VTL pools. Consolidating data on 'filling' tapes to prevent automigration of data, and inaccessibility of VTL pool during the automigration. Jim Schneider -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Curtis Preston Sent: Thursday, August 21, 2008 5:14 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM Administrative Tasks It's taking me forever, but I'm still developing the outline for my latest book. I have a question for you about managing a TSM system. What are the things you find yourself doing on a regular basis and how do you do them? Let me give you a few examples. 1. Monitoring backup success/failure. a. CLI b. TSM web interface c. third party product 2. Rerunning failed/missed backups 3. Putting tapes in a tape library, making them ready to use 4. Getting tapes offsite a. I send originals and don't make copies b. I send copies and make them via scripting c. I tell TSM how many copies and it manages everything 5. Expiration a. Run it every day/once a week, etc 6. Reclamation a. I set my threshold and forget it b. I set my threshold to 100% during backups, then back to my desired threshold after backups are done c. I set my threshold to 100% during backups, then gradually increase decrease my reclamation threshold 7. Make backup sets/instant archives a. If you use them, what do you use them for? 8. Active data pool 9. Monitoring for capacity/throughput issues a. Splitting/migrating part of a TSM instance to another instance 10. Installing new clients I'm not taking a survey of the different methods, here. I don't need to know how many people are doing what -- I'm just trying to make sure my list of administrative tasks is complete. Thanks in advance for any help. Curtis Preston | VP Data Protection GlassHouse Technologies, Inc. T: +1 760 710 2004 | C: +1 760 419 5838 | F: +1 760 710 2009 [EMAIL PROTECTED] | www.glasshouse.com http://www.glasshouse.com/ Infrastructure :: Optimized This email 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 email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: backing up mapped drives
A note of caution. Windows has a way of disconnecting your mapped drives when they haven't been accessed for a bit. Most programs will force a reconnect, but I've seen on some systems where the TSM backup expired all the files in an entire filesystem it couldn't access. You may want to run an automated check to be sure the filesystem is available before starting an incremental. If it drops during a backup, I think you are OK and the process will error out without expiring any files. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thorneycroft, Doug Sent: Friday, July 25, 2008 3:03 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] backing up mapped drives The unc should work, and it does show up with the local drives. You might need to tweak the permissions on the account that the scheduler is running under. A local account probably won't have access across the network -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gill, Geoffrey L. Sent: Friday, July 25, 2008 12:56 PM To: ADSM-L@VM.MARIST.EDU Subject: backing up mapped drives I was wondering if someone who might be backing up mapped drives on a particular server could weigh in on this please. We have a server, and I have not seen the setup because I have no access at this point, that I am told has mapped drives from a netapp. They want this drive backed up with TSM and I am looking to find the proper way to do this. Are either of these acceptable and if so when looking to restore data do these drives show up in the 'local' tree? DOMAIN ALL-LOCAL F: DOMAIN ALL-LOCAL \\host\d$ Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 (office) (858)412-9883 (blackberry) Email: [EMAIL PROTECTED] This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Decommissioned Servers
We attach the date (as in \\nodename\c$\_20080523) to our old filespaces and set a tickler for deleting them. We will also occasionally rename a filespace to force a full backup if a filespace is becoming too scattered on the offsite media. We set the tickler a little past when the last inactive file would have dropped from the renamed filespace, so we don't violate our retention policies. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Skylar Thompson Sent: Friday, May 23, 2008 9:31 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Decommissioned Servers Richard Rhodes wrote: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 05/22/2008 12:36:11 PM: 3) We put the clients name into a tracking file with the decommission date, so we don't forget when 90 days is up. We rename the node with a prefix so decommissioned nodes are easy to spot in a q node listing. We would rename nodeX to zzrt_nodeX. We also put a comment in the CONTACT node field with the date the node can be deleted from TSM, and the ticket number of the request that asked us to retire the node. Once a month someone goes through the TSM servers looking at the retired nodes and deletes appropriate ones. We do something similar with filespaces. We often are migrating to new storage and have both new and old filesystems setup and backed up. When we decommission the old storage, we'll append _old to the filespace. We then have blanket tolerances in our monitoring system for anything that ends in _old, so we don't get alerts when it's no longer being backed up. -- -- Skylar Thompson ([EMAIL PROTECTED]) -- Genome Sciences Department, System Administrator -- Foege Building S048, (206)-685-7354 -- University of Washington School of Medicine This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: working with 2 libraries
I've not tested the product, but Gresham Storage (www.gresham-storage.com) sells something called Clareti Backup Virtualization which is supposed to offer the look and feel of single large virtual library with multiple smaller physical libraries on the backend. I've also considered (but not implemented) a 1 devclass/1 stgpool model so if a pool grows large, it can be easily moved, or if the DR site has multiple libraries that are too small for all the offsite volumes, they could be distributed. I'm not sure if the 1 class/1 library is so deeply imbeded in the code that it can't be changed, but I'd vote for having the capability. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mario Behring Sent: Thursday, May 01, 2008 2:13 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] working with 2 libraries Hi list, I have two automated libraries (LIBLTO1: 3580 L18 / 3 drives and LIBLTO2: 3582 L23 / 2 drives) connected to the TSM Server. LIBLTO2 has just been connected. At this point, there are 5 STG POOLS pointing to the devclass that corresponds to LIBLTO1. I have some questions: 1- Is there any way to configure TSM to see both libraries as one? 2- If not, can I change a existing stg pool and point it to the new devclass? I checked the update command and there is no such option.or should I simply create new stg pools and point them to the new devclass? Any help is appreciated. Mario Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: HELP!! TIPS on freeing up library slots
I've scheduled this script to run every day to keep an eye on our volumes. I don't look at all of it every day, but if there is a problem, I can usually find the cause in the output. NOTE: YMMV and PLEASE test the sections in your environment to see how much cpu and time the queries may take. Bob. ** /* total volumes in the library */ select count(*) as Total volumes in the LTO Library from libvolumes /* total scratch */ select count(*) as Scratch volumes in the LTO Libraryfrom libvolumes where status='Scratch' /* newest scratch */ select max(volume_name) as Newest Volume from volhistory /* Total DR Media volumes */ select COUNT(*) as DRMedia Volumes from drmedia /* Total onsite volumes */ select COUNT(*) as Media Volumes from media /* Writable volumes - watch for too few writable in a collocated pool */ select stg.collocate as Collocated, - vol.stgpool_name as Storage Pool,- count(*) as Writable Vols - from stgpools stg, volumes vol - where stg.stgpool_name=vol.stgpool_name and - vol.devclass_name='LTOCLASS1' and - (vol.status='EMPTY' or vol.STATUS='FILLING') and - vol.access'OFFSITE' - group by stg.collocate, - vol.stgpool_name /* Allocated and available Scratch pools - watch for 0 vols scratch */ select stgpools.stgpool_name, - stgpools.maxscratch, - count(stgpools.maxscratch) as allocated_scratch, - stgpools.maxscratch-count(stgpools.maxscratch) as remaining_scratch - from stgpools,volumes - where (volumes.stgpool_name=stgpools.stgpool_name) and - ((stgpools.devclass='LTOCLASS1')) - group by stgpools.stgpool_name, - stgpools.maxscratch /* Find LRU volumes in the library */ select libv.volume_name, - vol.stgpool_name, - vol.status, - date(current_timestamp)-date(vol.last_read_date) as Read, - date(current_timestamp)-date(vol.last_write_date) as Written - from libvolumes libv, - volumes vol - where libv.volume_name=vol.volume_name - order by Read desc, - Written desc /* find offline drives */ q drive /* find offline paths */ q path /* show Cleaners, Scratch, DB vols, and improperly checked in volumes */ select volume_name, - status, - last_use, - home_element - from libvolumes - where volume_name not in (select volume_name from volumes) /* Show details of library volumes - old, full volumes are eject candidates */ /* old, full volumes are eject candidates */ /* small, volumes w/o recent write are move data candidates */ select lib.volume_name as Vol Name, - vol.stgpool_name as Stg Pool, - vol.status, - vol.pct_utilized as Util, - date(vol.last_write_date) as Last Write - from volumes vol, - libvolumes lib - where lib.volume_name=vol.volume_name - order by Last Write, - vol.status, - vol.pct_utilized /* filling volumes */ /* look for small tapes that haven't been recently written for move candidates */ select vol.stgpool_name as Stg Pool, - vol.volume_name as Vol Name, - vol.pct_utilized as Util, - date(vol.last_write_date) as Last Write, - vol.location - from volumes vol - where devclass_name='LTOCLASS1' and - status='FILLING' - order by vol.stgpool_name, - vol.pct_utilized /* query number of volumes a node occupies - large numbers = painful restores */ /* these are candidates for a full backup */ select distinct stgpool_name, node_name, - count(distinct volume_name) as Volumes - from volumeusage - group by stgpool_name, - node_name - order by stgpool_name, - Volumes desc /* query number of volumes a filespace occupies - large numbers = painful restores */ select distinct stgpool_name, node_name, filespace_name, - count(distinct volume_name) as Volumes - from volumeusage group by stgpool_name, - node_name, filespace_name - order by stgpool_name, node_name, - filespace_name /* volume inventory section - lists all known volumes and location for tape vault reconciliation */ /* list all scratch volumes */ select distinct volume_name, - max(date(date_time)) as Date Scratched - from volhistory - where type='STGDELETE' and - devclass='LTOCLASS1' and - volume_name not in(select volume_name from volumes) and - volume_name not in(select volume_name from drmedia) - group by volume_name - order by volume_name /* list all database backups */ select volume_name, - location, - voltype, - state - from drmedia - where voltype'CopyStgPool' - order by location, - volume_name /* list all TSM volumes */ select volume_name, - location, - status, - access - from volumes
Re: Backing up unavailable file systems causes objects to become inactive.
Thanks, we did some checking as to TSM's behavior if a file system drops during a backup. It correctly sees that files that should exist no longer do and puts up an error. We were concerned that our window of vulnerability might extend past the running of the preschedulecmd. Again, thanks for pointing us in the right direction. I'd still like to see an option that would force a prompt if a TSM process felt the need to expire all files in a file system. Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Robert Clark Sent: Friday, September 21, 2007 11:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Backing up unavailable file systems causes objects to become inactive. Write a script in your language of choice that compares the mount list with a list of crucial filesystems like /etc/ filesystems_crucial_to_backup Launch this script from the preschedulecmd, and if it returns a non- zero code, the backup won't run. For extra surety, you can look for files that should always be found on a mounted filesystem, or look for files you've written to the underlying mount point that you hope you never see. [RC] On Sep 21, 2007, at 2:22 PM, Bob Levad wrote: Greetings, I know this is working as designed, but I was hoping someone might have a work-a-round. Several times over the last 10 or so years, we have had file systems on servers cause problems and become unavailable, either through inadvertent dismounts or hardware issues. If we don't catch this quickly, TSM's behavior in these cases leaves something to be desired. TSM will assume that we have thrown away our data and will happily inactivate all of it's backed up objects. When we discover the problem, we are faced with backing up the data again (unless it was a true disk failure) and even if it is a recovery scenario, we need to do a point in time restore, as all active data has been inactivated (also followed by another complete backup). What I'm looking for is ideas as to what I could do to automatically cancel any active backup job if a file system becomes unavailable for whatever reason. Perhaps in some future version of TSM, a flag could be added for each domain statement to fail the backup and keep the previously stored data unless something explicit was entered to confirm the intent to expire. Thanks for listening...Any thoughts? Bob Levad Winnebago Industries, Inc. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Backing up unavailable file systems causes objects to become inactive.
Greetings, I know this is working as designed, but I was hoping someone might have a work-a-round. Several times over the last 10 or so years, we have had file systems on servers cause problems and become unavailable, either through inadvertent dismounts or hardware issues. If we don't catch this quickly, TSM's behavior in these cases leaves something to be desired. TSM will assume that we have thrown away our data and will happily inactivate all of it's backed up objects. When we discover the problem, we are faced with backing up the data again (unless it was a true disk failure) and even if it is a recovery scenario, we need to do a point in time restore, as all active data has been inactivated (also followed by another complete backup). What I'm looking for is ideas as to what I could do to automatically cancel any active backup job if a file system becomes unavailable for whatever reason. Perhaps in some future version of TSM, a flag could be added for each domain statement to fail the backup and keep the previously stored data unless something explicit was entered to confirm the intent to expire. Thanks for listening...Any thoughts? Bob Levad Winnebago Industries, Inc. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Media Fault
ANR8302E I/O error on drive DRIVE2 (mt2.0.0.5) (OP=LOCATE, Error Number=23, CC=0, KEY=03, ASC=14, ASCQ=00, ... Every week, a different tape is reporting error. ... Tape drives are fine since the same tape reports error on different drives. (*chuckle*) Well, it could mean that all your drives are consistently problematic. Refer to last week's postings about tape drive cleaning - the root of so many tape I/O problems. Dirty tape drives proficiently spread the gunk throughout your tape complement and to other drives. Remember also that libraries are not hermetically sealed units - and computer rooms are far from being Clean Rooms. If your library is in a dusty or high-traffic area, consider putting a portable air cleaner alongside it. Richard Sims, BU There is a new firmware level for that drive. I have not gotten that error message since it was applied (about 6/18). Bob Levad
