Re: Occupancy of a backupset

Ray,

I "point and shoot" my way through MS Query, but this is the Select
command submitted to TSM:

04/16/2004 13:08:38  ANR2017I Administrator USER issued command: DEFINE
CURSOR
                      C37e23b8 SQL="SELECT OCCUPANCY.NODE_NAME,
                      OCCUPANCY.FILESPACE_NAME, OCCUPANCY.STGPOOL_NAME,
                      OCCUPANCY.NUM_FILES, OCCUPANCY.PHYSICAL_MB,
 FROM OCCUPANCY       OCCUPANCY.LOGICAL_MB, OCCUPANCY.TYPE
 WHERE (OCCUPANCY.STGPOOL_NAME='BACKUPDISK')"

In that case I'm obtaining the occupancy of my disk pool "backupdisk". The
results get inserted into cell A1 of the Excel spreadsheet.  I sum the
data columns and enter those sums into a summary spreadsheet that graphs
the results.

I have a separate sheet and query for each storage pool, whereby MS Query
inserts a different storage pool name after the WHERE clause.

That way I can chart the growth of data in our TSM system with about 15
minutes of effort for each update.  I do this weekly to compare apples to
apples since our TSM system runs with a weekly maintenance schedule.

Tab Trepagnier
TSM Administrator
Laitram, L.L.C.








Ray Louvier <Ray.Louvier AT HALLIBURTON DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/17/2004 05:22 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Occupancy of a backupset


Tab, what is the select command you use for occupancy.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Tab Trepagnier
Sent: Friday, April 16, 2004 12:36 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Occupancy of a backupset

TSM 5.1.8.0 on AIX

Is there a way to easily determine the size of a backupset?

I track tape occupancy weekly to chart growth of our TSM system.  Each
Excel spreadsheet has an embedded "select from occupancy..." query.
That
allows me to determine how much data I have and where it is in about 5
minutes.

But data in a backupset does not show up under any "occupancy" measure
that I'm aware of.  As I shift more archives to backupsets, I'd like
some
way to show that the reduction in archive space isn't real - that data
is
just changing form to backupsets.  That way I could count the backupset
data along with all the other data I'm tracking.

TIA

Tab Trepagnier
TSM Administrator
Laitram, L.L.C.