Previous Topic: 7.2.3.4 VTS Database Space Modeling (DBMODEL)Next Topic: 7.2.3.4.2 DBMODEL Input Statements


7.2.3.4.1 Data Retention Specifications (FILE Statements)

Data retention specifications tell the CA MICS database how
many cycles of each file in each supported timespan are to be
saved, both in online and archive modes.

The worksheet is organized by information area.  Each file in
the area is listed by name.  For each file, a line is
formatted to allow six definitions in the online database and
two in the archive database:

o The online database files quantify the number of cycles of
  data that is maintained in the DETAIL, DAYS, WEEKS,
  MONTHS, and YEARS timespans and the TABLES data area.

o The two definitions for the archive database files quantify
  the number of cycles of data to be retained, up to the
  cutoff limit defined.  The archive definitions have no
  impact on the size of the database and can be specified
  whethert the weekly and/or monthly archive history
  files have actually been activated (see Section 2.3.3,
  CA MICS JCL Planning and Parameters, of the PIOM).

The worksheet formats provide an underscored area for the
user's definition, followed by the recommended value, shown
within parentheses.  If the underscored area contains a value
of 00, the file is not supported for the indicated timespan.
To add support, perform database tailoring as
described in Section 6.2, Tailoring the Database, of the
System Modification Guide (SMG).

When specifying a retention limit, remember that the number
may never be zero if the file has been defined to be active
in the timespan.

Example:

The FILE statements listed below illustrate how to enter the
information:

FILE VTS IVTTCA 00 33 52 24 00 02 000 024
FILE VTS IVTVDL 00 33 52 24 00 02 000 024
FILE VTS IVTVTC 00 33 52 24 00 02 000 024
FILE VTS IVTVCL 00 33 52 24 00 02 000 024
FILE VTS IVTIEX 00 33 52 24 00 02 000 024
FILE VTS IVTVCU 00 33 52 24 00 02 000 024
FILE VTS IVTPTU 00 33 52 24 00 02 000 024
FILE VTS IVTVPS 00 33 52 24 00 02 000 024