Estimating the size of the catalog initialization and maintenance utility

You can use the guidelines provided with the formula in this topic to estimate the size of the metadata catalog.

During the installation customization process you provide input to estimate the size of the metadata catalog. This estimate is used to allocate the file space that will store the metadata catalogs. The estimate is based on the formula below.

You can also use the formula if you set up your metadata catalogs manually. This is a generous estimate because an accurate size determination is not feasible and there is no guarantee to fully store a catalog. In the unlikely event that you run out of file space, you will receive an explicit error message providing further instructions.
ESTIMATED CATALOG OBJECT SIZE in Bytes = 314572800

   + <number of expected tables> * 3710
   + <number of expected tables> * <maximum or average number of expected columns per table>  * 776        

   + <number of expected views> * 3086
   + <number of expected views> * <maximum or average number of expected columns per view>  * 776

   + <number of expected indexes> * 1278
   + <number of expected indexes> * <maximum or average number of expected columns per index>  * 264

   + <number of expected stored procedures> * 1543
   + <number of expected stored procedures> * <maximum or average number of parameters per stored procedure>  * 264                      

TOTAL ESTIMATED CATALOG SIZE in Bytes = ESTIMATED CATALOG OBJECT SIZE

   + <user-defined reserved space in bytes>

TOTAL ESTIMATED CATALOG SIZE in Megabytes =  TOTAL ESTIMATED CATALOG SIZE in Bytes / 1048576
Notes:
  • You supply the number in brackets based on your planned usage of the catalog.
  • A conservative user would use the maximum number instead of the average number in the formula.
  • Minimally, you should reserve an additional 1/3 of the calculated catalog object size.
  • Indexes are typically used in Classic Federation for IMS, Db2, and Adabas data sources only.
  • Because stored procedures are rarely used, it is likely that you can ignore providing input for them.
  • A reserve for GRANT authorities is included in the formula which should be sufficient, even for the largest catalog.