ADSM-L

Re: Space occupied by a object

2006-10-30 12:49:24
Subject: Re: Space occupied by a object
From: Christopher Zahorak <chris AT UWINDSOR DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 30 Oct 2006 12:43:42 -0500
You could use:

q occu nodename

or more specifically...

select * from backups where node_name=hostname and
filespace_id=fsid-number

Chris.





Matthew Warren <Matthew.Warren AT DIGICA DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/30/2006 11:49 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Space occupied by a object






...in addition to my previous mail, as you are using TDP and it most
likely is generating filenames on the fly you most likely need to query
the archives table to find the names TDP Exchange has given it's archive
objects in TSM.

Matt.

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]
> On Behalf Of Thomas, Martin
> Sent: 30 October 2006 16:17
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Space occupied by a object
>
> Hi,
>
> We have some cleanup to run on the database to reduce occupancy in the
> library after a chance in retention policy by management.
>
> I want to delete certain TDP Exchange objects but before doing so, I
> need to know how much occupancy these object take.
>
> Of course TSM is not nice enough to give us a unique id
> across tables...
> like object_id in the backups table for example.
>
> Does someone know of a way to obtain the occupancy of an object?
>
> Thanks!
> Martin
>
>
>
>


This email is confidential and may be privileged. If you are not the
intended recipient please notify the sender immediately and delete the
email from your computer.

You should not copy the email, use it for any purpose or disclose its
contents to any other person.
Please note that any views or opinions presented in this email may be
personal to the author and do not necessarily represent the views or
opinions of Digica.
It is the responsibility of the recipient to check this email for the
presence of viruses. Digica accepts no liability for any damage caused by
any virus transmitted by this email.

UK: Phoenix House, Colliers Way, Nottingham, NG8 6AT UK
Reception Tel: + 44 (0) 115 977 1177
Support Centre: 0845 607 7070
Fax: + 44 (0) 115 977 7000
http://www.digica.com

SOUTH AFRICA: Building 3, Parc du Cap, Mispel Road, Bellville, 7535, South
Africa
Tel: + 27 (0) 21 957 4900
Fax: + 27 (0) 21 948 3135
http://www.digica.com

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