ADSM-L

content tables Vs occupancy tables.

2001-07-11 07:08:40
Subject: content tables Vs occupancy tables.
From: Ofer <ofer AT TRIP.CCC.CO DOT IL>
Date: Wed, 11 Jul 2001 14:10:34 +0200
 Hi all,

 I have a 100 DLT cartridges library with 35/70GB capacity each.
 This is like 7TB approximately data on the library if the compression
 utilization is like 100%( which is not the case).

 In addition, there are like 37 cartridges with scratch status.

 I would like to  know how much data I have on my tsm server so I have
 ran the following 2 select q.

 'select node_name,sum(file_size) as sum_file_size from contents group
by
 node_name'

 'select node_name,sum(PHYSICAL_MB) as sum_phys_mb from occupancy group
 by node_name'

 and I got the following result

 9,030,520 MB from the contents table

 2,422,690 MB from the occupancy table

 From the occupancy table I have a reasonable number that I can live
with
 but the values from the contents are bigger then my library with a 100%

 compression.

 what is the explanation for that number?.

I have 9TB on a library(Content Table) while the Maximum  capacity of
library is 7TB ( Not to mention that I have sum scratch cartridges on
the library ).

 I appreciate your prompt reply.

 All the Best,


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