DOCS

Evaluating the Database Space Needed for an Entry Point

To evaluate the database space needed for an entry point

In the left frame of the Connection Manager window, expand Database Installation & Configuration Tools:

Select Evaluate database space needed for an entry point, then click Next.

Double-click Evaluate database space needed for an entry point:

Select the database type from the Target database drop-down list (i.e., Oracle or SQL Server).

Specify numerical values in these fields:

Field	Description
Total number of programs	The total number of programs to be analyzed.
Number of lines per program	The average number of source code lines in the programs to be analyzed.
Source lines factor	The percentage increase a program may have in its number of source lines because of the expansion of included files. For example, if a program contains 1,000 lines of source code before copy members are expanded and 1,500 lines after they have been expanded, specify 50 as a value because the program size has increased by 50 percent.
Disk space factor	The percentage increase for overall entry point growth.

Select MB or GB from the Display unit drop-down list, depending on whether you want the disk space increase factor to be in megabytes (MB) or gigabytes (GB).

Click the ellipsis button [...] to specify the result file, or keep the default path (i.e., BECUBIC_HOME\CAE\log\storage.txt).

Click Run. The contents of the log file display on the Result tab, providing you with a complete description of the configuration of your server (i.e., the minimum size for CAE on each disk, minimum size for each tablespace or filegroup, etc.). The configuration that CAE Manager displays is based on the number of disks you have dedicated to CAE on your server.

Click Applications if you want to perform another action in CAE Manager, or click Quit. This is an example of the resulting configuration file:

+-------------------------------------+

| Space distribution for CAE Database |

| with various disk configurations |

+-------------------------------------+

=============================================================

= Target database

=============================================================

= Target database : Oracle

=============================================================

= Sources to load

=============================================================

= Total number of program kilo-lines : 100000

=============================================================

= Increase factors

=============================================================

= for source lines : 50 %

= for disk space : 10 %

=============================================================

= Configuration with 4 separate disks

=============================================================

Disk Total capacity in MB

--------------------------------------

DISK1 1500

DISK2 2000

DISK3 33849

DISK4 66071

Tablespace Disk Size

--------------------------------------

SYSTEM DISK1 fixed

UNDO DISK1 fixed

USR DISK1 fixed

TEMP DISK1 fixed

LOG files DISK2 fixed

SMALL_DATA DISK3 5

WRK_DATA DISK3 6

LOB DISK3 3223

DATA DISK3 14502

LNK_DATA DISK3 16113

SMALL_INDX DISK4 5

WRK_INDX DISK4 2

INDX DISK4 27393

LNK_INDX DISK4 38672

=============================================================

= Configuration with 6 separate disks

=============================================================

Disk Total capacity in MB

--------------------------------------

DISK1 1500

DISK2 2000

DISK3 17736

DISK4 27400

DISK5 16113

DISK6 38672

Tablespace Disk Size

--------------------------------------

SYSTEM DISK1 fixed

UNDO DISK1 fixed

USR DISK1 fixed

TEMP DISK1 fixed

LOG files DISK2 fixed

SMALL_DATA DISK3 5

WRK_DATA DISK3 6

LOB DISK3 3223

DATA DISK3 14502

SMALL_INDX DISK4 5

WRK_INDX DISK4 2

INDX DISK4 27393

LNK_DATA DISK5 16113

LNK_INDX DISK6 38672

OBJ_INDX DISK8 12