-----Remco Post wrote: ----- [On calculating the average size of a TSM database entry]
>select used_pages * page_size from db >select sum(num_files) from occupancy > >divide the first by the second number and multiply by the number of >copies you keep for each file > >In my home-environment: 806 (very small database, very few files) Directories, special files, and zero-length files often have database entries but no data in storage pools; TSM stores all the data needed to recreate such objects in the TSM database. When I execute 'delete filespace' commands the number of objects deleted is typically about 10 percent greater than the number of objects indicated by storage pool occupancy queries. If the same ratio applies to your workload, your calculation is overestimating the average size of an entry by about 10 percent.
