Re: backed up nodes

2008-03-17 Thread Keith Arbogast
This may be a poor man's way of getting the information, but it works. Do 'q dom' to get the total of registered clients. Than, do 'q node' and scan the list for ones whose last backup date is greater than '1'. Keith Arbogast Indiana University

Re: backed up nodes

2008-03-17 Thread Richard Sims
On Mar 16, 2008, at 9:51 PM, Avy Wong wrote: What started my question to ask this forum's expert is suddenly I was told that I have to keep track of all the nodes being backed up on tivoli. I still have to clarify with IBM licensing if this is to do with nodes currently being backed up on tivoli

Re: backed up nodes

2008-03-16 Thread Andrew Raibeck
gt; the confusion. > > > > Avy Wong > > Business Continuity Administrator > > Mohegan Sun > > 1 Mohegan Sun Blvd > > Uncasville, CT 06382 > > (860)862-8164 > > (cell) (860)961-6976 > > > > > > > > > > Shawn Dr

Re: backed up nodes

2008-03-16 Thread Andrew Raibeck
CT 06382 > (860)862-8164 > (cell) (860)961-6976 > > > > > Shawn Drew > <[EMAIL PROTECTED] > CAS.BNPPARIBAS.CO To > M>ADSM-L@VM.MARIST.EDU > Sent by: "ADSM: cc > Dist Sto

Re: backed up nodes

2008-03-16 Thread Avy Wong
<[EMAIL PROTECTED] Re: [ADSM-L] backed up nodes .EDU> 03/15/2008 07:13 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU>

Re: backed up nodes

2008-03-15 Thread Roger Deschner
Hmmm. I think you're right. I meant occupancy. The contents table is impossibly slow to process via SELECT. The occupancy table is much faster, though still not fast. There is an anomoly I noticed with occupancy data. SELECT * FROM OCCUPANCY is MUCH faster than QUERY OCC. So much faster that I mad

Re: backed up nodes

2008-03-15 Thread Shawn Drew
Protection Engineer Core IT Production BNP Paribas RCC, Inc. Internet [EMAIL PROTECTED] Sent by: ADSM-L@VM.MARIST.EDU 03/15/2008 03:04 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] backed up nodes On Mar 15, 2008, at 2:36 PM, Roger Deschner wrote: > That

Re: backed up nodes

2008-03-15 Thread Richard Sims
On Mar 15, 2008, at 2:36 PM, Roger Deschner wrote: That occupancy table can be REALLY slow to process if your system is at all large. I prefer to search the summary table which is fast, even with my 275gb database. Roger - Are you thinking of the Contents table? I have a large system, and it

Re: backed up nodes

2008-03-15 Thread Roger Deschner
. That occupancy table can be REALLY slow to process if your system is at all large. I prefer to search the summary table which is fast, even with my 275gb database. select distinct entity from summary where activity='BACKUP' ...will be MUCH faster. This gives you the past 30 days. If you want fe

Re: backed up nodes

2008-03-15 Thread Avy Wong
cc <[EMAIL PROTECTED] .EDU> Subject Re: [ADSM-L] backed up nodes 03/14/2008 08:12 PM Please respond to

Re: backed up nodes

2008-03-15 Thread Evans, Bill
nt: Friday, March 14, 2008 6:13 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] backed up nodes select distinct NODE_NAME from occupancy where TYPE='Bkup' On Mar 14, 2008, at 4:33 PM, Avy Wong wrote: > Hello, > Is there a command I can run to get the number of nodes being > backed > up on tivoli?

Re: backed up nodes

2008-03-14 Thread Richard Sims
select distinct NODE_NAME from occupancy where TYPE='Bkup' On Mar 14, 2008, at 4:33 PM, Avy Wong wrote: Hello, Is there a command I can run to get the number of nodes being backed up on tivoli?

backed up nodes

2008-03-14 Thread Avy Wong
Hello, Is there a command I can run to get the number of nodes being backed up on tivoli? Often nodes are created and registered on tivoli but not being backed up. I would think ip address is also one of the paremeter in the select statement as at times two nodes will be sharing same ip addre