Backup Central

Is it possible to query TSM with a select statement that will detail out
a particular
filespace. If so does any one have one.

Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for each or the number of files
active or inactive.

Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: tbrown < at > cenhud.com <mailto:tbrown < at > cenhud.com>
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255

http://www-1.ibm.com/support/docview.wss?rs=1019&context=SSSQWC&context=
SSGSG7&q1=ACTIVE+Data+pool+size&uid=swg21267260&loc=en_US&cs=utf-8&lang=
en

Regards, Rama

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L < at > VM.MARIST.EDU] On Behalf Of
Tim Brown
Sent: Wednesday, August 13, 2008 8:54 AM
To: ADSM-L < at > VM.MARIST.EDU
Subject: [ADSM-L] select statement to detail a filespace


Is it possible to query TSM with a select statement that will detail out
a particular
filespace. If so does any one have one.

Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for each or the number of files
active or inactive.

Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: tbrown < at > cenhud.com <mailto:tbrown < at > cenhud.com>
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255
--------------------------------------------------------

This message w/attachments (message) may be privileged, confidential or proprietary, and if you are not an intended recipient, please notify the sender, do not use or share it and delete it. Unless specifically indicated, this message is not an offer to sell or a solicitation of any investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Merrill Lynch. Subject to applicable law, Merrill Lynch may monitor, review and retain e-communications (EC) traveling through its networks/systems. The laws of the country of each sender/recipient may impact the handling of EC, and EC may be archived, supervised and produced in countries other than the country in which you are located. This message cannot be guaranteed to be secure or error-free. This message is subject to terms available at the following link: http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you consent to the foregoing.
--------------------------------------------------------

On Aug 13, 2008, at 8:53 AM, Tim Brown wrote:

Is it possible to query TSM with a select statement that will detail
out
a particular
filespace. If so does any one have one.

Say a filespace \\NODE1\D$ for node NODE1. This particular drive has 5
folders
Can TSM show the percentage of storage for each or the number of files
active or inactive.

Whereas the sizes of stored files cannot generally be determined from
TSM server queries, a storage percentage report is not doable.

Active/Inactive state is recorded by object, in the Backups and
Archives tables, meaning that a costly scan would have to be run. I
would not approach doing that unless there was a serious need for such
a report, given what it does to the server and database.

Richard Sims