Sizing estimate for the dsm/tc database – HP NonStop G-Series User Manual
Page 149
Database Design of DSM/TC
DSM/Tape Catalog User’s Guide — 520233-008
9 - 15
Sizing Estimate for the DSM/TC Database
Sizing Estimate for the DSM/TC Database
Because SQL/MP automatically uses disk space compression when writing information
in a database, the values in this estimate are greater than the actual space needed.
The values are based on these assumptions:
The average tape file name length is 20 characters.
The average volume catalog name length is 18 characters.
The average file catalog name length is 18 characters.
The average pool name length is 10 characters.
The average volume name length is 6 characters.
The average disk file name length is 26 characters.
The only other space requirement is that each subvolume with a file catalog or volume
catalog also have an SQL catalog that is created automatically. The disk space
required for the SQL catalog is minimal and does not change with an increase in size
of the file or volume catalog.
Minimum
Maximum
Average
Each tape file recorded
140 bytes
540 bytes
270 bytes
Each disk file recorded
180 bytes
600 bytes
410 bytes
Each pool configured
35 bytes
80 bytes
50 bytes
Each volume in a pool
80 bytes
340 bytes
180 bytes
Each assigned volume set
12 bytes
70 bytes
40 bytes