Re: SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP

2009-09-17 Thread Conway, Timothy
by being separate groups. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of stg admin Sent: Thursday, September 17, 2009 2:00 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP Does anyone have a script t

Re: SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP

2009-09-17 Thread Wolfgang J Moeller
> Does anyone have a script that will show the volumes associated with a > collocation group? select distinct vv.volume_name from nodes nn, volumeusage vv - where nn.collocgroup_name=upper('$1') and vv.node_name=nn.node_name You DON'T want to use the "collocgroup" table. Wolfgang J. Moe

SELECT FOR DISTINCT VOLUMES IN A COLLOCATION GROUP

2009-09-17 Thread stg admin
Does anyone have a script that will show the volumes associated with a collocation group? I'm trying to run this but receive an error; select distinct vu.volume_name, cg.collocgroup_name from volumeusage vu, collocgroup cg where vu.node_name=cg.node_name and vu.stgpool_name='DRMC' group by cg.col

Re: volumes in a collocation group?stg

2009-03-19 Thread Alex Paschal
day, March 15, 2009 11:47 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group?stg Hi Alex, Yes, this is related to improving restore times in a DR senario...so these are offsitevols from a copypool. Larry Clark (518) 712-5138 Home Office - Original Message

Re: volumes in a collocation group?stg

2009-03-19 Thread Alex Paschal
ch 15, 2009 11:42 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group?stg On Mar 15, 2009, at 1:37 PM, Alex Paschal wrote: > Nick, if you really want to mix data on tapes (I have no idea why you > would want to, but the beautiful thing about TSM is you ca

Re: volumes in a collocation group?

2009-03-18 Thread Bob Levad
"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: [AD

Re: volumes in a collocation group?

2009-03-18 Thread Larry Clark
e: [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 (Exter

Re: volumes in a collocation group?

2009-03-18 Thread Fred Johanson
-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

Re: volumes in a collocation group?

2009-03-18 Thread Botelho, Tiago (External)
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)?

Re: volumes in a collocation group?stg

2009-03-17 Thread Larry Clark
Tuesday, March 17, 2009 3:04 PM Subject: Re: [ADSM-L] volumes in a collocation group?stg Ok, we've never collocated our copy pools because I was under the impression that TSM consolidates each node to a small subset of tapes which in turn makes restores very fast/less mounts blah blah bla

Re: volumes in a collocation group?stg

2009-03-17 Thread Park, Rod
rch 17, 2009 1:54 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group?stg Yes, the underlying problem is they are not collocated and they have experienced delays because of: - multiple platforms requesting the same volumes concurrently - multiple servers on the same pla

Re: volumes in a collocation group?stg

2009-03-17 Thread Larry Clark
- From: "David E Ehresman" To: Sent: Tuesday, March 17, 2009 2:39 PM Subject: Re: [ADSM-L] volumes in a collocation group?stg That's cheating. If your DR test restore times are unexceptable you need to address the underlying problem because you don't get to prep for real d

Re: volumes in a collocation group?stg

2009-03-17 Thread David E Ehresman
o...so these are offsitevols from a copypool. Larry Clark (518) 712-5138 Home Office - Original Message - From: "Alex Paschal" To: Sent: Sunday, March 15, 2009 2:37 PM Subject: Re: [ADSM-L] volumes in a collocation group?stg Hi, All. The critical piece that Larry mentioned

Re: volumes in a collocation group?stg

2009-03-15 Thread Nick Laflamme
On Mar 15, 2009, at 1:37 PM, Alex Paschal wrote: Nick, if you really want to mix data on tapes (I have no idea why you would want to, but the beautiful thing about TSM is you can do nearly anything you want), the first way I can think of is to temporarily reduce MAXSCRATCH (or temporarily disabl

Re: volumes in a collocation group?stg

2009-03-15 Thread Larry Clark
Behalf Of Nick Laflamme Sent: Sunday, March 15, 2009 5:42 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group? On Mar 14, 2009, at 10:23 PM, Larry Clark wrote: What you say is curious..only nodes that are in a collocation group should have data on the

Re: volumes in a collocation group?stg

2009-03-15 Thread Alex Paschal
lamme Sent: Sunday, March 15, 2009 5:42 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] volumes in a collocation group? On Mar 14, 2009, at 10:23 PM, Larry Clark wrote: > What you say is curious..only nodes that are in a > collocation > group should have data on the v

Re: volumes in a collocation group?

2009-03-15 Thread Nick Laflamme
On Mar 14, 2009, at 10:23 PM, Larry Clark wrote: What you say is curious..only nodes that are in a collocation group should have data on the volumes in that collocation group. At least that is my understanding. Your saying more than one collocation group can store data on the same v

Re: volumes in a collocation group?

2009-03-15 Thread James R Owen
I believe Paul meant to say: Nodes not assigned to a specific collocation group are treated as if *each* is in *its* own private collocation group (i.e., collocation by node.) -- jim.o...@yale.edu Paul Zarnowski wrote: Nodes not assigned to a specific collocation group are treated as if they wer

Re: volumes in a collocation group?

2009-03-14 Thread Paul Zarnowski
" To: Sent: Saturday, March 14, 2009 11:41 PM Subject: Re: [ADSM-L] volumes in a collocation group? Larry, This would only be true if you had sufficient tapes so that each collocation group always has a tape in empty or filling status. Otherwise, TSM will start doubling up and putting mor

Re: volumes in a collocation group?

2009-03-14 Thread Larry Clark
explanation of filling volumes for collocations group members? Larry Clark - Original Message - From: "Paul Zarnowski" To: Sent: Saturday, March 14, 2009 11:41 PM Subject: Re: [ADSM-L] volumes in a collocation group? Larry, This would only be true if you had sufficient tap

Re: volumes in a collocation group?

2009-03-14 Thread Larry Clark
Larry Clark (518) 712-5138 Home Office - Original Message - From: "Paul Zarnowski" To: Sent: Saturday, March 14, 2009 11:41 PM Subject: Re: [ADSM-L] volumes in a collocation group? Larry, This would only be true if you had sufficient tapes so that each collocation group alway

Re: volumes in a collocation group?

2009-03-14 Thread Paul Zarnowski
To: Sent: Saturday, March 14, 2009 8:41 PM Subject: Re: [ADSM-L] volumes in a collocation group? On Mar 14, 2009, at 5:13 PM, Larry Clark wrote: Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)? QUERY NODEDATA COLLOCG=grpname S

Re: volumes in a collocation group?

2009-03-14 Thread Larry Clark
From looking at the command I think q nodedata collocg= would return all the members and volumes in a collocation group. Larry Clark (518) 712-5138 Home Office - Original Message - From: "Nick Laflamme" To: Sent: Saturday, March 14, 2009 8:41 PM Subject: Re: [ADSM-L] vo

Re: volumes in a collocation group?

2009-03-14 Thread Larry Clark
not be true Larry Clark - Original Message - From: "Nick Laflamme" To: Sent: Saturday, March 14, 2009 8:41 PM Subject: Re: [ADSM-L] volumes in a collocation group? On Mar 14, 2009, at 5:13 PM, Larry Clark wrote: Hi, Would someone have a query that retur

Re: volumes in a collocation group?

2009-03-14 Thread Nick Laflamme
On Mar 14, 2009, at 5:13 PM, Larry Clark wrote: Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)? QUERY NODEDATA COLLOCG=grpname STG=stgname I suspect your mental model of how collocation works is a bit tangled, because other col

volumes in a collocation group?

2009-03-14 Thread Larry Clark
Hi, Would someone have a query that returns all the volumes in a particular collocation group (within a copypool)?