No, BACKUPS and ARCHIVES have just one entry per file, regardless of the number of storage pools it's in. NUM_FILES from OCCUPANCY counts the number of files per storage pool, so it includes primary/active/copy pools.
You can look at the system catalog to see the schema of those tables: SELECT COLNAME,TYPENAME FROM syscat.columns where tabname='OCCUPANCY' SELECT COLNAME,TYPENAME FROM syscat.columns where tabname='BACKUPS' SELECT COLNAME,TYPENAME FROM syscat.columns where tabname='ARCHIVES' On 02/10/13 23:22, white jeff wrote: > Hi > > Doing some sizing for a client, who wants active data pools for a selection > of nodes > > TSM Server v6.3.1 > > select sum(num_files) from occupancy: > > Shows 139 million files. Fine > > So i want to know how many active and inactive files from the backups > table, and the number of objects in the archives table (mainly as a matter > of interest) > > Select count(*) from backups where state = 'ACTIVEVERSION' > 38 million objects > > Select count(*) from backups where state = 'INACTIVEVERSION' > 41 million objects > > Select count(*) from archives > 4 million objects > > So in total, 83 million objects > > But 55 million less than the occupancy number of files > > I thought it may be that a copy file might not appear in the backups or > archives table, but i have always assumed that it did. Happy to be told > otherwise, if definitely true. > > > Anyone have a thought on the discrepancy? > > Regards > -- -- Skylar Thompson ([email protected]) -- Systems Administrator, Genome Sciences Department -- University of Washington, School of Medicine
