ADSM-L

Re: total volumes usage in TSM.

2003-02-06 14:45:29
Subject: Re: total volumes usage in TSM.
From: Muthyam Reddy <MREDDY AT JOY DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 6 Feb 2003 14:24:18 -0500
** High Priority **

Hi Bill,
thanx for imm'te responce.
I have excludes db,disk,files pool volumes from my list and I have a track of 
these.And we are not holding backupsets..etc.

Here is my problem.
when I track all tapes from onsite+offsite+db got from 000007 to 000100 .

How can I find  a entry of 000003 in volumes history file.

please write to me.

thanks

>>> bill.boyer AT VERIZON DOT NET 02/06/03 01:11PM >>>
the DBVOLUMES table contains the DBVOL's not the DBBackup vols. Those are in
the VOLHISTORY table. Plus DISK and FILE storage pool volumes are in the
VOLUMES table. Are those needed in the total? Plus do you need to include
DBSnapshot, backupset, export,...volumes, too? Not a simple query unless you
know the specifics of the TSM site. Seems that except for the storage pool
volumes, everything else is somethere in the VOLHISTORY table.

Bill Boyer
DSS, Inc.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Hart, Charles
Sent: Thursday, February 06, 2003 11:06 AM
To: ADSM-L AT VM.MARIST DOT EDU 
Subject: Re: total volumes usage in TSM.


All VOlumes (Offsite + Onsite + etc)
select count(*) from volumes

All DB VOlumes
select count(*) from dbvolumes

-----Original Message-----
From: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK] 
Sent: Thursday, February 06, 2003 3:43 AM
To: ADSM-L AT VM.MARIST DOT EDU 
Subject: Re: total volumes usage in TSM.


q vol only gives storage pool volumes not dbb volumes





Muthyam Reddy <mreddy AT joy DOT com> on 02/05/2003 10:16:25 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu 
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  total volumes usage in TSM.



** High Priority **

Please this is emergency.

Hi ,
Here I'm trying to count total volumes usage in tivoli by adding
q vol+scratch tapes in library wich I got 450 tapes and these are defined in
primary,copy storage pools.
But in volume history shows 800 unique tapes used in different dates.

Deffenetly I missed something in my formula.....

Please can anybody explain correct formula to count total number of volumes
using by tsm (onsite+offsite).

my assumption is 'q vol' gives volume list of primary,copy pools and using
for
dbb.

We are using drm.

thanks in advance

/mani


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++

This electronic mail transmission contains information from Joy Mining
Machinery
which is confidential, and is intended only for the use of the proper
addressee.
If you are not the intended recipient, please notify us immediately at the
return
address on this transmission, or by telephone at (724) 779-4500, and delete
this
message and any attachments from your system.  Unauthorized use, copying,
disclosing, distributing, or taking any action in reliance on the contents
of
this
transmission is strictly prohibited and may be unlawful.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++++++++++++








**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern
Energy plc.
It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient,
any disclosure, copying, distribution or any action taken or omitted
to be taken in reliance on it, is prohibited and may be unlawful.
Any unauthorised recipient should advise the sender immediately of
the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************


+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
This electronic mail transmission contains information from Joy Mining Machinery
which is confidential, and is intended only for the use of the proper addressee.
If you are not the intended recipient, please notify us immediately at the 
return
address on this transmission, or by telephone at (724) 779-4500, and delete this
message and any attachments from your system.  Unauthorized use, copying,
disclosing, distributing, or taking any action in reliance on the contents of 
this
transmission is strictly prohibited and may be unlawful.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<Prev in Thread] Current Thread [Next in Thread>