Method Three

Preparing for Installation › Storage Requirements › Sizing Host Encyclopedia › Encyclopedia Estimating Methods › Method Three

Method Three

The following tables show the number of 4 KB pages allocated for the Schema, Data, and Public Interface tables or indexes for a small and a medium Host Encyclopedia. When using Storage Group, CA Gen automatically multiplies each value by four when generating the DDL.

The sizes of the following tables or indexes depend on the number and sizes of models.

Table/Index	Small	Medium
DASC	4800	33600
DASCI1	2400	16800
DASCI2	2400	16800
DOBJ	3000	21000
DOBJI1	900	6300
DOBJI3	1200	8400
DPRP	4800	33600
DPRPI1	800	5600
DPRPI1	800	5600
DSUBEX	6000	42000
DSUBEXI1	2400	16800
DSUBEXI2	2400	16800

You may need to adjust the sizes of the following tables or indexes:

Table/Index	Small or Medium
DHOBJ	1500
DHOBJI1	150
DHLOG	2500
DHLOGI1	500
DHLOGI2	500
DHLOGI3	1000
DTXT	6000
DTXTI1	325

The values of the following table or indexes are constant.

Table/Index	Small, Medium, or Large
DCOPY	150
DCOPYI1	150
DCOPYI2	150
DCPYUS	65
DCPYUSI1	10
DCPYUSI2	10
DFAMLY	65
DFAMLYI1	20
DFAMLYI2	20
DGRPUS0	65
DGRPUSI1	5
DGRPUSI2	5
DMAX	65
DMDL	65
DMDLI1	12
DMDLI2	24
DSETDF	400
DSETDFI1	400
DSETID	65
DSETIDI1	30
DSETIDI2	30
DSETIDI3	30
DSUBDF	400
DSUBDFI1	100
DSUBDFI2	100
DSUBID	65
DSUBIDI1	20
DSUBIDI2	20
DSUBUS	65
DSUBUSI1	10
DSUBUSI2	10
DUSR	65
DUSRI1	5
DXCPID	65
DXCPIDI1	5

The size of the following table or indexes depends on Public Interface usage.

Table/Index	Small or Medium
MODEL	65
MODELI1	10
MODELI1	10
MODELI2	1000
PIDATA	400
PIDATAI1	400
PIDATAI2	400
PIDATAI3	400
PINAME	100
PINAMEI2	80
PITEXT	1000
PITEXTI1	250
PITEXTI2	250

Do not resize the following schema tables.

Table/Index	Small or Medium
SASC	600
SASCI1	300
SASCI2	300
SASCI3	300
SDIV	600
SDIVI1	300
SDIVI2	300
SMDL	65
SMDLI10	5
SMDLI2	5
SOBJ	300
SOBJI1	300
SOBJI2	300
SPRP	600
SPRPI1	300
SPRPI2	300
STRG	600
STRGI1	300