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:[EMAIL PROTECTED]]On Behalf Of Hart, Charles Sent: Thursday, February 06, 2003 11:06 AM To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 3:43 AM To: [EMAIL PROTECTED] Subject: Re: total volumes usage in TSM. q vol only gives storage pool volumes not dbb volumes Muthyam Reddy <[EMAIL PROTECTED]> on 02/05/2003 10:16:25 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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. **********************************************************************
