Previous Topic: 2.3.4 Database Space Modeling Facility

Next Topic: 2.3.4.1.1 DATABASE Statement

2.3.4.1 Preparing the Modeling Input


The Installation Preparation Worksheet should have been
completed for use in building the required inputs for the
database space modeling process.

The DBMODEL parameter is distributed as a prototype in
sharedprefix.MICS.GENLIB(DBMDLDEF).  Component generations
adjust DBMDLDEF for database tailoring.  The COPYLIBU job
for each database unit adjusts the unit's
prefix.MICS.PARMS(DBMODEL) for new products and database
tailoring during unit modification or installation.

Update your DBMODEL member based on the data collected on the
Installation Preparation Worksheets.  This updates the
default values on the FILE statements for the products that
you are installing.

The Database Space Modeling Facility provides a method for
estimating the database's DASD space requirements.  The
modeling process considers one database per run.  Depending
upon the user's choice of maintaining a single database or
multiple database units, multiple modeling runs may be
necessary for different databases.

The modeling facility operates from a series of input
statements that define the database information areas, the
data retention requirements the user has specified for
maintaining online and archive data, and input data of about
one day.

There are two input statements that are to be specified as
input for the modeling analysis.  The statements include the
following:

    DATABASE:  Identifies the database being modeled.

    FILE:      Specifies the online and archive data
               retention limits for a specific database
               file.

Figure 2-34 illustrates the order of the input statements.
         +---------------------------------+
         | DATABASE name                   |
         +---------------------------------+-----+
             | FILE filename  retention-limits   |
             | FILE filename  retention-limits   |
             +-----------------------------------+

 Figure 2-34.  Statements for Single System Database

The following sections describe the syntax rules and format
for the two input statements and provide an example of their
use.

    1 - DATABASE Statement
    2 - Data Retention Specifications (FILE Statement)

Note:  We recommend that the retention limits predefined in
DBMODEL be used for your first run.  To see an example of
DBMODEL, refer to your sharedprefix.MICS.GENLIB(DBMDLDEF).