Thanks I was working on a report very similar but this will help Thanks again
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tab Trepagnier Sent: Monday, April 19, 2004 9:45 AM To: [EMAIL PROTECTED] Subject: 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 04/17/2004 05:22 AM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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:[EMAIL PROTECTED] On Behalf Of Tab Trepagnier Sent: Friday, April 16, 2004 12:36 PM To: [EMAIL PROTECTED] 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.
